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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html