Hello
I have a proxy that makes the function of balancer and I have a doubt.
This balancing between two proxies that do accounting, if any falls
during the course of a call, you lose accounting (record-route). Is
that correct?
Is it advisable to have at each proxy server as a slave and balance
the ip? Thanks
Regards
Hi all,
Trying to create the Homer SIP capture (Kamailio) DB and getting an error:
Error
SQL query:
CREATE TABLE `sip_capture` ( `id` bigint(20) unsigned NOT NULL
AUTO_INCREMENT, `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`micro_ts` bigint(18) NOT NULL DEFAULT '0', `method` varchar(50) NOT NULL
DEFAULT '', `reply_reason` varchar(100) NOT NULL, `ruri` varchar(200) NOT
NULL DEFAULT '', `ruri_user` varchar(100) NOT NULL DEFAULT '', `from_user`
varchar(100) NOT NULL DEFAULT '', `from_tag` varchar(64) NOT NULL DEFAULT
'', `to_user` varchar(100) NOT NULL DEFAULT '', `to_tag` varchar(64) NOT
NULL, `pid_user` varchar(100) NOT NULL DEFAULT '', `contact_user`
varchar(120) NOT NULL, `auth_user` varchar(120) NOT NULL, `callid`
varchar(100) NOT NULL DEFAULT '', `callid_aleg` varchar(100) NOT NULL
DEFAULT '', `via_1` varchar(256) NOT NULL, `via_1_branch` varchar(80) NOT
NULL, `cseq` varchar(25) NOT NULL, `diversion` varchar(256) NOT NULL,
`reason` varchar(200) NOT NULL, `content_type` varchar(256) NOT NULL,
`authorization` varchar(256) N[...]
MySQL said:
<http://172.20.25.149/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdo
c%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=1d6b9d77bce4c6f1648
83e3c6dd6bc09> Description: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'PARTITION BY RANGE ( UNIX_TIMESTAMP(`date`) ) (
PARTITION pmax VALUES LESS THAN ' at line 50
System Information:
. Apache/2.2.10 (Linux/SUSE)
. MySQL client version: 5.0.67
. PHP extension: mysqli
Server is SLES 11 SP1
Hi again...
(i do find myself ask many questions these days.... :-))
well, now here is one more:
i have 2 kamailio servers that i use in 2 locations. both use the same
tables and DBURL.
each of my server turns to a number portability (NP) server at its same
location.
for example, if server 1 has the call, it will turn to NP server 1 with the
query, and if the query fails, it will then turn to NP server 2.
the kamailio server 2 does the same. but, turns to NP server 2 first and if
it fails, to NP server 1.
once this is understood....
here is my issue - i want to have 1 generic cfg file for my 2 servers.
today, i use the same cfg file, but in server 1 i set it in the cfg to its
group, and on server 2 the same but a different group....
i tried to understand how do i get each server to "pull" its group from the
DB. something like "what is my group when my IP is X.Y.Z.Q ?
i raed the cfg_db module but didn't understand how to set it on my cfg file
and on the DB.
what is the best way to do what i want?
hope i was clear....
BR,
thanks to all the guys that help me so far, i appriciate it a lot!
Uri
Hello,
it is very likely I will be in London and visit UC Expo show
(http://www.ucexpo.co.uk/) at least the first day. Therefore I am
thinking of organizing a Kamailio/SIP/VoIP social networking event
(perhaps a dinner or pub meeting), on the evening of the 5th or 6th of
March. Are people from community interested in joining such event? If
yes, write me your preferred date -- based on feedback in the next days,
it will be decided whether it is going to happen and when.
Also, if many people would be interested in a project developments and
updates session (like the one did in 2010:
http://www.kamailio.org/w/present-and-future-of-sip-routing-2010-london/),
I can try to get a location for 2-3 hours on the 5th of March for such
meetup. Let me know as well your interest in such event.
Cheers,
Daniel
--
Daniel-Constantin Mierla -- http://www.asipto.comhttp://linkedin.com/in/miconda -- http://twitter.com/miconda
Hi,
i would like to get the kamailio server ip address on start up and save it
in an $shv().
i tried to use "myself" but did manage to get the ip from it.
any ideas?
Uri
Problem - if connection drop, call can persist.
In Asterisk there is silencedetecthangup - which should cause hangup, if
there is full silence for desired period of time.
Unfortunately it does not hangup.
I mean:
SIP client 1 ->Kamailio -> Asterisk ->Kamailio -> SIP client 2
If I drop connection for one of SIP clients, I expect call should be
automatically hangup after a time I set (20 sec).
But call persists. In worst case - if connection drops for both clients,
call will persist until Asterisk is restarted.
I will continue to look how to solve problem with Asterisk, but I am
curious if this can be done from Kamailio also.
If I can cancel call from both places - it will be great.
I need to ensure that if something wrong happens, call will be dropped
within 30 sec maximum.
Stoyan
Hello,
I am running kamailio 3.1.3 and I am making some tests with the exec
module. I am running a "dummy" script and it worked like a charm.
Now, I am testing what happens when the script takes "too much time" to
return a result. According to exec module documentation the/
time_to_kill /parameter should take care of it.
*time_to_kill* (INTEGER)
/Specifies the longest time a program is allowed to execute. If the
time is exceeded, the program is killed. /
BTW ... I am assuming /time /is in milliseconds. I think the
documentation should refer the time units.
Apparently kamailio ignores this parameter (or it doesn't work as I am
expecting). No matter which value I assign to /time_to_kill/, kamailio
doesn't kill the script and waits for the script to finish. In the
meanwhile some SIP timers are triggered ... resulting into a failed call.
The test I am doing is quite simple. For incoming INVITEs, use a
external script to check the status of a specific test user, if it
returns the keyword "busy" sends it to voicemail otherwise route the
INVITE to the local user. The test script returns a result after about 8
seconds.
Shouldn't the /time_to_kill/ be triggered and stop the script?
Here goes some relevant parts of my configuration. In attachment I am
sending the kamailio log with a debug value of 4.
/# ----- exec params -----/
/modparam("exec", "time_to_kill", 10)/
/# --- exec params end -----/
/#route just to check the exec module
route[TESTEXEC] {
xlog("L_INFO", "TESTEXEC: Entered ($rU)\n");
if ($rU == "miguel")
{
$var(calendarTMP)="/root/" + $rU + "_test.pl";
exec_avp("$var(calendarTMP)", "$avp(s:test)");
xlog("L_INFO", "TESTEXEC: Returned value is
$avp(s:test)\n");
if ($avp(s:test) == "busy") {
$ru = "sip:userbusy@" +
ASTSERVIPPORT; # Voicemail
route(RELAY);
}
}
xlog("L_INFO", "TESTEXEC: Exiting ($rU)\n");
return;
}
/
Regards,
Miguel Baptista
Hi
I want to use TCP keepalive to detect dead connections between Kamailio
and my SIP clients. I've got some questions about this:
1. If I enable it on Kamailio by setting for example:
tcp_crlf_ping = yes
tcp_keepalive = yes
tcp_keepidle = 60
tcp_keepintvl = 10
tcp_keepcnt = 3
>From what I read by gooling, that means Kamailio only responds to the
crlfcrlf sent by the client, but can't be configured to send the
crlfcrlf. Is this right?
2. On my client, if I use setsockopt to set the corresponding values:
SO_KEEPALIVE
TCP_KEEPCNT
TCP_KEEPIDLE
TCP_KEEPINTVL
would it make the client send crlfcrlf?
The reason I'm confused is, with these settings, if Kamailio can only
respond to crlfcrlf, but not send, then would the client only respond
too, as in 1. and 2., they seem to configure the same set of parameters?
Please help me clarify this. Thanks very much!
Yufei
--
Yufei Tao
Red Embedded
This E-mail and any attachments hereto are strictly confidential and intended solely for the addressee. If you are not the intended addressee please notify the sender by return and delete the message.
You must not disclose, forward or copy this E-mail or attachments to any third party without the prior consent of the sender.
Red Embedded Design, Company Number 06688253 Registered in England: The Waterfront, Salts Mill Rd, Saltaire, BD17 7EZ
Hi,
Just wanted to know if it is possible for kamailio to route calls to user's
skype/gtalk/yahoo messenger?
--
Regards,
*Abid Naseem*
+44 (793) 741 5043
+1 (415) 562 6333
I am a new user and am trying to configure kamailio to use SQLITE
instead of MYSQL. I see that SQLITE option is rather new and maybe not
as documented as MYSQL.
I am running on fedora 14 and have installed MYSQL3 from rpms. Kamailio
I built from sources because I need the SQLITE support.
What kamailio.cfg and kamctlrc parameters do I need to change to do
this?
I have already set these in kamctlrc:
...
## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, DBTEXT, or SQLITE
# by default none is loaded
#
# If you want to setup a database with kamdbctl, you must at least
specify
# this parameter
DBENGINE=SQLITE
## database host
DBHOST=localhost
## database name (for ORACLE this is TNS name)
# DBNAME=openser
...
and ran:
kamdbctl create openser
and
kamctl add user1 password1
successfully.
Now, it appears that I need to change kamailio.cfg for SQLITE. Can I
simply edit this file substituting SQLITE for MYSQL and loading the
SQLITE module?
How about this part:
...
####### Defined Values #########
# *** Value defines - IDs used later in config
#!ifdef WITH_MYSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!define DBURL "mysql://openser:openserrw@localhost/openser"
#!endif
...
Will this URL work with SQLITE?
Thanks in advance,
Perazim
