IMHO, If you are validating with MYSQL, the first thing you need to be sure of is what type of password are u validate with? If you are validate it with Unix-based password, the attribute in radcheck is Crypt-Password. Not User-Password otherwise it will intrepret it as clear text. Your MySQL + Radius is working. Just need some refinement.
** I'm also new to this. Currently defining freeRADIUS for prepaid system. And i would like some advice on Acct-Interim-Interval & Framed-Pool. I'm using freeRADIUS version 0.9.3 running on FreeBSD 4.9. Using another server (FreeBSD 4.9) as NAS running PPPoE. How do i configure the NAS to perform the Acct-Interim-Interval & Framed-Pool. Thanks. Regards, Dale > Message: 3 > Date: Fri, 28 May 2004 05:01:31 -0700 (PDT) > From: Alexander Khoo <[EMAIL PROTECTED]> > Subject: Re: Freeradius + Mysql Issues! > To: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > > --0-1976051846-1085745691=:83443 > Content-Type: text/plain; charset=us-ascii > > Hi, > > Thanks, I change my value to "jujai" but it still give me the same error! > > Any Suggestion? > > Regards > Alexander > > Kiran <[EMAIL PROTECTED]> wrote: > You need to have "jujai" in your table. > > --- Alexander Khoo wrote: > > > > Hi all, > > > > My goal is to use Freeradius with the sql module for > > authenticating > > > > users. I'm using version 0.9.3 (installed from rpms > > i created with the > > > > specfile that came with the tarball).I've been > > working > > > > off of this tutorial: > > http://www.frontios.com/freeradius.html > > > > > > > > I got but then I proceeded to follow the > > instructions for sql and have run in to some > > trouble. I followed all of the required steps and am > > unable to authenticate. I'm using the following > > command to test the server: > > > > radtest alexander jujai localhost 17 password > > > > and i get the following result: > > > > > > > > [EMAIL PROTECTED] root]# radtest alexander jujai localhost 17 > > password > > > > Sending Access-Request of id 240 to 127.0.0.1:1812 > > > > User-Name = "alexander" > > > > User-Password = "jujai" > > > > NAS-IP-Address = gk.orbit2000.net > > > > NAS-Port = 17 > > > > rad_recv: Access-Reject packet from host > > 127.0.0.1:1812, id=240, length=20 > > > > > > > > Here is a snippet of the output produced when i run > > in debug mode: > > > > rad_recv: Access-Request packet from host > > 127.0.0.1:32769, id=240, length=61 > > > > User-Name = "alexander" > > > > User-Password = "jujai" > > > > NAS-IP-Address = 255.255.255.255 > > > > NAS-Port = 17 > > > > modcall: entering group authorize for request 0 > > > > modcall[authorize]: module "preprocess" returns ok > > for request 0 > > > > modcall[authorize]: module "chap" returns noop for > > request 0 > > > > modcall[authorize]: module "eap" returns noop for > > request 0 > > > > rlm_realm: No '@' in User-Name = "alexander", > > looking up realm NULL > > > > rlm_realm: No such realm "NULL" > > > > modcall[authorize]: module "suffix" returns noop > > for request 0 > > > > radius_xlat: 'alexander' > > > > rlm_sql (sql): sql_set_user escaped user --> > > 'alexander' > > > > radius_xlat: 'SELECT id,UserName,Attribute,Value,op > > FROM radcheck WHERE Username = 'alexander' ORDER BY > > id' > > > > rlm_sql (sql): Reserving sql socket id: 4 > > > > radius_xlat: 'SELECT > > > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op > > FROM radgroupcheck,usergroup WHERE > > > > usergroup.Username = 'alexander' AND > > usergroup.GroupName = radgroupcheck.GroupName ORDER > > BY radgroupcheck.id' > > > > radius_xlat: 'SELECT id,UserName,Attribute,Value,op > > FROM radreply WHERE Username = 'alexander' ORDER BY > > id' > > > > radius_xlat: 'SELECT > > > radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op > > FROM radgroupreply,usergroup WHERE > > > > usergroup.Username = 'alexander' AND > > usergroup.GroupName = radgroupreply.GroupName ORDER > > BY radgroupreply.id' > > > > rlm_sql (sql): No matching entry in the database for > > request from user [alexander] > > > > rlm_sql (sql): Released sql socket id: 4 > > > > modcall[authorize]: module "sql" returns notfound > > for request 0 > > > > users: Matched DEFAULT at 152 > > > > modcall[authorize]: module "files" returns ok for > > request 0 > > > > modcall[authorize]: module "mschap" returns noop > > for request 0 > > > > modcall: group authorize returns ok for request 0 > > > > rad_check_password: Found Auth-Type System > > > > auth: type "System" > > > > modcall: entering group authenticate for request 0 > > > > modcall[authenticate]: module "unix" returns > > notfound for request 0 > > > > modcall: group authenticate returns notfound for > > request 0 > > > > auth: Failed to validate the user. > > > > Delaying request 0 for 1 seconds > > > > Finished request 0 > > > > Going to the next request > > > > --- Walking the entire request list --- > > > > Waking up in 1 seconds... > > > > --- Walking the entire request list --- > > > > Sending Access-Reject of id 240 to 127.0.0.1:32769 > > > > Waking up in 4 seconds... > > > > --- Walking the entire request list --- > > > > Cleaning up request 0 ID 240 with timestamp 40b49ae9 > > > > Nothing to do. Sleeping until we see a request. > > > > > > > > > > > > And here's the only entry in my radcheck table: > > > > > > > > +----+----------+-----------+----+---------+ > > > > | id | UserName | Attribute | op | Value | > > > > +----+----------+-----------+----+---------+ > > > > | 1 | alexander| Password | == | password| > > > > +----+----------+-----------+----+---------+ > > > > > > > > Any suggestions would be greatly appreciated. I've > > been working on this > > > > for several days now and haven't made much progress. > > I hope I've done > > > > enough footwork on my own to keep away the flames :) > > > > > > > > > > > > Thanks in advance, > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Friends. Fun. Try the all-new Yahoo! Messenger > > > > > > ____________________________________________________________ > Yahoo! Messenger - Communicate instantly..."Ping" > your friends today! Download Messenger Now > http://uk.messenger.yahoo.com/download/index.html > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > --------------------------------- > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger > --0-1976051846-1085745691=:83443 > Content-Type: text/html; charset=us-ascii > > <DIV>Hi,</DIV> > <DIV> </DIV> > <DIV>Thanks, I change my value to "jujai" but it still give me the same error!</DIV> > <DIV> </DIV> > <DIV>Any Suggestion?</DIV> > <DIV> </DIV> > <DIV>Regards</DIV> > <DIV>Alexander<BR><BR><B><I>Kiran <[EMAIL PROTECTED]></I></B> wrote:</DIV> > <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: > #1010ff 2px solid">You need to have "jujai" in your table.<BR><BR>--- Alexander Khoo > <[EMAIL PROTECTED]>wrote:<BR>> <BR>> Hi all,<BR>> <BR>> My goal is to > use Freeradius with the sql module for<BR>> authenticating<BR>> <BR>> > users. I'm using version 0.9.3 (installed from rpms<BR>> i created with > the<BR>> <BR>> specfile that came with the tarball).I've been<BR>> > working<BR>> <BR>> off of this tutorial: <BR>> > http://www.frontios.com/freeradius.html<BR>> <BR>> <BR>> <BR>> I got but > then I proceeded to follow the<BR>> instructions for sql and have run in to > some<BR>> trouble. I followed all of the required steps and am<BR>> unable to > authenticate. I'm using the following<BR>> command to test the server:<BR>> > <BR>> radtest alexander jujai localhost 17 password<BR>> <BR>> and i get > the following result:<BR>> <BR>> > <BR>> <BR>> [EMAIL PROTECTED] root]# radtest alexander jujai localhost > 17<BR>> password<BR>> <BR>> Sending Access-Request of id 240 to > 127.0.0.1:1812<BR>> <BR>> User-Name = "alexander"<BR>> <BR>> > User-Password = "jujai"<BR>> <BR>> NAS-IP-Address = gk.orbit2000.net<BR>> > <BR>> NAS-Port = 17<BR>> <BR>> rad_recv: Access-Reject packet from > host<BR>> 127.0.0.1:1812, id=240, length=20<BR>> <BR>> <BR>> <BR>> > Here is a snippet of the output produced when i run<BR>> in debug mode:<BR>> > <BR>> rad_recv: Access-Request packet from host<BR>> 127.0.0.1:32769, id=240, > length=61<BR>> <BR>> User-Name = "alexander"<BR>> <BR>> User-Password = > "jujai"<BR>> <BR>> NAS-IP-Address = 255.255.255.255<BR>> <BR>> NAS-Port > = 17<BR>> <BR>> modcall: entering group authorize for request 0<BR>> > <BR>> modcall[authorize]: module "preprocess" returns ok<BR>> for request > 0<BR>> <BR>> modcall[authorize]: module > "chap" returns noop for<BR>> request 0<BR>> <BR>> modcall[authorize]: > module "eap" returns noop for<BR>> request 0<BR>> <BR>> rlm_realm: No '@' > in User-Name = "alexander",<BR>> looking up realm NULL<BR>> <BR>> > rlm_realm: No such realm "NULL"<BR>> <BR>> modcall[authorize]: module "suffix" > returns noop<BR>> for request 0<BR>> <BR>> radius_xlat: 'alexander'<BR>> > <BR>> rlm_sql (sql): sql_set_user escaped user --><BR>> 'alexander'<BR>> > <BR>> radius_xlat: 'SELECT id,UserName,Attribute,Value,op<BR>> FROM radcheck > WHERE Username = 'alexander' ORDER BY<BR>> id'<BR>> <BR>> rlm_sql (sql): > Reserving sql socket id: 4<BR>> <BR>> radius_xlat: > 'SELECT<BR>><BR>radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op<BR>> > FROM radgroupcheck,usergroup WHERE<BR>> <BR>> usergroup.Username = > 'alexander' AND<BR>> usergroup.GroupName = radgroupcheck.GroupName > ORDER<BR>> BY radgroupcheck.id'<BR>> <BR>> radius_xlat: 'SELECT > id,UserName,Attribute,Value,op<BR>> FROM radreply WHERE Username = 'alexander' > ORDER BY<BR>> id'<BR>> <BR>> radius_xlat: > 'SELECT<BR>><BR>radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op<BR>> > FROM radgroupreply,usergroup WHERE<BR>> <BR>> usergroup.Username = > 'alexander' AND<BR>> usergroup.GroupName = radgroupreply.GroupName ORDER<BR>> > BY radgroupreply.id'<BR>> <BR>> rlm_sql (sql): No matching entry in the > database for<BR>> request from user [alexander]<BR>> <BR>> rlm_sql (sql): > Released sql socket id: 4<BR>> <BR>> modcall[authorize]: module "sql" returns > notfound<BR>> for request 0<BR>> <BR>> users: Matched DEFAULT at > 152<BR>> <BR>> modcall[authorize]: module "files" returns ok for<BR>> > request 0<BR>> <BR>> modcall[authorize]: module "mschap" returns noop<BR>> > for request 0<BR>> > <BR>> modcall: group authorize returns ok for request 0<BR>> <BR>> > rad_check_password: Found Auth-Type System<BR>> <BR>> auth: type > "System"<BR>> <BR>> modcall: entering group authenticate for request 0<BR>> > <BR>> modcall[authenticate]: module "unix" returns<BR>> notfound for request > 0<BR>> <BR>> modcall: group authenticate returns notfound for<BR>> request > 0<BR>> <BR>> auth: Failed to validate the user.<BR>> <BR>> Delaying > request 0 for 1 seconds<BR>> <BR>> Finished request 0<BR>> <BR>> Going > to the next request<BR>> <BR>> --- Walking the entire request list ---<BR>> > <BR>> Waking up in 1 seconds...<BR>> <BR>> --- Walking the entire request > list ---<BR>> <BR>> Sending Access-Reject of id 240 to 127.0.0.1:32769<BR>> > <BR>> Waking up in 4 seconds...<BR>> <BR>> --- Walking the entire request > list ---<BR>> <BR>> Cleaning up request 0 ID 240 with timestamp > 40b49ae9<BR>> <BR>> > Nothing to do. Sleeping until we see a request.<BR>> <BR>> <BR>> <BR>> > <BR>> <BR>> And here's the only entry in my radcheck table:<BR>> <BR>> > <BR>> <BR>> +----+----------+-----------+----+---------+<BR>> <BR>> | id > | UserName | Attribute | op | Value |<BR>> <BR>> > +----+----------+-----------+----+---------+<BR>> <BR>> | 1 | alexander| > Password | == | password|<BR>> <BR>> > +----+----------+-----------+----+---------+<BR>> <BR>> <BR>> <BR>> Any > suggestions would be greatly appreciated. I've<BR>> been working on this<BR>> > <BR>> for several days now and haven't made much progress.<BR>> I hope I've > done<BR>> <BR>> enough footwork on my own to keep away the flames :)<BR>> > <BR>> <BR>> <BR>> <BR>> <BR>> Thanks in advance,<BR>> <BR>> > <BR>> <BR>> ---------------------------------<BR>> Do you Yahoo!?<BR>> > Friends. Fun. Try the all-new Yahoo! Messenger > > <BR><BR><BR><BR><BR><BR>____________________________________________________________<BR>Yahoo! > Messenger - Communicate instantly..."Ping" <BR>your friends today! Download > Messenger Now <BR>http://uk.messenger.yahoo.com/download/index.html<BR><BR>- > <BR>List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html</BLOCKQUOTE><p> > <hr size=1><font face=arial size=-1>Do you Yahoo!?<br>Friends. Fun. > <a href="http://messenger.yahoo.com/";>Try the all-new Yahoo! Messenger</a> > --0-1976051846-1085745691=:83443-- > > > --__--__-- > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
