Radius error

Keith Willis ( kwillis@mail.interconnect.net )
Thu, 27 Feb 1997 00:18:51 -0600

--=====================_857045931==_
Content-Type: text/plain; charset="us-ascii"

Greetings!

We really like the product! The integration with a database is very nice.

But alas, we are having a problem with PAP it seems. After spending some
time troubleshooting it looks like we have about a 40% failure with PAP
login attempts.

We are using Ascend Max 4000s (latest rev, 5.0A), the latest RADIUSNT, and
the Access Database that came with RADIUSNT. We have no problem with
authentication if the user types in their login name and password at the
Ascend Terminal prompt.

But, if we use PAP under Windows 95....it fails authentication 40% of the
time.

For kicks, we ran Radius in debug mode (radius -x15 -u radius7.mdb -o) and
got the attached log. I was hoping someone more versed in this program
could point us in the right direction. FYI: The logs on the Max look
fine....I have those also, if you would like to see them.

PS: We have some other Maxes (same OS) using a Linux version of Radius with
no problems whatsoever. Both sets of Maxes are setup identical. This is
what leads us to believe it is related to something in RADIUSNT.

Thanks in advance for any help!

--=====================_857045931==_
Content-Type: text/plain; charset="us-ascii"
Content-Disposition: attachment; filename="radlate.txt"

Here is the log:

The last entry for user 'nolan' is the one that disconnected in the PAP login attempt. All other entries for user 'nolan' were fine and valid authentication. Please let me know if you see anything pertinent.

Thanks

Start Log:
----------------------------------------------------------------------

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='nolan' or sa.Sh
ell='nolan') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: xmen4879
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=1

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 56 to cf65c2fb (max1)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 601
radrecv: Request from host cf65c2fb code=4, id=57, length=79
User-Name = "nolan"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "225715071"
Acct-Authentic = RADIUS
NAS-Port-DNIS = "3523292"
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic) VALUES (Now(),'nolan','207.
101.194.251',20119,1,0,'225715071',1)

Freeing SQL Statement...
Sending Accounting Ack of id 57 to cf65c2fb (max1)

Response Time: 190
radrecv: Request from host cf65c2fc code=1, id=54, length=102
User-Name = "csc"
Password = "\030\035)\306U\2776\340"
NAS-Identifier = 207.101.194.252
NAS-Port = 20120
NAS-Port-Type = Async
User-Service = Login-User
State = ""
Ascend-Third-Prompt = "ppp default"
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.90
Acct-Session-Id = "225715590"
rad_authenticate_ODBC()
Password = "\030\035)\306U\2776\340"
Decrypted Password: basic13
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='csc' or sa.Shel
l='csc') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: basic13
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=859

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 54 to cf65c2fc (max2)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 591
radrecv: Request from host cf65c2fb code=4, id=58, length=175
User-Name = "nolan"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "225715071"
Acct-Authentic = RADIUS
Acct-Session-Time = 15
Acct-Input-Octets = 951
Acct-Output-Octets = 1291
Acct-Input-Packets = 259
Acct-Output-Packets = 29
Ascend-Disconnect-Cause = 45
Ascend-Connect-Progress = 60
Ascend-Data-Rate = 33600
Ascend-PreSession-Time = 19
Ascend-Pre-Input-Octets = 17
Ascend-Pre-Output-Octets = 93
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-First-Dest = 207.101.194.255
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.33
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,AcctSessionTime,AcctInputOct
ets,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,FramedProtocol,FramedAdd
ress) VALUES (Now(),'nolan','207.101.194.251',20119,2,0,'225715071',1,15,951,129
1,259,29,1,'207.101.194.33')

Freeing SQL Statement...
Sending Accounting Ack of id 58 to cf65c2fb (max1)

Response Time: 401
radrecv: Request from host cf65c3fa code=1, id=160, length=55
NAS-Identifier = 207.101.195.250
NAS-Port = 6
User-Name = "bac"
Password = "\376z\3713V\324\247\330*\306\022(\323X\221D"
rad_authenticate_ODBC()
Password = "\376z\3713V\324\247\330*\306\022(\323X\221D"
Decrypted Password: mov1eman
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='bac' or sa.Shel
l='bac') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: mov1eman
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=65

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 160 to cf65c3fa (serial)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 520
radrecv: Request from host cf65c3fa code=4, id=161, length=68
NAS-Identifier = 207.101.195.250
NAS-Port = 6
User-Name = ""
Acct-Status-Type = Start
User-Service = Framed-User
Acct-Session-Id = "00000338"
Framed-Protocol = PPP
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,AcctDelayTime) VALUES (Now(),
'207.101.195.250',6,'',1,2,'00000338',1,0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 161 to cf65c3fa (serial)

Response Time: 211
radrecv: Request from host cf65c3fa code=4, id=162, length=74
NAS-Identifier = 207.101.195.250
NAS-Port = 6
User-Name = ""
Acct-Status-Type = 3
User-Service = Framed-User
Acct-Session-Id = "00000338"
Framed-Protocol = PPP
Framed-Address = 207.101.195.73
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,FramedAddress,AcctDelayTime)
VALUES (Now(),'207.101.195.250',6,'',3,2,'00000338',1,'207.101.195.73',0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 162 to cf65c3fa (serial)

Response Time: 220
radrecv: Request from host cf65c2fb code=4, id=59, length=179
User-Name = "jcprocell"
NAS-Identifier = 207.101.194.251
NAS-Port = 20122
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "225715042"
Acct-Authentic = RADIUS
Acct-Session-Time = 2594
Acct-Input-Octets = 266069
Acct-Output-Octets = 2453083
Acct-Input-Packets = 61291
Acct-Output-Packets = 3476
Ascend-Disconnect-Cause = 45
Ascend-Connect-Progress = 65
Ascend-Data-Rate = 24000
Ascend-PreSession-Time = 23
Ascend-Pre-Input-Octets = 40
Ascend-Pre-Output-Octets = 97
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-First-Dest = 206.81.40.2
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.34
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,AcctSessionTime,AcctInputOct
ets,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,FramedProtocol,FramedAdd
ress) VALUES (Now(),'jcprocell','207.101.194.251',20122,2,0,'225715042',1,2594,2
66069,2453083,61291,3476,1,'207.101.194.34')

Freeing SQL Statement...
Sending Accounting Ack of id 59 to cf65c2fb (max1)

Response Time: 400
radrecv: Request from host cf65c37d code=1, id=126, length=60
NAS-Identifier = 207.101.195.125
NAS-Port = 10
User-Name = "manycops"
Password = "\006\241\231rg\010yW\233I\227\316S\323\216+"
rad_authenticate_ODBC()
Password = "\006\241\231rg\010yW\233I\227\316S\323\216+"
Decrypted Password: relee1
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='manycops' or sa
..Shell='manycops') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Activ
e<>0

Database Password: relee1
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=371

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 126 to cf65c37d (cisco2many)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 531
radrecv: Request from host cf65c37d code=4, id=127, length=68
NAS-Identifier = 207.101.195.125
NAS-Port = 10
User-Name = ""
Acct-Status-Type = Start
User-Service = Framed-User
Acct-Session-Id = "0000047E"
Framed-Protocol = PPP
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,AcctDelayTime) VALUES (Now(),
'207.101.195.125',10,'',1,2,'0000047E',1,0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 127 to cf65c37d (cisco2many)

Response Time: 210
radrecv: Request from host cf65c37d code=4, id=128, length=74
NAS-Identifier = 207.101.195.125
NAS-Port = 10
User-Name = ""
Acct-Status-Type = 3
User-Service = Framed-User
Acct-Session-Id = "0000047E"
Framed-Protocol = PPP
Framed-Address = 207.101.195.83
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,FramedAddress,AcctDelayTime)
VALUES (Now(),'207.101.195.125',10,'',3,2,'0000047E',1,'207.101.195.83',0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 128 to cf65c37d (cisco2many)

Response Time: 220
radrecv: Request from host cf65c2fb code=1, id=60, length=98
User-Name = "nolan"
Password = "\203\360?\253\027\366\243Q\335"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.34
Acct-Session-Id = "225715072"
rad_authenticate_ODBC()
Password = "\203\360?\253\027\366\243Q\335"
Decrypted Password: xmen4879
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='nolan' or sa.Sh
ell='nolan') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: xmen4879
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=1

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 60 to cf65c2fb (max1)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 601
radrecv: Request from host cf65c2fb code=4, id=61, length=91
User-Name = "nolan"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "225715072"
Acct-Authentic = RADIUS
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.35
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,FramedAddress
) VALUES (Now(),'nolan','207.101.194.251',20119,1,0,'225715072',1,1,'207.101.194
..35')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Duplicate value in index, primary
key, or relationship. Changes were unsuccessful.
Sending Accounting Ack of id 61 to cf65c2fb (max1)

Response Time: 240
radrecv: Request from host cf65c2fb code=4, id=62, length=175
User-Name = "nolan"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "225715072"
Acct-Authentic = RADIUS
Acct-Session-Time = 17
Acct-Input-Octets = 1299
Acct-Output-Octets = 1337
Acct-Input-Packets = 294
Acct-Output-Packets = 31
Ascend-Disconnect-Cause = 45
Ascend-Connect-Progress = 60
Ascend-Data-Rate = 31200
Ascend-PreSession-Time = 20
Ascend-Pre-Input-Octets = 455
Ascend-Pre-Output-Octets = 464
Ascend-Pre-Input-Packets = 107
Ascend-Pre-Output-Packets = 13
Ascend-First-Dest = 207.101.194.255
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.35
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,AcctSessionTime,AcctInputOct
ets,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,FramedProtocol,FramedAdd
ress) VALUES (Now(),'nolan','207.101.194.251',20119,2,0,'225715072',1,17,1299,13
37,294,31,1,'207.101.194.35')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Duplicate value in index, primary
key, or relationship. Changes were unsuccessful.
Sending Accounting Ack of id 62 to cf65c2fb (max1)

Response Time: 421
radrecv: Request from host cf65c3fa code=4, id=163, length=104
NAS-Identifier = 207.101.195.250
NAS-Port = 10
User-Name = ""
Acct-Status-Type = Stop
User-Service = Framed-User
Acct-Session-Id = "000002DA"
Framed-Protocol = PPP
Framed-Address = 207.101.195.68
Acct-Input-Octets = 65708
Acct-Output-Octets = 323902
Acct-Input-Packets = 688
Acct-Output-Packets = 529
Acct-Session-Time = 7466
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,FramedAddress,AcctInputOctets
,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,AcctSessionTime,AcctDelayTi
me) VALUES (Now(),'207.101.195.250',10,'',2,2,'000002DA',1,'207.101.195.68',6570
8,323902,688,529,7466,0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 163 to cf65c3fa (serial)

Response Time: 300
radrecv: Request from host cf65c2fb code=1, id=63, length=105
User-Name = "rhodes"
Password = "\255\012\023\377\002k\012F"
NAS-Identifier = 207.101.194.251
NAS-Port = 20122
NAS-Port-Type = Async
User-Service = Login-User
State = ""
Ascend-Third-Prompt = "ppp default"
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.36
Acct-Session-Id = "225715073"
rad_authenticate_ODBC()
Password = "\255\012\023\377\002k\012F"
Decrypted Password: marcus5
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='rhodes' or sa.S
hell='rhodes') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: marcus5
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=502

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 63 to cf65c2fb (max1)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 601
radrecv: Request from host cf65c2fb code=4, id=64, length=80
User-Name = "rhodes"
NAS-Identifier = 207.101.194.251
NAS-Port = 20122
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "225715073"
Acct-Authentic = RADIUS
NAS-Port-DNIS = "3523292"
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic) VALUES (Now(),'rhodes','207
..101.194.251',20122,1,0,'225715073',1)

Freeing SQL Statement...
Sending Accounting Ack of id 64 to cf65c2fb (max1)

Response Time: 200
radrecv: Request from host cf65c3fa code=4, id=164, length=104
NAS-Identifier = 207.101.195.250
NAS-Port = 3
User-Name = ""
Acct-Status-Type = Stop
User-Service = Framed-User
Acct-Session-Id = "00000336"
Framed-Protocol = PPP
Framed-Address = 207.101.195.69
Acct-Input-Octets = 9586
Acct-Output-Octets = 4905
Acct-Input-Packets = 59
Acct-Output-Packets = 50
Acct-Session-Time = 126
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,FramedAddress,AcctInputOctets
,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,AcctSessionTime,AcctDelayTi
me) VALUES (Now(),'207.101.195.250',3,'',2,2,'00000336',1,'207.101.195.69',9586,
4905,59,50,126,0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 164 to cf65c3fa (serial)

Response Time: 310
radrecv: Request from host cf65c2fb code=1, id=65, length=98
User-Name = "nolan"
Password = "3\311[9\354*\271\204\327"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.39
Acct-Session-Id = "225715074"
rad_authenticate_ODBC()
Password = "3\311[9\354*\271\204\327"
Decrypted Password: xmen4879
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='nolan' or sa.Sh
ell='nolan') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: xmen4879
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=1

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 65 to cf65c2fb (max1)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 590
radrecv: Request from host cf65c2fb code=4, id=66, length=91
User-Name = "nolan"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "225715074"
Acct-Authentic = RADIUS
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.40
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,FramedProtocol,FramedAddress
) VALUES (Now(),'nolan','207.101.194.251',20119,1,0,'225715074',1,1,'207.101.194
..40')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Duplicate value in index, primary
key, or relationship. Changes were unsuccessful.
Sending Accounting Ack of id 66 to cf65c2fb (max1)

Response Time: 250
radrecv: Request from host cf65c2fb code=4, id=67, length=175
User-Name = "nolan"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "225715074"
Acct-Authentic = RADIUS
Acct-Session-Time = 7
Acct-Input-Octets = 765
Acct-Output-Octets = 1277
Acct-Input-Packets = 200
Acct-Output-Packets = 30
Ascend-Disconnect-Cause = 45
Ascend-Connect-Progress = 60
Ascend-Data-Rate = 31200
Ascend-PreSession-Time = 20
Ascend-Pre-Input-Octets = 401
Ascend-Pre-Output-Octets = 399
Ascend-Pre-Input-Packets = 106
Ascend-Pre-Output-Packets = 12
Ascend-First-Dest = 207.101.194.255
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.40
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,AcctSessionTime,AcctInputOct
ets,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,FramedProtocol,FramedAdd
ress) VALUES (Now(),'nolan','207.101.194.251',20119,2,0,'225715074',1,7,765,1277
,200,30,1,'207.101.194.40')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Duplicate value in index, primary
key, or relationship. Changes were unsuccessful.
Sending Accounting Ack of id 67 to cf65c2fb (max1)

Response Time: 421
radrecv: Request from host cf65c3fa code=4, id=165, length=104
NAS-Identifier = 207.101.195.250
NAS-Port = 6
User-Name = ""
Acct-Status-Type = Stop
User-Service = Framed-User
Acct-Session-Id = "00000338"
Framed-Protocol = PPP
Framed-Address = 207.101.195.73
Acct-Input-Octets = 16098
Acct-Output-Octets = 56146
Acct-Input-Packets = 157
Acct-Output-Packets = 121
Acct-Session-Time = 118
Acct-Delay-Time = 0
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,NASPort,UserName,AcctS
tatusType,UserService,AcctSessionId,FramedProtocol,FramedAddress,AcctInputOctets
,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,AcctSessionTime,AcctDelayTi
me) VALUES (Now(),'207.101.195.250',6,'',2,2,'00000338',1,'207.101.195.73',16098
,56146,157,121,118,0)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Field 'Calls.UserName' can't be a
zero-length string.
Sending Accounting Ack of id 165 to cf65c3fa (serial)

Response Time: 300
radrecv: Request from host cf65c2fb code=1, id=68, length=107
User-Name = "jcprocell"
Password = "\365\253\332\206\262\221\341"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
NAS-Port-Type = Async
User-Service = Login-User
State = ""
Ascend-Third-Prompt = "ppp default"
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.41
Acct-Session-Id = "225715075"
rad_authenticate_ODBC()
Password = "\365\253\332\206\262\221\341"
Decrypted Password: jclana
Allocating Statement...

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

Database Password: jclana
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=894

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 68 to cf65c2fb (max1)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 621
radrecv: Request from host cf65c2fb code=4, id=69, length=83
User-Name = "jcprocell"
NAS-Identifier = 207.101.194.251
NAS-Port = 20119
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "225715075"
Acct-Authentic = RADIUS
NAS-Port-DNIS = "3523292"
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic) VALUES (Now(),'jcprocell','
207.101.194.251',20119,1,0,'225715075',1)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Duplicate value in index, primary
key, or relationship. Changes were unsuccessful.
Sending Accounting Ack of id 69 to cf65c2fb (max1)

Response Time: 220
radrecv: Request from host cf65c2fc code=1, id=55, length=108
User-Name = "p_gillis"
Password = "\360\357xn\327P\002<\015"
NAS-Identifier = 207.101.194.252
NAS-Port = 20101
NAS-Port-Type = Async
User-Service = Login-User
State = ""
Ascend-Third-Prompt = "ppp default"
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.47
Acct-Session-Id = "225715591"
rad_authenticate_ODBC()
Password = "\360\357xn\327P\002<\015"
Decrypted Password: abstract
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='p_gillis' or sa
..Shell='p_gillis') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Activ
e<>0

Database Password: abstract
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=234

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 55 to cf65c2fc (max2)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 610
radrecv: Request from host cf65c2fb code=4, id=70, length=177
User-Name = "gjuneau"
NAS-Identifier = 207.101.194.251
NAS-Port = 20105
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Id = "225715068"
Acct-Authentic = RADIUS
Acct-Session-Time = 537
Acct-Input-Octets = 7339
Acct-Output-Octets = 35036
Acct-Input-Packets = 2550
Acct-Output-Packets = 148
Ascend-Disconnect-Cause = 45
Ascend-Connect-Progress = 60
Ascend-Data-Rate = 14400
Ascend-PreSession-Time = 11
Ascend-Pre-Input-Octets = 369
Ascend-Pre-Output-Octets = 335
Ascend-Pre-Input-Packets = 117
Ascend-Pre-Output-Packets = 11
Ascend-First-Dest = 207.101.194.255
NAS-Port-DNIS = "3523292"
Framed-Protocol = PPP
Framed-Address = 207.101.194.23
Allocating Statement...

SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NASPort,AcctS
tatusType,AcctDelayTime,AcctSessionId,AcctAuthentic,AcctSessionTime,AcctInputOct
ets,AcctOutputOctets,AcctInputPackets,AcctOutputPackets,FramedProtocol,FramedAdd
ress) VALUES (Now(),'gjuneau','207.101.194.251',20105,2,0,'225715068',1,537,7339
,35036,2550,148,1,'207.101.194.23')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC Microsoft Access 7.0 Driver] Duplicate value in index, primary
key, or relationship. Changes were unsuccessful.
Sending Accounting Ack of id 70 to cf65c2fb (max1)

Response Time: 420
radrecv: Request from host cf65c2fc code=1, id=56, length=105
User-Name = "sprince"
Password = "\362\241A\245\021\357\033"
NAS-Identifier = 207.101.194.252
NAS-Port = 20111
NAS-Port-Type = Async
User-Service = Login-User
State = ""
Ascend-Third-Prompt = "ppp default"
NAS-Port-DNIS = "3523292"
Framed-Address = 207.101.194.50
Acct-Session-Id = "225715593"
rad_authenticate_ODBC()
Password = "\362\241A\245\021\357\033"
Decrypted Password: susman
Allocating Statement...

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

Database Password: susman
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=440

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 56 to cf65c2fc (max2)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 611
radrecv: Request from host cf65c3fa code=1, id=166, length=55
NAS-Identifier = 207.101.195.250
NAS-Port = 10
User-Name = "bac"
Password = "\333\317\020\232\217\221\246\303\247\254Y0\377\260\316\345"
rad_authenticate_ODBC()
Password = "\333\317\020\232\217\221\246\303\247\254Y0\377\260\316\345"
Decrypted Password: mov1eman
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate), DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='bac' or sa.Shel
l='bac') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Database Password: mov1eman
Freeing SQL Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadConfig
s rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountI
D=65

Freeing SQL Statement...
Loading radius defaults for this type...
Allocating Statement...
Allocating Statement...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadATConf
igs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.Accou
ntType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Ascend-Idle-Limit = Ascend-Idle-Limit (14400)
Freeing SQL Statement...
Sending Ack of id 166 to cf65c3fa (serial)
Framed-Protocol = PPP
User-Service = Framed-User
Ascend-Idle-Limit = 14400

Response Time: 520

--=====================_857045931==_
Content-Type: text/plain; charset="us-ascii"

_________________________________________________________________________
Keith Willis Interconnect Services Inc.
Director of Engineering Services 535 S. Carancahua Ste. 5
Mail: kwillis@interconnect.net Corpus Christi, Texas 78401
Dial-Up Access: 693-SURF (7873) Voice: (512) 884-3447

WWW: http://www.interconnect.net
"Corpus Christi's Own Full Service Internet Access Provider"
_________________________________________________________________________

--=====================_857045931==_--