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