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,
"Welcome to our mercurial repository"