(RADIATOR) Update Not working

[Hugh Irvine]

Hello Shaun -

The configuration looks OK - can you please send me a trace 4 showing what is 
happening?

thanks

Hugh


On Wed, 20 Feb 2002 07:43, Shaun Eck wrote:
> 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>

-- 
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.