[OpenSIPS-Users] Virtual_DB issue with NDBClUSTER

[Duane Larson]

Thanks for the idea Jeff.

On Tue, Dec 14, 2010 at 6:27 PM, Jeff Pyle <jpyle at fidelityvoice.com> 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" <duane.larson at gmail.com> 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
> >Users at lists.opensips.org
> >http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20101214/97f721f6/attachment.htm>