Freeradius Error Failed To Load Clients From Sql
Contents |
[ author ] Hello Alan, Test1 Where I do the command $ radtest testuser passsecret 127.0.0.1 1812 testing1234 It works and testing1234 /etc/freeradius/sites-enabled/default 177 failed to load module sql is what is configured in the clients.conf file. If I change the
Failed To Find "sql" In The "modules" Section.
secret to testing12345 and restart the radiusd server it works with the command $ radtest testuser passsecret 127.0.0.1 1812 instantiation failed for module sql freeradius testing12345 Also the radtest command output says $ radtest testuser passsecret 127.0.0.1 1812 testing12345 Sending Access-Request of id 18 to 127.0.0.1 port 1812 User-Name = "testuser" User-Password = "passsecret" freeradius errors parsing authorize section NAS-IP-Address = x.x.x.x NAS-Port = 1812 Message-Authenticator = 0x00000000000000000000000000000000 With x.x.x.x a public IP address (mine), that's why I supposed I didn't need an entry for 127.0.0.1 Test 2 When I start the radiusd server after adding an entry for 127.0.0.1 it says rlm_sql (sql): Released sql socket id: 4 rlm_sql (sql): Failed to add client 127.0.0.1 (myNAS3x) to clients
Rlm_sql_mysql: Couldn't Connect Socket To Mysql Server
list. Maybe there's a duplicate? Failed to load clients from SQL. /etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /etc/raddb/sites-enabled/default[177]: Failed to find "sql" in the "modules" section. /etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. As a conclusion I think clients.conf is still used because of test 1) when I change the secret. And that's why it finds a duplicate for 127.0.0.1 in Test 2. If I delete the entry in the mysql table it starts normally. I think commenting the files doesn't work authorize { sql #files } and radiusd still reads clients.conf, that should explain test 1 & 2 .... As I was writting this email I found the solution. I've put a comment on #$INCLUDE ${confdir}/clients.conf in radiusd.conf And normalised the section authorize { sql files } Now it behaves as expected. Thank you for your answers Le Samedi 9 novembre 2013 15h23, "A.L.M.Buxey at lboro.ac.uk"
♦ ♦ | Report Content as Inappropriate ♦ ♦ mysql errors when running http://freeradius.1045715.n5.nabble.com/mysql-errors-when-running-freeradius-td2783413.html freeradius I have been following the mysql guide on https://www.serveradminblog.com/2011/03/freeradius-install-howto-3/ the freeradius wiki for handling of users. I've had a few problems along the way and i can get radius accepting test packs not using mysql. I am using openSUSE 11.1. When i now try to launch radius failed to it is coming up with mysql errors, and i can't figure out why and what it's trying to do. One thing to note is that i install mysql after i installed freeradius, and I'm unsure whether this could be a problem too. I have also read that you failed to load need the mysql-devel files, which from looking in yast i do not have, and can not locate. The debug code can be found below. -----> linux-6pfg:/etc/raddb # radiusd -X FreeRADIUS Version 2.1.1, for host i686-suse-linux-gnu, built on Dec 3 2008 at 10:47:13 Copyright (C) 1999-2008 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License v2. Starting - reading configuration files ... including configuration file /etc/raddb/radiusd.conf including configuration file /etc/raddb/proxy.conf including configuration file /etc/raddb/clients.conf including files in directory /etc/raddb/modules/ including configuration file /etc/raddb/modules/attr_rewrite including configuration file /etc/raddb/modules/pam including configuration file /etc/raddb/modules/pap including configuration file /etc/raddb/modules/smbpasswd including configuration file /etc/raddb/modules/ldap including configuration file /etc/raddb/modules/mac2ip including configuration file /etc/raddb/modules/linelog including configuration file /etc/raddb/modules/detail.log including configuration file /etc/raddb/modules/always including configurat