[Serusers] SER MySQL Support

[Holger Kinkelin]

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 at 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 at 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