<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=856390921-09082006><FONT face=Arial
color=#0000ff size=2>Just noted there was a type in fifo_db_url. I corrected
this but it had the same result anyway... </FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=sv dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Från:</B> serusers-bounces@lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] <B>För </B>Roger
Lewau<BR><B>Skickat:</B> den 9 augusti 2006 22:52<BR><B>Till:</B>
serusers@iptel.org<BR><B>Ämne:</B> [Serusers] Trying to use a remote
mysql....<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>This is the two
lines I changed in my ser.cfg filen</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2>#fifo_db_url="mysql://ser:heslo@localhost/ser" </FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2>fifo_db_url="mysql://ser:heslo@192.168.12.140/ser" </FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006></SPAN><SPAN
class=448553720-09082006></SPAN><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2>#modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url",
"mysql://ser:heslo@localhost/ser") </FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2>modparam("auth_db|permissions|uri_db|usrloc|acc", "db_url",
"mysql://ser:heslo@192.168.121.140/ser")
</FONT></SPAN></FONT></SPAN><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN></DIV></DIV>
<DIV><SPAN class=448553720-09082006></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>Also updated serctl
as follows:</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2>SQL_HOST=192.168.121.140<BR></FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>I then Stopped Ser,
MySQL and restarted SER.</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>It takes a long time
then I get these line in the error log.. and ser fails to
start.</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>Aug 9 22:36:08
ns2 ser[43517]: new_connection(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)<BR>Aug 9 22:36:08 ns2 ser[43517]: db_init():
Could not create a connection<BR>Aug 9 22:36:08 ns2 ser[43517]: ERROR:
group_db_ver: unable to open database connection<BR>Aug 9 22:36:08 ns2
ser[43517]: group:mod_init(): Error while querying table version<BR>Aug 9
22:36:08 ns2 ser[43517]: init_mod(): Error while initializing module
group<BR></FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>Then I start the old
local mySQL server again and restart ser and it springs to life.
</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>Why is that? I am
not pointing to the local mysql server anymore... Have I missed something in the
configuration?</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>Any one who can help
with an explanation on this behaviour?</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006></SPAN><SPAN class=448553720-09082006><FONT
face=Arial size=2> </DIV></FONT></SPAN>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial size=2>Kind
regards</FONT></SPAN></DIV>
<DIV><SPAN class=448553720-09082006><FONT face=Arial
size=2>Roger</FONT></SPAN></DIV></BODY></HTML>