Did you checked out well your configuration?
You have to have something like...
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"
#......
modparam("auth_db|usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("usrloc", "db_mode", 2)
to ser load things up from database, check if you have the right username and password, and if your mysql database is running.
Regards,
_____
From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of IpTel List Sent: quinta-feira, 21 de Abril de 2005 8:19 To: Iptel Mailing list Subject: [Serusers] RE: Ser Crashes
Hi!
Thanx for help. It writes that he can't connect to MYSQL DB now ... Output is the following ...
root@ignosya:/usr/local/etc/ser# ser -E -d Listening on 127.0.0.1 [127.0.0.1]:5060 84.230.194.213 [84.230.194.213]:5060 192.168.1.1 [192.168.1.1]:5060 Aliases: 1.1.168.192.in-addr.arpa:5060 a84-230-194-213.elisa-laajakaista.fi:5060 localhost:5060 root@ignosya:/usr/local/etc/ser# stateless - initializing Maxfwd module- initializing 0(15143) connect_db(): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) 0(15143) db_init(): Error while trying to connect database 0(15143) mod_init(): Error while connecting database 0(15143) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules
root@ignosya:/usr/local/etc/ser#
So, it seams for me, that it's like MYSQL problem. So, i have to reconfigure it ... or check it up ...
But, are there any methods selecting mysql host adres? For example, if mysql is not on local machine ... is it enough to set SQL_HOST var?
Best wishes,
Alexandro.