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,'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,NA SPORT,NASIDENTIFIER) values (1058565951,'[EMAIL PROTECTED]',0,'3:2.261#184571819##spee d: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,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.
