<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thank you very much for taking the time to respond. This was exactly
what was causing me problems.<br>
<br>
<div class="moz-cite-prefix">On 12/23/2015 4:32 PM, Rik Broers
wrote:<br>
</div>
<blockquote cite="mid:E605C27E-E83E-497A-A98E-03A2C63DF56B@motto.nl"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<div>Make sure you are using innodb for all tables, by default
opensips creates myisam. This is specially true for galera mysql
clusters.</div>
<div id="AppleMailSignature"><br>
Regards, <br>
<p class="MsoNormal" style="margin: 0cm 0cm 12pt;"><span
style="background-color: rgba(255, 255, 255, 0);">Vriendelijke
groet,<br>
<br>
<b>Rik Broers</b><br>
Voice Engineer</span></p>
<div>
<div class="MsoNormal" style="margin: 0cm 0cm 0.0001pt;">
<hr align="left" noshade="noshade" size="1" width="100%">
</div>
</div>
<p class="MsoNormal" style="margin: 0cm 0cm 0.0001pt;"><o:p
style="background-color: rgba(255, 255, 255, 0);"> </o:p></p>
</div>
<div><br>
On 23 dec. 2015, at 20:13, Tim King <<a
moz-do-not-send="true" href="mailto:tim@triton.net"><a class="moz-txt-link-abbreviated" href="mailto:tim@triton.net">tim@triton.net</a></a>>
wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>I have two OpenSIPs servers running with a shared database
on a MySQL Cluster.<br>
<br>
The problem I am facing is there seems to be something stored
in the database that makes it only work with the server it was
created on. If I migrate the service to the node in the
cluster that was not used to create the database I find the
following error and opensips will not start.<br>
<br>
openSIPs-2 /usr/sbin/opensips[16028]:
ERROR:core:db_check_table_version: invalid version 0 for table
dialog found, expected 7<br>
<br>
If I run <i>opensipsdbctl reinit</i> on the cluster node that
did not originally create the database I can that run opensips
on that node but not the other.<br>
<br>
Can someone please tell me what setting I may be missing that
allows opensips to share the database. I have followed several
tutorials and they all mention using a shared database cluster
but I have not found any setting that will correct this
behavior.<br>
<br>
version: opensips 1.7.2-tls (x86_64/linux)<br>
flags: STATS: Off, USE_IPV6, USE_TCP, USE_TLS, DISABLE_NAGLE,
USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC,
FAST_LOCK-ADAPTIVE_WAIT<br>
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535<br>
poll method support: poll, epoll_lt, epoll_et, sigio_rt,
select.<br>
svnrevision: unknown<br>
@(#) $Id: main.c 8537 2011-11-08 17:02:11Z bogdan_iancu $<br>
main.c compiled on 09:32:43 Apr 19 2012 with gcc 4.4.6<br>
<br>
</div>
</blockquote>
<blockquote type="cite">
<div><tim.vcf></div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>Users mailing list</span><br>
<span><a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a></span><br>
<span><a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></span><br>
</div>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>