First,
I am getting the following errors in my radius logfile. I don't have a =
use named "mo" so=20
that one is understandable but the other 2 are not.
Mon Jun 29 12:33:31 1998: ODBC Error:23000:547:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement =
conflicted with COLUMN FOREIGN KEY constraint =
'FK__RadLogs__RadLogM__1E1A7EA3'. The conflict occurred in database =
'EMERALD', table 'RadLogMsgs', column 'RadLogMsgID'
Mon Jun 29 12:33:31 1998: User: mo Not found
I get the following error a lot all by its self.
Mon Jun 29 12:38:50 1998: ODBC Error:23000:2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY =
constraint 'pk_Calls': Attempt to insert duplicate key in object =
'Calls'.
Second,
I have 2 cisco routers that I am doing virtual private dialup networking =
with users dialing in and being authenicated through emerald. The =
following is the log of a normal login of one of these users using the =
radius loging feature.
radrecv: Request from host cf01b508 code=3D1, id=3D32, length=3D70
NAS-Identifier =3D 207.1.181.8
NAS-Port =3D 63000
User-Name =3D "Lanman"
Password =3D "\202\323\260o\340H\360{1\034 \002\243Uks"
User-Service =3D Framed-User
Framed-Protocol =3D PPP
rad_authenticate_ODBC()
Password =3D "\202\323\260o\340H\360{1\034 \002\243Uks"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, =
(ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), =
DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, =
sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, =
SubAccounts sa Where (sa.Login=3D'Lanman' or sa.Shell=3D'Lanman' or =
sa.Email=3D'Lanman') AND ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 =
and ma.Active<>0
Decrypted Password:=20
Database Password:=20
Checking for duplicate logins.
SQL Statement: RadCheckOnline 'Lanman'
Lanman found on-line 0 time(s).
SQL Statement: RadGetConfigs 171
Loading radius defaults for this type...
SQL Statement: RadGetATConfigs 'PPP'
User-Service =3D Framed-User (2)
Framed-Protocol =3D PPP (1)
Framed-Routing =3D Broadcast-Listen (3)
Idle-Timeout =3D 1200 (1200)
Ascend-Assign-IP-Pool =3D 1 (1)
Password =3D (0)
User-Name =3D (0)
Sending Ack of id 32 to cf01b508 (csntop.parod.com)
User-Service =3D Framed-User
Framed-Protocol =3D PPP
Framed-Routing =3D Broadcast-Listen
Idle-Timeout =3D 1200
Ascend-Assign-IP-Pool =3D 1
Password =3D " "
User-Name =3D " "
Resp Time: 50 Auth: 1/0 -> 1 Acct: 0/0/0 -> 1
radrecv: Request from host cf01b508 code=3D4, id=3D31, length=3D89
NAS-Identifier =3D 207.1.181.8
NAS-Port =3D 63000
User-Name =3D "Lanman"
Caller-Id =3D "192.168.98.41"
Acct-Status-Type =3D Start
User-Service =3D Framed-User
Acct-Session-Id =3D "000002BD"
Framed-Protocol =3D PPP
Acct-Delay-Time =3D 0
SQL Statement: INSERT INTO Calls =
(CallDate,NASIdentifier,NASPort,UserName,AcctStatusType,UserService,AcctS=
essionId,FramedProtocol,AcctDelayTime) VALUES =
(GetDate(),'207.1.181.8',63000,'Lanman',1,2,'000002BD',1,0)
Sending Accounting Ack of id 31 to cf01b508 (csntop.parod.com)
Resp Time: 80 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host cf01b508 code=3D4, id=3D33, length=3D119
NAS-Identifier =3D 207.1.181.8
NAS-Port =3D 63000
User-Name =3D "Lanman"
Caller-Id =3D "192.168.98.41"
Acct-Status-Type =3D Stop
User-Service =3D Framed-User
Acct-Session-Id =3D "000002BD"
Framed-Protocol =3D PPP
Acct-Input-Octets =3D 0
Acct-Output-Octets =3D 0
Acct-Input-Packets =3D 0
Acct-Output-Packets =3D 0
Acct-Session-Time =3D 0
Acct-Delay-Time =3D 0
SQL Statement: INSERT INTO Calls =
(CallDate,NASIdentifier,NASPort,UserName,AcctStatusType,UserService,AcctS=
essionId,FramedProtocol,AcctInputOctets,AcctOutputOctets,AcctSessionTime,=
AcctDelayTime) VALUES =
(GetDate(),'207.1.181.8',63000,'Lanman',2,2,'000002BD',1,0,0,0,0)
Sending Accounting Ack of id 33 to cf01b508 (csntop.parod.com)
Everything works fine but no one that is loging into csntop.parod.com =
(which is a cisco router) is showing up on the On-Line page of Emerald.=20