Shaun,
The syntax look right. It is case sensative though...make sure
you have everything in the same case that is is in your database. It
might help for you to reply to the list with a Trace of the Radiator
log.
-Ronan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Shaun Eck
Sent: Tuesday, 19 February, 2002 15:43
To: [EMAIL PROTECTED]
Subject: (RADIATOR) Update Not working
Hi
I have tried updating the balancetime in the Database, however it is not
working, could you please tell me what I am doing wrong.
Regards
<Realm sql.realm>
RewriteUsername s/^([^@]+).*/$1/
<AuthBy SQL>
Identifier SQL
DBSource dbi:Informix:tis.
DBUsername xxxxxx
DBAuth xxxxxx
AuthSelect select password, balancetime from subscribers where
(username='%n' and balancetime > 0)
AuthColumnDef 0,Password,check
AuthColumnDef 1,Session-Timeout,reply
AddToReply Service-Type = Framed-User,Framed-Protocol = PPP
AcctSQLStatement update subscribers set balancetime =
balancetime-0%{Acct-Session-Time} where username = '%n"
</AuthBy>
</Realm>
===
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.
