I know people are always asking for sample data, since I am in the process of testing the mysql version of dialup_admin for compatability
with my postgresql patches, I have created some sample data for testing.
-- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on.
delete from usergroup ;
insert into usergroup (username,groupname) values('fredf','ppp-unlimited');
insert into usergroup (username,groupname) values('barneyr','ppp-static');
insert into usergroup (username,groupname) values('troll','ppp-unlimited');
insert into usergroup (username,groupname) values('frog','nas-prompt');
delete from radcheck ;
insert into radcheck (username,attribute,op,value)
values('fredf','User-Password','==','wilma');
insert into radcheck (username,attribute,op,value)
values('barneyr','User-Password','==','betty');
insert into radcheck (username,attribute,op,value)
values('troll','Crypt-Password','==','$1$A8BotTi4$UTg2XL.fSStI2RFENUfnR.');
insert into radcheck (username,attribute,op,value)
values('frog','User-Password','==','kermit');
delete from radreply ;
insert into radreply (username,attribute,op,value)
values('barneyr','Framed-IP-Address',':=','10.19.65.38');
insert into radreply (username,attribute,op,value)
values('barneyr','Framed-IP-Netmask',':=','255.255.255.252');
delete from radgroupcheck ;
insert into radgroupcheck (groupname,attribute,op,value)
values('ppp-unlimited','Auth-Type',':=','Local');
insert into radgroupcheck (groupname,attribute,op,value)
values('ppp-static','Auth-Type',':=','Local');
insert into radgroupcheck (groupname,attribute,op,value)
values('nas-prompt','Auth-Type',':=','Local');
delete from radgroupreply ;
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Framed-Compression',':=','Van-Jacobsen-TCP-IP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Framed-Protocol',':=','PPP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Service-Type',':=','Framed-User');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Framed-MTU',':=','1500');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Framed-Compression',':=','Van-Jacobsen-TCP-IP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Framed-Protocol',':=','PPP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Service-Type',':=','Framed-User');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Framed-MTU',':=','1500');
insert into radgroupreply (groupname,attribute,op,value)
values('nas-prompt','Framed-MTU',':=','1500');
insert into radgroupreply (groupname,attribute,op,value)
values('nas-prompt','Framed-Compression',':=','Van-Jacobson-TCP-IP');
insert into radgroupreply (groupname,attribute,op,value)
values('nas-prompt','Service-Type',':=','NAS-Prompt');
delete from userinfo ;
insert into userinfo (username,name,mail,department,workphone,homephone,mobile)
values('fredf','Fred Flintstone','-','Quarry','-','-','-');
insert into userinfo (username,name,mail,department,workphone,homephone,mobile)
values('barneyr','Barney Rubble','-','Office','-','-','-');
insert into userinfo (username,name,mail,department,workphone,homephone,mobile)
values('troll','Erik The Red','-','Bridge','-','-','-');
insert into userinfo (username,name,mail,department,workphone,homephone,mobile)
values('frog','Kermit The Frog','-','Pond','-','-','-');
delete from totacct ;
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('joebob','2003-11-14','1','0','0','0','0','0','127.0.0.1');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('barneyr','2003-11-18','1','0','0','0','0','0','10.10.10.143');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('fredf','2003-11-18','2','9','9','0','0','0','10.10.10.143');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('radius','2003-11-18','1','0','0','0','0','0','10.10.10.143');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('troll','2003-11-18','1','0','0','0','0','0','10.10.10.143');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('troll','2003-11-18','4','0','0','0','0','0','10.10.10.170');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('vsa','2003-11-18','1','0','0','0','0','0','10.10.10.143');
insert into totacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('troll','2003-11-19','4','4846','3762','10','10509','18444','10.10.10.143');
delete from mtotacct ;
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('barneyr','2003-11-01','1','0','0','0','0','0','10.10.10.143');
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('fredf','2003-11-01','2','9','9','0','0','0','10.10.10.143');
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('joebob','2003-11-01','1','0','0','0','0','0','127.0.0.1');
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('radius','2003-11-01','1','0','0','0','0','0','10.10.10.143');
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('troll','2003-11-01','5','4846','3762','0','10509','18444','10.10.10.143');
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('troll','2003-11-01','4','0','0','0','0','0','10.10.10.170');
insert into mtotacct
(username,acctdate,connnum,conntotduration,connmaxduration,connminduration,inputoctets,outputoctets,nasipaddress)
values('vsa','2003-11-01','1','0','0','0','0','0','10.10.10.143');
delete from radacct ;
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','d1dbc255637487c23cf621315da8ae11','joebob','','127.0.0.1',1,'','2003-11-14
18:04:58-07','2003-11-14
18:04:58-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','770e59a2ae51eba5c8b275eb3d900e72','fredf','','10.10.10.143',6,'','2003-11-18
16:28:40-07','2003-11-18
16:28:40-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','2340befbee3253ade1e96fac7b9e8246','barneyr','','10.10.10.143',6,'','2003-11-18
16:29:01-07','2003-11-18
16:29:01-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','463d85c78900807fbd5301bc3f2d27e3','radius','','10.10.10.143',6,'','2003-11-18
16:29:18-07','2003-11-18
16:29:18-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','d5a84f20201e1cf50d72849966b20f11','troll','','10.10.10.143',6,'','2003-11-18
16:39:28-07','2003-11-18
16:39:28-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','6d75a72983e211807c54c4751a30b2ed','vsa','','10.10.10.143',6,'','2003-11-18
16:39:54-07','2003-11-18
16:39:54-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','2782a52c786de4894f9b41ac057c933c','troll','','10.10.10.170',1,'','2003-11-18
16:41:11-07','2003-11-18
16:41:11-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','74b4095b51db5dbd27138972bc71c800','troll','','10.10.10.170',1,'','2003-11-18
18:47:15-07','2003-11-18
18:47:15-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','0bc0fc1be0d2f428a45fed33bab05ea7','troll','','10.10.10.170',1,'','2003-11-18
18:49:41-07','2003-11-18
18:49:41-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0','5a0701c4486c10f2ce6d87fc99b6786e','troll','','10.10.10.170',1,'','2003-11-18
18:55:43-07','2003-11-18
18:55:43-07',0,'','','',0,0,'','','Login-Incorrect','','','','','');
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('00000006','530dba3aee514442','fredf','NULL','10.10.10.143',6,'','2003-11-18
19:00:39.022895-07','2003-11-18
19:00:48.365483-07',9,'','','',0,0,'','','','NAS-Prompt-User','','',0,0);
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('00000007','046889ad798663bf','troll','NULL','10.10.10.143',6,'','2003-11-19
09:42:55.260862-07','2003-11-19
09:43:05.470316-07',10,'','','',0,0,'','','','NAS-Prompt-User','','',0,0);
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('00000008','ac8bb45f4a5553de','troll','NULL','10.10.10.143',6,'','2003-11-19
09:57:02.454366-07','2003-11-19
10:59:44.452692-07',3762,'','','',9037,16133,'','','','Framed-User','PPP','10.10.10.145',0,0);
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('00000009','c3dfaa5752eaae4b','troll','NULL','10.10.10.143',6,'','2003-11-19
11:16:54.654387-07','2003-11-19
11:30:36.349198-07',822,'','','',1024,1669,'','','','Framed-User','PPP','10.10.10.146',0,0);
insert into radacct
(acctsessionid,acctuniqueid,username,realm,nasipaddress,nasportid,nasporttype,acctstarttime,acctstoptime,acctsessiontime,acctauthentic,connectinfo_start,connectinfo_stop,acctinputoctets,acctoutputoctets,calledstationid,callingstationid,acctterminatecause,servicetype,framedprotocol,framedipaddress,acctstartdelay,acctstopdelay)
values('0000000A','f7455db6190b2212','troll','NULL','10.10.10.143',6,'','2003-11-19
15:38:15.090849-07','2003-11-19
15:42:27.410874-07',252,'','','',448,642,'','','','Framed-User','PPP','10.10.10.147',0,0);
