Thanks for the idea Jeff.<br><br>
<div class="gmail_quote">On Tue, Dec 14, 2010 at 6:27 PM, Jeff Pyle <span dir="ltr"><<a href="mailto:jpyle@fidelityvoice.com">jpyle@fidelityvoice.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">I use Opensips with NDBCLUSTER, although not with db_virtual. Seems to<br>work okay with db_mysql. To keep things simple, each of my Opensips<br>
machines (VMs, really) has a mysqld instance whose only role is to be a<br>front-end to the cluster. I've tried it with CentOS RPMs, Debian (stable)<br>packages, and 7.1.x source from the MySQL site. All okay.<br><br>
Sorry, no further information on the virtual portion.<br><br><br>- Jeff<br><br><br>On 12/14/10 12:35 PM, "osiris123d" <<a href="mailto:duane.larson@gmail.com">duane.larson@gmail.com</a>> wrote:<br><br>><br>
>I am trying to get OpenSIPS Virtual_DB module to work with a MySQL Cluster<br>>that I have set up.<br>><br>>Instead of the database tables being the usual MyISAM I set them up to be<br>>NDBCLUSTER.<br>><br>
>Within the OpenSIPS config I have<br>><br>># ----- db_virtual params -----<br>>modparam("db_virtual", "db_urls", "define set1 ROUND")<br>>modparam("db_virtual", "db_urls",<br>
>"mysql://********:******@173.***.***.219/opensips")<br>>modparam("db_virtual", "db_urls",<br>>"mysql://********:******@173.***.***.218/opensips")<br>><br>><br>>To test I shut down the database on the 173.***.***.218 server and<br>
>OpenSIPS<br>>went down. When I try to restart OpenSIPS I see the following in the<br>>syslog<br>><br>>Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:<br>>ERROR:db_mysql:db_mysql_connect: driver error(2003): Can't connect to<br>
>MySQL<br>>server on '173.***.***.218' (111)<br>>Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:<br>>ERROR:db_mysql:db_mysql_new_connection: initial connect failed<br>>Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:<br>
>ERROR:core:db_do_init: could not add connection to the pool<br>>Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:<br>>ERROR:db_virtual:db_virtual_init: cant init db<br>>mysql://****:*****@173.***.***.218/opensips<br>
>Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:<br>>ERROR:db_mysql:db_mysql_submit_query: driver error: Got error 157 'Unknown<br>>error code' from NDBCLUSTER<br>>Dec 14 11:17:20 Proxy01 /usr/local/sbin/opensips[3843]:<br>
>ERROR:core:db_do_query: error while submitting query<br>>Dec 14 11:17:20 Proxy01 kernel: [235305.342266] opensips[3843]: segfault<br>>at<br>>20 ip 00000000004f4e03 sp 00007fffb3965840 error 4 in<br>>opensips[400000+14d000]<br>
><br>><br>><br>>Looks like it dumped the core and the core says<br>><br>>(gdb) backtrace<br>>#0 0x00000000004f4e03 in db_table_version (dbf=0x7ffff8d6e470,<br>>connection=0x8175e0, table=0x7f3e124e9b40) at db/db.c:359<br>
>#1 0x00000000004f51d1 in db_check_table_version (dbf=0x0, dbh=0x0,<br>>table=0x7f3e124e9b40, version=7) at db/db.c:398<br>>#2 0x00007f3e122e585e in mod_init () at uri_mod.c:265<br>>#3 0x0000000000493514 in init_mod (m=0x798348) at sr_module.c:457<br>
>#4 0x00000000004934ac in init_mod (m=0x798418) at sr_module.c:452<br>>#5 0x00000000004934ac in init_mod (m=0x7984e8) at sr_module.c:452<br>>#6 0x00000000004934ac in init_mod (m=0x7985b8) at sr_module.c:452<br>
>#7 0x00000000004934ac in init_mod (m=0x798688) at sr_module.c:452<br>>#8 0x00000000004934ac in init_mod (m=0x798758) at sr_module.c:452<br>>#9 0x00000000004934ac in init_mod (m=0x798828) at sr_module.c:452<br>
>#10 0x00000000004934ac in init_mod (m=0x7988f8) at sr_module.c:452<br>>#11 0x00000000004934ac in init_mod (m=0x7989c8) at sr_module.c:452<br>>#12 0x00000000004934ac in init_mod (m=0x798a98) at sr_module.c:452<br>
>#13 0x00000000004934ac in init_mod (m=0x798b68) at sr_module.c:452<br>>#14 0x00000000004934ac in init_mod (m=0x798c38) at sr_module.c:452<br>>#15 0x00000000004934ac in init_mod (m=0x798d08) at sr_module.c:452<br>
>#16 0x00000000004934ac in init_mod (m=0x798dd8) at sr_module.c:452<br>>#17 0x00000000004934ac in init_mod (m=0x798ea8) at sr_module.c:452<br>>#18 0x00000000004934ac in init_mod (m=0x798f78) at sr_module.c:452<br>
>#19 0x00000000004934ac in init_mod (m=0x799048) at sr_module.c:452<br>>#20 0x00000000004934ac in init_mod (m=0x799118) at sr_module.c:452<br>>#21 0x00000000004934ac in init_mod (m=0x7991e8) at sr_module.c:452<br>
>#22 0x00000000004934ac in init_mod (m=0x799528) at sr_module.c:452<br>>#23 0x00000000004934ac in init_mod (m=0x7996c8) at sr_module.c:452<br>>#24 0x00000000004934ac in init_mod (m=0x799798) at sr_module.c:452<br>
>#25 0x00000000004934ac in init_mod (m=0x799868) at sr_module.c:452<br>>#26 0x00000000004934ac in init_mod (m=0x799a70) at sr_module.c:452<br>>#27 0x00000000004934ac in init_mod (m=0x799b40) at sr_module.c:452<br>
>#28 0x00000000004934ac in init_mod (m=0x799c10) at sr_module.c:452<br>>#29 0x00000000004934ac in init_mod (m=0x799ce0) at sr_module.c:452<br>>#30 0x00000000004934ac in init_mod (m=0x799db0) at sr_module.c:452<br>
>#31 0x00000000004934ac in init_mod (m=0x799e80) at sr_module.c:452<br>>#32 0x00000000004934ac in init_mod (m=0x799f50) at sr_module.c:452<br>>#33 0x00000000004934ac in init_mod (m=0x79a020) at sr_module.c:452<br>
>#34 0x000000000042c4f0 in main (argc=<value optimized out>, argv=<value<br>>optimized out>) at main.c:1351<br>><br>><br>>Can you not use NDBCluster with OpenSIPS???<br>>--<br>>View this message in context:<br>
><a href="http://opensips-open-sip-server.1449251.n2.nabble.com/Virtual-DB-issue-wit" target="_blank">http://opensips-open-sip-server.1449251.n2.nabble.com/Virtual-DB-issue-wit</a><br>>h-NDBClUSTER-tp5834548p5834548.html<br>
>Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br>><br>>_______________________________________________<br>>Users mailing list<br>><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br><br><br>_______________________________________________<br>Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>