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(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