thanks Alan I found the problem was in the "attribute" field where I put "Cleartext-Password" based on the wiki : http://wiki.freeradius.org/SQL-HOWTO after I changed the value to just "password" it works fine now. note: I put "==" in "op" field because that was the default value mysql> desc radcheck; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | == | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ just like the radgroupreply, where the default value is "=" mysql> desc radgroupreply; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | groupname | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | = | | | value | varchar(253) | NO | | | | +-----------+------------------+------+-----+---------+----------------+ thanks again Alan. On Sun, 27 Nov 2011 16:26:13 +0000, Alan Buxey wrote
Hi,
after I complete the installation, I tried to test it : # radtest usertest passtest localhost:1812 0 testing123 Sending Access-Request of id 180 to 127.0.0.1 port 1812 User-Name = "usertest" User-Password = "passtest" NAS-IP-Address = 10.1.1.28 NAS-Port = 0 rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=180, length=20
dont really care about this - the 'radiusd -X' output is what is needed for this list.
+----+----------+--------------------+----+----------+ | id | username | attribute | op | value | +----+----------+--------------------+----+----------+ | 1 | usertest | Cleartext-Password | == | passtest | +----+----------+--------------------+----+----------+
wrong 'op' value. change that to := rather than ==
alan
------------------------------- Bogi Aditya Sisfo - IMTelkom Telkom Institute of Management http://bogi.blog.imtelkom.ac.id