Re: [RadiusNT] RadiusNt 3 Auth Problem

Mike Kovacich ( (no email) )
Mon, 10 Jan 2000 21:23:35 -0500

OK, I'll try again. Same problem but with MS ACCESS. Is the below fix as suggested by Peter Deacon available for a MS ACCESS database or is this
fix available for SQL users only ?

Mike Kovacich wrote:

> Same problem but with MS ACCESS.
>
> Peter Deacon wrote:
>
> > On Sun, 9 Jan 2000 hostmaster@interaxs.net wrote:
> >
> > > I have purchased and installed version 3 and I am having a problem with it.
> >
> > > The caching is great but, it seems that any additions or changes to the
> > > Active status of an account are not recognized. We are using an MSSQL db.
> >
> > > If a new user signs up online, all necessary db entries are made during the
> > > signup process to allow them instant access to our network. Since
> > > installing v 3, they cannot authenticate. The RadLogs reason is 10 User not
> > > found.
> >
> > > If a users account has been deactivated for non-payment (Active set to 0)
> > > and a payment is recorded to their account, they are automatically
> > > reinstated to Active = 1. They cannot authenticate. Again RagLogs reason 10
> > > User not found.
> >
> > It's a bug in the RadGetUser stored procedure found in the install/upgrade
> > scripts for RadiusNT databases.
> >
> > Replace the proc below with the one currently in your mssql db.
> >
> > (Don't do this if your using Emerald)
> >
> > CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) AS
> > SELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType, sa.LoginLimit, sa.TimeLeft,
> > MasterExpire=CASE WHEN maExpireDate IS NULL THEN NULL ELSE DATEDIFF(Day,'Jan 11970',DATEADD(Day,ma.Extension+ma.OverDue,maExpireDate)) END,
> > SubExpire=CASE WHEN saExpireDate IS NULL THEN NULL ELSE DATEDIFF(Day,'Jan 1 1970',DATEADD(Day,sa.Extension,saExpireDate))
> > END FROM SubAccounts sa, MasterAccounts ma
> > WHERE sa.CustomerID = ma.CustomerID
> > AND sa.Active <> 0
> > AND ma.Active <> 0
> > AND sa.Login = @user
> > AND (@password IS NULL OR sa.Password = @password)
> > GO
> >
> > ciao,
> > Peter
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
>
> --
> Mike Kovacich
> System Administrator
> mailto:sysadmin@inter-pc.com
>
> Inter-PC Internet Services
> http://www.inter-pc.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

--Mike KovacichSystem Administratormailto:sysadmin@inter-pc.com

Inter-PC Internet Serviceshttp://www.inter-pc.com

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