cannot connect to mysql

[Lewis Bergman]

Rusma wrote:
> 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
> [root at Customercare 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
>  
> [root at Customercare raddb]# radtest test0001 test88 127.0.0.1 
> <http://127.0.0.1> 1812 testing123
> Sending Access-Request of id 30 to 127.0.0.1 <http://127.0.0.1> port 1812
>         User-Name = "test0001"
>         User-Password = "test88"
>         NAS-IP-Address = 255.255.255.255 <http://255.255.255.255>
>         NAS-Port = 1812
> Re-sending Access-Request of id 30 to 127.0.0.1 <http://127.0.0.1> port 1812
>         User-Name = "test0001"
>         User-Password = "test88"
>         NAS-IP-Address = 255.255.255.255 <http://255.255.255.255>
>         NAS-Port = 1812
> rad_recv: Access-Reject packet from host 127.0.0.1:1812 
> <http://127.0.0.1:1812>, id=30, length=2
>  
> [root at Customercare 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 ..?
try op='==' for the pass instead of :=
-- 
Lewis Bergman
Texas Communications
4309 Maple St.
Abilene, TX 79602-8044
Off. 325-691-1301
Cell 325-439-0533
fax  325-695-6841