[Serusers] SER with MYsql could not start

[Amar Tuladhar]

Dear sir,

 

While starting SER I get error:

======================

Mar  6 12:47:23 localhost ser: parse error (28,13-14): failed to load module

Mar  6 12:54:12 localhost ser: ERROR: load_module: could not open module
</usr/local/lib/ser/modules/mysql.so>: /usr/local/lib/ser/modules/mysql.so:
undefined symbol: executor_globals

Mar  6 12:54:12 localhost ser: parse error (28,13-14): failed to load module

 

 

Other info:

=========

[root at localhost log]# mysql -e status -p

Enter password:

--------------

mysql  Ver 14.12 Distrib 5.0.51a, for redhat-linux-gnu (i386) using readline
5.0

 

Connection id:          17

Current database:

Current user:           root at localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.0.51a Source distribution

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    latin1

Db     characterset:    latin1

Client characterset:    latin1

Conn.  characterset:    latin1

UNIX socket:            /var/lib/mysql/mysql.sock

Uptime:                 3 hours 7 min 37 sec

 

Threads: 1  Questions: 971  Slow queries: 0  Opens: 401  Flush tables: 1
Open tables: 64  Queries per second avg: 0.086

--------------

 

SER Version

=========

Server: Sip EXpress router (0.9.7 (i386/linux))

 

 

SER Config file

===========

[root at localhost ser]# cat ser.cfg.mysql

#

# $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=7         # debug level (cmd line: -dddddddddd)

#fork=yes

#log_stderror=no        # (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 -------------------

 

# 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("localhost", "subscriber")) {

                                www_challenge("localhost", "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();

        };

}

 

[root at localhost ser]#

 

 

Hope to receive your solutions, thank you.

Amar Tuladhar

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090306/8164f020/attachment.htm>