We are using kamailio 4.2.0 with auth_db enabled and connected to a MySQL server. Occasionally, in the middle of the night when there is no activity we get the following errors out of the blue (the last three lines are repeated indefinitely). According to the MySQL site <http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html>, this can be caused by a connect timeout that is too short (We verified that Aborted_connects is steadily rising). The kamailio server is right next to the database server so there is no network latency.
We increased the db_mysql timeout_interval parameter, but we still see MySQL’s Aborted_connects counter incrementing. So it’s like kamailio is still timing out on connection attempts. Ideas?
Thanks.
Oct 1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Host ‘X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct 1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
...
Running 4.3.x (both .1 and .2) I have seen it happening twice sofar that
dialogs (the module) will not end, resulting in to calls failing due to call
limits based on active dialogs. Accounting logged a BYE for all these calls.
kamcmd tm.stats shows an increasing number of current/waiting transactions (as
grphed in attachment).
Has anyone seen this problem?
Hello,
Sorry to bother and if I sound like a newb thats because I am kind of
new (but im trying =) )
I am having some issues getting started using LCR and was wondering if
anyone could point me in the right direction and/or let me know what I
am doing wrong. I began setting up the other day using kamailio
(4.4.0-dev5) from git (maybe I picked the wrong version?) and am
struggling to get lcr to work properly. So far I have been able to get
the module to load, added the route to the config and have added some
LCR values. Inbound calling is working perfectly to a registered device
which is great so far.
This is my config for the LCR:
http://pastebin.com/LUF0Pgr1
I have the following values in my database for LCR:
http://pastebin.com/bDpQug0J
I was not sure if dumping all the text in the email would be appropriate
if needed please let me know to resend with the configs in the email.
Whats strange to me is that even with the xlog I do not get any messages
to syslog at all, I have defined WITH_DEBUG, debug level at 3, and log
facility set to LOG_LOCAL0
(Sorry if I'm bringing up multiple issues)
Anyways back on point, I'm wondering if this is related to the avp's
listed, I am not sure what the avps referenced are supposed to
represent, when I try to dump all the avps I get a empty list, and it is
querying the usr_preference table for these. Is there something I need
to add within this table, or is there perhaps something wrong with my
configuration?
[root@localhost kamailio]# kamctl avp list
database engine 'MYSQL' loaded
Control engine 'FIFO' loaded
Query: SELECT uuid,username,domain,attribute,type,value FROM
usr_preferences ;
Dumping AVPs
Thank you!
Hi Everyone,
We are using Kamailio 4.2.0 with TLS. It’s setup so multiple phones can register to the same account and they all ring together.
It always works great unless one of the phones is on a slower Internet connection. Occasionally that phone will start ringing after another phone has already picked up the call. The problem is that the INVITE to the slow phone is not followed by a CANCEL. So the phone keeps on ringing for a long time.
When there is no problem, the logs on the phone show:
Receive: INVITE
Send: 180 Ringing
Received: CANCEL
Send: 200 Ok
When the phone keeps ringing:
Delay: up to several seconds
Receive: INVITE
Send: 180 Ringing
The problem never seems to happen if I wait until all of the phones have received the INVITE. So is the late 180 response not getting handled by the right session?
Any ideas on how to track this down?
On 07.10.2015 16:41, Daniel-Constantin Mierla wrote:
> Hello,
>
> in the event route for uac_req_send() is practically during handling the
> reply for what was sent before. Also, the uac_req_send() sends something
> out of the processed sip message, so typically functions won't work
> because they will be applied to the processed sip message.
>
> Maybe try setting the avp with the timeout value (see tm parameters),
> might work, I haven't checked -- report the results, would be good to know.
Unfortunately solution with fr_timer_avp also doesn't work. Only set
globally fr_timer works. Well... there is always a solution. Thanks anyway.
> Cheers,
> Daniel
Regards,
Paweł
Hi,
It is posibility to set timeout for uac_req_send with setting "evroute"
to 1. Yes, I found a solution without this set when using
event_route[tm:local-request] [1] but with "evroute" option this don't
work ofcorse.
regards
Pawel
[1] http://lists.sip-router.org/pipermail/sr-users/2011-October/070695.html
Hi,
Just wanted to see how to get SIREMIS user manaual?
Regards,
Voyimir
[image: me]*Vojimir Raovic*, Principal Engineer & Co-founder
*Office:* +61 8 9200 3500 | *Web:* www.norwoodsystems.com | *Twitter: *
@norwoodsystems <http://twitter.com/norwoodsystems>
*Direct:* +61 8 9200 3503 | *Mobile:* +61 450 019 775
[image: me][image: me] [image: me]
NOTICE: If you are not an authorised recipient of this e-mail, please
contact Norwood Systems immediately by return e-mail or by telephone on +61
8 9200 3500. In this case, you should not read, print, re-transmit, store
or act in reliance on this e-mail or any attachments, and should destroy
all copies of them. This e-mail and any attachments are confidential and
may contain legally privileged information and/or copyright material of
Norwood Systems or third parties. You should only re-transmit, distribute
or commercialise the material if you are authorised to do so. Any legal
privilege attaching to the contents of this e-mail or any attachments is
expressly reserved and is not waived by any transmission to an unauthorised
recipient. This notice should not be removed.
*Please consider the environment before printing this e-mail.*
Hello All
I have been looking for answers and trying really hard to figure out if I
can use Kamailio as a Dual Router (Inbound and Outbound using 2 IPs on 1 Eth
"Amazon AWS")
I can not seem to find information is this is possible using Kamailio or if
am just plain "stupid" and can not read the Wiki well enough J
Hope you can help
//Mark
Hello,
I did a new small project with Asterisk to register it on consul
(http://consul.io) to use a discovery service tools.
The project is here : https://github.com/sboily/asterisk-consul-module
This last day, i'm working to use kamailio as a loadbalancer for
Asterisk and autoscale it. You can find example on my
docker-compose.yml, contribs directory and README.
It's not perfect, because i'm clearly not a kamailio expert, but it works.
So, i'm looking about feeling to this dev, and i would expect some help
from kamailio community to configure kamailio as a LB better ;)
I will be at astricon, so if people want to share with me about this
project, contact me.
Have a good day
Sylvain
