Mercurial > hg > freeDiameter
changeset 449:c5e37091553a
Updated app_diameap documentation and diameap.sql script
author | Souheil Ben Ayed <souheil@tera.ics.keio.ac.jp> |
---|---|
date | Thu, 29 Jul 2010 14:07:30 +0900 |
parents | 9493b8d8a35f |
children | f6e85a0694eb |
files | extensions/app_diameap/README extensions/app_diameap/diameap.sql |
diffstat | 2 files changed, 44 insertions(+), 12 deletions(-) [+] |
line wrap: on
line diff
--- a/extensions/app_diameap/README Thu Jul 29 13:57:09 2010 +0900 +++ b/extensions/app_diameap/README Thu Jul 29 14:07:30 2010 +0900 @@ -40,7 +40,9 @@ 1- Add DiamEAP extension to freeDiameter. See freeDiameter documentation (http://www.freediameter.net/) -2- Edit the extensions/CMakeList.txt file to add DiamEAP to freeDiameter. +2-Create a new MySQL database and add tables using the sql script 'diameap.sql'. + +3- Edit the extensions/CMakeList.txt file to add DiamEAP to freeDiameter. Add the following lines: @@ -51,9 +53,9 @@ Note: you can enable DiamEAP to be built with freeDiameter by setting the BUILD_APP_DIAMEAP to ON. If you enable it here you don't need to enable it when building freeDiameter. -3- Enable DiamEAP by enabling BUILD_DIAMEAP option with CMake: +4- Enable DiamEAP by enabling BUILD_APP_DIAMEAP option with CMake: -cmake -DBUILD_DIAMEAP:BOOl=ON ../ +cmake -DBUILD_APP_DIAMEAP:BOOl=ON ../
--- a/extensions/app_diameap/diameap.sql Thu Jul 29 13:57:09 2010 +0900 +++ b/extensions/app_diameap/diameap.sql Thu Jul 29 14:07:30 2010 +0900 @@ -5,19 +5,16 @@ # # # # # # -# MySQL command to load the scrip: # +# MySQL command to load the script: # # mysql> mysql -u username -p password diameap_ui < diameap.sql # # # ######################################################################### -CREATE TABLE IF NOT EXISTS `authz` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `grp` int(11) NOT NULL, - `attribute` set('Service-Type','Callback-Number','Callback-Id','Idle-Timeout','Port-Limit','NAS-Filter-Rule','Filter-Id','Configuration-Token','QoS-Filter-Rule','Framed-Protocol','Framed-Routing','Framed-MTU','Framed-Compression','Framed-IP-Address','Framed-IP-Netmask','Framed-Route','Framed-Pool','Framed-Interface-Id','Framed-IPv6-Prefix','Framed-IPv6-Pool','Framed-IPv6-Route','Framed-IPX-Network','Framed-Appletalk-Link','Framed-Appletalk-Network','Framed-Appletalk-Zone') Not NULL DEFAULT 'Service-Type', - `op` set('==','>','>=','<','<=','!=','~=','=+','+==','+>','+>=','+<','+<=','+!=','+~=','==+','>+','>=+','<+','<=+','!=+') NOT NULL DEFAULT '==', - `value` char(255) NOT NULL, - PRIMARY KEY (`id`) -); +-- -------------------------------------------------------- + +-- +-- Table structure for table `authe` +-- CREATE TABLE IF NOT EXISTS `authe` ( `id` int(11) NOT NULL AUTO_INCREMENT, @@ -27,6 +24,27 @@ PRIMARY KEY (`id`) ); +-- -------------------------------------------------------- + +-- +-- Table structure for table `authz` +-- + +CREATE TABLE IF NOT EXISTS `authz` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `grp` int(11) NOT NULL, + `attribute` set('NAS-IPv6-Address','NAS-Identifier','NAS-IP-Address','NAS-Port','NAS-Port-Id','NAS-Port-Type','Called-Station-Id','Calling-Station-Id','Connect-Info','Originating-Line-Info','Service-Type','Callback-Number','Callback-Id','Idle-Timeout','Port-Limit','NAS-Filter-Rule','Filter-Id','Configuration-Token','QoS-Filter-Rule','Framed-Protocol','Framed-Routing','Framed-MTU','Framed-Compression','Framed-IP-Address','Framed-IP-Netmask','Framed-Route','Framed-Pool','Framed-Interface-Id','Framed-IPv6-Prefix','Framed-IPv6-Pool','Framed-IPv6-Route','Framed-IPX-Network','Framed-Appletalk-Link','Framed-Appletalk-Network','Framed-Appletalk-Zone') NOT NULL DEFAULT 'Service-Type', + `op` set('==','>','>=','<','<=','!=','~=','=+','+==','+>','+>=','+<','+<=','+!=','+~=','==+','>+','>=+','<+','<=+','!=+') NOT NULL DEFAULT '==', + `value` char(255) NOT NULL, + PRIMARY KEY (`id`) +); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `grp` +-- + CREATE TABLE IF NOT EXISTS `grp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `grp_name` char(255) NOT NULL, @@ -34,6 +52,12 @@ PRIMARY KEY (`id`) ); +-- -------------------------------------------------------- + +-- +-- Table structure for table `users` +-- + CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, @@ -44,6 +68,12 @@ PRIMARY KEY (`id`) ); +-- -------------------------------------------------------- + +-- +-- Table structure for table `user_grp` +-- + CREATE TABLE IF NOT EXISTS `user_grp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL,