RE: (RADIATOR) Update not working

Jaskaran Singh Thu, 13 Jun 2002 13:15:50 -0700

Hi all

I think I have narrowed the problem to the fact that in my request I am only getting these attributes

Code: Accounting-Request

Identifier: 46

Authentic: E<25><167><9><235><190><14>b<9>a$<4><240>m<144><166>

Attributes:

Acct-Delay-Time = 0

NAS-IP-Address = 132.238.2.11

Acct-Status-Type = Accounting-On

Called-Station-Id = "123456789"

Calling-Station-Id = "987654321"

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jaskaran Singh
Sent: Thursday, June 13, 2002 3:25 PM
To: [EMAIL PROTECTED]
Subject: (RADIATOR) Update not working

Hello

If anyone can help me out with this question, I have a an Update Query which was working till 2 days back, but now has stopped working.

This is the query

Identifier Block-Time-SQL

DBSource dbi:mysql:test2:localhost

DBUsername xxxxx

DBAuth xxxxxx

DefaultSimultaneousUse 1

AuthSelect Select Time_Left from RADUSERS where User_Name='%n'

AuthColumnDef 0,Session-Timeout=Time_Left,reply

AccountingTable RADUSERS

AcctSQLStatement Update RADUSERS set Time_Left=Time_Left -'%{Acct-Session-Time}' \

where User_Name='%n';

</AuthBy>

Description Handler for Handling Accounting Requests from Students

AuthBy Block-Time-SQL

</Handler>

but it doesn’t execute. I am also attaching a trace 4 along with it.

Thu Jun 13 15:07:22 2002: DEBUG: Handling with Radius::AuthSQL

Thu Jun 13 15:07:22 2002: DEBUG: Handling accounting with Radius::AuthSQL

Thu Jun 13 15:07:22 2002: DEBUG: do query is: Update RADUSERS set Time_Left=Time_Left -'' where User_Name='';

Thu Jun 13 15:07:22 2002: DEBUG: Accounting accepted

Thu Jun 13 15:07:22 2002: DEBUG: Packet dump:

Any Ideas what I am doing wrong ??????

Thanks

Jaskaran Singh

University Systems & Security

Fairleigh Dickinson University

Teaneck, NJ 07666

RE: (RADIATOR) Update not working

Reply via email to