<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-2" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:tnt@kalik.net">tnt@kalik.net</a> a écrit :
<blockquote cite="mid:A9RRQxy1.1220641107.2468330.tnt@kalik.net"
type="cite">
<pre wrap="">Have you replaced sql with proper instance name in sqlippool.conf?
</pre>
</blockquote>
Yes I added the name of the sql instance used for accouting: mysqldb in
my case.<br>
<blockquote cite="mid:A9RRQxy1.1220641107.2468330.tnt@kalik.net"
type="cite">
<pre wrap="">Ivan Kalik
Kalik Informatika ISP
Dana 5/9/2008, "Alexandre Chapellon" <a class="moz-txt-link-rfc2396E" href="mailto:alexandre.chapellon@mana.pf"><alexandre.chapellon@mana.pf></a> pi¹e:
</pre>
<blockquote type="cite">
<pre wrap="">
Alan DeKok a écrit :
</pre>
<blockquote type="cite">
<pre wrap="">Alexandre Chapellon wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I have a problem loading freeradius since i enabled sqlippool
</pre>
</blockquote>
<pre wrap=""> You need to enable the SQL module, too.
</pre>
<blockquote type="cite">
<pre wrap="">i get the following message:
freeradius: symbol lookup error:
/usr/lib/freeradius/rlm_sqlippool-2.0.5.so: undefined symbol: sql_get_socket
</pre>
</blockquote>
<pre wrap="">...
</pre>
<blockquote type="cite">
<pre wrap="">and none of the linked library contains any sql_get_socket symbol (in
fact for most of thoose lib files nm returns no symbols)
What the hell did I miss?
</pre>
</blockquote>
<pre wrap=""> List "sql" in the "instantiate" section so it's loaded, too.
</pre>
</blockquote>
<pre wrap="">In fact I am using too different sql modules, the first for
authentication (named oracledb which uses oracle driver) and the second
for accouting (named mysqldb, which uses mysql shims... of course).
So i have no more module called "sql", and so i tryed adding "mysqldb"
instead of "sql".
Unfortunatly, I still get the undefined symbol error when running
freeradius -X, and looking deeper at the output I can see in the lines
that the rlm_sql module seems to be linked correctly... as you can see:
....
rlm_sql (mysqldb): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded
and linked
rlm_sql (mysqldb): Attempting to connect to <a class="moz-txt-link-abbreviated" href="mailto:freeradius@127.0.0.1:/accounting">freeradius@127.0.0.1:/accounting</a>
rlm_sql (mysqldb): starting 0
rlm_sql (mysqldb): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (mysqldb): Connected new DB handle, #0
....
freeradius: symbol lookup error:
/usr/lib/freeradius/rlm_sqlippool-2.0.5.so: undefined symbol: sql_get_socket
</pre>
<blockquote type="cite">
<pre wrap=""> Alan DeKok.
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap=""><!---->
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
</body>
</html>