-----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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
