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(a)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