Hi,
Thanks, I change my value to "jujai" but it still give me the same error!
Any Suggestion?
Regards
Alexander
Kiran <[EMAIL PROTECTED]> wrote:
Kiran <[EMAIL PROTECTED]> wrote:
You need to have "jujai" in your table.
--- Alexander Khoo <[EMAIL PROTECTED]>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
