[Serusers] Database Connection Issue

[Darren Nay]

Hey All,

 

I've got an odd problem.  I've configured SER to talk to MySQL located on
the localhost successfully.  However, I now want to move my MySQL database
to a separate server from SER for performance reasons.

 

The problem is that now I've moved the database server and changed the
db_url in my ser.cfg file and SER is still looking for the local socket in
/tmp/mysql.sock.  

 

My db_url in ser.cgi looks like this:

 

# -- auth params --

modparam("auth_db", "calculate_ha1", yes)

modparam("auth_db", "password_column", "password")

modparam("auth_db", "db_url", "mysql://ser:heslo@db1-grv1/ser")

 

user:ser

pass:heslo

host:db1-grv1

 

db1-grv1 is mapped to the mysql server IP in the /etc/hosts file.  I can
connect fine remotely using the "mysql" client tool and the user/pass above.

 

However, when I start SER I get the following ...

 

Listening on 

              my.ip.iz.her [my.ip.iz.her]:5060

Aliases: my.hst.iz.her:5060 

WARNING: no fork mode 

stateless - initializing

Maxfwd module- initializing

acc - initializing

 0(28939) connect_db(): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

 0(28939) db_init(): Error while trying to connect database

 0(28939) mod_init(): Error while connecting database

 0(28939) init_mod(): Error while initializing module usrloc

ERROR: error while initializing modules 

 

Any suggestions?  Is my syntax for the "db_url" parameter correct?  

 

Any help would be appreciated.  Thanks in advance.

 

 

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