Freeradius 1.1.0 & Mysql 5.x
Hello, I am trying to get freeradius 1.1.0 up with mysql 5.0 and it is giving me trouble. radiusd -X shows that the sql connection is established but radiusd doesn't limit the connections based on num_sql_socks and it continues to connect until my mysql hits its max connections. At that point it begins this... rlm_sql ((null)): Attempting to connect rlm_sql_mysql #299 rlm_sql_mysql: Starting connect to MySQL server for #299 rlm_sql ((null)): Connected new DB handle, #299 rlm_sql ((null)): starting 300 rlm_sql ((null)): Attempting to connect rlm_sql_mysql #300 rlm_sql_mysql: Starting connect to MySQL server for #300 rlm_sql_mysql: Couldn't connect socket to MySQL server radiusd@localhost :radius rlm_sql_mysql: Mysql error 'Too many connections' rlm_sql ((null)): Failed to connect DB handle #300 rlm_sql ((null)): starting 301 rlm_sql ((null)): starting 302 rlm_sql ((null)): starting 303 rlm_sql ((null)): starting 304 and it continues until i Ctrl-C it Anyone have any ideas? Thanks, Chad
Chadwick Sorrell <mirotrem@gmail.com> wrote:
radiusd -X shows that the sql connection is established but radiusd doesn't limit the connections based on num_sql_socks and it continues to connect until my mysql hits its max connections. At that point it begins this...
rlm_sql ((null)): Attempting to connect rlm_sql_mysql #299
That's a fairly serious problem. The initial "(null)" should *not* be happening, and appears to be impossible, based on my reading of the code. And the max number of sockets is hard-coded in the source to 256, so a socket number greater than that is impossible. I don't know what's wrong, but I've never seen this before. Something is very, very, wrong with your installation. Alan DeKok.
Chadwick Sorrell wrote:
I am trying to get freeradius 1.1.0 up with mysql 5.0 and it is giving me trouble. [...] rlm_sql ((null)): Attempting to connect rlm_sql_mysql #300
It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the version of the libmysqlclient headers on your system. And please turn off HTML in your email client when posting to this mailing list: http://freeradius.org/list/users.html -- Nicolas Baradakis
On 1/9/06, Nicolas Baradakis <nbk@sitadelle.com> wrote:
It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the version of the libmysqlclient headers on your system.
PHP is accessing Mysql fine, well more to the point, PHP was compiled with Mysql 5 headers fine. I am using Gentoo. What else can I check? Chad
Chadwick Sorrell wrote:
On 1/9/06, Nicolas Baradakis <nbk@sitadelle.com> wrote:
It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the version of the libmysqlclient headers on your system.
PHP is accessing Mysql fine, well more to the point, PHP was compiled with Mysql 5 headers fine. I am using Gentoo. What else can I check?
I'd suggest to check whether *FreeRADIUS* was compiled with Mysql 5 headers. Also check if you have several versions of the libmysqlclient installed simultaneously: perhaps the linker picks up the wrong version. See the output of the command: $ ldd /usr/lib/freeradius/rlm_sql_mysql.so -- Nicolas Baradakis
Nicolas, As soon as I remove the --disable-static from the configure it seems to work fine. What do you think could be causing that? Thanks, Chad On 1/10/06, Nicolas Baradakis <nbk@sitadelle.com> wrote:
Chadwick Sorrell wrote:
On 1/9/06, Nicolas Baradakis <nbk@sitadelle.com> wrote:
It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the version of the libmysqlclient headers on your system.
PHP is accessing Mysql fine, well more to the point, PHP was compiled with Mysql 5 headers fine. I am using Gentoo. What else can I check?
I'd suggest to check whether *FreeRADIUS* was compiled with Mysql 5 headers. Also check if you have several versions of the libmysqlclient installed simultaneously: perhaps the linker picks up the wrong version.
See the output of the command: $ ldd /usr/lib/freeradius/rlm_sql_mysql.so
-- Nicolas Baradakis
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Alan DeKok -
Chadwick Sorrell -
Nicolas Baradakis