Re: [Emerald] Yet another SQL problem
Dale E. Reed Jr. ( (no email) )
Mon, 16 Aug 1999 10:29:52 -0700
Ed Miller wrote:
>
> Any ideas on the problem? I really want to get this backed up
> correctly.
> Here is the output from -x15 which ras run today. BTW, all accounts
> come thru as expired:
>
> Resp Time: 2250 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
> radrecv: Request from host 7f000001 code=1, id=121, length=59
> NAS-Identifier = 127.0.0.1
> NAS-Port = 0
> User-Name = "emiller"
> Password = "#\020L=Z\010}\346"
> rad_authenticate_ODBC()
> Password = "#\020L=Z\010}\346"
>
> 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.LoginLimit From MasterAccounts ma, SubAccounts sa Where
> (sa.Login='emil
> ler' or sa.Shell='emiller' or sa.Email='emiller') AND
> ma.CustomerID=sa.CustomerI
> D and sa.Active<>0 and ma.Active<>0
>
> Decrypted Password: password
> Database Password: password
> Sending Reject of id 121 to 7f000001 (localhost)
> Your Account is Expired.
Cut/paste the SQL Statement into isql_w and send me the results.
Have you checked the saexpireDate to see what its set at?
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart