I am afraid I don't. Looks like I must have deleted it.<br><br>
<div class="gmail_quote">On Wed, Dec 22, 2010 at 4:02 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Hi Duane,<br><br>Do you still have the core file ? I would be interested in getting some info from there.<br>
<br>Regards,<br>Bogdan
<div>
<div></div>
<div class="h5"><br><br>osiris123d wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">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") 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 OpenSIPS<br>
went down. When I try to restart OpenSIPS I see the following in the 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 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 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></blockquote><br><br>-- <br></div></div><font color="#888888">Bogdan-Andrei Iancu<br>OpenSIPS Event - expo, conf, social, bootcamp<br>2 - 4 February 2011, ITExpo, Miami, USA<br><a href="http://www.voice-system.ro/" target="_blank">www.voice-system.ro</a></font>
<div>
<div></div>
<div class="h5"><br><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>