(RADIATOR) Radusage table not updated.

[Hugh Irvine]

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,'connect_test at dsl.datafx.com.au',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,'connect_test at dsl.datafx.com.au',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 =  
> '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,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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.