ServerAccess follow up.

hostmaster@interaxs.net
Fri, 24 Apr 1998 18:59:15 -0400

Below is the debug capyure from an auth attempt while Server Access was on.
The sql fetch fails. Not certain why...

Jim

radrecv: Request from host cef4b5fe code=1, id=156, length=73
User-Name = "MIK"
Password = "n\010\207\025\015mGP\363\227\012\204c\312\327+"
NAS-Identifier = 206.244.181.254
NAS-Port = 18
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "n\010\207\025\015mGP\363\227\012\204c\312\327+"

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell, sa.TimeLeft, sa.LoginLimit From MasterAccounts ma, SubAccounts sa
Whe
re (sa.Login='MIK' or sa.Shell='MIK') AND ma.CustomerID=sa.CustomerID and
sa.Act
ive<>0 and ma.Active<>0

Decrypted Password: xxxx
Database Password: xxxx
Checking for duplicate logins.

SQL Statement: Select Count(*) from CallsOnline Where UserName='MIK' and
AcctSt
atusType=1

MIK found on-line 0 time(s).
Checking for port access.

SQL Statement: Select MaxSessionLength From Servers s, ServerAccess sa
Where s
..ServerID = sa.ServerID AND sa.Port=18 AND s.IPAddress = '206.244.181.254'
AND s
a.AccountType = 'PPP'

LOG: ODBC: SQLFetch Error: (07001)
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.

ODBC: SQLFetch Error: (07001)
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
ODBC: SQLFetch Error: (07001)
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
Sending Reject of id 156 to cef4b5fe (pm1)
LOG: User: MIK port Access denied
User: MIK port Access denied
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, UserName, Data)
VALUE
S (16, Now, 'MIK', 'Server: Port:0')
----------------------------
hostmaster@interaxs.net
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773