I have been running SER quite successfully for a long time now. So tonight I dared to replicate the database to a remote server and changed the ser.cfg as follows.
This is the two lines I changed in my ser.cfg filen
#fifo_db_url="mysql://ser:heslo@localhost/ser" fifo_db_url="mysql://ser:heslo@192.168.12.140/ser"
#modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url", "mysql://ser:heslo@192.168.121.140/ser")
Also updated serctl as follows:
SQL_HOST=192.168.121.140
I then Stopped Ser, MySQL and restarted SER.
It takes a long time then I get these line in the error log.. and ser fails to start.
Aug 9 22:36:08 ns2 ser[43517]: new_connection(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Aug 9 22:36:08 ns2 ser[43517]: db_init(): Could not create a connection Aug 9 22:36:08 ns2 ser[43517]: ERROR: group_db_ver: unable to open database connection Aug 9 22:36:08 ns2 ser[43517]: group:mod_init(): Error while querying table version Aug 9 22:36:08 ns2 ser[43517]: init_mod(): Error while initializing module group
Then I start the old local mySQL server again and restart ser and it springs to life. Why is that? I am not pointing to the local mysql server anymore... Have I missed something in the configuration?
Even more strange, it seems that all authentication and accounting gets queried in the new server as I see can see the data in the new server alse sees the client connection from SER.
Any one who can help with an explanation on this behaviour?
Kind regards Roger
Just noted there was a type in fifo_db_url. I corrected this but it had the same result anyway...
_____
Från: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] För Roger Lewau Skickat: den 9 augusti 2006 22:52 Till: serusers@iptel.org Ämne: [Serusers] Trying to use a remote mysql....
I have been running SER quite successfully for a long time now. So tonight I dared to replicate the database to a remote server and changed the ser.cfg as follows.
This is the two lines I changed in my ser.cfg filen
#fifo_db_url="mysql://ser:heslo@localhost/ser" fifo_db_url="mysql://ser:heslo@192.168.12.140/ser"
#modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url", "mysql://ser:heslo@192.168.121.140/ser")
Also updated serctl as follows:
SQL_HOST=192.168.121.140
I then Stopped Ser, MySQL and restarted SER.
It takes a long time then I get these line in the error log.. and ser fails to start.
Aug 9 22:36:08 ns2 ser[43517]: new_connection(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Aug 9 22:36:08 ns2 ser[43517]: db_init(): Could not create a connection Aug 9 22:36:08 ns2 ser[43517]: ERROR: group_db_ver: unable to open database connection Aug 9 22:36:08 ns2 ser[43517]: group:mod_init(): Error while querying table version Aug 9 22:36:08 ns2 ser[43517]: init_mod(): Error while initializing module group
Then I start the old local mySQL server again and restart ser and it springs to life. Why is that? I am not pointing to the local mysql server anymore... Have I missed something in the configuration?
Even more strange, it seems that all authentication and accounting gets queried in the new server as I see can see the data in the new server alse sees the client connection from SER.
Any one who can help with an explanation on this behaviour?
Kind regards Roger
The error message is telling you what's wrong.
Aug 9 22:36:08 ns2 ser[43517]: group:mod_init(): Error while querying table version
You don't have 'group' in your modparam for 'db_url'
-Evan
Roger Lewau wrote:
Just noted there was a type in fifo_db_url. I corrected this but it had the same result anyway...
Från: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] För Roger Lewau Skickat: den 9 augusti 2006 22:52 Till: serusers@iptel.org Ämne: [Serusers] Trying to use a remote mysql....
I have been running SER quite successfully for a long time now. So tonight I dared to replicate the database to a remote server and changed the ser.cfg as follows.
This is the two lines I changed in my ser.cfg filen
#fifo_db_url="mysql://ser:heslo@localhost/ser" fifo_db_url="mysql://ser:heslo@192.168.12.140/ser"
#modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url", "mysql://ser:heslo@localhost/ser") modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url", "mysql://ser:heslo@192.168.121.140/ser")
Also updated serctl as follows:
SQL_HOST=192.168.121.140
I then Stopped Ser, MySQL and restarted SER.
It takes a long time then I get these line in the error log.. and ser fails to start.
Aug 9 22:36:08 ns2 ser[43517]: new_connection(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Aug 9 22:36:08 ns2 ser[43517]: db_init(): Could not create a connection Aug 9 22:36:08 ns2 ser[43517]: ERROR: group_db_ver: unable to open database connection Aug 9 22:36:08 ns2 ser[43517]: group:mod_init(): Error while querying table version Aug 9 22:36:08 ns2 ser[43517]: init_mod(): Error while initializing module group
Then I start the old local mySQL server again and restart ser and it springs to life. Why is that? I am not pointing to the local mysql server anymore... Have I missed something in the configuration?
Even more strange, it seems that all authentication and accounting gets queried in the new server as I see can see the data in the new server alse sees the client connection from SER.
Any one who can help with an explanation on this behaviour?
Kind regards Roger
Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Evan Borgström -
Roger Lewau