Accounting Errors

John Rickabaugh ( (no email) )
Thu, 28 May 1998 21:22:30 -0600

Dale,

Ever since the last beta, currently running the full zip downloaded today
from the ftp site, I have been unable to get the calls online to update.
Here is a snip from the accounting debug log:

radrecv: Request from host cea89302 code=4, id=57, length=58

Acct-Status-Type = Start
Acct-Session-Id = "1919"
User-Name = "info4you"
NAS-Port = 2
NAS-Identifier = "DU"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)
VALUES (Now(),1,'1919','info4you',2,'DU')

SQL Statement: UPDATE CallsOnline Set
Username='info4you',AcctStatusType=1, CallDate=Now(), FramedAddress=NULL
WHERE NASIdentifier='DU' and NASPort=2 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.

Sending Accounting Ack of id 57 to cea89302 (DU)

Resp Time: 47 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host cea89302 code=4, id=58, length=58

Acct-Status-Type = Stop
Acct-Session-Id = "1919"
User-Name = "info4you"
NAS-Port = 2
NAS-Identifier = "DU"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)
VALUES (Now(),2,'1919','info4you',2,'DU')

SQL Statement: UPDATE CallsOnline Set
Username='info4you',AcctStatusType=2, CallDate=Now(), FramedAddress=NULL
WHERE NASIdentifier='DU' and NASPort=2 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.

Sending Accounting Ack of id 58 to cea89302 (DU)

Resp Time: 16 Auth: 1/0 -> 1 Acct: 2/0/0 -> 2
radrecv: Request from host cea89302 code=4, id=60, length=58

Acct-Status-Type = Start
Acct-Session-Id = "1920"
User-Name = "info4you"
NAS-Port = 2
NAS-Identifier = "DU"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)
VALUES (Now(),1,'1920','info4you',2,'DU')

SQL Statement: UPDATE CallsOnline Set
Username='info4you',AcctStatusType=1, CallDate=Now(), FramedAddress=NULL
WHERE NASIdentifier='DU' and NASPort=2 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.

Sending Accounting Ack of id 60 to cea89302 (DU)

Resp Time: 31 Auth: 2/0 -> 2 Acct: 3/0/0 -> 3
radrecv: Request from host cea89302 code=4, id=61, length=58

Acct-Status-Type = Stop
Acct-Session-Id = "1920"
User-Name = "info4you"
NAS-Port = 2
NAS-Identifier = "DU"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)
VALUES (Now(),2,'1920','info4you',2,'DU')

SQL Statement: UPDATE CallsOnline Set
Username='info4you',AcctStatusType=2, CallDate=Now(), FramedAddress=NULL
WHERE NASIdentifier='DU' and NASPort=2 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.

Sending Accounting Ack of id 61 to cea89302 (DU)

Resp Time: 31 Auth: 2/0 -> 2 Acct: 4/0/0 -> 4
radrecv: Request from host cea89302 code=4, id=63, length=58

Acct-Status-Type = Start
Acct-Session-Id = "1921"
User-Name = "info4you"
NAS-Port = 2
NAS-Identifier = "DU"
Framed-Protocol = PPP

SQL Statement: INSERT INTO Calls
(CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASIdentifier)
VALUES (Now(),1,'1921','info4you',2,'DU')

SQL Statement: UPDATE CallsOnline Set
Username='info4you',AcctStatusType=1, CallDate=Now(), FramedAddress=NULL
WHERE NASIdentifier='DU' and NASPort=2 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.

Sending Accounting Ack of id 63 to cea89302 (DU)

Resp Time: 31 Auth: 3/0 -> 3 Acct: 5/0/0 -> 5

What do I need to do to correct this. The calls table is updating
correctly.

John