cannot connect to mysql

[Rusma]

On 2/9/06, Lewis Bergman <lbergman at wtxs.net> wrote:
>
> 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
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>


problem already solve, after turn of unix, pam in accounting section.
thanks anyway.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060209/902170fa/attachment.html>