Calls Online

Bruno Tremblay ( (no email) )
Fri, 22 May 1998 08:05:00 -0400

Hi,

I have some problemes with my calls online.
All Other things appear to work fine.

There the message I got.

Radrecv: Request from host c7a6db03 code=4, id=30, length=126
Acct-Status-Type = Stop
NAS-Identifier = XXX.XXX.XXX.X
Acct-Delay-Time = 0
NAS-Port = 8
Acct-Session-ID = "1138774.21.08.0"
Acct-Authentic = RADIUS
User-Service = Framed-User
Acct-Session-Time = 16
Framed-Protocol = PPP
Framed-Addrress = XXX.XXX.XXX.XXX
Acct-Input-Packets = 52
Acct-Output-Packets = 53
Acct-Input-Octets = 3771
Acct-Output-Octets = 17466

SQL Statement: INSERT INTO Calls (CallDate,AcctStatusType,NASIdentifier,
AcctDelayTime,UserName,NASPort, AcctSessionID,
AcctSessionTime,FramedAddress,AcctInputOctets,AcctOutputOctets) VALUES
(Now(),2,'XXX.XXX.XXX.X',0,'XXXppp',8,'1137844.21.08.0',16.'XXX.XXX.XXX.XXX,
3771,17466)

SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,
CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE
NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',
0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)

ODBC Error:07001:-3010:
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.
Expected 2.

SQL Statement: UPDATE SubAccounts SET TimeLeft=TimeLeft-16 Where
TimeLieft<>Null And TimeLeft<>-9999 And Login='XXXppp'

Sending Accounting Ack of id 30 to c7a6db03 (Vserver (XXX.XXX.XXX.X))

Resp Time: 230 Auth: 8/1 -> 9 Acct: 14/0/0 -> 14

If someone can say me which value I need to use in table ServerAccess,
StartTime and StopTime. Each time I tried to use that service I got tha
error in logs : Server:Vserver9 (XXX.XXX.XXX.XXX) Port:15 (Time)

Thanks

Bruno Tremblay