Re: SV: [Serusers] Trying to use a remote mysql....

Just noted there was a type in fifo_db_url. I corrected this but it had the same result anyway... _____ Från: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] För Roger Lewau Skickat: den 9 augusti 2006 22:52 Till: serusers(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers