Problems with authentication usin Freeradius with mysql

Daniel Bojczuk daniel at cirp.usp.br
Thu Mar 1 14:05:03 CET 2007


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




More information about the Freeradius-Users mailing list