[Serusers] RE: Ser Crashes

[Elton Machado]

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 at iptel.org [mailto:serusers-bounces at 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 at 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 at 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 at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050428/42c88908/attachment.htm>