[Emerald] FW: problem with authentication

wilson@dagupan.com
Tue, 4 Jan 2000 11:39:05 +0800

Last year 1999, all logins were fine, then when we reached the year 2000,
users suddenly fail to login. Using the radius -x15 and radlogin, we get the
following:

> from radlogin screen:
>
> reply-message="you are not allowed access from this port"
>
> from the radius-x15 screen:
>
> Accounting Column 18 (1): 'Status'
> 19 Accounting Columns Loaded
>
> Enterprise features enabled.
>
> RadiusNT 2.5.178 (Emerald Standard) Initialized...
>
>
> radrecv: Request from host 7f000001 code=1, id=49, length=57
> NAS-Identifier = 127.0.0.1
> NAS-Port = 0
> User-Name = "user1"
> Password = "\305\327\033\003h\314\327I\217\371\372K\301y\234\277"
> rad_authenticate_ODBC()
>
> SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
> (ma.Extension+ma
> .OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
> sa.Extensi
> on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
> sa.Sh
> ell, sa.TimeLeft, sa.LoginLimit, ma.Balance, ma.OverLimit From
> MasterAccounts ma
> , SubAccounts sa Where sa.Login='user1' AND ma.CustomerID=sa.CustomerID
> and sa
> .Active<>0 and ma.Active<>0
>
> Balance: 0.00
> OverLimit: 5000.00
> Checking for duplicate logins.
>
> SQL Statement: RadCheckOnline 'user1'
>
> user1 found on-line 0 time(s).
> Checking for port access.
>
> SQL Statement: RadCheckPort '127.0.0.1', 0, 'PPP10R'
>
> ODBC Error:S0002:208:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> 'ServerAcces
> s'.
>
> Sending Reject of id 49 to 7f000001 (localhost)
> User: user1 port Access denied
> User: user1 port Access denied
> SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data,
> NASIde
> ntifier, NASPort, CallerID) VALUES (16, GetDate(), 'user1',
> 'Server:localhost P
> ort:0 (Time)', '127.0.0.1', 0, NULL)
>
> Resp Time: 350 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
>

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart