sr-users March 2012

sr-users@lists.kamailio.org

87 participants
163 discussions

msilo is failing to in db connection...
by Krishna Kurapati 06 Mar '12

06 Mar '12

Hi all, I am trying to use msilo module from modules_k. Unfortunately it if failing during DB initialization. Other modules are initializing fine. I am using Kamailio 3.2.2. Not sure why the connection is not found. I tried to increase the MAX mysql connections to 250. I see the same error after I increase the connections. The config file is pretty standard: loadmodule "msilo.so" modparam("msilo", "add_date", 0); modparam("msilo", "db_url", DBURL); # The DBURL works for other modules... Here is the Log output: 0(14115) DEBUG: <core> [cfg.y:1684]: loading module msilo.so 0(14115) DEBUG: <core> [sr_module.c:557]: load_module: trying to load </usr/local/kamailio-3.2.2/lib64/kamailio/modules_k/msilo.so> ..... 0(14117) DEBUG: <core> [sr_module.c:928]: DEBUG: init_mod: msilo 0(14117) DEBUG: <core> [sr_module.c:667]: find_export_record: found <db_bind_api> in module db_mysql [/usr/local/kamailio-3.2.2/lib64/kamailio/modules/db_mysql.so] 0(14117) DEBUG: <core> [db.c:212]: using db bind api for db_mysql 0(14117) DEBUG: <core> [db.c:299]: connection 0x7fc20d1ace60 not found in pool 0(14117) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/openser 0(14117) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES) 0(14117) ERROR: <core> [db.c:303]: could not add connection to the pool 0(14117) ERROR: msilo [msilo.c:319]: failed to connect to the database 0(14117) ERROR: <core> [sr_module.c:932]: init_mod(): Error while initializing module msilo (/usr/local/kamailio-3.2.2/lib64/kamailio/modules_k/msilo.so) ERROR: error while initializing modules Any help? Thanks

3 6

Re: [SR-Users] msilo is failing to in db connection...
by Daniel-Constantine Mierla 06 Mar '12

06 Mar '12

fwd to the list - reply all failed in first place ... > Hello, > > the module connects in mod init to check the table version, otherwise it does not do any message storage related operations with the database. It should work fine at runtime even if mod init does not connect to db. > > But it is strange of mod init fails but child init goes on. Do you have a firewall with policies related to active connections (rate of new connections)? > > Cheers, > Daniel > > On Sat, Mar 3, 2012 at 6:16 PM, Krishna Kurapati <kkurapat(a)gmail.com> wrote: > Further investigation into the issue revealed that the db_conn in the module_init is failing... When I commented out the code, > the module is initialized ok. Not sure if this is will fine. > > #if 0 > db_con = msilo_dbf.init(&ms_db_url); > if (!db_con) > { > LM_ERR("failed to connect to the database\n"); > return -1; > } > > if(db_check_table_version(&msilo_dbf, db_con, &ms_db_table, S_TABLE_VERSION) < 0) { > LM_ERR("error during table version check.\n"); > return -1; > } > if(db_con) > msilo_dbf.close(db_con); > db_con = NULL; > #endif > > Is the module not suppose to connect to database in the module init? > > Thanks > > > On Sat, Mar 3, 2012 at 10:13 AM, Krishna Kurapati <kkurapat(a)gmail.com> wrote: > Hi, > > Thanks for the response. I looked at the DBURL and it looked just fine. I wanted to test and see if the module is reading the config > param or not, I deliberately changed it to > > modparam("msilo", "db_url", "mysql://root:xxxxx@localhost/openser"); > > When I ran it, the logs shows the user as 'openser' not the 'root' that I gave in config param. May be somewhere in the code, > db_url is being overwritten by DEFAULT_DB_URL. > > 0(28806) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/openser > 0(28806) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES) > 0(28806) ERROR: <core> [db.c:312]: could not add connection to the pool 0(28806) ERROR: msilo [msilo.c:365]: failed to connect to the database > > Thanks > Krish Kura > > On Sat, Mar 3, 2012 at 5:14 AM, Daniel-Constantin Mierla <miconda(a)gmail.com> wrote: > Hello, > > the error says the username, password or IP address are invalid to connect to mysql -- access denied. There does not seem like being other connections using same db_url, check for typos in db_url parameter. > > Cheers, > Daniel > > > > On 3/3/12 12:39 AM, Krishna Kurapati wrote: >> Hi all, >> >> I am trying to use msilo module from modules_k. Unfortunately it if failing during DB initialization. >> Other modules are initializing fine. I am using Kamailio 3.2.2. >> >> Not sure why the connection is not found. I tried to increase the MAX mysql connections to 250. I see the >> same error after I increase the connections. >> >> The config file is pretty standard: >> >> loadmodule "msilo.so" >> modparam("msilo", "add_date", 0); >> modparam("msilo", "db_url", DBURL); # The DBURL works for other modules... >> >> Here is the Log output: >> >> 0(14115) DEBUG: <core> [cfg.y:1684]: loading module msilo.so >> 0(14115) DEBUG: <core> [sr_module.c:557]: load_module: trying to load </usr/local/kamailio-3.2.2/lib64/kamailio/modules_k/msilo.so> >> >> ..... >> >> 0(14117) DEBUG: <core> [sr_module.c:928]: DEBUG: init_mod: msilo >> 0(14117) DEBUG: <core> [sr_module.c:667]: find_export_record: found <db_bind_api> in module db_mysql [/usr/local/kamailio-3.2.2/lib64/kamailio/modules/db_mysql.so] >> 0(14117) DEBUG: <core> [db.c:212]: using db bind api for db_mysql >> 0(14117) DEBUG: <core> [db.c:299]: connection 0x7fc20d1ace60 not found in pool >> 0(14117) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/openser >> 0(14117) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'openser'@'localhost' (using password: YES) >> 0(14117) ERROR: <core> [db.c:303]: could not add connection to the pool 0(14117) ERROR: msilo [msilo.c:319]: failed to connect to the database >> 0(14117) ERROR: <core> [sr_module.c:932]: init_mod(): Error while initializing module msilo (/usr/local/kamailio-3.2.2/lib64/kamailio/modules_k/msilo.so) >> ERROR: error while initializing modules >> >> Any help? >> >> Thanks >> >> >> >> _______________________________________________ >> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list >> sr-users(a)lists.sip-router.org >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > -- > Daniel-Constantin Mierla -- http://www.asipto.com > http://linkedin.com/in/miconda -- http://twitter.com/miconda > > > > > > -- > Daniel-Constantin Mierla > http://www.asipto.com

1 0

disptacher failover
by Klaus Darilion 06 Mar '12

06 Mar '12

Hi! Imagine a dispatcher list with 3 entries. I wonder what happens if one of the targets fail. Is the traffic moved evenly to the remaining 2 nodes or is the whole traffic of the broken node moved to one of the nodes? I took a quick look at the code and it seems that the whole traffic is moved to the next node in the list (i=i+1): while (ds_skip_dst(idx->dlist[i].flags)) { if(ds_use_default!=0 && idx->nr!=1) i = (i+1)%(idx->nr-1); else i = (i+1)%idx->nr; Is my assumption correct? Thanks Klaus

2 1

Question regarding... LCR Module
by kamailio Padawan 06 Mar '12

06 Mar '12

Hello, I have attempted to ask questions on IRC with no response. I really appreciate any help from anybody! I am using Kamailio 3.2.2. I am unable to get anything loaded in $avp(i:709). I am attempting to route between 2 media handling asterisk boxes. I am trying to load balance between them. I have the following entries in my tables... *lcr_gw* * id,lcr_id,gw_name,ip_addr,hostname,port,params,uri_scheme,transport,strip,prefix,tag,flags,defunct * 1, 1, media1, *1.1.3.123*, *1.1.3.123*, 5060, , 1, 1, 0, 0, 0 2, 1, media2, *1.1.4.123*, *1.1.4.123*, 5060, , 1, 1, 0, 0, 0 *lcr_rule* *id,lcr_id,prefix,from_uri,stopper,enabled* * * 1, 1, *[1][0-9][0-9][0-9][0-9]*, 0, 1 *lcr_rule_target* *id,lcr_id,rule_id,gw_id,priority,weight* 1, 1, 1, *1*, 1, 5 2, 1, 1, *2*, 1, 5 I was under the impression that, if my from URI was 15555, and I have 2 gateways, that I can call *load_gws("1","$fU")* and return the gateways that match the *from_uri* rule of 15555 , then look the rule_id up in * lcr_rule_target* and return the *2* gws gw_id[1] and gw_id[2], which are the 2 entries in the* lcr_gw* table..... and it would be weighted 5 and 5 so that it would load balance. Right now..... I get nothing loaded in $avp(i:709). I thought this would show the IP/Hostname of the media1 or media2 gws. The variable is null far before the call to *load_gws*. I'm loading it at the top in a modparam like *modparam("lcr", "gw_uri_avp", "$avp(i:709)")* *modparam("lcr", "ruri_user_avp", "$avp(i:500)")* When i get the result of calling the *load_gws*() function into a variable. The variable is *2*. Is that the number of rows returned? Why is that parameter [avp(i:709)] always empty? How can i get next_gw() to complete and not fail? Thank you so much.... I am very new to Kamailio and am very interested... Kamailio Padawan Learner

2 1

TOS value in configuration
by Olle E. Johansson 04 Mar '12

04 Mar '12

I've set tos=IPTOS_RELIABILITY in my configuration, which follows https://www.kamailio.org/wiki/cookbooks/3.2.x/core#tos which has the following examples: tos=IPTOS_LOWDELAY tos=0x10 tos=IPTOS_RELIABILITY but I get a configuration error: 0(45338) : <core> [cfg.y:3501]: parse error in config file /usr/local/etc/kamailio/kam-global.inc, line 29, column 5-21: syntax error 0(45338) : <core> [cfg.y:3501]: parse error in config file /usr/local/etc/kamailio/kam-global.inc, line 29, column 5-21: number expected Has this option been deprecated or is it a small bug? /O

2 1

Facebook page for Kamailio
by Olle E. Johansson 04 Mar '12

04 Mar '12

Just to make sure we're in the flow, I've started a Facebook page for Kamailio. http://www.facebook.com/kamailio Feel free to like it if you're a Facebook user. There's also a Google+ page. If you have news to share, you're welcome to add it on these pages. /O

2 1

Building Up a Kamailio Server
by Faisal Rehman 03 Mar '12

03 Mar '12

Hi Everyone, I am totally new to Kamailio & going to build up Kamailio server as an XMPP server with the following wanted functionalities: -Have XMPP client to register to my kamailio server - The XMPP clients should all be able to see each others presence - The XMPP clients should be able to IM other XMPP clients - The registered sip client will be able to just dial any other sip client. No need for any gateway or trunk for now I have a good previous background with SIP but its my first time to work with XMPP & Kamailio & that's why I am in need of a bit help & assistance. I have installed Kamailio on my CentOS box & now going to start to configure it in order to complete the above requirements, so any links or any refferals will be highly appreciated. Regards, Faisal Rehman

2 5

XMPP module not passing subscribes coming from xmpp side
by Dan-Cristian Bogos 02 Mar '12

02 Mar '12

Hey Guys, I was wondering if anyone having experience with using xmpp module as presence gateway between SIP and XMPP. I started evaluating it and till now got some weird results, not sure if it is just my setup which does not match the one widely used or the module is incomplete. Regarding my setup, I use OpenFIRE 3.7.1 on one side and Kamailio 3.2.0 out of debian packages on the other. The issue I got right now is that the subscribe coming from XMPP side produces no action/reply on SIP side. Bellow you can see the packet coming from OpenFIRE: # T 2012/03/02 09:49:57.743750 127.0.0.1:5275 -> 127.0.0.1:49965 [AP] <presence id="4h8F6-19" to="dan4(a)gw.mydomain.com" type="subscribe" from="dan(a)mydomain.com"><c xmlns="http://jabber.org/protocol/caps" ext="voice-v1 video-v1 camera-v1 " hash="sha-1" node="http://jitsi.org" ver="ohjz8WKq0ZQRiNWRNcapX4BBHLk="/></presence> """ Anyone here got this working somehow? Ta, DanB

2 1

iOS push notification using Kamailio
by Krishna Kurapati 02 Mar '12

02 Mar '12

Hi, I have been looking at the usrloc module's source code to see how the uuid that is sent in +sip.instance parameter in the Contact header. Apparently, the module ensures that only one contact per uuid exists. However the uuid is not stored in the database. The reason I need the uuid in the database is to access it when the iOS device is offline inorder to send a push notification. I am using pjsip which supports sending the uuid of the device ( w/ rfc 5626 support) in the REGISTER message. Has anyone implemented push notification using this or other methods using Kamailio? Thanks Krish Kura

2 1

automatically switch to TCP
by Klaus Darilion 01 Mar '12

01 Mar '12

Hi! Is there a feature somewhere (core, tm) to automatically switch from UDP to TCP? It may be useful with bodies > 64K. regards Klaus

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users March 2012