cannot connect to mysql

Rusma rusma.p at gmail.com
Thu Feb 9 05:08:36 CET 2006


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 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

[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 ..?

best regards,
rusma permana
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060209/0e2f4467/attachment.html>


More information about the Freeradius-Users mailing list