<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Check the archives. I've answered this a couple of times already. <br>
<br>
mysql 5.0.X has modified the default behaviour of how the socket
timeout works. By default, it times out connections after a period of
time. There was a patch after about 5.0.12 to allow people to modify
this behaviour, but the patch didn't work until 5.0.19. <br>
<br>
In order to get SER 0.9.X to work with 5.0.19 and above and reconnect
after a timed out socket, you need to modify the my_con.c in
$SER-SRC/modules/mysql and recompile the mysql module. <br>
<br>
I've attached a modified my_con.c file that has the correct options to
utilise the patched mysql code. It will fix the reconnect issues
(allowing SER to reconnect once the socket has timed out). <br>
<br>
N. <br>
<br>
<br>
Andrey Kuprianov wrote:
<blockquote
cite="mid:ab5f5bda0705240051p389b91aem3cf9e05d703b1c52@mail.gmail.com"
type="cite">
<pre wrap="">Im also having this problem. I even upgraded SER to 0.9.7-pre8, but
still the same.
I tend to think, though, that this is a MySQL version problem. I
installed MySQL 5.0 from Ubuntu's packages. I think reinstalling MySQL
or just upgrading it (or maybe downgrading to 4.1), should do the
trick.
On 5/24/07, Nhadie <a class="moz-txt-link-rfc2396E" href="mailto:nhadie@tbgi.net.ph"><nhadie@tbgi.net.ph></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi All
How can i make sure that when mysql dies, ser will not allow calls anymore?
Because i had a problem, when mysql died, ser still continued to allow
calls and i was not able to account it.
How can i resolve this. Thank You in Advance.
Regards
Ronald
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<br>
</body>
</html>