CallsOnline

Gary Austin ( (no email) )
Mon, 31 Mar 1997 23:30:04 -0500

Here is what I get when I run in -x15 mode:

radrecv: Request from host d0054c04 code=1, id=80, length=78
User-Name = "test"
Password = "test"
NAS-Identifier = nas number
NAS-Port = 4
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "test"
Decrypted Password: test
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d',
ma.extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.L
ogin, sa.Shell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa
Where (s
a.Login='test' or sa.Shell='test') AND ma.CustomerID=sa.CustomerID an
d sa.Active<>0 and ma.Active<>0

ODBC: SQLFetch Error:100: (00000)

Freeing SQL Statement...
Not Found in ODBC, Checking users file...
rad_authenticate()
Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is test
decrypted pwd is test
Sending Ack of id 80 to d0054c04 (correct number)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 255.255.255.254
Framed-Netmask = 255.255.255.0
Framed-Routing = Broadcast-Listen
Framed-Compression = Van-Jacobsen-TCP-IP
Framed-MTU = 1500

Response Time: 343
radrecv: Request from host d0054c04 code=4, id=77, length=118
Acct-Session-Id = "04002C2D"
User-Name = "test2"
NAS-Identifier = nas number
NAS-Port = 6
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Session-Time = 2332
Acct-Authentic = RADIUS
Acct-Input-Octets = 27100
Acct-Output-Octets = 18495
Acct-Terminate-Cause = User-Request
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = good number
Acct-Delay-Time = 657
Allocating Statement...

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentif
ier,NASPort,NASPortType,AcctStatusType,AcctSessionTime,AcctAuthentic,Acc
tInpu
tOctets,AcctOutputOctets,UserService,FramedProtocol,FramedAddress,AcctD
elayTi
me) VALUES (Now(),'04002C2D','test2','nas number',6,0,2,2332,1,27100,18495
,2,1,'good number',657)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 97 Driver] The changes you
requested to th
e table were not successful because they would create duplicate values
in the
index, primary key,
Sending Accounting Ack of id 77 to d0054c04 (nas number)

Response Time: 391
radrecv: Request from host d0054c04 code=4, id=81, length=94
Acct-Session-Id = "04002C3F"
User-Name = "test3"
NAS-Identifier = nas number
NAS-Port = 4
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = good number
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentif
ier,NASPort,NASPortType,AcctStatusType,AcctAuthentic,UserService,Framed
Protoc
ol,FramedAddress,AcctDelayTime) VALUES (Now(),'04002C3F','test3','nas
number',4,0,1,1,2,1,'good number',0)

Freeing SQL Statement...
Allocating Statement...

C:\radius>

I get a DR. Watson error right after the Allocating Statement. It is an
access violation error. Then Radius stops and I am at the c:\radius
prompt.