Re: Freeradius with either LDAP or Mysql Error lib not found
Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory It seems that your mysql drivers have not been installed successfully, thanks to freeradius, it has the option to install mysql server along free radius . (use this command sudo apt-get install mysql-server (somthing like that if not work,, google it). Hopefully problem will be solve On Fri, Mar 8, 2013 at 12:51 PM, Iftakhul Anwar an...@meruvian.org wrote: Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013 : Error: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module sql Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[177]: Failed to find sql in the modules section. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. i've read in some article that it's solved by installed mysql-devel package. In this case i've installed libmysqlclient-dev on my ubuntu 12.04 But still get same error. It's also happen on my freeradius ldap? [error LDAP] /usr/local/etc/raddb/modules/ldap[29]: Failed to link to module 'rlm_ldap': rlm_ldap.so: cannot open shared object file: No such file or directory /usr/local/etc/raddb/sites-enabled/default[305]: Failed to find ldap in the modules section. /usr/local/etc/raddb/sites-enabled/default[305]: Failed to parse ldap How i can solve this issue ? Thanks -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Best Regards Muhammad Nadeem Muhammad Ali Jinnah University - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with either LDAP or Mysql Error lib not found
I've installed mysql-server on my system even before i installed freeradius server. Any another tips to solve this ? On Fri, Mar 8, 2013 at 2:59 PM, Muhammad Nadeem mnadeem8...@gmail.comwrote: Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory It seems that your mysql drivers have not been installed successfully, thanks to freeradius, it has the option to install mysql server along free radius . (use this command sudo apt-get install mysql-server (somthing like that if not work,, google it). Hopefully problem will be solve On Fri, Mar 8, 2013 at 12:51 PM, Iftakhul Anwar an...@meruvian.orgwrote: Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013 : Error: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module sql Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[177]: Failed to find sql in the modules section. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. i've read in some article that it's solved by installed mysql-devel package. In this case i've installed libmysqlclient-dev on my ubuntu 12.04 But still get same error. It's also happen on my freeradius ldap? [error LDAP] /usr/local/etc/raddb/modules/ldap[29]: Failed to link to module 'rlm_ldap': rlm_ldap.so: cannot open shared object file: No such file or directory /usr/local/etc/raddb/sites-enabled/default[305]: Failed to find ldap in the modules section. /usr/local/etc/raddb/sites-enabled/default[305]: Failed to parse ldap How i can solve this issue ? Thanks -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Best Regards Muhammad Nadeem Muhammad Ali Jinnah University - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with either LDAP or Mysql Error lib not found
Ok man.. set LD_LIBRARY_PATH to your mysql drivers,, like for oracle it will be SET PATH=LD_LIBRARY_PATH=$ORACLE_HOME/lib On Fri, Mar 8, 2013 at 1:02 PM, Iftakhul Anwar an...@meruvian.org wrote: I've installed mysql-server on my system even before i installed freeradius server. Any another tips to solve this ? On Fri, Mar 8, 2013 at 2:59 PM, Muhammad Nadeem mnadeem8...@gmail.comwrote: Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory It seems that your mysql drivers have not been installed successfully, thanks to freeradius, it has the option to install mysql server along free radius . (use this command sudo apt-get install mysql-server (somthing like that if not work,, google it). Hopefully problem will be solve On Fri, Mar 8, 2013 at 12:51 PM, Iftakhul Anwar an...@meruvian.orgwrote: Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013 : Error: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module sql Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[177]: Failed to find sql in the modules section. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. i've read in some article that it's solved by installed mysql-devel package. In this case i've installed libmysqlclient-dev on my ubuntu 12.04 But still get same error. It's also happen on my freeradius ldap? [error LDAP] /usr/local/etc/raddb/modules/ldap[29]: Failed to link to module 'rlm_ldap': rlm_ldap.so: cannot open shared object file: No such file or directory /usr/local/etc/raddb/sites-enabled/default[305]: Failed to find ldap in the modules section. /usr/local/etc/raddb/sites-enabled/default[305]: Failed to parse ldap How i can solve this issue ? Thanks -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Best Regards Muhammad Nadeem Muhammad Ali Jinnah University - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Best Regards Muhammad Nadeem Muhammad Ali Jinnah University - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with either LDAP or Mysql Error lib not found
If you install using packages, it's usually contained on separate packages. For example: http://packages.ubuntu.com/search?suite=quantalkeywords=freeradius i.e. freeradius-mysql, freeradius-ldap. -- Fajar On Fri, Mar 8, 2013 at 7:02 PM, Iftakhul Anwar an...@meruvian.org wrote: I've installed mysql-server on my system even before i installed freeradius server. Any another tips to solve this ? On Fri, Mar 8, 2013 at 2:59 PM, Muhammad Nadeem mnadeem8...@gmail.com wrote: Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory It seems that your mysql drivers have not been installed successfully, thanks to freeradius, it has the option to install mysql server along free radius . (use this command sudo apt-get install mysql-server (somthing like that if not work,, google it). Hopefully problem will be solve On Fri, Mar 8, 2013 at 12:51 PM, Iftakhul Anwar an...@meruvian.org wrote: Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013 : Error: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module sql Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[177]: Failed to find sql in the modules section. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. i've read in some article that it's solved by installed mysql-devel package. In this case i've installed libmysqlclient-dev on my ubuntu 12.04 But still get same error. It's also happen on my freeradius ldap? [error LDAP] /usr/local/etc/raddb/modules/ldap[29]: Failed to link to module 'rlm_ldap': rlm_ldap.so: cannot open shared object file: No such file or directory /usr/local/etc/raddb/sites-enabled/default[305]: Failed to find ldap in the modules section. /usr/local/etc/raddb/sites-enabled/default[305]: Failed to parse ldap - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with either LDAP or Mysql Error lib not found
As Fajar says, some distros split up the functions into separate packages (so you don't need to install loads of things just to have a basic server) use your package manager to find/install the sub packages alan -- This smartphone uses free WiFi around the world with eduroam, now that's what I call smart. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with either LDAP or Mysql Error lib not found
HI All, I just recompile my freeadius with specific directory library.I use command : ./configure --with-mysql-lib-dir=/usr/lib/mysql --with-ldap-lib-dir=/usr/lib/ldap Now ldap and mysql running well :D Thanks all On Fri, Mar 8, 2013 at 3:41 PM, Alan Buxey a.l.m.bu...@lboro.ac.uk wrote: As Fajar says, some distros split up the functions into separate packages (so you don't need to install loads of things just to have a basic server) use your package manager to find/install the sub packages alan -- This smartphone uses free WiFi around the world with eduroam, now that's what I call smart. -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius with either LDAP or Mysql Error lib not found
Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013 : Error: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module sql Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[177]: Failed to find sql in the modules section. Fri Mar 8 13:44:46 2013 : Error: /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. i've read in some article that it's solved by installed mysql-devel package. In this case i've installed libmysqlclient-dev on my ubuntu 12.04 But still get same error. It's also happen on my freeradius ldap? [error LDAP] /usr/local/etc/raddb/modules/ldap[29]: Failed to link to module 'rlm_ldap': rlm_ldap.so: cannot open shared object file: No such file or directory /usr/local/etc/raddb/sites-enabled/default[305]: Failed to find ldap in the modules section. /usr/local/etc/raddb/sites-enabled/default[305]: Failed to parse ldap How i can solve this issue ? Thanks -- *M.Iftakhul Anwar* Meruvian Integrator High Performance Computing / Cloud Computing (HPC/CC) Office Phone : 021-93586577 Mobile Phone : 085215331477 Blog : http://blog.mervpolis.com/roller/anwar FB : http://www.facebook.com/troya.adromeda Website : www.meruvian.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
error message connection to MySQL. (Error Message :rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0)
Hi, I try to authenticate freeradius 2.1.8 using mysql5.0.26. Information of my system: 1. OS is SuSE Linux SLES10 SP2. 2. I have installed following RPM for FreeRadius 2.1.8: #rpm -qa |grep freeradius freeradius-server-utils-2.1.8-1.1 freeradius-client-libs-1.1.6-4.1 freeradius-server-2.1.8-1.1 freeradius-client-devel-1.1.6-4.1 freeradius-server-devel-2.1.8-1.1 freeradius-client-1.1.6-4.1 freeradius-server-debuginfo-2.1.8-1.1 freeradius-server-libs-2.1.8-1.1 3. installed following MySQL RPM: # rpm -qa |grep mysql apache2-mod_auth_mysql-3.0.0-14.2 mysql-5.0.26-12.18 mysql-shared-5.0.26-12.18 perl-DBD-mysql-3.0002-15.2 php5-mysql-5.2.5-9.5 mysql-client-5.0.26-12.18 I have successfully installed the RPM for freeradius and test for authentication using file users is successful. When I tried to authenticate via MySQL, it failed. There is no connection record to MySQL in log file of MySQL. Searching the WWW, I found out there is a RPM named freeradius-mysql* for Red Hat FC. There is no such RPM for SuSE in download website of freeradius.org. Is corresponding RPM required for SLES10SP2? Where to download? Or, such functionality is already included in one of my installed RPM? Terminal 1 message: # radtest user1 test1 localhost 1812 RAD7429secret Sending Access-Request of id 250 to 127.0.0.1 port 1812 User-Name = user1 User-Password = test1 NAS-IP-Address = 158.182.158.61 NAS-Port = 1812 rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=250, length=20 Terminal 2 message: Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 32768, id=250, length =57 User-Name = user1 User-Password = test1 NAS-IP-Address = 158.182.158.61 NAS-Port = 1812 +- entering group authorize {...} ++[preprocess] returns ok [auth_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/auth-deta il-%Y%m%d - /var/log/radius/radacct/127.0.0.1/auth-detail-20100428 [auth_log] /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d exp ands to /var/log/radius/radacct/127.0.0.1/auth-detail-20100428 [auth_log] expand: %t - Wed Apr 28 20:38:07 2010 ++[auth_log] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] No '@' in User-Name = user1, looking up realm NULL [suffix] No such realm NULL ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound [sql] expand: %{User-Name} - user1 [sql] sql_set_user escaped user -- 'user1' rlm_sql (sql): Ignoring unconnected handle 4.. rlm_sql (sql): Ignoring unconnected handle 3.. rlm_sql (sql): Ignoring unconnected handle 2.. rlm_sql (sql): Ignoring unconnected handle 1.. rlm_sql (sql): Ignoring unconnected handle 0.. rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 ++[sql] returns fail Using Post-Auth-Type Reject +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} - user1 attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 250 to 127.0.0.1 port 32768 Waking up in 4.9 seconds. Cleaning up request 0 ID 250 with timestamp +10 Ready to process requests. --- Cheers, Joe __ Information from ESET Smart Security, version of virus signature database 5066 (20100427) __ The message was checked by ESET Smart Security. http://www.eset.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: error message connection to MySQL. (Error Message :rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0)
You very helpfully deleted all the interesting information from the debug log (please always post the full log). But you can do this yourself. Take a look at sql initialization section and see what it's saying about initializing the sql driver, in this case it should be rlm_sql_mysql, that should answer most of your questions. As to whether rlm_sql_mysql is in a different RPM, I can't help you as I don't know Debian packaging, but it's easy to tell if one of the RPM's you did install installed it, just looking in the freeradius library directory (which is defined at the top of the main freeradius config file (probably /etc/raddb/radiusd.conf) -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeradius doesn't start at boot-time : mysql error
Hello, I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host (both centos5). When I use /etc/init.d/radiusd as root it starts up correctly. But when the service is launched at boot time, I get this error-log : Wed Feb 6 16:17:46 2008 : Info: Using deprecated naslist file. Support for this will go away soon. Wed Feb 6 16:17:46 2008 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Wed Feb 6 16:17:46 2008 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Wed Feb 6 16:17:46 2008 : Info: rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius Wed Feb 6 16:17:46 2008 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Wed Feb 6 16:17:49 2008 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius Wed Feb 6 16:17:49 2008 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.1.1' (113)' Wed Feb 6 16:17:49 2008 : Error: rlm_sql (sql): Failed to connect DB handle #0 Wed Feb 6 16:17:49 2008 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 Wed Feb 6 16:17:49 2008 : Error: rlm_sql (sql): generate_sql_clients() returned error Wed Feb 6 16:17:49 2008 : Error: radiusd.conf[14]: sql: Module instantiation failed. Wed Feb 6 16:17:49 2008 : Error: radiusd.conf[1844] Unknown module sql. Wed Feb 6 16:17:49 2008 : Error: radiusd.conf[1773] Failed to parse authorize section. I look at tcpdump on the mysql-server host, and during the boot of my freeradius server, I see no traffic comming from freeradius host. There is no reject in the firewall. I've tried to put the radius rc.d script in S99 to start it as late as possible, but nothing changes. I also noticed that it doesen't seem to retry to connect to the database later. Or is it after a long time ? Is this a bug ? Where is the retry time configured (I cant try to set up to 5 seconds) ? Thanks for answers Laetitia. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I added column im radacct and all it's Ok, thanks for your help. Pablo Marinko Tarlac wrote: Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql error
Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: radius:/usr/local/var/log/radius# tail radius.log -f Mon Jan 14 16:01:37 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Any help please? Thanks in advance, Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I'm using freeradius 2.0.0 on Debian Etch, I think the problem is case sensitivity as you mentioned because in schema.sql is un lower case and in dialup.conf also. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
in lower case really? Marinko Tarlac wrote: Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I didn't try lowercase but XAscendSessionSvrKey - varchar(10) works fine :) Pablo Lucchetti wrote: in lower case really? Marinko Tarlac wrote: Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
1.1.7 [EMAIL PROTECTED] wrote: What freeradius version are you using? Ivan Kalik Kalik Informatika ISP Dana 24/12/2007, ikpirhu last [EMAIL PROTECTED] piše: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, Pablo Lucchetti [EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED] :radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
its not a freeradius Kalik. im 100% sure thats a mysql problem. at the url http://dev.mysql.com/doc/refman/5.0/en/old-client.html they said that maybe is a library ( dll , so ) problem. maybe you have both of them installed ( mysql4 and 5 ) if its not an production system i suggest to uninstall and reinstall (not upgrade) the mysql server and clients. As always , remember to backup your entire databases. On 24/12/2007, Pablo Lucchetti [EMAIL PROTECTED] wrote: I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Yes I'll do that. Thanks, Pablo ikpirhu last wrote: its not a freeradius Kalik. im 100% sure thats a mysql problem. at the url http://dev.mysql.com/doc/refman/5.0/en/old-client.html http://dev.mysql.com/doc/refman/5.0/en/old-client.html they said that maybe is a library ( dll , so ) problem. maybe you have both of them installed ( mysql4 and 5 ) if its not an production system i suggest to uninstall and reinstall (not upgrade) the mysql server and clients. As always , remember to backup your entire databases. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Any help? Pablo ikpirhu last wrote: its not a freeradius Kalik. im 100% sure thats a mysql problem. at the url http://dev.mysql.com/doc/refman/5.0/en/old-client.html http://dev.mysql.com/doc/refman/5.0/en/old-client.html they said that maybe is a library ( dll , so ) problem. maybe you have both of them installed ( mysql4 and 5 ) if its not an production system i suggest to uninstall and reinstall (not upgrade) the mysql server and clients. As always , remember to backup your entire databases. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list
Re: Mysql error
Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xen #1 Freeradius: 1.1.7 Mysql-server and client: 5.0 Libmysqlclient: libmysqlclient15-dev libmysqlclient15off Regards, Pablo liran tal wrote: Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf [14]: sql: Module instantiation failed. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Hey Pablo, On Dec 24, 2007 2:59 PM, Pablo Lucchetti [EMAIL PROTECTED] wrote: Great Liran! Now is working fine Thanks a lot. Sure Pablo, enjoy the holidays and you're new freeradius+mysql installation :-) Regards, Liran Tal. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:27 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xen #1 Freeradius: 1.1.7 Mysql-server and client: 5.0 Libmysqlclient: libmysqlclient15-dev libmysqlclient15off I'm assuming you installed freeradius from source, right? If so, re-compile it as you have mentioned that you upgrade the packages. Regards, Liran. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf [14]: sql: Module instantiation failed. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Freeradius, MySql Daloradius! ;) liran tal wrote: Hey Pablo, On Dec 24, 2007 2:59 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Great Liran! Now is working fine Thanks a lot. Sure Pablo, enjoy the holidays and you're new freeradius+mysql installation :-) Regards, Liran Tal. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:27 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xen #1 Freeradius: 1.1.7 Mysql-server and client: 5.0 Libmysqlclient: libmysqlclient15-dev libmysqlclient15off I'm assuming you installed freeradius from source, right? If so, re-compile it as you have mentioned that you upgrade the packages. Regards, Liran. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf [14]: sql: Module instantiation failed. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Cool! Let me know how daloRADIUS goes with FreeRADIUS 1.1.7. Regards, Liran. On Dec 24, 2007 8:06 PM, Pablo Lucchetti [EMAIL PROTECTED] wrote: Freeradius, MySql Daloradius! ;) liran tal wrote: Hey Pablo, On Dec 24, 2007 2:59 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Great Liran! Now is working fine Thanks a lot. Sure Pablo, enjoy the holidays and you're new freeradius+mysql installation :-) Regards, Liran Tal. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:27 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xen #1 Freeradius: 1.1.7 Mysql-server and client: 5.0 Libmysqlclient: libmysqlclient15-dev libmysqlclient15off I'm assuming you installed freeradius from source, right? If so, re-compile it as you have mentioned that you upgrade the packages. Regards, Liran. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf [14]: sql: Module instantiation failed. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Maybe this helps: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Norbert Wegener Pablo Lucchetti wrote: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql error
Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Error: rlm_sql_mysql: MYSQL Error
Hi all, I am using freeradius 1.1.0. The backend is mysql 5.0.22 which is located on a different server on the same network. My configuration is as follows: I am doing some stress testing to benchmark my infrastructure. I use SIPp for the same. The SIPp sends the calls to cisco gateway, the cisco gateway sends the authentication request to freeradius server. The radius server queries the mysql databaseand once the authentication is successful and the call is completed;the accounting request is also passed to the radius server by cisco which in turn is sent to the mysql database. Now I kept the SIPp at rate of 45 calls per second, but after say 10 to 15 minutes the radius server dies. This is the message I could see in the log: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Error: rlm_sql_mysql: MYSQL Error: Cannot get resultFri Jul 7 14:18:46 2006 : Error: rlm_sql_mysql: MYSQL Error:Fri Jul 7 14:18:46 2006 : Error: rlm_sql_mysql: MYSQL Error: No FieldsFri Jul 7 14:18:46 2006 : Error: rlm_sql_mysql: MYSQL error:Fri Jul 7 14:18:46 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4Fri Jul 7 14:18:46 2006 : Error: rlm_sql (sql): failed after re-connect. I tried googling the archive but could not get a proper solution. One more thing; I had configured rlm_mysql using the following command: ./configure --without-thread. Could this be a cause of some problem, I did this as the radius was not finding mysql libraries. Can someone please help on this. Thanks in advance. w/regards, Jayesh Nambiar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
MYSQL error 1312
Hello all I am trying to use MySQL 5.0.19 Stored Procedure with Free Radius 1.1. This is my Procedure DELIMITER $$ DROP PROCEDURE IF EXISTS `radius`.`auth`$$ CREATE PROCEDURE `auth`(user1 varchar(100)) BEGIN SELECT id, UserName, Attribute, Value, op FROM radius.radcheck WHERE Username =user1 ORDER BY id; END$$ DELIMITER ; When I run this procedure from Query Browser the procedure runs fine but wen I run this procedure using Free Radius I get this error radius_xlat: 'CALL auth('202.80.61.42')' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: MYSQL check_error: 1312 received rlm_sql_getvpdata: database query error rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 is it some problem with the driver. What do u think is the problem Vignesh Bhaskar Novanet Technologies - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius+mysql+error
Hello everybody. I have configured free radius yo work with my sql.my sql server is also running.I have configured sql.conf and freeradius.conf to work with free radius.But when i start radius in debugging mode then i find the following errors.What can be the error. [EMAIL PROTECTED] mysql]# /usr/local/freeradius/sbin/radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded SQL Counter Module: Instantiated sqlcounter (noresetcounter) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Listening on proxy *:1814 Ready to process requests. and it does not authenticate any users Rupak - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql+error
On Wed, Jun 01, 2005 at 07:07:02AM +0545, [EMAIL PROTECTED] wrote: radius.But when i start radius in debugging mode then i find the following errors.What can be the error. rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' What can the errors be? Let's see, what don't you understand about the above error? -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql+error
Hello, Check your sql configuration in sql.conf in the following area # Connect info server = yousqlip login = user password = pws Abdul Lateef Kapilvastu Lumbini __ Discover Yahoo! Find restaurants, movies, travel and more fun for the weekend. Check it out! http://discover.yahoo.com/weekend.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql+error
Thank you I just finished it successfully. Actually the problem was with the sql server.Now I am defining the attribute Max-All-Session in seconds. That means I am defining time limitations. [Prepaid].But what I want is that I will make a user and it can surf unlimited.But the total time should be automatically appended in my sql.What is the Attribute for this and the Value also. And can we define time limitations in minutes/hours Hello, Check your sql configuration in sql.conf in the following area # Connect info server = yousqlip login = user password = pws Abdul Lateef Kapilvastu Lumbini __ Discover Yahoo! Find restaurants, movies, travel and more fun for the weekend. Check it out! http://discover.yahoo.com/weekend.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section authorize { preprocess # counter # attr_filter # eap suffix sql files # mschap } accounting { # acct_unique detail # counter unix sql radutmp # sradutmp } and I have not commented the default values.Will make any problem?. On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Try installing the Mysql rpm separately and then check wether ur MySQL is running correctly or not. Try this tweak,hope it will clear the mess. On 6/1/05, Rupak [EMAIL PROTECTED] wrote: Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section authorize { preprocess # counter # attr_filter # eap suffix sql files # mschap } accounting { # acct_unique detail # counter unix sql radutmp # sradutmp } and I have not commented the default values.Will make any problem?. On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kamran Bukhari - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
Well I have installed the following things of my sql.The things are the following. rpm -q mysql--it is installed rpm -q mysql-server--it is installed rpm -q mysql-devel---it is installed. These packages were installed from redhat9.But when I start the service Service mysqld start/status it says mysqld dead but subsys locked.what may be the problem?. Try installing the Mysql rpm separately and then check wether ur MySQL is running correctly or not. Try this tweak,hope it will clear the mess. : Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section authorize { preprocess # counter # attr_filter # eap suffix sql files # mschap } accounting { # acct_unique detail # counter unix sql radutmp # sradutmp } and I have not commented the default values.Will make any problem?. rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. -- Kamran Bukhari - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
U dont have to change anything to my.cnf as when u install the new rpm, the cnf file will be automatically adjusted. After succesful installation, run the mysql client. After the successful running, do some changes to sql.conf in raddb as u wish. for tutorial , try mysql website as they got good manual. On 6/1/05, Rupak [EMAIL PROTECTED] wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kamran Bukhari - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html usually there is no need to change anythin in my.cnf by default. Per default the mysql user root exists and has *NO* password set! If u want to restrict him to use password or restrict him to hosts u can either use the mysql-set-permission utility or enter the mysql console and use sql like that: grant all privileges on database.tables to root@host identified by password; wildards at database and tables are allowed. U may use *.* if u want to restrict root for all existing databases! host can be your hostname, or localhost or an ip address. Usually it is a good thing to restrict root to connections from localhost. And do not forget the semicolon at the end of the line :D U should not restrict the privileges of root ;) cheers Sebastian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Additionally, if mysql failed to start have a look at /var/log/mysql_error.log or something similar to that. It will tell you the reason... Also something could have screwed your /var/run/mysql/mysqld.sock. For testing u may rename the file and restart mysqld then. It should then create a new socket... cheers Sebastian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
I checked bu there is no mysqld.sock in /var/run/mysqld. May be because my sql is not started. Because it gives back an error telling that mysqld dead but subsys locked Rupak Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Additionally, if mysql failed to start have a look at /var/log/mysql_error.log or something similar to that. It will tell you the reason... Also something could have screwed your /var/run/mysql/mysqld.sock. For testing u may rename the file and restart mysqld then. It should then create a new socket... cheers Sebastian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius+mysql error
I configured freeradius it was working well.Now I wanted to make it work with my sql.My distro is redhat9 and I am using the version mysql-3.23.54a-11.rpm.Free radius was working and authenticating user.But after configuring the files to make it work with sql it is not working well.It gave me the following errors.I did exactly that was defined in the resources.Like in the forum section of chillispot.org .Tutorial was posted by barteki. And other sites as well. [EMAIL PROTECTED] rlm_sql_mysql]# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded SQL Counter Module: Instantiated sqlcounter (noresetcounter) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Can any one point me to a correct lane Thanking you - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Hello Download MYSQL with all its libraries e.g. i got MySQL 4.11. You are missing with libraries, thats y this message is prompting U. after downloading the libraries, Use following command rpm -Uvh --nodeps MySQL-server-... .rpm (use ur server version at ...) rpm -Uvh MySQL-share.rpm (use the share version u got) rpm -Uvh Mysql-clientrpm then use # /etc/init.d/mysql start Then compile freeradius and make again.Hope u wont get the message back. Bye On 5/31/05, Rupak [EMAIL PROTECTED] wrote: I configured freeradius it was working well.Now I wanted to make it work with my sql.My distro is redhat9 and I am using the version mysql-3.23.54a-11.rpm.Free radius was working and authenticating user.But after configuring the files to make it work with sql it is not working well.It gave me the following errors.I did exactly that was defined in the resources.Like in the forum section of chillispot.org .Tutorial was posted by barteki. And other sites as well. [EMAIL PROTECTED] rlm_sql_mysql]# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded SQL Counter Module: Instantiated sqlcounter (noresetcounter) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Can any one point me to a correct lane Thanking you - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kamran Bukhari - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql Error Message and Postgresql Question
Ugur GUNCER wrote: Hi Im my radius server gives Mysql check_error : 1054 received message after user authorization procc. What is it mean My usergroup table is empty !!! modcall: entering group authorize modcall[authorize]: module preprocess returns ok radius_xlat: 'dark' rlm_sql (sql): sql_set_user escaped user -- 'dark' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'dark' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'dark' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql_mysql: MYSQL check_error: 1054 received rlm_sql_getvpdata: database query error radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'dark' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'dark' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql_mysql: MYSQL check_error: 1054 received rlm_sql_getvpdata: database query error rlm_sql (sql): Released sql socket id: 4 And my second question is im exporting detail to mysql But i want to export detail to postgresql At same time with mysql i edit my Radius.conf . Like this # Include another file that has the SQL-related configuration. # This is another file solely because it tends to be big. # # The following configuration file is for use with MySQL. # # For Postgresql, use: ${confdir}/postgresql.conf # For MS-SQL, use: ${confdir}/mssql.conf # $INCLUDE ${confdir}/sql.conf The line above should be commented out or removed. $INCLUDE /usr/local/radiusd/etc/raddb/postgresql.conf # Write a 'utmp' style log file, of which users are currently # logged in, and where they've logged in from. # And postgresql.conf like this # Connect info server = localhost login = puser password = ppass # Database table configuration radius_db = pdata_db But in postgres radacct table is empty - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html