Hello everybody!
I want to use the mySQL-support for SER but I've got a problem: When I start SER I get the following error
DrScheme@dell:/usr/local/etc/ser> /usr/local/sbin/ser 0(7443) ERROR: load_module: could not open module </usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.12: cannot open shared object file: No such file or directory 0(7443) parse error (18,13-14): failed to load module ERROR: bad config file (1 errors)
When I get this right, the libmysqlclient.so-file is missing. I looked for the file and indeed, it's not on the box.
I don't know where to get that file from and where to put it, when I have it. Could please someone tell me?
Incase you need to know what I did up to now:
- I installed mySQL (4.1.13-3) using YaST on my Suse 10.0 box. The mySQL server is running happily - I installed SER 0.9.6 from a tar.gz package, run the script for mySQL-Tables and I use the following config-file
# $Id: hello-world.cfg 46 2006-01-25 04:21:30Z /CN=Paul Hazlett/emailAddress=paul@onsip.org $ debug=3 fork=no log_stderror=yes
listen=192.168.0.31 # put your server IP address here port=5060 children=4
dns=no rev_dns=no fifo="/tmp/ser_fifo"
# mysql-support fifo_db_url="mysql://ser:heslo@localhost/ser" # --- # mysql-support 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" # mysql-support loadmodule "/usr/local/lib/ser/modules/uri_db.so" loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so" # ---
modparam("usrloc", "db_mode", 0) modparam("rr", "enable_full_lr", 1) # mysql-support modparam("auth_db|uri_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("auth_db", "calculate_ha1", 1) modparam("auth_db", "password_column", "password") # ---
route {
# ------------------------------------------------------------------------ # Sanity Check Section # ------------------------------------------------------------------------ if (!mf_process_maxfwd_header("10")) { sl_send_reply("483", "Too Many Hops"); break; };
if (msg:len > max_len) { sl_send_reply("513", "Message Overflow"); break; };
# ------------------------------------------------------------------------ # Record Route Section # ------------------------------------------------------------------------ if (method!="REGISTER") { record_route(); };
# ------------------------------------------------------------------------ # Loose Route Section # ------------------------------------------------------------------------ if (loose_route()) { route(1); break; };
# ------------------------------------------------------------------------ # Call Type Processing Section # ------------------------------------------------------------------------ if (uri!=myself) { route(1); break; };
if (method=="ACK") { route(1); break; } else if (method=="REGISTER") { route(2); break; };
lookup("aliases"); if (uri!=myself) { route(1); break; };
if (!lookup("location")) { sl_send_reply("404", "User Not Found"); break; };
route(1); }
route[1] { # ------------------------------------------------------------------------ # Default Message Handler # ------------------------------------------------------------------------ if (!t_relay()) { sl_reply_error(); }; }
route[2] { # ------------------------------------------------------------------------ # REGISTER Message Handler # ------------------------------------------------------------------------ # mysql support if (!www_authorize("","subscriber")) { www_challenge("","0"); break; }; # ---
if (!save("location")) { sl_reply_error(); }; }
Regards, Holger