cannot connect to mysql

[Rusma]

dear all,

im a newbie, i have configured freeradius + mysql, but i can't connect user from radcheck table.

please give me an advices,

 

etc/rc.d/rc.radiusd restart
Starting FreeRADIUS:Thu Feb  9 10:51:54 2006 : Info: Starting - reading configuration files ...
radiusd

[EMAIL PROTECTED] raddb]# tail -f /usr/local/var/log/radius/radius.log

Thu Feb  9 10:51:54 2006 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Thu Feb  9 10:51:54 2006 : Info: rlm_sql (sql): Attempting to connect to hidden

Thu Feb  9 10:51:54 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Thu Feb  9 10:51:54 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Thu Feb  9 10:51:54 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Thu Feb  9 10:51:54 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Thu Feb  9 10:51:54 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Thu Feb  9 10:51:54 2006 : Info: Ready to process requests.

 

table radcheck

150;"test0001";"Max-All-Session";":=";"54000";"0000-00-00 00:00:00";"NULL";;0;"0000-00-00 00:00:00";0;1
152;"test0001";"User-Password";":=";"test88";"0000-00-00 00:00:00";"NULL";;0;"0000-00-00 00:00:00";0;1

 

[EMAIL PROTECTED] raddb]# radtest test0001 test88 127.0.0.1 1812 testing123
Sending Access-Request of id 30 to 127.0.0.1 port 1812
        User-Name = "test0001"
        User-Password = "test88"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
Re-sending Access-Request of id 30 to 127.0.0.1 port 1812
        User-Name = "test0001"
        User-Password = "test88"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=30, length=2

 

[EMAIL PROTECTED] raddb]# tail -f /usr/local/var/log/radius/radius.log
Thu Feb  9 11:01:01 2006 : Auth: Login incorrect: [test0001/test88] (from client localhost port 1812)
Thu Feb  9 11:07:01 2006 : Auth: Login incorrect: [test0001/test88] (from client localhost port 1812)

 

any idea ..?

 

best regards,

rusma permana
 

 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html