cannot connect to mysql
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@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@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@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
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@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@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@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
On 2/9/06, Lewis Bergman <lbergman@wtxs.net> 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@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@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@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
Rusma wrote: - 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.
participants (2)
-
Lewis Bergman -
Rusma