<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>we are testing SER 0.9.6 and SER 2.0 in a Red Hat
Enterprise Linux AS release 3 (Taroon Update 8) environment. For test persitence
auth mode configuration we have installed a MySQL 5 server with development
libraries. The RPM pakages are:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>MySQL-shared-compat-5.0.27-0.rhel3<BR>MySQL-server-standard-5.0.27-0.rhel3<BR>MySQL-devel-standard-5.0.27-0.rhel3<BR>MySQL-client-standard-5.0.27-0.rhel3</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We have compiled, installed and configurated both
SER 0.9.6 and SER 2.0 following the INSTALL instructions. Besides, our
environment has all the previous requirements for installing SER. In a no
persitence auth mode configuration the SER server works fine, but when we
configure a persistence auth mode using mysql module (previous mysql.so
generation and installation and ser.cfg configuration) the server crash.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We are compiling and installing without error using
this commands (for instance in SER 0.9.6):</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>make mode=debug include_modules="mysql" all<BR>make
include_modules="mysql" install</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The error is this (for instance in SER 0.9.6,
see line 2 in the log) :</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> 0(17102) loading module
/usr/local/lib/ser/modules/mysql.so<BR> 0(17102) ERROR: load_module: could
not open module </usr/local/lib/ser/modules/mysql.so>:
/usr/local/lib/ser/modules/mysql.so: undefined symbol: log<BR> 0(17102)
parse error (28,13-14): failed to load module<BR> 0(17102) loading module
/usr/local/lib/ser/modules/sl.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/tm.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/rr.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/maxfwd.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/usrloc.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/registrar.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/textops.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/auth.so<BR> 0(17102) loading module
/usr/local/lib/ser/modules/auth_db.so<BR> 0(17102) set_mod_param_regex:
usrloc matches module usrloc<BR> 0(17102) set_mod_param_regex: found
<db_mode> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]<BR> 0(17102) set_mod_param_regex:
auth_db matches module auth_db<BR> 0(17102) set_mod_param_regex: found
<calculate_ha1> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]<BR> 0(17102) set_mod_param_regex:
auth_db matches module auth_db<BR> 0(17102) set_mod_param_regex: found
<password_column> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]<BR> 0(17102) set_mod_param_regex:
rr matches module rr<BR> 0(17102) set_mod_param_regex: found
<enable_full_lr> in module rr
[/usr/local/lib/ser/modules/rr.so]<BR> 0(17102) find_export: found
<mf_process_maxfwd_header> in module maxfwd
[/usr/local/lib/ser/modules/maxfwd.so]<BR> 0(17102) find_export: found
<sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR> 0(17102) find_export: found
<sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR> 0(17102) find_export: found
<record_route> in module rr
[/usr/local/lib/ser/modules/rr.so]<BR> 0(17102) find_export: found
<loose_route> in module rr
[/usr/local/lib/ser/modules/rr.so]<BR> 0(17102) find_export: found
<append_hf> in module textops
[/usr/local/lib/ser/modules/textops.so]<BR> 0(17102) find_export: found
<append_hf> in module textops
[/usr/local/lib/ser/modules/textops.so]<BR> 0(17102) find_export: found
<www_authorize> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]<BR> 0(17102) find_export: found
<www_challenge> in module auth
[/usr/local/lib/ser/modules/auth.so]<BR> 0(17102) find_export: found
<save> in module registrar
[/usr/local/lib/ser/modules/registrar.so]<BR> 0(17102) find_export: found
<lookup> in module registrar
[/usr/local/lib/ser/modules/registrar.so]<BR> 0(17102) find_export: found
<append_hf> in module textops
[/usr/local/lib/ser/modules/textops.so]<BR> 0(17102) find_export: found
<lookup> in module registrar
[/usr/local/lib/ser/modules/registrar.so]<BR> 0(17102) find_export: found
<sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR> 0(17102) find_export: found
<append_hf> in module textops
[/usr/local/lib/ser/modules/textops.so]<BR> 0(17102) find_export: found
<t_relay> in module tm
[/usr/local/lib/ser/modules/tm.so]<BR> 0(17102) find_export: found
<sl_reply_error> in module sl_module
[/usr/local/lib/ser/modules/sl.so]<BR>ERROR: bad config file (1
errors)</FONT></DIV>
<DIV><FONT face=Arial size=2>.....</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The SER configuration file content is:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>#<BR># $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44
andrei Exp $<BR>#<BR># simple quick-start config script<BR>#</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ----------- global configuration parameters
------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>debug=4 # debug level
(cmd line: -dddddddddd)<BR>#fork=yes<BR>log_stderror=yes # (cmd line:
-E)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>/* Uncomment these lines to enter debugging
mode<BR>fork=no<BR>log_stderror=yes<BR>*/</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>check_via=no # (cmd. line:
-v)<BR>dns=no #
(cmd. line: -r)<BR>rev_dns=no # (cmd. line:
-R)<BR>#port=5060<BR>#children=4<BR>fifo="/tmp/ser_fifo"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ------------------ module loading
----------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use SQL
database<BR>loadmodule "/usr/local/lib/ser/modules/mysql.so"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>loadmodule
"/usr/local/lib/ser/modules/sl.so"<BR>loadmodule
"/usr/local/lib/ser/modules/tm.so"<BR>loadmodule
"/usr/local/lib/ser/modules/rr.so"<BR>loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"<BR>loadmodule
"/usr/local/lib/ser/modules/usrloc.so"<BR>loadmodule
"/usr/local/lib/ser/modules/registrar.so"<BR>loadmodule
"/usr/local/lib/ser/modules/textops.so"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want digest
authentication<BR># mysql.so must be loaded !<BR>loadmodule
"/usr/local/lib/ser/modules/auth.so"<BR>loadmodule
"/usr/local/lib/ser/modules/auth_db.so"<BR># ----------------- setting
module-specific parameters ---------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># -- usrloc params --</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>#modparam("usrloc", "db_mode",
0)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># Uncomment this if you want to use SQL
database<BR># for persistent storage and comment the previous
line<BR>modparam("usrloc", "db_mode", 2)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># -- auth params --<BR># Uncomment if you are using
auth module<BR>#<BR>modparam("auth_db", "calculate_ha1", yes)<BR>#<BR># If you
set "calculate_ha1" parameter to yes (which true in this config),<BR># uncomment
also the following parameter)<BR>#<BR>modparam("auth_db", "password_column",
"password")</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># -- rr params --<BR># add value to ;lr param to
make some broken UAs happy<BR>modparam("rr", "enable_full_lr", 1)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># ------------------------- request routing
logic -------------------<BR># ------------------------- request routing
logic -------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2># main routing logic</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>route{</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2> #
initial sanity checks -- messages
with<BR> # max_forwards==0, or
excessively long requests<BR> if
(!mf_process_maxfwd_header("10"))
{<BR>
sl_send_reply("483","Too Many
Hops");<BR>
break;<BR>
};<BR> if (msg:len >= 2048 )
{<BR>
sl_send_reply("513", "Message too
big");<BR>
break;<BR> };</FONT></DIV>
<DIV> </DIV><FONT face=Arial size=2>
<DIV><BR> # we record-route all
messages -- to make sure that<BR> #
subsequent messages will go through our proxy;
that's<BR> # particularly good if
upstream and downstream entities<BR> #
use different transport protocol<BR>
if (!method=="REGISTER") record_route();</DIV>
<DIV> </DIV>
<DIV> # subsequent messages withing a
dialog should take the<BR> # path
determined by record-routing<BR> if
(loose_route())
{<BR>
# mark routing logic in
request<BR>
append_hf("P-hint:
rr-enforced\r\n");<BR>
route(1);<BR>
break;<BR> };</DIV>
<DIV>if (!uri==myself)
{<BR>
# mark routing logic in
request<BR>
append_hf("P-hint:
outbound\r\n");<BR>
route(1);<BR>
break;<BR> };</DIV>
<DIV> </DIV>
<DIV> # if the request is for other
domain use UsrLoc<BR> # (in case, it
does not work, use the following
command<BR> # with proper names and
addresses in it)<BR> if (uri==myself)
{</DIV>
<DIV> </DIV>
<DIV>
if (method=="REGISTER") {</DIV>
<DIV> </DIV>
<DIV>
# Uncomment this if you want to use digest
authentication<BR>
if (!www_authorize("mydomain.org", "subscriber"))
{<BR>
www_challenge("mydomain.org",
"0");<BR>
break;<BR>
};</DIV>
<DIV> </DIV>
<DIV>
save("location");<BR>
break;<BR>
};</DIV>
<DIV> </DIV>
<DIV>
lookup("aliases");<BR>
if (!uri==myself)
{<BR>
append_hf("P-hint: outbound
alias\r\n");<BR>
route(1);<BR>
break;<BR>
};</DIV>
<DIV> </DIV>
<DIV>
# native SIP destinations are handled using our USRLOC
DB<BR>
if (!lookup("location"))
{<BR>
sl_send_reply("404", "Not
Found");<BR>
break;<BR>
};<BR>
};<BR> append_hf("P-hint: usrloc
applied\r\n");<BR>
route(1);<BR>}</DIV>
<DIV> </DIV>
<DIV>route[1]<BR>{<BR> # send it out
now; use stateful forwarding as it works
reliably<BR> # even for
UDP2TCP<BR> if (!t_relay())
{<BR>
sl_reply_error();<BR> };<BR>}</DIV>
<DIV> </DIV>
<DIV>Searching mysql libraries in the environment we have:</DIV>
<DIV> </DIV>
<DIV># ldconfig -p | grep -i
mysqlclient<BR> libmysqlclient_r.so.15
(libc6) =>
/usr/lib/libmysqlclient_r.so.15<BR>
libmysqlclient_r.so.14 (libc6) =>
/usr/lib/libmysqlclient_r.so.14<BR>
libmysqlclient_r.so.12 (libc6) =>
/usr/lib/libmysqlclient_r.so.12<BR>
libmysqlclient_r.so.10 (libc6) =>
/usr/lib/libmysqlclient_r.so.10<BR>
libmysqlclient_r.so (libc6) =>
/usr/lib/libmysqlclient_r.so<BR>
libmysqlclient.so.15 (libc6) =>
/usr/lib/libmysqlclient.so.15<BR>
libmysqlclient.so.14 (libc6) =>
/usr/lib/libmysqlclient.so.14<BR>
libmysqlclient.so.12 (libc6) =>
/usr/lib/libmysqlclient.so.12<BR>
libmysqlclient.so.10 (libc6) =>
/usr/lib/libmysqlclient.so.10<BR>
libmysqlclient.so (libc6) => /usr/lib/libmysqlclient.so</DIV>
<DIV> </DIV>
<DIV># ls -ltr /usr/lib/mysql<BR>total 16096<BR>-rw-r--r-- 1
root root
57872 oct 21 2006 libmygcc.a<BR>-rwxr-xr-x 1
root
root 789 oct 21 2006
libz.la<BR>-rw-r--r-- 1 root
root 165448 oct 21 2006
libz.a<BR>-rw-r--r-- 1 root
root 1657008 oct 21 2006
libmystrings.a<BR>-rw-r--r-- 1 root
root 922784 oct 21 2006
libmysys.a<BR>-rw-r--r-- 1 root
root 27974 oct 21 2006
libdbug.a<BR>-rw-r--r-- 1 root
root 587234 oct 21 2006
libmyisammrg.a<BR>-rw-r--r-- 1 root
root 1832838 oct 21 2006
libmyisam.a<BR>-rw-r--r-- 1 root
root 41910 oct 21 2006
libvio.a<BR>-rw-r--r-- 1 root
root 416488 oct 21 2006
libheap.a<BR>-rwxr-xr-x 1 root
root 969 oct 21 2006
libmysqlclient_r.la<BR>-rw-r--r-- 1
root root 4978414 oct
21 2006 libmysqlclient_r.a<BR>-rwxr-xr-x 1
root
root 923 oct 21 2006
libmysqlclient.la<BR>-rw-r--r-- 1 root
root 4956358 oct 21 2006
libmysqlclient.a<BR>-rw-r--r-- 1 root
root 738080 oct 21 2006
mysqld.sym</DIV>
<DIV> </DIV>
<DIV>We have tried with SER 2.0 too, but the error is the same.</DIV>
<DIV> </DIV>
<DIV>What are we doing bad???????</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=Arial size=2>Eduardo</FONT></DIV></BODY></HTML>