radrecv: Request from host 3fa0f2c1 code=1, id=176, length=92
User-Name = "hancock"
Password = "DT\220\344g\306\265"
NAS-Identifier = 63.160.242.193
NAS-Port = 20318
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
State = ""
NAS-Port-DNIS = "3572872"
Acct-Session-Id = "316167831"
rad_authenticate_ODBC()
Password = "DT\220\344g\306\265"
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, sa.TimeLeft, sa.LoginLimit From
MasterAccounts ma, SubAccounts sa Where (sa.Login='hancock' or
sa.Shell='hancock') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0
Decrypted Password: ***
Database Password: ***
Checking for port access.
SQL Statement: RadCheckPort '63.160.242.193', 20318, 'PPP'
SQL Statement: RadGetConfigs 854
Loading radius defaults for this type...
SQL Statement: RadGetATConfigs 'PPP'
User-Service = 2 (2)
Framed-Protocol = 1 (1)
Session-Timeout = 1 (18000)
Ascend-Maximum-Time = 1 (18000)
CHECK NAS-Port-Type = Async (1)
Sending Reject of id 176 to 3fa0f2c1 (maxD)
User: hancock check attributed failed.
User: hancock check attributed failed.
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUES (18, GetDate(), 'hancock', '***')
ODBC Error:23000:547:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__632EC2FF'. The
conflict occurred in database 'Backup', table 'RadLogMsgs', column
'RadLogMsgID'
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart