[Serusers] SER server doesn't start with mysql persistente auth mode configuration

Eduardo del Bas Junquera edelbas at polar.es
Fri Sep 28 13:45:44 CEST 2007


Hi all,

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:

MySQL-shared-compat-5.0.27-0.rhel3
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3

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. 

We are compiling and installing without error using this commands (for instance in SER 0.9.6):

make mode=debug include_modules="mysql" all
make include_modules="mysql" install

The error is this (for instance in SER 0.9.6, see line 2 in the log) :

 0(17102) loading module /usr/local/lib/ser/modules/mysql.so
 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
 0(17102) parse error (28,13-14): failed to load module
 0(17102) loading module /usr/local/lib/ser/modules/sl.so
 0(17102) loading module /usr/local/lib/ser/modules/tm.so
 0(17102) loading module /usr/local/lib/ser/modules/rr.so
 0(17102) loading module /usr/local/lib/ser/modules/maxfwd.so
 0(17102) loading module /usr/local/lib/ser/modules/usrloc.so
 0(17102) loading module /usr/local/lib/ser/modules/registrar.so
 0(17102) loading module /usr/local/lib/ser/modules/textops.so
 0(17102) loading module /usr/local/lib/ser/modules/auth.so
 0(17102) loading module /usr/local/lib/ser/modules/auth_db.so
 0(17102) set_mod_param_regex: usrloc matches module usrloc
 0(17102) set_mod_param_regex: found <db_mode> in module usrloc [/usr/local/lib/ser/modules/usrloc.so]
 0(17102) set_mod_param_regex: auth_db matches module auth_db
 0(17102) set_mod_param_regex: found <calculate_ha1> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
 0(17102) set_mod_param_regex: auth_db matches module auth_db
 0(17102) set_mod_param_regex: found <password_column> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
 0(17102) set_mod_param_regex: rr matches module rr
 0(17102) set_mod_param_regex: found <enable_full_lr> in module rr [/usr/local/lib/ser/modules/rr.so]
 0(17102) find_export: found <mf_process_maxfwd_header> in module maxfwd [/usr/local/lib/ser/modules/maxfwd.so]
 0(17102) find_export: found <sl_send_reply> in module sl_module [/usr/local/lib/ser/modules/sl.so]
 0(17102) find_export: found <sl_send_reply> in module sl_module [/usr/local/lib/ser/modules/sl.so]
 0(17102) find_export: found <record_route> in module rr [/usr/local/lib/ser/modules/rr.so]
 0(17102) find_export: found <loose_route> in module rr [/usr/local/lib/ser/modules/rr.so]
 0(17102) find_export: found <append_hf> in module textops [/usr/local/lib/ser/modules/textops.so]
 0(17102) find_export: found <append_hf> in module textops [/usr/local/lib/ser/modules/textops.so]
 0(17102) find_export: found <www_authorize> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
 0(17102) find_export: found <www_challenge> in module auth [/usr/local/lib/ser/modules/auth.so]
 0(17102) find_export: found <save> in module registrar [/usr/local/lib/ser/modules/registrar.so]
 0(17102) find_export: found <lookup> in module registrar [/usr/local/lib/ser/modules/registrar.so]
 0(17102) find_export: found <append_hf> in module textops [/usr/local/lib/ser/modules/textops.so]
 0(17102) find_export: found <lookup> in module registrar [/usr/local/lib/ser/modules/registrar.so]
 0(17102) find_export: found <sl_send_reply> in module sl_module [/usr/local/lib/ser/modules/sl.so]
 0(17102) find_export: found <append_hf> in module textops [/usr/local/lib/ser/modules/textops.so]
 0(17102) find_export: found <t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]
 0(17102) find_export: found <sl_reply_error> in module sl_module [/usr/local/lib/ser/modules/sl.so]
ERROR: bad config file (1 errors)
.....

The SER configuration file content is:

#
# $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $
#
# simple quick-start config script
#

# ----------- global configuration parameters ------------------------

debug=4         # debug level (cmd line: -dddddddddd)
#fork=yes
log_stderror=yes # (cmd line: -E)

/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/

check_via=no    # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
#port=5060
#children=4
fifo="/tmp/ser_fifo"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"

loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------

# -- usrloc params --

#modparam("usrloc", "db_mode",   0)

# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)

# -- auth params --
# Uncomment if you are using auth module
#
modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
modparam("auth_db", "password_column", "password")

# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)

# -------------------------  request routing logic -------------------
# -------------------------  request routing logic -------------------

# main routing logic

route{

        # initial sanity checks -- messages with
        # max_forwards==0, or excessively long requests
        if (!mf_process_maxfwd_header("10")) {
                sl_send_reply("483","Too Many Hops");
                break;
        };
        if (msg:len >=  2048 ) {
                sl_send_reply("513", "Message too big");
                break;
        };


        # we record-route all messages -- to make sure that
        # subsequent messages will go through our proxy; that's
        # particularly good if upstream and downstream entities
        # use different transport protocol
        if (!method=="REGISTER") record_route();

        # subsequent messages withing a dialog should take the
        # path determined by record-routing
        if (loose_route()) {
                # mark routing logic in request
                append_hf("P-hint: rr-enforced\r\n");
                route(1);
                break;
        };
if (!uri==myself) {
                # mark routing logic in request
                append_hf("P-hint: outbound\r\n");
                route(1);
                break;
        };

        # if the request is for other domain use UsrLoc
        # (in case, it does not work, use the following command
        # with proper names and addresses in it)
        if (uri==myself) {

                if (method=="REGISTER") {

                        # Uncomment this if you want to use digest authentication
                        if (!www_authorize("mydomain.org", "subscriber")) {
                                www_challenge("mydomain.org", "0");
                                break;
                        };

                        save("location");
                        break;
                };

                lookup("aliases");
                if (!uri==myself) {
                        append_hf("P-hint: outbound alias\r\n");
                        route(1);
                        break;
                };

                # native SIP destinations are handled using our USRLOC DB
                if (!lookup("location")) {
                        sl_send_reply("404", "Not Found");
                        break;
                };
        };
        append_hf("P-hint: usrloc applied\r\n");
        route(1);
}

route[1]
{
        # send it out now; use stateful forwarding as it works reliably
        # even for UDP2TCP
        if (!t_relay()) {
                sl_reply_error();
        };
}

Searching mysql libraries in the environment we have:

# ldconfig -p | grep -i mysqlclient
        libmysqlclient_r.so.15 (libc6) => /usr/lib/libmysqlclient_r.so.15
        libmysqlclient_r.so.14 (libc6) => /usr/lib/libmysqlclient_r.so.14
        libmysqlclient_r.so.12 (libc6) => /usr/lib/libmysqlclient_r.so.12
        libmysqlclient_r.so.10 (libc6) => /usr/lib/libmysqlclient_r.so.10
        libmysqlclient_r.so (libc6) => /usr/lib/libmysqlclient_r.so
        libmysqlclient.so.15 (libc6) => /usr/lib/libmysqlclient.so.15
        libmysqlclient.so.14 (libc6) => /usr/lib/libmysqlclient.so.14
        libmysqlclient.so.12 (libc6) => /usr/lib/libmysqlclient.so.12
        libmysqlclient.so.10 (libc6) => /usr/lib/libmysqlclient.so.10
        libmysqlclient.so (libc6) => /usr/lib/libmysqlclient.so

# ls -ltr /usr/lib/mysql
total 16096
-rw-r--r--    1 root     root        57872 oct 21  2006 libmygcc.a
-rwxr-xr-x    1 root     root          789 oct 21  2006 libz.la
-rw-r--r--    1 root     root       165448 oct 21  2006 libz.a
-rw-r--r--    1 root     root      1657008 oct 21  2006 libmystrings.a
-rw-r--r--    1 root     root       922784 oct 21  2006 libmysys.a
-rw-r--r--    1 root     root        27974 oct 21  2006 libdbug.a
-rw-r--r--    1 root     root       587234 oct 21  2006 libmyisammrg.a
-rw-r--r--    1 root     root      1832838 oct 21  2006 libmyisam.a
-rw-r--r--    1 root     root        41910 oct 21  2006 libvio.a
-rw-r--r--    1 root     root       416488 oct 21  2006 libheap.a
-rwxr-xr-x    1 root     root          969 oct 21  2006 libmysqlclient_r.la
-rw-r--r--    1 root     root      4978414 oct 21  2006 libmysqlclient_r.a
-rwxr-xr-x    1 root     root          923 oct 21  2006 libmysqlclient.la
-rw-r--r--    1 root     root      4956358 oct 21  2006 libmysqlclient.a
-rw-r--r--    1 root     root       738080 oct 21  2006 mysqld.sym

We have tried with SER 2.0 too, but the error is the same.

What are we doing bad???????

Thanks in advance,
Eduardo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070928/270ee4d9/attachment.htm>


More information about the sr-users mailing list