Problems with authentication usin Freeradius with mysql
Hi.. I'm developing an authentication system using Freeradius 1.0.2 with mysql 4.0.24_Debian-10sarge2-log. In mysql I have the database radius: +------------------+ | Tables_in_radius | +------------------+ | nas | | radacct | | radcheck | | radgroupcheck | | radgroupreply | | radpostauth | | radreply | | usergroup | +------------------+ The table radcheck: +----+----------+-----------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+-----------+----+-------+ | 1 | daniel | Password | == | senha | | 2 | joao | Password | == | senha | +----+----------+-----------+----+-------+ The table radgroupchec: +----+-------------+------------------+----+-------+ | id | GroupName | Attribute | op | Value | +----+-------------+------------------+----+-------+ | 1 | sessaounica | Simultaneous-Use | := | 1 | +----+-------------+------------------+----+-------+ The table usergroup: +----------+-------------+----------+ | UserName | GroupName | priority | +----------+-------------+----------+ | daniel | sessaounica | 1 | +----------+-------------+----------+ When I use de command: radtest daniel senha 143.107.200.64:1812 0 teste The log file shows me: Tue Feb 27 11:01:14 2007 : Auth: Login incorrect: [daniel] (from client testee port 0) Someone can help-me? It's the first time I'm using freeradius. Thank's -- Daniel Bojczuk SCREDES/CIRP
Daniel Bojczuk wrote:
Hi.. I'm developing an authentication system using Freeradius 1.0.2
Please upgrade to 1.1.4, which should be in Debian.
The log file shows me: Tue Feb 27 11:01:14 2007 : Auth: Login incorrect: [daniel] (from client testee port 0)
Someone can help-me? It's the first time I'm using freeradius.
Run the server in debugging mode, as suggested in the FAQ, README, INSTALL, and daily on this list. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alan DeKok wrote:
Someone can help-me? It's the first time I'm using freeradius.
Run the server in debugging mode, as suggested in the FAQ, README, INSTALL, and daily on this list.
Launch, as root, "radiusd -X -A" and study the output. - -- ============== +----------------------------------------------+ Martin Gadbois | "Windows might take you from 0 to 60 faster, | S/W Developer | but to go to 100 you need Unix." | Colubris Networks Inc. +----------------------------------------------+ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFF5uHK9Y3/iTTCEDkRAlNTAJ9lfPEYj8Z16NN+Mi9kDejRSG1e/QCgjLaG MNwT70xUsAlFxzoRPLNV+tY= =r02b -----END PGP SIGNATURE-----
Run the server in debugging mode, as suggested in the FAQ, README, INSTALL, and daily on this list.
Thank's for the tip. I'm new on this list too! I run freeradius in debug mode. The error is bellow: rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns ok for request 0 rad_check_password: Found Auth-Type System auth: type "System" ERROR: Unknown value specified for Auth-Type. Cannot perform requested action. auth: Failed to validate the user. Login incorrect: [daniel] (from client testee port 0) Someone can help me again? Thank's -- Daniel Bojczuk SCREDES/CIRP
Daniel Bojczuk wrote:
Hi.. I'm developing an authentication system using Freeradius 1.0.2
Please upgrade to 1.1.4, which should be in Debian.
The log file shows me: Tue Feb 27 11:01:14 2007 : Auth: Login incorrect: [daniel] (from client testee port 0)
Someone can help-me? It's the first time I'm using freeradius.
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Daniel Bojczuk wrote: ...
rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns ok for request 0 rad_check_password: Found Auth-Type System auth: type "System" ERROR: Unknown value specified for Auth-Type. Cannot perform requested action. auth: Failed to validate the user. Login incorrect: [daniel] (from client testee port 0)
Someone can help me again?
Edit the "users" file to get rid of the line that says "Auth-Type = System". Use 1.1.4, which solves other issues. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
It works! Thank you for answering! Daniel Bojczuk
Daniel Bojczuk wrote: ...
rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns ok for request 0 rad_check_password: Found Auth-Type System auth: type "System" ERROR: Unknown value specified for Auth-Type. Cannot perform requested action. auth: Failed to validate the user. Login incorrect: [daniel] (from client testee port 0)
Someone can help me again?
Edit the "users" file to get rid of the line that says "Auth-Type = System".
Use 1.1.4, which solves other issues.
Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Daniel Bojczuk SCREDES/CIRP
participants (3)
-
Alan DeKok -
Daniel Bojczuk -
Martin Gadbois