但是打开网页就是权限审核失败。
我是以root身份登陆的
按道理可以呀。SqlDatabaseName = "radius"
SqlPassword = "1234"
SqlUsername = "root"
SqlLocalName = "192.168.0.20" ConnStr = "DRIVER={MySQL ODBC 3.51 Driver};OPTION=35;
OPTION=35这个值是默认的,还是设置的,在哪里设置呢 楼主，我的linux成功安装unixODBC-2.2.3-6.i386.rpm
MyODBC-2.50.39-11.i386.rpm
可以打开一个跟windows一个的操作界面，在linux下测试连接也成功。
可是用你的程序连接linux下mysql数据库还是报上面一样的错误
有没有什么办法连接
注意我的myodbc版本是MyODBC-2.50
驱动名可以在linux下自己设
我设为mysql 2.50
可是还是连不上
SqlDatabaseName = "radius"
SqlPassword = "1234"
SqlUsername = "root"
SqlLocalName = "192.168.0.20"
ConnStr = "DRIVER={mysql 2.50 };
OPTION=
这一项我删了，还是没用
请楼主帮忙 楼主
我总是权限审核失败我想数据库是连上了
关键是登陆不了
可能用户名密码不对
我安装mysql的root密码为1234
难道用这个用户和密码不行吗
后来我来添加了一个具有root权限的用户:radius密码也是radius，一样登陆不了。
我用dialup_admin,php的登陆完全正常
可以正常使用说明我的freeradius和mysql工作站都正常
那为什么就不能使用你的程序吗
你说登陆页面的用户名和密码自己设
那在数据库哪个表格添加管理员用户和密码
请楼主指教
谢谢！ 还是不行我在，我在radcheck表里建了一个用户
test密码test还是进不了
你的backadmin下login.asp有这么一条语句,sql="select * from Acl where UserName='"&Username&"'"
我这里没有acl表呀
这是表应该是管理员的用户和密码吧
那acl表结构是怎样的呢
你的selfcare 下面login.asp语句又是这样sql="select * from radcheck where UserName='"&Username&"' and
这个表里我有用户名和密码test test，我用这个用户进去就说用户名错误。
你能否告诉我一下
或者把你的radius库sql文件发给我这样我自己看一下也知道了 权限审核失败，表示你没有正常登陆而打开需要身份验证的页面，后台是在backadmin目录下，自服务在selfcare下，都是default.asp，你再查一查，还有，需要手工在mysql数据库添加管理员用户
还是不行我抓图你看，你看地址栏，就知道我地址没有错 还是错误
明明`radcheck`表里有test密码test这个用户就是登陆不了 我用后台backadmin登陆还是不行
我新建了一个acl表加用户admin admin
登陆错误
我抓图看一下 用户名错误
是不是我的acl表结构错误
我不知道楼主的radius库是怎么样的 看了上面的贴图，我突然想到一个问题，对于raidus表的访问权限问题，默认是本机访问权限，需要修改，为了方便起见，可以设为任何机器都可以访问。这也就是为什么linux下dialupadmin使用正常，但是asp下无法连接的原因
另自服系统的用户密码属性设为password看看，因为在这个属性中使用user-password或者password都可以，但是我在设计是仅使用password。
acl表是我自建的一个表，由于我现在在家上网，具体的结构现在真的记不清了，我看看在告诉你们吧。 id smallint(6) 否主要的 auto_increment
UserName varchar(20) 否无
Password varchar(20) 否无
Private char(1) 否无 楼主,我想我知道为什么登陆不上了
我看了一下chdecacl.inc文件这句话
if session("UserName")="" and session("Private")="" then
改成
if not session("UserName")="" and session("Private")="" then
就可以登陆上去,不过不能添加用户添加给,不过也没有用.
你的login.asp文件有这么一句话
sql="select * from Acl where UserName='"&Username&"'"
response.write sql
rs.open sql,conn,1,1
if not rs.eof or err then
if rs("Password")=password then
session("UserName")=UserName
session("Private")=rs("Private")
response.Redirect("main.asp")
我看一下,好像语句很正确
判断password=password,刚会话的姓名等于登陆的用户名
问题就在这里,我用了正确的用户名和密码,也不能把名字赋予给会话名
这样,if session("UserName")="" and session("Private")="" then
chdecacl.inc文件检查不到会话的名字,就报权限错误
我改成not就是说不要会话名也能登陆上去.可是没用
我发现别的asp文件都要调用session("UserName")这个变量,所以别的文件不能正常使用.
或者我把所有asp文件的头部删除
这一段,也能登陆,不过不能添加用户和组操作.不过我可以证明一点,登陆时也要调用数据库acl表中的用户名和密码,如果错了一样登陆不进去.
现在足以证明数据库应该问题不大,问题就在session("UserName")变量得不到值,不能将登陆名的值赋予给他.我asp不是很懂.解决不了
所以请楼主大人指教.
还是得说声谢谢.感谢楼主一直回复我,帮助我. 我在mysql加了一个具有所有权限的用户radius
对于raidus表的访问权限问题，我已经设好了，radius用户对radius表有所有权限并且是远程的
并且添加好了acl表，是按照你的数据结构加了
并且加好了用admin
可是访问还是出现权限审核失败，请重新登陆
还是session("UserName")=UserName没有赋值
这是怎么一回事呀。 数据库权限为radius所有
回复 #44 yuanyonghuio 的帖子
一下是我的整个的表结构，和测试数据管理员用户名/密码：wendy/wendy
测试前台用户名密码：/test1/test1 wendyzh/wendyzh
# MySQL dump 8.14
#
# Host: localhost Database: radius
#--------------------------------------------------------
# Server version 3.23.41
#
# Table structure for table 'Acl'
#
DROP TABLE IF EXISTS `Acl`;
CREATE TABLE `Acl` (
`id` smallint(6) NOT NULL auto_increment,
`UserName` varchar(20) NOT NULL default '',
`Password` varchar(20) NOT NULL default '',
`Private` char(1) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
#
# Dumping data for table 'Acl'
#
INSERT INTO `Acl` VALUES (1,'wendy','wendy','0');
#
# Table structure for table 'badusers'
#
DROP TABLE IF EXISTS `badusers`;
CREATE TABLE `badusers` (
`id` int(10) NOT NULL auto_increment,
`UserName` varchar(30) default NULL,
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
`Reason` varchar(200) default NULL,
`Admin` varchar(30) default '-',
PRIMARY KEY(`id`),
KEY `UserName` (`UserName`),
KEY `Date` (`Date`)
) TYPE=MyISAM;
#
# Dumping data for table 'badusers'
#
#
# Table structure for table 'mtotacct'
#
DROP TABLE IF EXISTS `mtotacct`;
CREATE TABLE `mtotacct` (
`MTotAcctId` bigint(21) NOT NULL auto_increment,
`UserName` varchar(64) NOT NULL default '',
`AcctDate` date NOT NULL default '0000-00-00',
`ConnNum` bigint(12) default NULL,
`ConnTotDuration` bigint(12) default NULL,
`ConnMaxDuration` bigint(12) default NULL,
`ConnMinDuration` bigint(12) default NULL,
`InputOctets` bigint(12) default NULL,
`OutputOctets` bigint(12) default NULL,
`NASIPAddress` varchar(15) default NULL,
PRIMARY KEY(`MTotAcctId`),
KEY `UserName` (`UserName`),
KEY `AcctDate` (`AcctDate`),
KEY `UserOnDate` (`UserName`,`AcctDate`),
KEY `NASIPAddress` (`NASIPAddress`)
) TYPE=MyISAM;
#
# Dumping data for table 'mtotacct'
#
#
# Table structure for table 'nas'
#
DROP TABLE IF EXISTS `nas`;
CREATE TABLE `nas` (
`id` int(10) NOT NULL auto_increment,
`nasname` varchar(128) NOT NULL default '',
`shortname` varchar(32) default NULL,
`type` varchar(30) default 'other',
`ports` int(5) default NULL,
`secret` varchar(60) NOT NULL default 'secret',
`community` varchar(50) default NULL,
`description` varchar(200) default 'RADIUS Client',
PRIMARY KEY(`id`),
KEY `nasname` (`nasname`)
) TYPE=MyISAM;
#
# Dumping data for table 'nas'
#
INSERT INTO `nas` VALUES (1,'nas1.icci.com.cn','nas1','linux',500,'Radius.icci','192.168.1.250','Mikrotik access server');
#
# Table structure for table 'radacct'
#
DROP TABLE IF EXISTS `radacct`;
CREATE TABLE `radacct` (
`RadAcctId` bigint(21) NOT NULL auto_increment,
`AcctSessionId` varchar(32) NOT NULL default '',
`AcctUniqueId` varchar(32) NOT NULL default '',
`UserName` varchar(64) NOT NULL default '',
`Realm` varchar(64) default '',
`NASIPAddress` varchar(15) NOT NULL default '',
`NASPortId` int(12) default NULL,
`NASPortType` varchar(32) default NULL,
`AcctStartTime` datetime NOT NULL default '0000-00-00 00:00:00',
`AcctStopTime` datetime NOT NULL default '0000-00-00 00:00:00',
`AcctSessionTime` int(12) default NULL,
`AcctAuthentic` varchar(32) default NULL,
`ConnectInfo_start` varchar(32) default NULL,
`ConnectInfo_stop` varchar(32) default NULL,
`AcctInputOctets` bigint(12) default NULL,
`AcctOutputOctets` bigint(12) default NULL,
`CalledStationId` varchar(50) NOT NULL default '',
`CallingStationId` varchar(50) NOT NULL default '',
`AcctTerminateCause` varchar(32) NOT NULL default '',
`ServiceType` varchar(32) default NULL,
`FramedProtocol` varchar(32) default NULL,
`FramedIPAddress` varchar(15) NOT NULL default '',
`AcctStartDelay` int(12) default NULL,
`AcctStopDelay` int(12) default NULL,
PRIMARY KEY(`RadAcctId`),
KEY `UserName` (`UserName`),
KEY `FramedIPAddress` (`FramedIPAddress`),
KEY `AcctSessionId` (`AcctSessionId`),
KEY `AcctUniqueId` (`AcctUniqueId`),
KEY `AcctStartTime` (`AcctStartTime`),
KEY `AcctStopTime` (`AcctStopTime`),
KEY `NASIPAddress` (`NASIPAddress`)
) TYPE=MyISAM;
#
# Dumping data for table 'radacct'
#
INSERT INTO `radacct` VALUES (1,'81000084','9afb8166fa8ed8a7','test1','','192.168.1.250',4377,'Virtual','2005-07-23 09:58:29','2005-07-23 09:59:11',43,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (2,'81000085','37f555dd19fd0603','test1','','192.168.1.250',4378,'Virtual','2005-07-23 09:59:18','2005-07-23 09:59:56',37,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (3,'81000086','69dcbb669a14e3dd','test1','','192.168.1.250',4388,'Virtual','2005-07-23 10:14:49','0000-00-00 00:00:00',0,'RADIUS','','',0,0,'192.168.1.250','192.168.1.51','','Framed-User','PPP','192.168.21.199',0,0);
INSERT INTO `radacct` VALUES (4,'81000087','586745aad18c3378','test1','','192.168.1.250',4396,'Virtual','2005-07-23 10:22:57','0000-00-00 00:00:00',0,'RADIUS','','',0,0,'192.168.1.250','192.168.1.51','','Framed-User','PPP','192.168.21.202',0,0);
INSERT INTO `radacct` VALUES (5,'81000088','9edb9ae2c4a070f1','test1','','192.168.1.250',4402,'Virtual','2005-07-23 10:30:23','2005-07-23 10:32:30',127,'RADIUS','','',4293,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.198',0,0);
INSERT INTO `radacct` VALUES (6,'81000089','3d789a61651e2f9b','test1','','192.168.1.250',4403,'Virtual','2005-07-23 10:32:38','2005-07-23 10:36:31',233,'RADIUS','','',3377,110,'192.168.1.250','192.168.1.51','Session-Timeout','Framed-User','PPP','192.168.21.193',0,0);
INSERT INTO `radacct` VALUES (7,'8100008a','dda6ab5ce4f83fed','test1','','192.168.1.250',4415,'Virtual','2005-07-23 11:29:28','2005-07-23 11:30:27',59,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.207',0,0);
INSERT INTO `radacct` VALUES (8,'8100008b','67d26c7e4503a80e','test1','','192.168.1.250',4417,'Virtual','2005-07-23 11:30:32','0000-00-00 00:00:00',0,'RADIUS','','',0,0,'192.168.1.250','192.168.1.51','','Framed-User','PPP','192.168.21.180',0,0);
INSERT INTO `radacct` VALUES (9,'8100008c','8159137021489efd','test1','','192.168.1.250',4430,'Virtual','2005-07-23 12:24:46','2005-07-23 12:35:26',641,'RADIUS','','',143596,283385,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.169',0,0);
INSERT INTO `radacct` VALUES (10,'8100008d','40618e974e37bdbd','test1','','192.168.1.250',4433,'Virtual','2005-07-23 12:35:34','2005-07-23 12:36:50',76,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.173',0,0);
INSERT INTO `radacct` VALUES (11,'8100008e','d391fcb30f440b5e','test1','','192.168.1.250',4435,'Virtual','2005-07-23 12:37:36','2005-07-23 12:38:17',40,'RADIUS','','',1264,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.175',0,0);
INSERT INTO `radacct` VALUES (12,'8100008f','0c6b271c9adf354a','test1','','192.168.1.250',4436,'Virtual','2005-07-23 12:39:05','2005-07-23 12:40:30',85,'RADIUS','','',3382,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.163',0,0);
INSERT INTO `radacct` VALUES (13,'81000090','9a5905969527356a','test1','','192.168.1.250',4438,'Virtual','2005-07-23 12:40:40','2005-07-23 12:41:20',40,'RADIUS','','',4161,110,'192.168.1.250','192.168.1.53','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (14,'81000091','9a97a735023b2bd9','test1','','192.168.1.250',4441,'Virtual','2005-07-23 12:41:32','2005-07-23 12:43:03',90,'RADIUS','','',2184,110,'192.168.1.250','192.168.1.53','User-Request','Framed-User','PPP','192.168.21.160',0,0);
INSERT INTO `radacct` VALUES (15,'81000092','1cd93aaa51cf6797','test1','','192.168.1.250',4451,'Virtual','2005-07-23 12:45:01','2005-07-23 12:45:35',35,'RADIUS','','',3890,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.215',0,0);
INSERT INTO `radacct` VALUES (16,'81000093','d8aeb90307634b8d','test1','','192.168.1.250',4453,'Virtual','2005-07-23 12:45:51','2005-07-23 12:47:21',91,'RADIUS','','',1992,110,'192.168.1.250','192.168.1.53','User-Request','Framed-User','PPP','192.168.21.179',0,0);
INSERT INTO `radacct` VALUES (17,'81000094','e0c3a9a5a3714bdd','test1','','192.168.1.250',4456,'Virtual','2005-07-23 12:47:37','2005-07-23 12:51:10',213,'RADIUS','','',26480,18544,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.156',0,0);
INSERT INTO `radacct` VALUES (18,'81000095','536ee1ac09488e3c','test1','','192.168.1.250',4458,'Virtual','2005-07-23 12:51:16','2005-07-23 12:52:00',44,'RADIUS','','',3382,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.155',0,0);
INSERT INTO `radacct` VALUES (19,'81000096','33c6c8bda103b167','test1','','192.168.1.250',4460,'Virtual','2005-07-23 12:52:49','2005-07-23 13:02:57',608,'RADIUS','','',3377,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.153',0,0);
INSERT INTO `radacct` VALUES (20,'81000097','9dd1c84627c8e6d2','test1','','192.168.1.250',4462,'Virtual','2005-07-23 13:03:03','2005-07-23 13:23:22',1218,'RADIUS','','',5382,110,'192.168.1.250','192.168.1.51','Session-Timeout','Framed-User','PPP','192.168.21.152',0,0);
INSERT INTO `radacct` VALUES (21,'81000098','4f7198fbc85829cb','test1','','192.168.1.250',4476,'Virtual','2005-07-23 13:56:01','2005-07-23 13:58:11',131,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (22,'81000099','9cc35f62c3abae85','test1','','192.168.1.250',4478,'Virtual','2005-07-23 14:03:04','2005-07-23 14:05:07',124,'RADIUS','','',14877,7776,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (23,'8100009a','948d78515c437005','test1','','192.168.1.250',4480,'Virtual','2005-07-23 14:07:25','2005-07-23 14:14:05',401,'RADIUS','','',4730,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.190',0,0);
INSERT INTO `radacct` VALUES (24,'8100009b','ac7a7c6367b498c0','test1','','192.168.1.250',4482,'Virtual','2005-07-23 14:14:11','2005-07-23 14:15:54',103,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.134',0,0);
INSERT INTO `radacct` VALUES (25,'8100009c','252d4378d63d525a','test1','','192.168.1.250',4484,'Virtual','2005-07-23 14:17:31','2005-07-23 15:04:25',2814,'RADIUS','','',747181,4590150,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.229',0,0);
INSERT INTO `radacct` VALUES (26,'8100009d','23131e50afeae56f','wendyzh','','192.168.1.250',4485,'Virtual','2005-07-23 14:18:35','2005-07-23 14:22:05',211,'RADIUS','','',6464,110,'192.168.1.250','192.168.1.53','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (27,'8100009e','efd711edb60a6b06','wendyzh','','192.168.1.250',4487,'Virtual','2005-07-23 14:23:04','2005-07-23 14:26:27',203,'RADIUS','','',5199,110,'192.168.1.250','192.168.1.53','User-Request','Framed-User','PPP','192.168.21.129',0,0);
INSERT INTO `radacct` VALUES (28,'8100009f','0eebd73e671dff08','test1','','192.168.1.250',4499,'Virtual','2005-07-23 15:20:32','2005-07-23 15:20:59',27,'RADIUS','','',3148,110,'192.168.1.250','192.168.1.51','Session-Timeout','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (29,'810000a0','7c9cea22b2536398','test1','','192.168.1.250',4502,'Virtual','2005-07-23 15:22:02','2005-07-23 16:22:02',3600,'RADIUS','','',26418,23416,'192.168.1.250','192.168.1.51','Session-Timeout','Framed-User','PPP','192.168.21.249',0,0);
INSERT INTO `radacct` VALUES (30,'810000a1','9454685d5940d993','test1','','192.168.1.250',4527,'Virtual','2005-07-23 17:27:38','2005-07-25 08:13:11',139534,'RADIUS','','',429649,587793,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.141',0,0);
INSERT INTO `radacct` VALUES (31,'810000a2','7443f8129d9ab57c','wendyzh','','192.168.1.250',4553,'Virtual','2005-07-23 19:32:28','2005-07-23 19:49:54',1046,'RADIUS','','',587805,2183119,'','221.201.213.29','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (32,'810000a3','e49fe2bc9b20fd30','wendyzh','','192.168.1.250',4640,'Virtual','2005-07-24 15:26:14','2005-07-24 15:30:19',244,'RADIUS','','',104078,441019,'','221.201.213.165','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (33,'810000a4','60c0e4a713b4f9b4','wendyzh','','192.168.1.250',4641,'Virtual','2005-07-24 15:30:33','2005-07-24 15:31:19',46,'RADIUS','','',23836,76871,'','221.201.213.165','User-Request','Framed-User','PPP','192.168.21.55',0,0);
INSERT INTO `radacct` VALUES (34,'810000a5','5b64206e08839c89','test1','','192.168.1.250',4702,'Virtual','2005-07-25 08:17:09','2005-07-25 08:37:46',1237,'RADIUS','','',13702072,225519,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.168',0,0);
INSERT INTO `radacct` VALUES (35,'810000a6','ef2d477da6dcef79','test1','','192.168.1.250',4724,'Virtual','2005-07-25 11:21:17','2005-07-25 11:21:30',13,'RADIUS','','',2941,110,'192.168.1.250','192.168.1.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (41,'810000ac','f083623fa3f99cc1','test1','','192.168.31.250',6698,'Virtual','2005-08-05 13:16:35','2005-08-05 13:21:09',274,'RADIUS','','',129367,282493,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (37,'810000a8','f70812db21dc3cde','test1','','192.168.31.250',4989,'Virtual','2005-07-27 08:07:02','2005-07-27 09:15:07',4084,'RADIUS','','',29556499,7637927,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.148',0,0);
INSERT INTO `radacct` VALUES (38,'810000a9','d3a47ec04f70bad4','wendyzh','','192.168.31.250',5824,'Virtual','2005-07-30 22:30:39','2005-07-30 22:35:37',299,'RADIUS','','',12030,79877,'','60.20.188.153','User-Request','Framed-User','PPP','192.168.21.133',0,0);
INSERT INTO `radacct` VALUES (39,'810000aa','c42ecfd34492890e','test1','','192.168.31.250',6091,'Virtual','2005-08-02 09:41:51','2005-08-02 09:43:27',96,'RADIUS','','',18135,179453,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (40,'810000ab','b90236f81e186d12','test1','','192.168.31.250',6093,'Virtual','2005-08-02 09:43:49','2005-08-02 09:46:31',162,'RADIUS','','',3905,110,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.51',0,0);
INSERT INTO `radacct` VALUES (42,'810000ad','ecfd6b2b2eb7ff88','test1','','192.168.31.250',6701,'Virtual','2005-08-05 13:29:26','2005-08-05 13:30:48',82,'RADIUS','','',3325,421,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (43,'810000ae','5349b094c7c9846f','test1','','192.168.31.250',6705,'Virtual','2005-08-05 13:32:43','2005-08-05 13:33:39',56,'RADIUS','','',11428,3890,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.204',0,0);
INSERT INTO `radacct` VALUES (44,'810000af','260b0b88c3270228','test1','','192.168.31.250',8223,'Virtual','2005-08-16 17:40:13','2005-08-16 17:40:45',32,'RADIUS','','',2947128,4492,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (45,'810000b0','62d59f751d953dff','test1','','192.168.31.250',9279,'Virtual','2005-08-23 09:24:28','2005-08-23 09:25:20',51,'RADIUS','','',42338,258429,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (46,'810000b1','0648976766d2eca6','test1','','192.168.31.250',9280,'Virtual','2005-08-23 09:25:48','2005-08-23 09:26:04',17,'RADIUS','','',52754,184946,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.150',0,0);
INSERT INTO `radacct` VALUES (47,'810000b2','c548bc5e01bb1f5d','test1','','192.168.31.250',9474,'Virtual','2005-08-24 13:54:44','2005-08-24 14:04:44',599,'RADIUS','','',553719,22035551,'','192.168.16.206','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (48,'810000b3','b8778ceb280384c2','test1','','192.168.31.250',9481,'Ethernet','2005-08-24 14:21:29','2005-08-24 14:29:05',456,'RADIUS','','',578833,27440061,'PPPOE_Coffee','00:0D:60:01:05:6F','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (49,'810000b4','8bc54d7da6029775','test1','','192.168.31.250',9504,'Ethernet','2005-08-24 14:31:21','2005-08-24 14:32:15',54,'RADIUS','','',45661,1307510,'PPPOE_Coffee','00:0D:60:01:05:6F','User-Request','Framed-User','PPP','192.168.21.219',0,0);
INSERT INTO `radacct` VALUES (50,'810000b5','e956c4ad226b763d','test1','','192.168.31.250',9508,'Ethernet','2005-08-24 14:33:00','2005-08-24 14:33:31',31,'RADIUS','','',13357,36972,'PPPOE_Coffee','00:0D:60:01:05:6F','User-Request','Framed-User','PPP','192.168.21.248',0,0);
INSERT INTO `radacct` VALUES (51,'810000b6','4d28688600261206','test1','','192.168.31.250',9512,'Ethernet','2005-08-24 14:35:23','2005-08-24 14:35:57',35,'RADIUS','','',29096,456537,'PPPOE_Coffee','00:0D:60:01:05:6F','User-Request','Framed-User','PPP','192.168.21.210',0,0);
INSERT INTO `radacct` VALUES (52,'810000b7','c2330f074dd9977d','test1','','192.168.31.250',9516,'Ethernet','2005-08-24 14:37:28','2005-08-24 14:48:36',668,'RADIUS','','',225739,6482469,'PPPOE_Coffee','00:0D:60:01:05:6F','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (53,'810000b8','d971d6b0501cae4b','test1','','192.168.31.250',9568,'Virtual','2005-08-24 19:07:15','2005-08-24 19:10:03',167,'RADIUS','','',22315,127080,'','60.20.227.152','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (54,'810000b9','1b427153e820212c','test1','','192.168.31.250',9570,'Virtual','2005-08-24 19:10:11','2005-08-24 19:10:39',27,'RADIUS','','',20340,10487,'','60.20.227.152','User-Request','Framed-User','PPP','192.168.21.150',0,0);
INSERT INTO `radacct` VALUES (55,'810000ba','d6dce6b2ea5e6a9c','test1','','192.168.31.250',9574,'Virtual','2005-08-24 19:11:41','2005-08-24 19:16:37',296,'RADIUS','','',58936,212744,'','60.20.227.152','User-Request','Framed-User','PPP','192.168.21.149',0,0);
INSERT INTO `radacct` VALUES (56,'810000bb','72c86aaba74623cd','test1','','192.168.31.250',9576,'Virtual','2005-08-24 19:16:45','2005-08-24 19:38:04',1279,'RADIUS','','',506945,17448977,'','60.20.227.152','User-Request','Framed-User','PPP','192.168.21.147',0,0);
INSERT INTO `radacct` VALUES (57,'810000bc','79202e02521a9668','test1','','192.168.31.250',9733,'Virtual','2005-08-26 09:49:00','2005-08-26 10:13:20',1461,'RADIUS','','',7817,1042,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.252',0,0);
INSERT INTO `radacct` VALUES (58,'810000bd','a3d9f90554b622cd','test1','','192.168.31.250',9739,'Virtual','2005-08-26 10:13:35','2005-08-26 10:39:32',1557,'RADIUS','','',101917,598955,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (59,'810000be','dcf96220e5287326','test1','','192.168.31.250',9744,'Virtual','2005-08-26 10:39:39','2005-08-26 10:40:13',35,'RADIUS','','',3148,110,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.55',0,0);
INSERT INTO `radacct` VALUES (60,'810000bf','25f85adfaf025bb4','test1','','192.168.31.250',9797,'Virtual','2005-08-26 17:11:14','2005-08-28 09:56:59',146746,'RADIUS','','',2842440648,1430514440,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.178',0,0);
INSERT INTO `radacct` VALUES (61,'810000c0','71b408634557110b','test1','','192.168.31.250',11543,'Virtual','2005-09-07 20:38:00','2005-09-07 20:43:18',318,'RADIUS','','',502167,21525010,'','60.20.189.91','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (62,'810000c1','0e1cd317d1b46da8','test1','','192.168.31.250',11545,'Virtual','2005-09-07 20:45:37','2005-09-07 20:52:27',411,'RADIUS','','',567037,4262537,'','60.20.189.91','User-Request','Framed-User','PPP','192.168.21.214',0,0);
INSERT INTO `radacct` VALUES (63,'810000c2','a2387065394ee5fd','test1','','192.168.31.250',11546,'Virtual','2005-09-07 20:53:42','2005-09-07 21:15:04',1282,'RADIUS','','',1472074,9718294,'','60.20.189.91','User-Request','Framed-User','PPP','192.168.21.247',0,0);
INSERT INTO `radacct` VALUES (64,'810000c3','d33e180d0772361a','test1','','192.168.31.250',11548,'Virtual','2005-09-07 21:20:04','2005-09-07 21:20:23',18,'RADIUS','','',3941,110,'','60.20.189.91','User-Request','Framed-User','PPP','192.168.21.227',0,0);
INSERT INTO `radacct` VALUES (65,'810000c4','c2b6edbb9eb21dbd','test1','','192.168.31.250',11549,'Virtual','2005-09-07 21:21:29','2005-09-07 21:23:52',142,'RADIUS','','',16357,141363,'','60.20.189.91','NAS-Request','Framed-User','PPP','192.168.21.254',0,16777216);
INSERT INTO `radacct` VALUES (66,'810000c5','848693e76b008408','test1','','192.168.31.250',11550,'Virtual','2005-09-07 21:24:32','2005-09-07 21:24:49',17,'RADIUS','','',3648,110,'','60.20.190.85','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (67,'810000c6','d9aac9ae13862c0b','test1','','192.168.31.250',11551,'Virtual','2005-09-07 21:30:46','2005-09-07 21:32:28',102,'RADIUS','','',6230,2820,'','60.20.190.85','User-Request','Framed-User','PPP','192.168.21.219',0,0);
INSERT INTO `radacct` VALUES (68,'810000c7','788f530fe445afc7','test1','','192.168.31.250',11552,'Virtual','2005-09-07 21:34:18','2005-09-07 21:34:44',27,'RADIUS','','',4411,110,'','60.20.190.85','User-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (69,'810000c8','83b6379df9becfa2','test1','','192.168.31.250',11553,'Virtual','2005-09-07 21:39:44','2005-09-07 21:52:17',752,'RADIUS','','',1129743,6766766,'','60.20.190.85','User-Request','Framed-User','PPP','192.168.21.65',0,0);
INSERT INTO `radacct` VALUES (70,'810000c9','3b3a99899bb494d9','test1','','192.168.31.250',12094,'Virtual','2005-09-11 11:03:13','2005-09-11 11:05:35',143,'RADIUS','','',91793,1290971,'','60.20.224.83','NAS-Request','Framed-User','PPP','192.168.21.254',0,0);
INSERT INTO `radacct` VALUES (71,'81000000','e1f6da598dd17b08','test1','','192.168.31.250',14,'Virtual','2005-09-14 08:52:28','2005-09-14 08:55:28',180,'RADIUS','','',26172,147111,'192.168.31.250','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.253',0,0);
INSERT INTO `radacct` VALUES (72,'81000001','de8190d64d4c8da2','test1','','192.168.31.250',15,'Virtual','2005-09-14 09:01:52','2005-09-14 09:04:52',180,'RADIUS','','',2781,110,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.251',0,0);
INSERT INTO `radacct` VALUES (73,'81000002','71429f2d3cd296d0','wendyzh','','192.168.31.250',16,'Virtual','2005-09-14 09:02:32','2005-09-14 09:03:37',65,'RADIUS','','',2962,383,'192.168.31.250','192.168.31.51','NAS-Request','Framed-User','PPP','192.168.21.249',0,0);
INSERT INTO `radacct` VALUES (74,'81000003','3a94cd2a0608a439','wendyzh','','192.168.31.250',17,'Virtual','2005-09-14 09:03:59','2005-09-14 09:04:55',56,'RADIUS','','',3172,344,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.21.247',0,0);
INSERT INTO `radacct` VALUES (75,'81000004','e7b15c30acf3c3e7','test1','','192.168.31.250',116,'Virtual','2005-09-14 17:49:10','2005-09-14 17:58:47',577,'RADIUS','','',44810,40562,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (76,'81000005','5fe1cc19e698947b','test1','','192.168.31.250',119,'Virtual','2005-09-14 17:58:55','2005-09-14 17:58:56',1,'RADIUS','','',110,86,'','192.168.31.51','User-Request','Framed-User','PPP','0.0.0.0',0,0);
INSERT INTO `radacct` VALUES (77,'81000006','bbd65331c267ef1f','test1','','192.168.31.250',120,'Virtual','2005-09-14 17:59:13','2005-09-14 17:59:13',0,'RADIUS','','',110,86,'','192.168.31.51','User-Request','Framed-User','PPP','0.0.0.0',0,0);
INSERT INTO `radacct` VALUES (78,'81000007','f0138af0863fbdc7','test1','','192.168.31.250',121,'Virtual','2005-09-14 17:59:47','2005-09-14 17:59:47',0,'RADIUS','','',110,86,'','192.168.31.51','User-Request','Framed-User','PPP','0.0.0.0',0,0);
INSERT INTO `radacct` VALUES (79,'81000008','5fd091cfca42397d','test1','','192.168.31.250',122,'Virtual','2005-09-14 18:00:25','2005-09-14 18:05:50',325,'RADIUS','','',26614,25732,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (80,'81000009','7d9843b1cad797b3','test1','','192.168.31.250',124,'Virtual','2005-09-14 18:06:11','2005-09-14 18:07:22',72,'RADIUS','','',9046,12038,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (81,'8100000a','6ba6806a84dbe007','test1','','192.168.31.250',125,'Virtual','2005-09-14 18:07:30','2005-09-14 18:10:31',181,'RADIUS','','',357906,12797154,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.251',0,0);
INSERT INTO `radacct` VALUES (82,'8100000b','539b096edc37b1c6','test1','','192.168.31.250',144,'Virtual','2005-09-14 19:43:15','2005-09-14 19:50:13',418,'RADIUS','','',105625,1054115,'','60.20.227.111','User-Request','Framed-User','PPP','192.168.59.250',0,0);
INSERT INTO `radacct` VALUES (83,'8100000c','f4fc14eb12e14a1e','test1','','192.168.31.250',165,'Virtual','2005-09-15 08:01:07','2005-09-15 08:04:02',175,'RADIUS','','',13194,10080,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.249',0,0);
INSERT INTO `radacct` VALUES (84,'8100000d','4f1ee208ceabf5aa','test1','','192.168.31.250',166,'Virtual','2005-09-15 08:04:11','2005-09-15 08:05:59',109,'RADIUS','','',7360,5090,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.248',0,0);
INSERT INTO `radacct` VALUES (85,'8100000e','8ebb95bf497ca02a','test1','','192.168.31.250',167,'Virtual','2005-09-15 08:06:04','2005-09-15 08:08:33',150,'RADIUS','','',14179,15872,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.247',0,0);
INSERT INTO `radacct` VALUES (86,'8100000f','00d33492916eb013','test1','','192.168.31.250',168,'Virtual','2005-09-15 08:08:39','2005-09-15 08:10:13',93,'RADIUS','','',10162,11794,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.246',0,0);
INSERT INTO `radacct` VALUES (87,'81000010','553314cced202c73','test1','','192.168.31.250',169,'Virtual','2005-09-15 08:13:42','2005-09-15 08:14:46',64,'RADIUS','','',5620,3350,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.245',0,0);
INSERT INTO `radacct` VALUES (88,'81000011','313ac0175c0d5539','test1','','192.168.31.250',170,'Virtual','2005-09-15 08:14:54','2005-09-15 08:14:54',0,'RADIUS','','',110,86,'','192.168.31.51','User-Request','Framed-User','PPP','0.0.0.0',0,0);
INSERT INTO `radacct` VALUES (89,'81000012','efbd7bbd132d0837','test1','','192.168.31.250',171,'Virtual','2005-09-15 08:16:53','2005-09-15 08:20:13',201,'RADIUS','','',19587,19184,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.244',0,0);
INSERT INTO `radacct` VALUES (90,'81000013','371de022ffb0e5e8','test1','','192.168.31.250',172,'Virtual','2005-09-15 08:20:22','2005-09-15 08:26:27',364,'RADIUS','','',29740,27748,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.243',0,0);
INSERT INTO `radacct` VALUES (91,'81000014','23a7e9d18605cd5f','test1','','192.168.31.250',173,'Virtual','2005-09-15 08:26:36','2005-09-15 08:29:11',156,'RADIUS','','',49384,107845,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.242',0,0);
INSERT INTO `radacct` VALUES (92,'81000015','75d48ea540429a47','test1','','192.168.31.250',174,'Virtual','2005-09-15 08:29:18','2005-09-15 08:31:52',154,'RADIUS','','',15231,17687,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.241',0,0);
INSERT INTO `radacct` VALUES (93,'81000016','8f321e33391e93b7','test1','','192.168.31.250',175,'Virtual','2005-09-15 08:32:04','2005-09-15 08:33:03',60,'RADIUS','','',4452,2570,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.240',0,0);
INSERT INTO `radacct` VALUES (94,'81000017','244fb356c24c9232','test1','','192.168.31.250',176,'Virtual','2005-09-15 08:33:09','2005-09-15 08:34:25',76,'RADIUS','','',8702,10753,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.239',0,0);
INSERT INTO `radacct` VALUES (95,'81000018','a7c99eaba25cdfc3','test1','','192.168.31.250',177,'Virtual','2005-09-15 08:34:33','2005-09-15 08:35:16',42,'RADIUS','','',3920,1550,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.238',0,0);
INSERT INTO `radacct` VALUES (96,'81000019','a77b9f0b151ee920','test1','','192.168.31.250',178,'Virtual','2005-09-15 08:36:09','2005-09-15 08:36:41',33,'RADIUS','','',3614,1620,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.237',0,0);
INSERT INTO `radacct` VALUES (97,'8100001a','bade9deb5a102616','test1','','192.168.31.250',179,'Virtual','2005-09-15 08:36:47','2005-09-15 08:37:41',55,'RADIUS','','',7830,10633,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.236',0,0);
INSERT INTO `radacct` VALUES (98,'8100001b','c960e51822b6d085','test1','','192.168.31.250',180,'Virtual','2005-09-15 08:37:58','2005-09-15 08:38:12',13,'RADIUS','','',2388,290,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.235',0,0);
INSERT INTO `radacct` VALUES (99,'8100001c','8610e1d252ae8fd0','test1','','192.168.31.250',181,'Virtual','2005-09-15 08:38:28','2005-09-15 08:41:07',159,'RADIUS','','',15685,16962,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.234',0,0);
INSERT INTO `radacct` VALUES (100,'8100001d','8d55780ae2ae97f7','test1','','192.168.31.250',182,'Virtual','2005-09-15 08:41:31','2005-09-15 08:43:04',93,'RADIUS','','',7860,5549,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.233',0,0);
INSERT INTO `radacct` VALUES (101,'8100001e','73210abb9bb0774b','test1','','192.168.31.250',183,'Virtual','2005-09-15 08:43:10','2005-09-15 08:43:50',40,'RADIUS','','',2656,830,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.232',0,0);
INSERT INTO `radacct` VALUES (102,'8100001f','b6cffb939ae1e0dd','test1','','192.168.31.250',184,'Virtual','2005-09-15 08:43:57','2005-09-15 08:45:13',75,'RADIUS','','',6916,4391,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.231',0,0);
INSERT INTO `radacct` VALUES (103,'81000020','9c961fc0099fc5da','test1','','192.168.31.250',185,'Virtual','2005-09-15 08:45:19','2005-09-15 08:45:41',22,'RADIUS','','',2306,480,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.230',0,0);
INSERT INTO `radacct` VALUES (104,'81000021','5d40d20f2c917d3a','test1','','192.168.31.250',186,'Virtual','2005-09-15 08:45:47','2005-09-15 08:46:36',49,'RADIUS','','',6534,7595,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.229',0,0);
INSERT INTO `radacct` VALUES (105,'81000022','2a6453d74b0e626c','test1','','192.168.31.250',187,'Virtual','2005-09-15 08:46:42','2005-09-15 08:59:56',795,'RADIUS','','',63561,53779,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.228',0,0);
INSERT INTO `radacct` VALUES (106,'81000023','9686644c162896a5','test1','','192.168.31.250',188,'Virtual','2005-09-15 09:00:02','2005-09-15 09:00:49',46,'RADIUS','','',3975,1920,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.227',0,0);
INSERT INTO `radacct` VALUES (107,'81000024','8fef65869a918e5c','test1','','192.168.31.250',189,'Virtual','2005-09-15 09:00:55','2005-09-15 09:01:42',47,'RADIUS','','',7376,9923,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.226',0,0);
INSERT INTO `radacct` VALUES (108,'81000025','e906ce050e58ba19','test1','','192.168.31.250',190,'Virtual','2005-09-15 09:01:48','2005-09-15 10:59:10',7042,'RADIUS','','',190208,435820,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.225',0,0);
INSERT INTO `radacct` VALUES (109,'81000026','892f9249eb36e999','test1','','192.168.31.250',198,'Virtual','2005-09-15 11:00:57','2005-09-15 11:06:19',322,'RADIUS','','',86029,1075624,'','192.168.31.51','NAS-Request','Framed-User','PPP','192.168.59.224',0,0);
INSERT INTO `radacct` VALUES (110,'81000027','8557ae89a82dd333','test1','','192.168.31.250',200,'Virtual','2005-09-15 11:06:49','2005-09-15 11:07:44',55,'RADIUS','','',70675,1912592,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.223',0,0);
INSERT INTO `radacct` VALUES (111,'81000028','4318b4c8c6a6f970','test1','','192.168.31.250',203,'Virtual','2005-09-15 11:16:16','2005-09-15 11:19:14',178,'RADIUS','','',50308,276341,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.222',0,0);
INSERT INTO `radacct` VALUES (112,'81000029','74ccfc5af3f80ab7','test1','','192.168.31.250',204,'Virtual','2005-09-15 11:19:21','2005-09-15 11:24:40',320,'RADIUS','','',6891,1519,'','192.168.31.51','User-Request','Framed-User','PPP','192.168.59.221',0,0);
INSERT INTO `radacct` VALUES (113,'81100000','516fb76f2f35ad85','test1','','192.168.31.250',43,'Virtual','2005-09-16 20:21:57','2005-09-16 20:38:59',1022,'RADIUS','','',562171,6035991,'','60.20.228.53','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (114,'81100001','0be652afc3c84f24','test1','','192.168.31.250',50,'Virtual','2005-09-17 06:09:50','2005-09-17 07:01:56',3127,'RADIUS','','',1460357,10698748,'','60.20.178.96','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (115,'81100002','f7efa655facfb7ac','test1','','192.168.31.250',286,'Virtual','2005-09-18 20:56:37','2005-09-18 20:59:16',159,'RADIUS','','',404064,1329289,'','60.20.184.243','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (116,'81100003','23d586f3cdb3cc3c','test1','','192.168.31.250',666,'Virtual','2005-09-21 19:51:33','2005-09-21 19:53:48',135,'RADIUS','','',57373,133753,'','60.20.183.123','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (117,'81100004','1f3a4d9a39d4e84b','test1','','192.168.31.250',668,'Virtual','2005-09-21 19:54:18','2005-09-21 19:56:50',152,'RADIUS','','',32966,83957,'','60.20.228.71','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (118,'81100005','2593fa246693415a','test1','','192.168.31.250',669,'Virtual','2005-09-21 19:57:39','2005-09-21 21:24:49',5230,'RADIUS','','',41105,56364,'','60.20.177.155','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (119,'81100006','0dcff6013557d350','test1','','192.168.31.250',743,'Virtual','2005-09-22 19:47:44','2005-09-22 19:57:01',556,'RADIUS','','',1246265,4935396,'','60.20.227.145','User-Request','Framed-User','PPP','192.168.59.251',0,0);
INSERT INTO `radacct` VALUES (120,'81100007','35ce3eb15393a6d6','test1','','192.168.31.250',876,'Virtual','2005-09-23 19:43:45','2005-09-23 19:55:32',707,'RADIUS','','',2404117,10763182,'','60.20.187.25','User-Request','Framed-User','PPP','192.168.59.250',0,0);
INSERT INTO `radacct` VALUES (121,'81100008','67255b7f6febe427','test1','','192.168.31.250',880,'Virtual','2005-09-23 20:01:23','2005-09-23 20:01:52',29,'RADIUS','','',17806,39013,'','60.20.227.198','User-Request','Framed-User','PPP','192.168.59.249',0,0);
INSERT INTO `radacct` VALUES (122,'81100009','f8e83c9980e0ba83','test1','','192.168.31.250',881,'Virtual','2005-09-23 20:02:28','2005-09-23 20:07:37',309,'RADIUS','','',598153,3192078,'','60.20.227.198','User-Request','Framed-User','PPP','192.168.59.248',0,0);
INSERT INTO `radacct` VALUES (123,'8110000a','2f4c339084f65275','test1','','192.168.31.250',899,'Virtual','2005-09-24 11:30:02','2005-09-24 12:48:24',4703,'RADIUS','','',173579,248825,'','60.20.184.84','NAS-Request','Framed-User','PPP','192.168.59.247',0,0);
INSERT INTO `radacct` VALUES (124,'8110000b','72fc56033c16559a','test1','','192.168.31.250',908,'Virtual','2005-09-24 12:50:16','2005-09-24 22:06:29',33379,'RADIUS','','',75609321,18871972,'','60.20.190.57','User-Request','Framed-User','PPP','192.168.59.246',0,0);
INSERT INTO `radacct` VALUES (125,'8110000c','72c705385b36f598','test1','','192.168.31.250',1011,'Virtual','2005-09-25 06:13:50','2005-09-25 06:33:36',1187,'RADIUS','','',466524,3080773,'','60.20.178.94','User-Request','Framed-User','PPP','192.168.59.245',0,0);
INSERT INTO `radacct` VALUES (126,'8110000d','7efd6bf3798d65f5','test1','','192.168.31.250',1012,'Virtual','2005-09-25 09:10:59','2005-09-25 09:28:40',1062,'RADIUS','','',63375,96475,'','60.20.188.11','User-Request','Framed-User','PPP','192.168.59.244',0,0);
INSERT INTO `radacct` VALUES (127,'8110000e','2fe69a86ef9c5393','test1','','192.168.31.250',1131,'Virtual','2005-09-25 20:02:20','2005-09-25 20:04:19',119,'RADIUS','','',205200,1008706,'','60.20.228.66','User-Request','Framed-User','PPP','192.168.59.243',0,0);
INSERT INTO `radacct` VALUES (128,'8110000f','6d5847ef8815e1cf','test1','','192.168.31.250',2202,'Virtual','2005-10-04 19:35:19','2005-10-04 19:42:01',403,'RADIUS','','',353658,2386359,'','60.20.178.46','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (129,'81100010','c6d3cb319b5b9e89','test1','','192.168.31.250',2347,'Virtual','2005-10-06 19:02:17','2005-10-06 19:04:05',107,'RADIUS','','',167336,3800810,'','60.20.228.217','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (130,'81100011','4c153a31fb141c23','test1','','192.168.31.250',2349,'Virtual','2005-10-06 19:06:44','2005-10-06 19:14:07',444,'RADIUS','','',825057,8875363,'','60.20.228.217','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (131,'81100012','38b6aad50efeca29','test1','','192.168.31.250',3352,'Virtual','2005-10-12 20:47:15','2005-10-12 20:52:24',308,'RADIUS','','',558798,6734423,'','60.20.231.207','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (132,'81100013','65a4d9c376e65936','test1','','192.168.31.250',3359,'Virtual','2005-10-13 06:19:58','2005-10-13 06:21:54',116,'RADIUS','','',210178,2088145,'','60.20.177.242','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (133,'81100014','61a679975f723757','test1','','192.168.31.250',3964,'Virtual','2005-10-18 16:36:18','2005-10-18 17:39:05',3767,'RADIUS','','',1275394,19206730,'','60.20.177.2','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (134,'81100015','a7a0d8b5d94409ba','test1','','192.168.31.250',3967,'Virtual','2005-10-18 18:30:52','2005-10-18 19:15:16',2665,'RADIUS','','',3183341,106798616,'','60.20.224.72','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (135,'81100016','9583a6dcbd6b872c','test1','','192.168.31.250',3991,'Virtual','2005-10-19 20:00:10','2005-10-19 20:03:35',205,'RADIUS','','',311905,6304135,'','60.20.230.116','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (136,'81100017','0bf7856c757b5953','test1','','192.168.31.250',3992,'Virtual','2005-10-19 20:20:09','2005-10-19 20:22:50',161,'RADIUS','','',228043,4529473,'','60.20.230.116','User-Request','Framed-User','PPP','192.168.59.251',0,0);
INSERT INTO `radacct` VALUES (137,'81100018','b946ce0ab9973b40','test1','','192.168.31.250',4005,'Virtual','2005-10-20 18:55:45','2005-10-20 19:39:25',2621,'RADIUS','','',3817298,111487858,'','60.20.226.196','User-Request','Framed-User','PPP','192.168.59.250',0,0);
INSERT INTO `radacct` VALUES (138,'81100019','9d5c411e5373b48d','test1','','192.168.31.250',4089,'Virtual','2005-10-26 21:50:57','2005-10-26 21:59:23',506,'RADIUS','','',742077,15862091,'','60.20.225.42','User-Request','Framed-User','PPP','192.168.59.249',0,0);
INSERT INTO `radacct` VALUES (139,'8110001a','57a2c3ff25ed51a7','test1','','192.168.31.250',4131,'Virtual','2005-10-29 17:35:24','2005-10-29 17:40:46',323,'RADIUS','','',279149,3759472,'','60.20.225.73','NAS-Request','Framed-User','PPP','192.168.59.248',0,0);
INSERT INTO `radacct` VALUES (140,'8110001b','13bd3adf1da9584f','test1','','192.168.31.250',4132,'Virtual','2005-10-29 17:49:55','2005-10-29 17:52:52',177,'RADIUS','','',365981,3885585,'','60.20.178.136','User-Request','Framed-User','PPP','192.168.59.247',0,0);
INSERT INTO `radacct` VALUES (141,'81200000','bad2c4c497170178','test1','','192.168.31.250',17,'Virtual','2005-10-31 20:17:07','2005-10-31 20:49:46',1959,'RADIUS','','',829986,10016194,'','60.20.189.214','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (142,'81200001','4391c32b5265d239','test1','','192.168.31.250',41,'Virtual','2005-11-03 20:38:16','2005-11-03 20:41:51',214,'RADIUS','','',395851,9685449,'','60.20.189.172','User-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (143,'81200002','a3318f15b15e2dcf','test1','','192.168.31.250',55,'Virtual','2005-11-04 20:49:07','2005-11-04 21:21:41',1954,'RADIUS','','',566700,9121547,'','60.20.229.236','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (144,'81200003','4fb0ef52f6428c44','test1','','192.168.31.250',64,'Virtual','2005-11-07 19:13:37','2005-11-07 19:26:13',755,'RADIUS','','',667731,12959478,'','60.20.229.75','User-Request','Framed-User','PPP','192.168.59.251',0,0);
INSERT INTO `radacct` VALUES (145,'81200004','da553218f389f212','test1','','192.168.31.250',65,'Virtual','2005-11-07 19:26:42','2005-11-07 19:31:15',273,'RADIUS','','',441751,13145448,'','60.20.184.180','User-Request','Framed-User','PPP','192.168.59.250',0,0);
INSERT INTO `radacct` VALUES (146,'81300000','65f2223814c02c83','test1','','192.168.31.250',15,'Virtual','2005-11-10 19:04:45','2005-11-10 19:09:22',276,'RADIUS','','',106893,133671,'','60.20.228.68','User-Request','Framed-User','PPP','192.168.59.254',0,0);
INSERT INTO `radacct` VALUES (147,'81300001','0db1f2ac56d4fed3','test1','','192.168.31.250',16,'Virtual','2005-11-10 19:09:50','2005-11-10 19:22:12',742,'RADIUS','','',909898,15487854,'','60.20.188.151','NAS-Request','Framed-User','PPP','192.168.59.253',0,0);
INSERT INTO `radacct` VALUES (148,'81300002','7cfa3ef194201679','test1','','192.168.31.250',17,'Virtual','2005-11-10 19:55:49','2005-11-10 21:14:15',4707,'RADIUS','','',3764753,88670744,'','60.20.184.117','User-Request','Framed-User','PPP','192.168.59.252',0,0);
INSERT INTO `radacct` VALUES (149,'81300003','8a9f4d3f10c13f59','test1','','192.168.31.250',34,'Virtual','2005-11-12 07:58:03','2005-11-12 07:58:46',43,'RADIUS','','',4490,195,'','60.20.176.108','User-Request','Framed-User','PPP','192.168.59.251',0,0);
INSERT INTO `radacct` VALUES (150,'81300004','83432d4af46b2548','test1','','192.168.31.250',37,'Virtual','2005-11-12 11:01:25','2005-11-12 12:21:17',4793,'RADIUS','','',2345660,45993390,'','60.20.185.241','User-Request','Framed-User','PPP','192.168.59.250',0,0);
INSERT INTO `radacct` VALUES (151,'81300005','d494222b64788ac0','test1','','192.168.31.250',39,'Virtual','2005-11-12 18:55:39','2005-11-12 19:31:02',2124,'RADIUS','','',447913,5190245,'','60.20.183.124','User-Request','Framed-User','PPP','192.168.59.249',0,0);
#
# Table structure for table 'radcheck'
#
DROP TABLE IF EXISTS `radcheck`;
CREATE TABLE `radcheck` (
`id` int(11) unsigned NOT NULL auto_increment,
`UserName` varchar(64) NOT NULL default '',
`Attribute` varchar(32) NOT NULL default '',
`op` char(2) NOT NULL default '==',
`Value` varchar(253) NOT NULL default '',
PRIMARY KEY(`id`),
KEY `UserName` (`UserName`(32))
) TYPE=MyISAM;
#
# Dumping data for table 'radcheck'
#
INSERT INTO `radcheck` VALUES (10,'test1','Simultaneous-Use',':=','1');
INSERT INTO `radcheck` VALUES (8,'test1','Password','==','123');
INSERT INTO `radcheck` VALUES (11,'test1','Auth-Type','==','MS-CHAP');
INSERT INTO `radcheck` VALUES (14,'wendyzh','Password','==','123');
INSERT INTO `radcheck` VALUES (13,'test1','Fall-Through',':=','1');
INSERT INTO `radcheck` VALUES (15,'wendyzh','Fall-Through',':=','Yes');
INSERT INTO `radcheck` VALUES (16,'wendyzh','Simultaneous-Use',':=','1');
INSERT INTO `radcheck` VALUES (17,'wendyzh','Auth-Type','==','MS-CHAP');
#
# Table structure for table 'radgroupcheck'
#
DROP TABLE IF EXISTS `radgroupcheck`;
CREATE TABLE `radgroupcheck` (
`id` int(11) unsigned NOT NULL auto_increment,
`GroupName` varchar(64) NOT NULL default '',
`Attribute` varchar(32) NOT NULL default '',
`op` char(2) NOT NULL default '==',
`Value` varchar(253) NOT NULL default '',
PRIMARY KEY(`id`),
KEY `GroupName` (`GroupName`(32))
) TYPE=MyISAM;
#
# Dumping data for table 'radgroupcheck'
#
INSERT INTO `radgroupcheck` VALUES (6,'test','Auth-Type','==','MS-CHAP');
INSERT INTO `radgroupcheck` VALUES (5,'test','Simultaneous-Use',':=','1');
#
# Table structure for table 'radgroupreply'
#
DROP TABLE IF EXISTS `radgroupreply`;
CREATE TABLE `radgroupreply` (
`id` int(11) unsigned NOT NULL auto_increment,
`GroupName` varchar(64) NOT NULL default '',
`Attribute` varchar(32) NOT NULL default '',
`op` char(2) NOT NULL default '=',
`Value` varchar(253) NOT NULL default '',
`prio` int(10) unsigned NOT NULL default '0',
PRIMARY KEY(`id`),
KEY `GroupName` (`GroupName`(32))
) TYPE=MyISAM;
#
# Dumping data for table 'radgroupreply'
#
INSERT INTO `radgroupreply` VALUES (25,'test','Rate-Limit','==','640000/640000',0);
INSERT INTO `radgroupreply` VALUES (24,'test','Framed-Pool',':=','MobileUser_VPN_Client',0);
INSERT INTO `radgroupreply` VALUES (15,'test','Framed-IP-Netmask',':=','255.255.255.255',0);
INSERT INTO `radgroupreply` VALUES (14,'test','Framed-IP-Address',':=','255.255.255.254',0);
INSERT INTO `radgroupreply` VALUES (13,'test','Framed-Compression',':=','None',0);
INSERT INTO `radgroupreply` VALUES (12,'test','Framed-Protocol',':=','PPP',0);
INSERT INTO `radgroupreply` VALUES (11,'test','Port-Limit','==','1',0);
INSERT INTO `radgroupreply` VALUES (22,'test','Group',':=','PPPOE_Isp',0);
INSERT INTO `radgroupreply` VALUES (23,'test','Framed-Pool',':=','MobileUser_VPN_Client',0);
#
# Table structure for table 'radpostauth'
#
DROP TABLE IF EXISTS `radpostauth`;
CREATE TABLE `radpostauth` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(64) NOT NULL default '',
`pass` varchar(64) NOT NULL default '',
`reply` varchar(32) NOT NULL default '',
`date` timestamp(14) NOT NULL,
PRIMARY KEY(`id`)
) TYPE=MyISAM;
#
# Dumping data for table 'radpostauth'
#
INSERT INTO `radpostauth` VALUES (1,'test1','Chap-Password','Access-Accept',20050723095829);
INSERT INTO `radpostauth` VALUES (2,'test1','Chap-Password','Access-Accept',20050723095918);
INSERT INTO `radpostauth` VALUES (3,'test1','Chap-Password','Access-Accept',20050723101449);
INSERT INTO `radpostauth` VALUES (4,'test1','Chap-Password','Access-Accept',20050723102257);
INSERT INTO `radpostauth` VALUES (5,'test1','Chap-Password','Access-Accept',20050723103023);
INSERT INTO `radpostauth` VALUES (6,'test1','Chap-Password','Access-Accept',20050723103238);
INSERT INTO `radpostauth` VALUES (7,'test1','Chap-Password','Access-Accept',20050723112928);
INSERT INTO `radpostauth` VALUES (8,'test1','Chap-Password','Access-Accept',20050723113032);
INSERT INTO `radpostauth` VALUES (9,'test1','Chap-Password','Access-Accept',20050723122446);
INSERT INTO `radpostauth` VALUES (10,'test1','Chap-Password','Access-Accept',20050723123534);
INSERT INTO `radpostauth` VALUES (11,'test1','Chap-Password','Access-Accept',20050723123736);
INSERT INTO `radpostauth` VALUES (12,'test1','Chap-Password','Access-Accept',20050723123905);
INSERT INTO `radpostauth` VALUES (13,'test1','Chap-Password','Access-Accept',20050723124040);
INSERT INTO `radpostauth` VALUES (14,'test1','Chap-Password','Access-Accept',20050723124132);
INSERT INTO `radpostauth` VALUES (15,'test1','Chap-Password','Access-Accept',20050723124501);
INSERT INTO `radpostauth` VALUES (16,'test1','Chap-Password','Access-Accept',20050723124551);
INSERT INTO `radpostauth` VALUES (17,'test1','Chap-Password','Access-Accept',20050723124737);
INSERT INTO `radpostauth` VALUES (18,'test1','Chap-Password','Access-Accept',20050723125116);
INSERT INTO `radpostauth` VALUES (19,'test1','Chap-Password','Access-Accept',20050723125249);
INSERT INTO `radpostauth` VALUES (20,'test1','Chap-Password','Access-Accept',20050723130303);
INSERT INTO `radpostauth` VALUES (21,'test1','Chap-Password','Access-Accept',20050723135601);
INSERT INTO `radpostauth` VALUES (22,'test1','Chap-Password','Access-Accept',20050723140304);
INSERT INTO `radpostauth` VALUES (23,'test1','Chap-Password','Access-Accept',20050723140725);
INSERT INTO `radpostauth` VALUES (24,'test1','Chap-Password','Access-Accept',20050723141411);
INSERT INTO `radpostauth` VALUES (25,'test1','Chap-Password','Access-Accept',20050723141731);
INSERT INTO `radpostauth` VALUES (26,'wendyzh','Chap-Password','Access-Accept',20050723141835);
INSERT INTO `radpostauth` VALUES (27,'wendyzh','Chap-Password','Access-Accept',20050723142304);
INSERT INTO `radpostauth` VALUES (28,'test1','Chap-Password','Access-Accept',20050723152032);
INSERT INTO `radpostauth` VALUES (29,'test1','Chap-Password','Access-Accept',20050723152202);
INSERT INTO `radpostauth` VALUES (30,'test1','Chap-Password','Access-Accept',20050723172738);
INSERT INTO `radpostauth` VALUES (31,'wendyzh','Chap-Password','Access-Accept',20050723193228);
INSERT INTO `radpostauth` VALUES (32,'wendyzh','Chap-Password','Access-Accept',20050724152614);
INSERT INTO `radpostauth` VALUES (33,'wendyzh','Chap-Password','Access-Accept',20050724153033);
INSERT INTO `radpostauth` VALUES (34,'test1','Chap-Password','Access-Accept',20050725081709);
INSERT INTO `radpostauth` VALUES (35,'test1','Chap-Password','Access-Accept',20050725112117);
INSERT INTO `radpostauth` VALUES (36,'test1','Chap-Password','Access-Accept',20050725163403);
INSERT INTO `radpostauth` VALUES (37,'test1','Chap-Password','Access-Accept',20050727080701);
INSERT INTO `radpostauth` VALUES (38,'wendyzh','Chap-Password','Access-Accept',20050730223039);
INSERT INTO `radpostauth` VALUES (39,'test1','Chap-Password','Access-Accept',20050802094151);
INSERT INTO `radpostauth` VALUES (40,'test1','Chap-Password','Access-Accept',20050802094349);
INSERT INTO `radpostauth` VALUES (41,'test1','Chap-Password','Access-Accept',20050805131635);
INSERT INTO `radpostauth` VALUES (42,'test1','Chap-Password','Access-Accept',20050805132926);
INSERT INTO `radpostauth` VALUES (43,'test1','Chap-Password','Access-Accept',20050805133243);
INSERT INTO `radpostauth` VALUES (44,'test1','Chap-Password','Access-Accept',20050816174013);
INSERT INTO `radpostauth` VALUES (45,'test1','Chap-Password','Access-Accept',20050823092428);
INSERT INTO `radpostauth` VALUES (46,'test1','Chap-Password','Access-Accept',20050823092548);
INSERT INTO `radpostauth` VALUES (47,'test1','Chap-Password','Access-Accept',20050824135444);
INSERT INTO `radpostauth` VALUES (48,'test1','Chap-Password','Access-Accept',20050824142129);
INSERT INTO `radpostauth` VALUES (49,'test1','Chap-Password','Access-Accept',20050824143121);
INSERT INTO `radpostauth` VALUES (50,'test1','Chap-Password','Access-Accept',20050824143300);
INSERT INTO `radpostauth` VALUES (51,'test1','Chap-Password','Access-Accept',20050824143523);
INSERT INTO `radpostauth` VALUES (52,'test1','Chap-Password','Access-Accept',20050824143728);
INSERT INTO `radpostauth` VALUES (53,'test1','Chap-Password','Access-Accept',20050824190715);
INSERT INTO `radpostauth` VALUES (54,'test1','Chap-Password','Access-Accept',20050824191011);
INSERT INTO `radpostauth` VALUES (55,'test1','Chap-Password','Access-Accept',20050824191141);
INSERT INTO `radpostauth` VALUES (56,'test1','Chap-Password','Access-Accept',20050824191645);
INSERT INTO `radpostauth` VALUES (57,'test1','Chap-Password','Access-Accept',20050826094900);
INSERT INTO `radpostauth` VALUES (58,'test1','Chap-Password','Access-Accept',20050826101335);
INSERT INTO `radpostauth` VALUES (59,'test1','Chap-Password','Access-Accept',20050826103939);
INSERT INTO `radpostauth` VALUES (60,'test1','Chap-Password','Access-Accept',20050826171114);
INSERT INTO `radpostauth` VALUES (61,'test1','Chap-Password','Access-Accept',20050907203800);
INSERT INTO `radpostauth` VALUES (62,'test1','Chap-Password','Access-Accept',20050907204537);
INSERT INTO `radpostauth` VALUES (63,'test1','Chap-Password','Access-Accept',20050907205342);
INSERT INTO `radpostauth` VALUES (64,'test1','Chap-Password','Access-Accept',20050907212004);
INSERT INTO `radpostauth` VALUES (65,'test1','Chap-Password','Access-Accept',20050907212129);
INSERT INTO `radpostauth` VALUES (66,'test1','Chap-Password','Access-Accept',20050907212432);
INSERT INTO `radpostauth` VALUES (67,'test1','Chap-Password','Access-Accept',20050907213046);
INSERT INTO `radpostauth` VALUES (68,'test1','Chap-Password','Access-Accept',20050907213418);
INSERT INTO `radpostauth` VALUES (69,'test1','Chap-Password','Access-Accept',20050907213944);
INSERT INTO `radpostauth` VALUES (70,'test1','Chap-Password','Access-Accept',20050911110313);
INSERT INTO `radpostauth` VALUES (71,'test1','Chap-Password','Access-Accept',20050914085228);
INSERT INTO `radpostauth` VALUES (72,'test1','Chap-Password','Access-Accept',20050914090152);
INSERT INTO `radpostauth` VALUES (73,'wendyzh','Chap-Password','Access-Accept',20050914090232);
INSERT INTO `radpostauth` VALUES (74,'wendyzh','Chap-Password','Access-Accept',20050914090359);
INSERT INTO `radpostauth` VALUES (75,'test1','Chap-Password','Access-Accept',20050914174910);
INSERT INTO `radpostauth` VALUES (76,'test1','Chap-Password','Access-Accept',20050914175855);
INSERT INTO `radpostauth` VALUES (77,'test1','Chap-Password','Access-Accept',20050914175913);
INSERT INTO `radpostauth` VALUES (78,'test1','Chap-Password','Access-Accept',20050914175947);
INSERT INTO `radpostauth` VALUES (79,'test1','Chap-Password','Access-Accept',20050914180025);
INSERT INTO `radpostauth` VALUES (80,'test1','Chap-Password','Access-Accept',20050914180611);
INSERT INTO `radpostauth` VALUES (81,'test1','Chap-Password','Access-Accept',20050914180730);
INSERT INTO `radpostauth` VALUES (82,'test1','Chap-Password','Access-Accept',20050914194315);
INSERT INTO `radpostauth` VALUES (83,'test1','Chap-Password','Access-Accept',20050915080107);
INSERT INTO `radpostauth` VALUES (84,'test1','Chap-Password','Access-Accept',20050915080411);
INSERT INTO `radpostauth` VALUES (85,'test1','Chap-Password','Access-Accept',20050915080604);
INSERT INTO `radpostauth` VALUES (86,'test1','Chap-Password','Access-Accept',20050915080839);
INSERT INTO `radpostauth` VALUES (87,'test1','Chap-Password','Access-Accept',20050915081342);
INSERT INTO `radpostauth` VALUES (88,'test1','Chap-Password','Access-Accept',20050915081454);
INSERT INTO `radpostauth` VALUES (89,'test1','Chap-Password','Access-Accept',20050915081653);
INSERT INTO `radpostauth` VALUES (90,'test1','Chap-Password','Access-Accept',20050915082022);
INSERT INTO `radpostauth` VALUES (91,'test1','Chap-Password','Access-Accept',20050915082635);
INSERT INTO `radpostauth` VALUES (92,'test1','Chap-Password','Access-Accept',20050915082918);
INSERT INTO `radpostauth` VALUES (93,'test1','Chap-Password','Access-Accept',20050915083204);
INSERT INTO `radpostauth` VALUES (94,'test1','Chap-Password','Access-Accept',20050915083309);
INSERT INTO `radpostauth` VALUES (95,'test1','Chap-Password','Access-Accept',20050915083433);
INSERT INTO `radpostauth` VALUES (96,'test1','Chap-Password','Access-Accept',20050915083609);
INSERT INTO `radpostauth` VALUES (97,'test1','Chap-Password','Access-Accept',20050915083647);
INSERT INTO `radpostauth` VALUES (98,'test1','Chap-Password','Access-Accept',20050915083758);
INSERT INTO `radpostauth` VALUES (99,'test1','Chap-Password','Access-Accept',20050915083828);
INSERT INTO `radpostauth` VALUES (100,'test1','Chap-Password','Access-Accept',20050915084131);
INSERT INTO `radpostauth` VALUES (101,'test1','Chap-Password','Access-Accept',20050915084310);
INSERT INTO `radpostauth` VALUES (102,'test1','Chap-Password','Access-Accept',20050915084357);
INSERT INTO `radpostauth` VALUES (103,'test1','Chap-Password','Access-Accept',20050915084519);
INSERT INTO `radpostauth` VALUES (104,'test1','Chap-Password','Access-Accept',20050915084547);
INSERT INTO `radpostauth` VALUES (105,'test1','Chap-Password','Access-Accept',20050915084642);
INSERT INTO `radpostauth` VALUES (106,'test1','Chap-Password','Access-Accept',20050915090002);
INSERT INTO `radpostauth` VALUES (107,'test1','Chap-Password','Access-Accept',20050915090055);
INSERT INTO `radpostauth` VALUES (108,'test1','Chap-Password','Access-Accept',20050915090148);
INSERT INTO `radpostauth` VALUES (109,'test1','Chap-Password','Access-Accept',20050915110057);
INSERT INTO `radpostauth` VALUES (110,'test1','Chap-Password','Access-Accept',20050915110649);
INSERT INTO `radpostauth` VALUES (111,'test1','Chap-Password','Access-Accept',20050915111616);
INSERT INTO `radpostauth` VALUES (112,'test1','Chap-Password','Access-Accept',20050915111921);
INSERT INTO `radpostauth` VALUES (113,'test1','Chap-Password','Access-Accept',20050916202157);
INSERT INTO `radpostauth` VALUES (114,'test1','Chap-Password','Access-Accept',20050917060950);
INSERT INTO `radpostauth` VALUES (115,'test1','Chap-Password','Access-Accept',20050918205637);
INSERT INTO `radpostauth` VALUES (116,'test1','Chap-Password','Access-Accept',20050921195133);
INSERT INTO `radpostauth` VALUES (117,'test1','Chap-Password','Access-Accept',20050921195418);
INSERT INTO `radpostauth` VALUES (118,'test1','Chap-Password','Access-Accept',20050921195739);
INSERT INTO `radpostauth` VALUES (119,'test1','Chap-Password','Access-Accept',20050922194744);
INSERT INTO `radpostauth` VALUES (120,'test1','Chap-Password','Access-Accept',20050923194345);
INSERT INTO `radpostauth` VALUES (121,'test1','Chap-Password','Access-Accept',20050923200123);
INSERT INTO `radpostauth` VALUES (122,'test1','Chap-Password','Access-Accept',20050923200228);
INSERT INTO `radpostauth` VALUES (123,'test1','Chap-Password','Access-Accept',20050924113002);
INSERT INTO `radpostauth` VALUES (124,'test1','Chap-Password','Access-Accept',20050924125016);
INSERT INTO `radpostauth` VALUES (125,'test1','Chap-Password','Access-Accept',20050925061350);
INSERT INTO `radpostauth` VALUES (126,'test1','Chap-Password','Access-Accept',20050925091059);
INSERT INTO `radpostauth` VALUES (127,'test1','Chap-Password','Access-Accept',20050925200220);
INSERT INTO `radpostauth` VALUES (128,'test1','Chap-Password','Access-Accept',20051004193519);
INSERT INTO `radpostauth` VALUES (129,'test1','Chap-Password','Access-Accept',20051006190217);
INSERT INTO `radpostauth` VALUES (130,'test1','Chap-Password','Access-Accept',20051006190644);
INSERT INTO `radpostauth` VALUES (131,'test1','Chap-Password','Access-Accept',20051012204715);
INSERT INTO `radpostauth` VALUES (132,'test1','Chap-Password','Access-Accept',20051013061958);
INSERT INTO `radpostauth` VALUES (133,'test1','Chap-Password','Access-Accept',20051018163618);
INSERT INTO `radpostauth` VALUES (134,'test1','Chap-Password','Access-Accept',20051018183052);
INSERT INTO `radpostauth` VALUES (135,'test1','Chap-Password','Access-Accept',20051019200010);
INSERT INTO `radpostauth` VALUES (136,'test1','Chap-Password','Access-Accept',20051019202009);
INSERT INTO `radpostauth` VALUES (137,'test1','Chap-Password','Access-Accept',20051020185545);
INSERT INTO `radpostauth` VALUES (138,'test1','Chap-Password','Access-Accept',20051026215057);
INSERT INTO `radpostauth` VALUES (139,'test1','Chap-Password','Access-Accept',20051029173524);
INSERT INTO `radpostauth` VALUES (140,'test1','Chap-Password','Access-Accept',20051029174955);
INSERT INTO `radpostauth` VALUES (141,'test1','Chap-Password','Access-Accept',20051031201707);
INSERT INTO `radpostauth` VALUES (142,'test1','Chap-Password','Access-Accept',20051103203816);
INSERT INTO `radpostauth` VALUES (143,'test1','Chap-Password','Access-Accept',20051104204907);
INSERT INTO `radpostauth` VALUES (144,'test1','Chap-Password','Access-Accept',20051107191337);
INSERT INTO `radpostauth` VALUES (145,'test1','Chap-Password','Access-Accept',20051107192642);
INSERT INTO `radpostauth` VALUES (146,'test1','Chap-Password','Access-Accept',20051110190445);
INSERT INTO `radpostauth` VALUES (147,'test1','Chap-Password','Access-Accept',20051110190950);
INSERT INTO `radpostauth` VALUES (148,'test1','Chap-Password','Access-Accept',20051110195549);
INSERT INTO `radpostauth` VALUES (149,'test1','Chap-Password','Access-Accept',20051112075803);
INSERT INTO `radpostauth` VALUES (150,'test1','Chap-Password','Access-Accept',20051112110125);
INSERT INTO `radpostauth` VALUES (151,'test1','Chap-Password','Access-Accept',20051112185539);
#
# Table structure for table 'radreply'
#
DROP TABLE IF EXISTS `radreply`;
CREATE TABLE `radreply` (
`id` int(11) unsigned NOT NULL auto_increment,
`UserName` varchar(64) NOT NULL default '',
`Attribute` varchar(32) NOT NULL default '',
`op` char(2) NOT NULL default '=',
`Value` varchar(253) NOT NULL default '',
PRIMARY KEY(`id`),
KEY `UserName` (`UserName`(32))
) TYPE=MyISAM;
#
# Dumping data for table 'radreply'
#
INSERT INTO `radreply` VALUES (14,'test1','Framed-IP-Address',':=','255.255.255.254');
INSERT INTO `radreply` VALUES (13,'test1','Framed-Compression',':=','None');
INSERT INTO `radreply` VALUES (12,'test1','Framed-Protocol',':=','PPP');
INSERT INTO `radreply` VALUES (11,'test1','Port-Limit',':=','1');
INSERT INTO `radreply` VALUES (15,'test1','Framed-IP-Netmask',':=','255.255.255.255');
INSERT INTO `radreply` VALUES (16,'wendyzh','Port-Limit',':=','1');
INSERT INTO `radreply` VALUES (17,'wendyzh','Framed-Protocol',':=','PPP');
INSERT INTO `radreply` VALUES (18,'wendyzh','Framed-Compression',':=','None');
INSERT INTO `radreply` VALUES (19,'wendyzh','Framed-IP-Address',':=','255.255.255.254');
INSERT INTO `radreply` VALUES (20,'wendyzh','Framed-IP-Netmask',':=','255.255.255.255');
#
# Table structure for table 'totacct'
#
DROP TABLE IF EXISTS `totacct`;
CREATE TABLE `totacct` (
`TotAcctId` bigint(21) NOT NULL auto_increment,
`UserName` varchar(64) NOT NULL default '',
`AcctDate` date NOT NULL default '0000-00-00',
`ConnNum` bigint(12) default NULL,
`ConnTotDuration` bigint(12) default NULL,
`ConnMaxDuration` bigint(12) default NULL,
`ConnMinDuration` bigint(12) default NULL,
`InputOctets` bigint(12) default NULL,
`OutputOctets` bigint(12) default NULL,
`NASIPAddress` varchar(15) default NULL,
PRIMARY KEY(`TotAcctId`),
KEY `UserName` (`UserName`),
KEY `AcctDate` (`AcctDate`),
KEY `UserOnDate` (`UserName`,`AcctDate`),
KEY `NASIPAddress` (`NASIPAddress`),
KEY `NASIPAddressOnDate` (`AcctDate`,`NASIPAddress`)
) TYPE=MyISAM;
#
# Dumping data for table 'totacct'
#
#
# Table structure for table 'usergroup'
#
DROP TABLE IF EXISTS `usergroup`;
CREATE TABLE `usergroup` (
`id` int(11) unsigned NOT NULL auto_increment,
`UserName` varchar(64) NOT NULL default '',
`GroupName` varchar(64) NOT NULL default '',
PRIMARY KEY(`id`),
KEY `UserName` (`UserName`(32))
) TYPE=MyISAM;
#
# Dumping data for table 'usergroup'
#
INSERT INTO `usergroup` VALUES (2,'test1','test');
#
# Table structure for table 'userinfo'
#
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`id` int(10) NOT NULL auto_increment,
`UserName` varchar(30) default NULL,
`Name` varchar(200) default NULL,
`Mail` varchar(200) default NULL,
`Department` varchar(200) default NULL,
`WorkPhone` varchar(200) default NULL,
`HomePhone` varchar(200) default NULL,
`Mobile` varchar(200) default NULL,
PRIMARY KEY(`id`),
KEY `UserName` (`UserName`),
KEY `Departmet` (`Department`)
) TYPE=MyISAM;
#
# Dumping data for table 'userinfo'
#
INSERT INTO `userinfo` VALUES (3,'test1','test1','','','',NULL,NULL);
INSERT INTO `userinfo` VALUES (4,'wendyzh','wendyzh','','','',NULL,NULL);