[RadiusNT] SQL 7 Upgrade

Garcia Melga Pablo ( pablo.garcia@xlnet.com.ar )
Tue, 31 Aug 1999 13:54:12 -0300

Hi I'm moving my RadiusNT Database from SQL 6.5 to SQL 7(they are located in
diferent machines), I did transfer the Database from the SQL 6.5 to the SQL
7, now I can't get anybody to authenticate in ODBC mode, the -x15 debug
option gives me a lot of this messages
"
radrecv: Request from host c829af04 code=1, id=27, length=163 User-Name
= "psiarg"
Password = "\267eAe6L\333b\315~.n\210\020M-"
NAS-Identifier = 200.41.175.4
NAS-Port = 11
Acct-Session-Id = "36982"
Received unknown attribute 38979, vendor 429
User-Service = Framed-User
Framed-Protocol = PPP
Received unknown attribute 38977, vendor 429
Received unknown attribute 36889, vendor 429
Received unknown attribute 36890, vendor 429
Received unknown attribute 36891, vendor 429
Caller-Id = ""
NAS-Port-DNIS = "5638"
NAS-Port-Type = Async
rad_authenticate_ODBC()
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 From MasterAccounts ma,
SubAccounts sa Where sa.Login='psiarg' AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and ma.Active<>0

Sending Reject of id 27 to c829af04 (XL-USR)
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data,
CallerID) VALUES (10, GetDate(), 'psiarg', 'fu592t30', '')

User: psiarg Not found
Resp Time: 50 Auth: 0/248 -> 248 Acct: 9/0/0 -> 9

"

And the logfile says
"User: psiarg Not foundTue Aug 31 13:14:02 1999: ODBC Error:23000:2627:"

I was running RadiusNT 2.5.124, I upgraded to 2.5.175 but the problems
remains.
Anybody has any idea of what's going on ??

Thank's in Advance.

Atte. Pablo F. Garcia Melga
XL-NET HostMaster
Tel: 4819-5170
Fax: 4819-5188
e-mail: pablo.garcia@xlnet.com.ar
ICQ # : 13889842

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