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

[Evan Borgström]

	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 at lists.iptel.org
> [mailto:serusers-bounces at lists.iptel.org] För Roger Lewau
> Skickat: den 9 augusti 2006 22:52
> Till: serusers at 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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers