(RADIATOR) Config Emerald

[Carlos Molina]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greetings.

We are testing radiator with emerald, but we are see on the debugs that 
the start/stop request query is:

Mon Nov 25 11:28:47 2002: DEBUG: do query is: insert into Calls 
(NASPort,UserName,CallDate,AcctSessionId,AcctStatusType,NASIdentifier,AcctDelayTime) 
values (31,'srodriguez','Nov 25, 2002 
11:28','000048AC',3,'172.16.254.254',0)


We are see that the emerald, accepts, for billing purposes .on the 
LoginLimit field on SubAccounts table , two values: 0 (stop request) and 
1 (start request)

Look, that the query have the 3 value for AcctStatusType

I see on my config file the following lines

AcctSQLStatement update ServerPorts set Username='%n', 
AcctSessionId='%{Acct-Session-Id}', AcctStatusType= case 
'%{Acct-Status-Type}' when 'Stop' then 2 else 1 end, CallDate=getdate(), 
FramedAddress='%a'
where ServerID=(select ServerID from Servers where 
IPAddress='%{Client:Name}') and Port=0%{NAS-Port}


but originally this was

AcctSQLStatement update ServerPorts set Username='%n', 
AcctSessionId='%{Acct-Session-Id}', AcctStatusType= case 
'%{Acct-Status-Type}' when 'Start' then 1 when 'Stop' then 2 else 3 end, 
CallDate=getdate(), FramedAddress='%a', 
CallerId='%{Calling-Station-Id}', ConnectInfo='%{Connect-Info}' where 
ServerID=(select ServerID from Servers where IPAddress='%{Client:Name}') 
and Port=0%{NAS-Port}

Note that we delete the 3 value for the case statement on the 
Acct-Status-Type field.

The problem is that we don't see this change reflect.

On what module we should make the changes to reflect this situation..??

Thanks a lot.

Carlos
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE94pJtho8byKxa2jgRAvapAJ9MVcZE+rjyKsxyD+0vjqU9KtxXmgCfYSlw
sTZIpUbzj+sJrnKkR6YAXGM=
=wGaG
-----END PGP SIGNATURE-----


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