(RADIATOR) Update not working

[Jaskaran Singh]

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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
Behalf Of Jaskaran Singh
Sent: Thursday, June 13, 2002 3:25 PM
To: radiator at open.com.au
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
<AuthBy SQL>
        
        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>
 
<Handler Request-Type = Accounting-Request>
        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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020613/03a98a74/attachment.html>