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