[SR-Users] prefix_route and db_cluster not working
Daniel-Constantin Mierla
miconda at gmail.com
Wed Oct 12 10:33:19 CEST 2016
Hello,
On 11/10/16 15:56, Martin Nyström wrote:
>
> Hi Daniel,
>
>
>
> So the solution is basically to wait for the DB APIv1 implementation
> in prefix_route?
>
yes. But I am not using the module and I am not aware of anyone working
on it, so not sure if this is going to happen very soon.
As alternative, it might be possible that you can replace it with mtree
+ calling route(NAME) after the mtree match in config.
Cheers,
Daniel
>
>
>
>
>
>
>
>
> Martin *Nyström* | Connectel
>
> *Direct: *+46 10 180 00 07
>
> *Support:* +46 771 12 12 10
>
> *Web:* www.connectel.se <http://www.connectel.se/>
>
>
>
> *From: *Daniel-Constantin Mierla <miconda at gmail.com>
> *Reply-To: *"miconda at gmail.com" <miconda at gmail.com>
> *Date: *Monday 10 October 2016 at 13:26
> *To: *"Kamailio (SER) - Users Mailing List"
> <sr-users at lists.sip-router.org>, Martin Nyström
> <martin.nystrom at connectel.se>
> *Subject: *Re: [SR-Users] prefix_route and db_cluster not working
>
>
>
> Hello,
>
> the prefix_route module was written by SER guys, when Kamailio and SER
> were split projects, and it uses what we refer as DB APIv2 (specific
> for ser project), while db_cluster implements DB APIv1 (specific for
> kamailio project).
>
> From my point of view, it will be easier to add support for DB APIv1
> in prefix_route module than implementing DB APIv2 in db_cluster. I
> think there very few modules implementing DB APIv2 at this moment
> (maybe around 5) and perhaps they should get support for DB APIv1.
>
> Cheers,
> Daniel
>
>
>
> On 10/10/16 10:05, Martin Nyström wrote:
>
> Hi,
>
>
>
> I have an issue when I am unable to get prefix_route to work
> together with db_cluster. If I set the db_url manually it works
> great, pointing it to a specific database. However we need the
> redundancy for this module.
>
>
>
> Dispatcher uses the same cluster without any issues.
>
>
>
> The following are my configuration sets:
>
>
>
> # DB CLUSTER (db_cluster.inc)
>
> loadmodule *"db_cluster.so"*
>
>
>
> modparam(*"db_cluster"*, *"connection"*,
> *"KAMDB01=>mysql://kamailio:password123@192.168.55.10/kamailio
> <mailto:mysql://kamailio:password123@192.168.55.10/kamailio>"*)
>
> modparam(*"db_cluster"*, *"connection"*,
> *"KAMDB02=>mysql://kamailio:password123@192.168.55.11/kamailio
> <mailto:mysql://kamailio:password123@192.168.55.11/kamailio>"*)
>
>
>
> modparam(*"db_cluster"*, *"cluster"*,
> *"AccCluster=>KAMDB02=9s9s;KAMDB01=4s4s"*)
>
> modparam(*"db_cluster"*, *"cluster"*,
> *"Settings=>KAMDB02=9s9s;KAMDB01=4s4s"*)
>
>
>
> # KAMAILIO.CFG (kamailio.cfg)
>
> # PREFIX ROUTE MODPARAM
>
>
>
> loadmodule "prefix_route.so"
>
> include_file "db_cluster.inc"
>
> modparam(*"prefix_route"*, *"db_url"*, *"cluster://Settings"*)
>
> modparam(*"prefix_route"*, *"db_table"*, *"prefix_route"*)
>
> modparam(*"prefix_route"*, *"exit"*, 1)
>
>
>
>
>
> Syslog output:
>
>
>
> Oct10 09:53:03 kamailio01 /usr/local/sbin/kamailio[5225]: ERROR:
> <core> [db_cmd.c:122]: db_cmd(): DB driver cluster does not
> implement mandatory db_cmd function
>
> Oct10 09:53:03 kamailio01 /usr/local/sbin/kamailio[5225]: ERROR:
> <core> [db_cmd.c:168]: db_cmd(): db_cmd: Cannot create db_cmd
> structure
>
> Oct10 09:53:03 kamailio01 /usr/local/sbin/kamailio[5225]: ERROR:
> prefix_route [prefix_route.c:126]: pr_db_load(): prefix_route:
> db_load(): db_cmd() failed
>
> Oct10 09:53:03 kamailio01 /usr/local/sbin/kamailio[5225]: :
> prefix_route [prefix_route.c:214]: mod_init(): prefix_route:
> db_load() failed
>
> Oct10 09:53:03 kamailio01 /usr/local/sbin/kamailio[5225]: ERROR:
> <core> [sr_module.c:974]: init_mod(): Error *while*initializing
> module prefix_route (usr/local/lib64/kamailio/modules/prefix_route.so)
>
> Oct10 09:53:03 kamailio01 /usr/local/sbin/kamailio[5225]: INFO:
> <core> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
>
>
>
>
>
> Ubuntu 14.04LTS
>
> version: kamailio 4.3.6 (x86_64/linux) 105a17
>
> flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS,
> USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM,
> SHM_MMAP, PKG_MALLOC, DBG_QM_MALLOC, USE_FUTEX,
> FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER,
> USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES
>
> ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN
> 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
>
> poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
>
> id: 105a17
>
> compiled on 10:06:12 Oct 4 2016 with gcc 4.8.4
>
>
>
>
>
> Thank you.
>
>
>
>
> _______________________________________________
>
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>
> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
> --
> Daniel-Constantin Mierla
> http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda
> Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Oct 24-26, 2016 - http://www.asipto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20161012/318ae15a/attachment.html>
More information about the sr-users
mailing list