(RADIATOR) Radusage table not updated.

[Michael Bellears]

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,NASPORT,NASIDENTIFIER) values (1058565951,'connect_test at dsl.datafx.com.au',0,'3:2.261#184571819##speed:UBR:256#/',1,'0000980F',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,NASPORT,NASIDENTIFIER) values (1058565951,'connect_test at dsl.datafx.com.au',0,'3:2.261#184571819##speed:UBR:256#/',1,'0000980F',1,'203.63.121.145')

But no results via Radmin Web Interface, or via CLI:

mysql> select USERNAME,TIME_STAMP,ACCTSESSIONID,ACCTSESSIONTIME,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,ACCTSTATUSTYPE from RADUSAGE where USERNAME = 'connect_test at dsl.datafx.com.au'  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,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTSESSIONID,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,FRAMEDIPADDRESS,ACCTDELAYTIME,DNIS,ACCTINPUTOCTETS,ACCTSTATUSTYPE,ACCTSESSIONID,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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.