Re: (RADIATOR) Authby Sql

[Ujwol]

Hi Hugh,     Nice to hear from you. Please let us know the exact date, when you'll be visiting Nepal. We're gald to welcome you in Nepal.         About the Authby Sql thing, we still couldn't work it out. Authby Clause <AuthBy SQL>         Identifier      SQL         DBSource        dbi:Sybase:RADIATOR         DBUsername    aaa          DBAuth           pwd         AuthSelect      select PASSWORD from SUBSCRIBERS where USERNAME="%n"         AuthColumnDef 0, User-Password, check         FailureBackoffTime      10 </AuthBy>   The username and password in sql table is in this format   ujwol                $1$isuP4v7R$dAFqUFLqhdg0iQ7OQa   And the trace4 debug   Fri Mar 16 09:47:28 2001: INFO: Server started: Radiator 2.18 on chautari.mos.com.np Fri Mar 16 09:47:36 2001: DEBUG: Packet dump: *** Received from 127.0.0.1 port 1037 .... Code:       Access-Request Identifier: 212 Authentic:  1234567890123456 Attributes: User-Name = "ujwol" Service-Type = Framed-User NAS-IP-Address = 203.63.154.1 NAS-Port = 1234 Called-Station-Id = "123456789" Calling-Station-Id = "987654321" NAS-Port-Type = Async User-Password = "<140><225>(<194><195>\<4><246><188>8<9><160><216>}x<153>" Fri Mar 16 09:47:36 2001: DEBUG: Handling request with Handler 'Realm=' Fri Mar 16 09:47:36 2001: DEBUG:  Deleting session for ujwol, 203.63.154.1, 1234 Fri Mar 16 09:47:36 2001: DEBUG: Handling with Radius::AuthSQL Fri Mar 16 09:47:36 2001: DEBUG: Handling with Radius::AuthSQL Fri Mar 16 09:47:36 2001: DEBUG: Query is: select PASSWORD from SUBSCRIBERS where USERNAME="ujwol" Fri Mar 16 09:47:36 2001: DEBUG: Radius::AuthSQL looks for match with ujwol Fri Mar 16 09:47:37 2001: DEBUG: Radius::AuthSQL REJECT: Bad Password Fri Mar 16 09:47:37 2001: DEBUG: Query is: select PASSWORD from SUBSCRIBERS where USERNAME="DEFAULT" Fri Mar 16 09:47:37 2001: INFO: Access rejected for ujwol: Bad Password Fri Mar 16 09:47:37 2001: DEBUG: Packet dump: *** Sending to 127.0.0.1 port 1037 .... Code:       Access-Reject Identifier: 212 Authentic:  1234567890123456 Attributes: Reply-Message = "Request Denied" Regards Ujwol Manandhar Mercantile Communications P.O.Box 876 DurbarMarg Kathmandu, Nepal Tel : +977-1-240920 Fax :+977-1-225407 ----- Original Message ----- From: Hugh Irvine To: Ujwol ; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 16, 2001 5:06 AM Subject: Re: (RADIATOR) Authby Sql Hello Ujwol - Please say hello to everyone at MOS for me, and please tell Sanjib that I am planning on coming to visit Nepal in October this year. On Thursday 15 March 2001 23:21, Ujwol wrote: > > Hi, >     We're trying to use Authby Sql, after converting linux 6.2 shadow > password file into MSSQL table by buildsql. But the problem is, we couldn't > get the users authenticated with this Linux MD5 password encryption. We get > bad encrypted password result. But it works fine with Standard Unix crypt > format. Here is the authby clause. > > <AuthBy SQL> >         Identifier      SQL >         DBSource        dbi:Sybase:RADIATOR >         DBUsername     abc >         DBAuth          pwd >         AuthSelect     select PASSWORD from SUBSCRIBERS where USERNAME=%0 >         AuthColumnDef 0, Encrypted-Password, check >         FailureBackoffTime      10 > </AuthBy> The above will not work because you are not using a Unix crypt password with the "Encrypted-Password" directive. As long as the Linux MD5 password has the standard prefix ("$1$"), you should just use the following:          AuthColumnDef 0, User-Password, check Radiator understands all the standard prefixes for passwords. Have a look at section 13.1.1 in the Radiator 2.18 reference manual. regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.