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,'[EMAIL
PROTECTED]',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,'[EMAIL
PROTECTED]',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 = '[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,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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
