RE: (RADIATOR) Radusage table not updated.
> > Hello Michael - > > Can you please tell me what versions of Radiator and Radmin you are > running? > > Latest versions are Radiator 3.6 (plus patches) and Radmin 1.7 (plus > patches). Certainly Hugh: Radiator-3.5(No patches) RAdmin 1.7(No Patches) Regards, MB > > regards > > Hugh > > > On Tuesday, Jul 22, 2003, at 10:38 Australia/Melbourne, Michael > Bellears wrote: > > > Hi Hugh, > > > >> > >> The problem is due to the incorrect quoting of the string > containing > >> the "@" sign. > > > > Ok. > > > >> In most clauses based on SQL, %0 can be used for the > username string > >> and it will always be correctly quoted. > > > > As Radmin is being used for Acct., how would I modify the insert > > clause?(In the radmin.cfg, or would it require source-file mod?) > > > > Thanks for your assistance. > > > > Regards, > > MB > > > >> regards > >> > >> Hugh > >> > >> > >> On Monday, Jul 21, 2003, at 20:24 Australia/Melbourne, Michael > >> Bellears > >> wrote: > >> > >>> > >>> Hi Hugh, > >>> > > You should try the queries by hand to see what is happening. > > >>> > >>> Upon further investigation, it appears as though the '@' in the > >>> username is causing the problem: > >>> > >>> Success without '@' > >>> > >>> mysql> insert into RADUSAGE > >>> > >> > (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME, > >> C > >>> l > >>> > >> ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT > >> OCTETS,AC > >>> CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) > >>> values (1,'31200 > >>> LAPM/ > >>> > >> V42BIS',344121,1058742326,'connect_test','755798217','203.149. > >> 64.50',0, > >>> '55849500',28682053,2,'86D0',89390039,3,'203.149.64.3'); > >>> Query OK, 1 row affected (0.01 sec) > >>> > >>> mysql> select > >>> > >> > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NAS > >> I > >>> D > >>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = > >>> 'connect_test' order by TIME_STAMP; > >>> +--++---+- > >>> +-+---+-++ > >>> | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | > >>> FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | > >>> +--++---+- > >>> +-+---+-++ > >>> | connect_test | 1058742326 | 86D0 | 344121 | > >>> 203.149.64.50 | 203.149.64.3 | 3 | 2 | > >>> +--++---+- > >>> +-+---+-++ > >>> 1 row in set (0.00 sec) > >>> > >>> Failure with '@' > >>> > >>> mysql> insert into RADUSAGE > >>> > >> > (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME, > >> C > >>> l > >>> > >> ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT > >> OCTETS,AC > >>> CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) > >>> values (1,'31200 > >>> LAPM/ > >>> > >> V42BIS',344121,1058742326,'[EMAIL PROTECTED]','75 > >> 5798217', > >>> > >> '203.149.64.50',0,'55849500',28682053,2,'86D0',89390039,3, > >> '203.149. > >>> 64.3'); > >>> Query OK, 1 row affected (0.00 sec) > >>> > >>> mysql> select > >>> > >> > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NAS > >> I > >>> D > >>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = > >>> '[EMAIL PROTECTED]' order by TIME_STAMP; Empty > set (0.00 > >>> sec) > >>> > >>> Insert with correct data, but removing the '@' from username: > >>> > >>> mysql> insert into RADUSAGE > >>> > >> > (ACCTTERMINATECAUSE,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_ > >> N > >>> u > >>> > >> mber,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTST > >> ATUSTYPE, > >>> ACCTOUTPUTOCTETS,ACCTSESSIONID,NASPORT,NASIDENTIFIER) values > >>> (18,21210,1058781354,'connect_test','atm > >>> 11','203.149.70.10',0,'3:2.261#184571819##speed:UBR:256#/ > >>> ',74104,2,77696,'9813',1,'203.63.121.145'); > >>> Query OK, 1 row affected (0.00 sec) > >>> > >>> mysql> select > >>> > >> > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NAS > >> I > >>> D > >>> ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = > >>> 'connect_test' order by TIME_STAMP; > >>> +--++---+- > >>> +-++-++ > >>> | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | > >>> FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | > >>> +--++---+- > >>> +-++-++ > >>> | connect_test | 1058742326 | 86D0 | 344121 | > >>> 203.149.64.50 | 203.149.64.3 | 3 | 2 | > >>> | connect_test | 1058781
Re: (RADIATOR) Radusage table not updated.
Hello Michael - Can you please tell me what versions of Radiator and Radmin you are running? Latest versions are Radiator 3.6 (plus patches) and Radmin 1.7 (plus patches). regards Hugh On Tuesday, Jul 22, 2003, at 10:38 Australia/Melbourne, Michael Bellears wrote: Hi Hugh, The problem is due to the incorrect quoting of the string containing the "@" sign. Ok. In most clauses based on SQL, %0 can be used for the username string and it will always be correctly quoted. As Radmin is being used for Acct., how would I modify the insert clause?(In the radmin.cfg, or would it require source-file mod?) Thanks for your assistance. Regards, MB regards Hugh On Monday, Jul 21, 2003, at 20:24 Australia/Melbourne, Michael Bellears wrote: Hi Hugh, You should try the queries by hand to see what is happening. Upon further investigation, it appears as though the '@' in the username is causing the problem: Success without '@' mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,C l ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT OCTETS,AC CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values (1,'31200 LAPM/ V42BIS',344121,1058742326,'connect_test','755798217','203.149. 64.50',0, '55849500',28682053,2,'86D0',89390039,3,'203.149.64.3'); Query OK, 1 row affected (0.01 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI D ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test' order by TIME_STAMP; +--++---+- +-+---+-++ | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | +--++---+- +-+---+-++ | connect_test | 1058742326 | 86D0 | 344121 | 203.149.64.50 | 203.149.64.3 | 3 | 2 | +--++---+- +-+---+-++ 1 row in set (0.00 sec) Failure with '@' mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,C l ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT OCTETS,AC CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values (1,'31200 LAPM/ V42BIS',344121,1058742326,'[EMAIL PROTECTED]','75 5798217', '203.149.64.50',0,'55849500',28682053,2,'86D0',89390039,3, '203.149. 64.3'); Query OK, 1 row affected (0.00 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI D ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = '[EMAIL PROTECTED]' order by TIME_STAMP; Empty set (0.00 sec) Insert with correct data, but removing the '@' from username: mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_N u mber,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTST ATUSTYPE, ACCTOUTPUTOCTETS,ACCTSESSIONID,NASPORT,NASIDENTIFIER) values (18,21210,1058781354,'connect_test','atm 11','203.149.70.10',0,'3:2.261#184571819##speed:UBR:256#/ ',74104,2,77696,'9813',1,'203.63.121.145'); Query OK, 1 row affected (0.00 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI D ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test' order by TIME_STAMP; +--++---+- +-++-++ | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | +--++---+- +-++-++ | connect_test | 1058742326 | 86D0 | 344121 | 203.149.64.50 | 203.149.64.3 | 3 | 2 | | connect_test | 1058781354 | 9813 | 21210 | 203.149.70.10 | 203.63.121.145 | 1 | 2 | +--++---+- +-++-++ 2 rows in set (0.00 sec) Any suggestions on how to get around this? (I would like the username to be inserted with the '@dsl.datafx.com.au' if possible) Thanks in advance, MB On Saturday, Jul 19, 2003, at 08:43 Australia/Melbourne, Michael Bellears wrote: Radiator/Radmin is auth/acct for dialup users (MAX6000/PM3's), and also DSL users(Cisco7200). Dialup users acct data is successfully updated in the RADUSAGE table, but DSL clients are not(RADONLINE is working for both). I see the insert in trace4: Sat Jul 19 08:05:51 2003: DEBUG: do query is: insert into RADUSAGE (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES SIONID,NA SPORT,NASIDENTIFIER) values (
RE: (RADIATOR) Radusage table not updated.
Hi Hugh, > > The problem is due to the incorrect quoting of the string containing > the "@" sign. Ok. > In most clauses based on SQL, %0 can be used for the username string > and it will always be correctly quoted. As Radmin is being used for Acct., how would I modify the insert clause?(In the radmin.cfg, or would it require source-file mod?) Thanks for your assistance. Regards, MB > regards > > Hugh > > > On Monday, Jul 21, 2003, at 20:24 Australia/Melbourne, > Michael Bellears > wrote: > > > > > Hi Hugh, > > > >> > >> You should try the queries by hand to see what is happening. > >> > > > > Upon further investigation, it appears as though the '@' in the > > username is causing the problem: > > > > Success without '@' > > > > mysql> insert into RADUSAGE > > > (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,C > > l > > > ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT > OCTETS,AC > > CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) > > values (1,'31200 > > LAPM/ > > > V42BIS',344121,1058742326,'connect_test','755798217','203.149. > 64.50',0, > > '55849500',28682053,2,'86D0',89390039,3,'203.149.64.3'); > > Query OK, 1 row affected (0.01 sec) > > > > mysql> select > > > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI > > D > > ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = > > 'connect_test' order by TIME_STAMP; > > +--++---+- > > +-+---+-++ > > | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | > > FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | > > +--++---+- > > +-+---+-++ > > | connect_test | 1058742326 | 86D0 | 344121 | > > 203.149.64.50 | 203.149.64.3 | 3 | 2 | > > +--++---+- > > +-+---+-++ > > 1 row in set (0.00 sec) > > > > Failure with '@' > > > > mysql> insert into RADUSAGE > > > (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,C > > l > > > ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUT > OCTETS,AC > > CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) > > values (1,'31200 > > LAPM/ > > > V42BIS',344121,1058742326,'[EMAIL PROTECTED]','75 > 5798217', > > > '203.149.64.50',0,'55849500',28682053,2,'86D0',89390039,3, > '203.149. > > 64.3'); > > Query OK, 1 row affected (0.00 sec) > > > > mysql> select > > > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI > > D > > ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = > > '[EMAIL PROTECTED]' order by TIME_STAMP; > > Empty set (0.00 sec) > > > > Insert with correct data, but removing the '@' from username: > > > > mysql> insert into RADUSAGE > > > (ACCTTERMINATECAUSE,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_N > > u > > > mber,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTST > ATUSTYPE, > > ACCTOUTPUTOCTETS,ACCTSESSIONID,NASPORT,NASIDENTIFIER) values > > (18,21210,1058781354,'connect_test','atm > > 11','203.149.70.10',0,'3:2.261#184571819##speed:UBR:256#/ > > ',74104,2,77696,'9813',1,'203.63.121.145'); > > Query OK, 1 row affected (0.00 sec) > > > > mysql> select > > > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASI > > D > > ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = > > 'connect_test' order by TIME_STAMP; > > +--++---+- > > +-++-++ > > | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | > > FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | > > +--++---+- > > +-++-++ > > | connect_test | 1058742326 | 86D0 | 344121 | > > 203.149.64.50 | 203.149.64.3 | 3 | 2 | > > | connect_test | 1058781354 | 9813 | 21210 | > > 203.149.70.10 | 203.63.121.145 | 1 | 2 | > > +--++---+- > > +-++-++ > > 2 rows in set (0.00 sec) > > > > Any suggestions on how to get around this? (I would like > the username > > to be inserted with the '@dsl.datafx.com.au' if possible) > > > > Thanks in advance, > > MB > > > >> > >> > >> On Saturday, Jul 19, 2003, at 08:43 Australia/Melbourne, Michael > >> Bellears wrote: > >> > >>> Radiator/Radmin is auth/acct for dialup users > (MAX6000/PM3's), and > >>> also DSL users(Cisco7200). > >>> > >>> Dialup users acct data is successfully up
Re: (RADIATOR) Radusage table not updated.
Hello Michael - The problem is due to the incorrect quoting of the string containing the "@" sign. In most clauses based on SQL, %0 can be used for the username string and it will always be correctly quoted. regards Hugh On Monday, Jul 21, 2003, at 20:24 Australia/Melbourne, Michael Bellears wrote: Hi Hugh, You should try the queries by hand to see what is happening. Upon further investigation, it appears as though the '@' in the username is causing the problem: Success without '@' mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Cl ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,AC CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values (1,'31200 LAPM/ V42BIS',344121,1058742326,'connect_test','755798217','203.149.64.50',0, '55849500',28682053,2,'86D0',89390039,3,'203.149.64.3'); Query OK, 1 row affected (0.01 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASID ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test' order by TIME_STAMP; +--++---+- +-+---+-++ | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | +--++---+- +-+---+-++ | connect_test | 1058742326 | 86D0 | 344121 | 203.149.64.50 | 203.149.64.3 | 3 | 2 | +--++---+- +-+---+-++ 1 row in set (0.00 sec) Failure with '@' mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Cl ient_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,AC CTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values (1,'31200 LAPM/ V42BIS',344121,1058742326,'[EMAIL PROTECTED]','755798217', '203.149.64.50',0,'55849500',28682053,2,'86D0',89390039,3,'203.149. 64.3'); Query OK, 1 row affected (0.00 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASID ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = '[EMAIL PROTECTED]' order by TIME_STAMP; Empty set (0.00 sec) Insert with correct data, but removing the '@' from username: mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_Nu mber,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE, ACCTOUTPUTOCTETS,ACCTSESSIONID,NASPORT,NASIDENTIFIER) values (18,21210,1058781354,'connect_test','atm 11','203.149.70.10',0,'3:2.261#184571819##speed:UBR:256#/ ',74104,2,77696,'9813',1,'203.63.121.145'); Query OK, 1 row affected (0.00 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASID ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test' order by TIME_STAMP; +--++---+- +-++-++ | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | +--++---+- +-++-++ | connect_test | 1058742326 | 86D0 | 344121 | 203.149.64.50 | 203.149.64.3 | 3 | 2 | | connect_test | 1058781354 | 9813 | 21210 | 203.149.70.10 | 203.63.121.145 | 1 | 2 | +--++---+- +-++-++ 2 rows in set (0.00 sec) Any suggestions on how to get around this? (I would like the username to be inserted with the '@dsl.datafx.com.au' if possible) Thanks in advance, MB On Saturday, Jul 19, 2003, at 08:43 Australia/Melbourne, Michael Bellears wrote: Radiator/Radmin is auth/acct for dialup users (MAX6000/PM3's), and also DSL users(Cisco7200). Dialup users acct data is successfully updated in the RADUSAGE table, but DSL clients are not(RADONLINE is working for both). I see the insert in trace4: Sat Jul 19 08:05:51 2003: DEBUG: do query is: insert into RADUSAGE (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES SIONID,NA SPORT,NASIDENTIFIER) values (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571 819##spee d:UBR:256#/',1,'980F',1,'203.63.121.145') And also the insert in the mysql logs: 88528 Query insert into RADUSAGE (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES SIONID,NA SPORT,NASIDENTIFIER) values (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571 819##spee d:UBR:256#/',1,'980F',1,'203.63.
RE: (RADIATOR) Radusage table not updated.
Hi Hugh, > > You should try the queries by hand to see what is happening. > Upon further investigation, it appears as though the '@' in the username is causing the problem: Success without '@' mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values (1,'31200 LAPM/V42BIS',344121,1058742326,'connect_test','755798217','203.149.64.50',0,'55849500',28682053,2,'86D0',89390039,3,'203.149.64.3'); Query OK, 1 row affected (0.01 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test' order by TIME_STAMP; +--++---+-+-+---+-++ | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | +--++---+-+-+---+-++ | connect_test | 1058742326 | 86D0 | 344121 | 203.149.64.50 | 203.149.64.3 | 3 | 2 | +--++---+-+-+---+-++ 1 row in set (0.00 sec) Failure with '@' mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTSESSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values (1,'31200 LAPM/V42BIS',344121,1058742326,'[EMAIL PROTECTED]','755798217','203.149.64.50',0,'55849500',28682053,2,'86D0',89390039,3,'203.149.64.3'); Query OK, 1 row affected (0.00 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = '[EMAIL PROTECTED]' order by TIME_STAMP; Empty set (0.00 sec) Insert with correct data, but removing the '@' from username: mysql> insert into RADUSAGE (ACCTTERMINATECAUSE,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_Number,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTOUTPUTOCTETS,ACCTSESSIONID,NASPORT,NASIDENTIFIER) values (18,21210,1058781354,'connect_test','atm 11','203.149.70.10',0,'3:2.261#184571819##speed:UBR:256#/',74104,2,77696,'9813',1,'203.63.121.145'); Query OK, 1 row affected (0.00 sec) mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test' order by TIME_STAMP; +--++---+-+-++-++ | USERNAME | TIME_STAMP | ACCTSESSIONID | ACCTSESSIONTIME | FRAMEDIPADDRESS | NASIDENTIFIER | NASPORT | ACCTSTATUSTYPE | +--++---+-+-++-++ | connect_test | 1058742326 | 86D0 | 344121 | 203.149.64.50 | 203.149.64.3 | 3 | 2 | | connect_test | 1058781354 | 9813 | 21210 | 203.149.70.10 | 203.63.121.145 | 1 | 2 | +--++---+-+-++-++ 2 rows in set (0.00 sec) Any suggestions on how to get around this? (I would like the username to be inserted with the '@dsl.datafx.com.au' if possible) Thanks in advance, MB > > > On Saturday, Jul 19, 2003, at 08:43 Australia/Melbourne, Michael > Bellears wrote: > > > Radiator/Radmin is auth/acct for dialup users (MAX6000/PM3's), and > > also DSL users(Cisco7200). > > > > Dialup users acct data is successfully updated in the > RADUSAGE table, > > but DSL clients are not(RADONLINE is working for both). > > > > I see the insert in trace4: > > > > Sat Jul 19 08:05:51 2003: DEBUG: do query is: insert into RADUSAGE > > > (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES > SIONID,NA > > SPORT,NASIDENTIFIER) values > > > (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571 > 819##spee > > d:UBR:256#/',1,'980F',1,'203.63.121.145') > > > > And also the insert in the mysql logs: > > > > 88528 Query insert into RADUSAGE > > > (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSES > SIONID,NA > > SPORT,NASIDENTIFIER) values > > > (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571 > 819##spee > > d:UBR:256#/',1,'980F',1,'203.63.121.145') > > > > But no results via Radmin Web Interface, or via CLI: > > > > mysql> select > > > USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDR > ESS,NASID > > ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USER
Re: (RADIATOR) Radusage table not updated.
Hello Michael - You should try the queries by hand to see what is happening. regards Hugh On Saturday, Jul 19, 2003, at 08:43 Australia/Melbourne, Michael Bellears wrote: Radiator/Radmin is auth/acct for dialup users (MAX6000/PM3's), and also DSL users(Cisco7200). Dialup users acct data is successfully updated in the RADUSAGE table, but DSL clients are not(RADONLINE is working for both). I see the insert in trace4: Sat Jul 19 08:05:51 2003: DEBUG: do query is: insert into RADUSAGE (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSESSIONID,NA SPORT,NASIDENTIFIER) values (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571819##spee d:UBR:256#/',1,'980F',1,'203.63.121.145') And also the insert in the mysql logs: 88528 Query insert into RADUSAGE (TIME_STAMP,USERNAME,ACCTDELAYTIME,DNIS,ACCTSTATUSTYPE,ACCTSESSIONID,NA SPORT,NASIDENTIFIER) values (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571819##spee d:UBR:256#/',1,'980F',1,'203.63.121.145') But no results via Radmin Web Interface, or via CLI: mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASID ENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = '[EMAIL PROTECTED]' order by TIME_STAMP; ERROR 1032: Can't find record in 'RADUSAGE' I see no errors in mysql.err log. A dialup users succesful insert FYR: Trcae4: Sat Jul 19 08:06:17 2003: DEBUG: do query is: insert into RADUSAGE (Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_Number,F RAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTSE SSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values ('49333',863,1058565977,'eplan','755103035','203.149.64.51',0,'55848000 ',10315,2,'425834844',45523,20206,'203.149.64.4') MySQL Log: 88528 Query insert into RADUSAGE (Connect_info,ACCTSESSIONTIME,TIME_STAMP,USERNAME,Client_Phone_Number,F RAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTSE SSIONID,ACCTOUTPUTOCTETS,NASPORT,NASIDENTIFIER) values ('49333',863,1058565977,'eplan','755103035','203.149.64.51',0,'55848000 ',10315,2,'425834844',45523,20206,'203.149.64.4') Thanks in advance. Regards, MB === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening? -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.