Re: [Emerald] Strange Serv-U issue

Dale E. Reed Jr. ( (no email) )
Fri, 21 Jan 2000 14:27:36 -0800

"David V. Brenner" wrote:
>
> : Here's the kicker: If I attempt to log in the first user, the
> : user is simply
> : denied access, as he should be. If, however, I try the same with
> : the second
> : account, Serv-U crashes immediately after I enter the user name and press
> : {enter} and Dr. Watson pulls out his stethoscope. Iam never
> : prompted for a
> : password. Cool, 'eh?
>
> This is nuts. If I add a user directory entry in Emerald for the user who
> is crashing Serv-U, it works fine. This is a problem. If there is no
> directory, he should simply be denied access - not blow up my server. :D

The only thing I could think of is if the homedir is null, causing some
problems. You could try modifying your VerifyFTPUser proc to wrap a
isnull around the homedir:

CREATE PROCEDURE VerifyFTPUser @username varchar(32) AS
DECLARE @globallimit INT
SELECT @globallimit = Value FROM Configs WHERE ConfigID = 60
Select AccountID,Login, Shell,
CASE WHEN (ma.OverLimit > 0 AND ma.OverLimit > ma.Balance) OR
DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate) < GetDate()
THEN RIGHT(CONVERT(VARCHAR(10),RAND()),4) +
RIGHT(CONVERT(VARCHAR(10),RAND()),4)
ELSE sa.Password END AS Password, ISNULL(HomeDir, 'noaccess') as
HomeDir, ISNULL(HomeDirLimit, @globallimit) AS HomeDirLimit
From MasterAccounts ma, SubAccounts sa
Where ma.CustomerID = sa.CustomerID
AND sa.CustomerID=ma.CustomerID
AND ma.Active=1
AND sa.Active=1
AND (Login = @username or Shell = @username or Email = @username)
GO

-- 

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