[RadiusNT] Another Drwatson of a long username and another bug in RadiusNT

Graeme Slogrove ( Graeme@na.co.za )
Thu, 16 Sep 1999 16:04:01 +0200

Note that RadiusNT does not convert and ' characters in the login string to
'' before trying to insert into the database, and that a long username once
again generates a DrWatson.

This is now really bugging me, as RadCheck does not re-start the service
properly after this.

--- SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,(ma.Extension+ma..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,sa.Shell, sa.LoginLimit, ma.Balance, ma.OverLimit From MasterAccounts ma,SubAccounts sa  Wheresa.Login='wb//M6F3fg+.zRIXub!#lF+>s/ApAQ{!HX0d|V_JP*bsU)TRck`"m;&'_uT%<kn'  AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

ODBC Error:37000:170: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntaxnear '_uT'.

Resp Time: 30 Auth: 971/312 -> 1292 Acct: 2007/0/0 -> 2007

radrecv: Request from host c416a06a code=1, id=116, length=120 User-Name = "-Y!\H.}=KL]}j`Ry#+5*R*El S<X" Password = "\323\253\0128`Z\372\262A\303dpl\351\376\262" NAS-Identifier = NAS-Port = 7 NAS-Port-Type = Async Connect-Info = "31200 MNP/NONE" NAS-Port-DNIS = "7000" Caller-Id = "0117943787"rad_authenticate_ODBC()


---Graeme Slogrove, BSc (Eng) Elec (Wits)Director, Systems Development & Value Added ServicesNetActive InternetTel: 011-719-0333    Fax: 011-719-0444Support: 011-719-0300

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