Hi!
I'm having troubles connecting Kamailio to an external MySQL database (on Microsoft Azure Cloud).
Initially creating the database with kamctl worked fine, but accessing it at runtime via db_url fails.
A somewhat unusual thing about the connection to a MySQL database on Azure is that the username contains an '@' character.
This leads me to believe that this case is somewhat unhandled when parsing the database URI.
Trying to connect to something like
modparam("sipcapture", "db_url", "mysql://user@clouddb:password@clouddb.mysql.database.azure.com/db")
Results in errors starting Kamailio
ERROR: db_mysql [km_my_con.c:124]: db_mysql_new_connection(): driver error: Unknown MySQL server host 'clouddb' (-2)
ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the pool
ERROR: sipcapture [sipcapture.c:1146]: child_init(): unable to connect to database [mysql://user@clouddb:password@clouddb.mysql.database.azure.com/db] from capture_mode param.
Is there a trick on how to achieve a connection in this case like some sort of escape character probably?
Mit freundlichen Grüßen
Florian Floimair (IMS) 1568
Hello Kamailio list!
I've been working with the LCR module and I wanted to use the lcr_id to
match some ID's I have somewhere else.
However, due to the lcr_count my lcr_ids must be less than the lcr_count. I
understand the reason behind the lcr_count, what I think is a mistake is to
have the lcr_id dependent of the lcr_count.
Ideally we should be able to use any lcr_id value, just observing that the
total amount of lcr groups should not exceed the lcr_count.
The problem is this if that appears in the load_gws, to_gw and from_gw
functions in lcr_mod.c:
if ((lcr_id < 1) || (lcr_id > lcr_count_param)) {
LM_ERR("invalid lcr_id parameter value %d\n", lcr_id);
return -1;
}
I ended up using another table to make the conversion of ids, but this is
horrible.... Any other reason to force the lcr_id to be less than the
lcr_count?
Best Regards,
Patrick Wakano
Hello Experts,
I am new to ansible and deploying kamailio through ansible.Sucessfully deployed kamailio but my requirement is to add media server through ansible.As I am using dispatcher module in kamailio,not able to find any script that directly insert one media server IP and port into dispatcher table from ansible.(I am using ansible in one system and deploying kamailio in other).
Any suggestion will be highly appreciated as always.
Thanks,
Narayan
+91-9035438928
Through Firefox likely means via websockets (wss) rather than via the sip port. Many things could interfere with the latter. Take heart, though: websockets is harder to set up so you're likely through the worst.
Look at logs and see what iftop shows you about traffic on the server as you try to make sip connections. Also try your sip client with a known-good sip server (e.g. Iptel) just to make sure the problem isn't with the client.
-------- Original message --------
From: "Wilkins, Steve" <swwilkins(a)mitre.org>
Date: 11/28/2017 6:39 AM (GMT-08:00)
To: "Kamailio (SER) - Users Mailing List" <sr-users(a)lists.kamailio.org>
Subject: [SR-Users] Using SIP tools through Kamailio and Asterisk - chrome issue.
Has anyone seen the issue where, when using a sip tool and going from Kamailio to Asterisk, that audio and video won’t work, yet it works fine through Firefox? I am almost sure this not an issue with Kamailio, but I am pretty new to SIP and don’t know 100% for sure.
Thank you
Has anyone seen the issue where, when using a sip tool and going from Kamailio to Asterisk, that audio and video won't work, yet it works fine through Firefox? I am almost sure this not an issue with Kamailio, but I am pretty new to SIP and don't know 100% for sure.
Thank you
Hello,
I set up kamailio cluster. dmq_usrloc works fine, but PUSBLISH and
SUBSCRIBE replication not.
If I make a call to first node I've got many(hundreds) PUBLISH messages
from first node to first node and some messages (8 for example) to other
nodes.
And second xnotice in config not executes. And errors n log ERROR: <core>
[core/sr_module.c:1726]: get_int_fparam(): Unsupported param type for int
value: 32
How to replicate publish and subscribe, is it wrong way?
my confiig:
request_route {
if(is_method("KDMQ")) {
if ($Rp == 5050) { dmq_handle_message(); exit; }
else { drop; }
}
.....
.....
if(is_method("PUBLISH|SUBSCRIBE")) {
if(!dmq_is_from_node()) {
xnotice("AAAAAAAA");
dmq_t_replicate("1");
xnotice("AAAAAAAABBBBBBBBBBB");
}
}
2017/11/28 12:56:06.415601 192.168.8.213:5060 -> 192.168.8.213:5060
PUBLISH sip:34200@siptest. SIP/2.0
Via: SIP/2.0/UDP
192.168.8.213;branch=z9hG4bKc7a5.cee84051000000000000000000000000.0
To: <sip:34200@siptest>
From: <sip:34200@siptest.>;tag=ae81df16b5a52fc1f62f9b45f337e660-db10
CSeq: 10 PUBLISH
Call-ID: 4c8f9e6e799efcd7-57244(a)192.168.8.213
Content-Length: 556
User-Agent: kamailio (5.0.4 (x86_64/linux))
Max-Forwards: 70
Event: dialog
Expires: 125
Content-Type: application/dialog-info+xml
<?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0"
state="full" entity="sip:34200@siptest.">
<dialog id="898932197-5060-86(a)BJC.BGI.D.DB"
call-id="898932197-5060-86(a)BJC.BGI.D.DB" direction="initiator">
<state>Trying</state>
<remote>
<identity>sip:53003@siptest.t</identity>
<target uri="sip:53003@siptest.tg"/>
</remote>
<local>
<identity>sip:34200@siptest</identity>
<target uri="sip:34200@siptest"/>
</local>
</dialog>
</dialog-info>
--
Aydar A. Kamalov
Hi,
We use Kamailio as a SIP server, and SEMS as an SBC. We have a need to use the dispatcher/carrierroute modules to provide HA/load sharing across two different parts of our environment:
1) Our SBCs
2) Our peer’s SIP servers
We have pairs of SBCs (for now) and they have the same network connectivity - different IPs of course, but they can reach the same things.
Our peer’s network has 2 SIP servers (again, for now) reachable through either SBC.
We select which SBC pair to use based on where the calls are going, in a branch route. In some cases, we use parallel forking, in others we use serial forking (i.e. to a media server for a prompt, then sending the call to wherever it needs to go).
Right now there is no automatic failover or load sharing, so this is all simple logic - if call is to x peer or y customer, use x SBC or y SBC. I’m trying to add the failover/loadbalancing now.
I have a few half baked ideas about how to achieve a network like this, but thought I’d ask if anyone else had done this first before I went too overboard.
Currently I’m thinking of calling cr_route to figure out which peer SIP server, from there figuring out which SBC pair, and then calling ds_select_dst to select which SBC in the pair to set $du. I’m being tripped up though, as I can’t call cr_route or ds_select_dst in a branch route, but, as far as I’m aware that’s where I’d need to do so in order to handle this for multiple branches. Should I be looping the request through the SIP server to achieve this (i.e. force $du = 127.0.0.1 in my branch_route), or, can I avoid that complexity?
--
Nathan Ward
Hello,
We suddenly had an issue on one Kamailio instance: we were not able to
restart. Kamailio started to boot and fork and suddenly crashed.
The last logs reported a failure regarding the ability to connect to one
MySQL instance.
I finally succeed to restart after increasing: fork_delay=5000 to
fork_delay=9000.
How this could happen suddenly? We already restarted Kamailio on this
server.
Regards,
Igor.