[Serusers] MySQL on different server

[Jiri Kuthan]

According to the log messages you sent, you have not set up the group module for use
with the mysql connection. -jiri

At 09:45 PM 3/20/2004, Doug R wrote:
>I'm trying to run SER with a MySQL setup.  I want to put the SER on one server, and the MySQL on another server.  I am using the following parameters in my ser.cfg.  Why can't I get this working right?  I've tried connecting using MySQL's client commands directly and it works.  It seems to be only doing this on the authdb section, because I tried commenting the usrloc database commands out, and it still only produces one error message.  So apparently usrloc's MYSQL connection IS working, just not authdb's.
>
>Thanks
>
># Uncomment this if you want to use SQL database
># for persistent storage and comment the previous line
>modparam("usrloc", "db_mode", 2)
>modparam("usrloc", "db_url", "mysql://ser:password@192.168.1.194/ser")
>
># -- auth params --
># Uncomment if you are using auth module
>#
>modparam("auth_db", "calculate_ha1", yes)
>#
># If you set "calculate_ha1" parameter to yes (which true in this config),
># uncomment also the following parameter)
>#
>modparam("auth_db", "password_column", "password")
>modparam("auth_db", "db_url", "mysql://ser:password@192.168.1.194/ser")
>
># -- rr params --
># add value to ;lr param to make some broken UAs happy
>modparam("rr", "enable_full_lr", 1)
>
>I get the following messages in my log file:
>
>Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
>Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: db_init(): Could not create a connection
>Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: group:mod_init(): Unable to connect database
>Mar 20 15:32:17 sip1 /usr/local/sbin/ser[26794]: init_mod(): Error while initializing module group
> 
>                   
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers

--
Jiri Kuthan            http://iptel.org/~jiri/