[Serusers] SER with MySql - Error! Need Help!

[Alberto Cruz]

Did you already check at the /usr/local/lib/ser/modules or at the 
/usr/lib that the requested files.so exists?

If the problem is the libmysqlclient maybe you need to reinstall MySQL 
in order to make the mysql shared libraries from the scratch

Regards

Alberto Cruz

Valério Vendrame Costa wrote:

> I have one problem to use SER with Mysql.
> I want to autenticate user by mysql database acount...
> When I try to start SER, system show this message:
>
> Help me please!
>
> [root at myserver tester]# /usr/local/sbin/ser -E
> 0(6250) ERROR: load_module: could not open module 
> </usr/local/lib/ser/modules/mysql.so>: /usr/lib/libmysqlclient.so.10: 
> invalid ELF header
> 0(6250) parse error (31,13-49): failed to load module
> ERROR: bad config file (1 errors)
>
> Before I run Ser I input this commands:
> [root at myserver tester]# declare -x SIP_DOMAIN="mysertest.com"
> [root at myserver tester]# /usr/local/sbin/serctl start
>
> My config file "ser.cfg" is:
>
>
> # ----------- global configuration parameters ------------------------
>
> #debug=3         # debug level (cmd line: -dddddddddd)
> #fork=yes
> #log_stderror=no    # (cmd line: -E)
>
> /* Uncomment these lines to enter debugging mode
> debug=7
> 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"
>
> alias=mysertest.com
>
> # ------------------ 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"
>
> # 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 > max_len ) {
>         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
>     record_route();
>     # loose-route processing
>     if (loose_route()) {
>         t_relay();
>         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=~"mysertest.com") {
>
>         if (method=="REGISTER") {
>
> # Uncomment this if you want to use digest authentication
>             if (!www_authorize("mysertest.com", "subscriber")) {
>                 www_challenge("mysertest.com", "0");
>                 break;
>             };
>
>             save("location");
>             break;
>         };
>
>         # native SIP destinations are handled using our USRLOC DB
>         if (!lookup("location")) {
>             sl_send_reply("404", "Not Found");
>             break;
>         };
>     };
>     # forward to current uri now; use stateful forwarding; that
>     # works reliably even if we forward from TCP to UDP
>     if (!t_relay()) {
>         sl_reply_error();
>     };
>
> }
>
> If somebody can help me... Thanks! Valerio.
>
> _________________________________________________________________
> MSN Busca: fácil, rápido, direto ao ponto.  http://search.msn.com.br
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>