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@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@myserver tester]# declare -x SIP_DOMAIN="mysertest.com" [root@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
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@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@myserver tester]# declare -x SIP_DOMAIN="mysertest.com" [root@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers