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.
Your Account is Expired.
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data,
Caller
ID) VALUES (12, GetDate(), 'emiller', '-52390626', NULL)
Resp Time: 234 Auth: 0/2 -> 2 Acct: 0/0/0 -> 0
>
>
>
> > Ed Miller wrote:
> > >
> > > Boy I missed that one all together.
> > > Sorry Charlie. ;-)
> > > I need sleep.
> > > Only when running in ODBC.
> > > Yes, it works fine in TEXT.
> >
> > What does the DB entry for the user look like, then?
>
> Paid-thur, Billed and expire all are 12/19/01
>
>
> >
> > > > Ed Miller wrote:
> > > > >
> > > > > Dale,
> > > > > Can you come up with any reason why this is happening?
> > > >
> > > > I was waiting for you to respond to Charlie's question, as it was
> > > > the same I was going to ask you. Did you see his response?
> > > > The users file has nothing to do with authentication, unless you
> > > > are in both mode. Are you?
> > > >
> > > > >
> > > > > > I have gotten time to move my damaged DB to another server
but
> > > when I
> > > > > > plug into that server
> > > > > > all accounts come through as expired.
> > > > > > I ran check db against the new server but it did not help.
> > > > > > This is the output from radlogin:
> > > > > >
> > > > > > C:\radius>radlogin emiller password
> > > > > >
> > > > > > Checking Radius user emiller:
> > > > > > Reply-Message = "Your Account is Expired.\012"
> > > > > >
> > > > > > This is what is in the radusers files:
> > > > > >
> > > > > > emiller Password = "password", Expiration = "Dec 19 2001"
> > > > > > Ascend-Idle-Limit = 1200
> > > > > > Framed-Protocol = 1
> > > > > > Idle-Timeout = 1200
> > > > > > User-Service = 2
> > > > > >
> > > > > > Again any ideas?
> > > > > >
> > > > > > Ed Miller
> > >
> > > For more information about this list (including removal) go to:
> > > http://www.iea-software.com/support/maillists/liststart
> >
> >
> > --
> >
> > 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
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart