sr-users

sr-users@lists.kamailio.org

4 participants
37456 discussions

AVP obtain with regular expression
by Anto 14 Feb '12

14 Feb '12

Hello I'm using AVP, but I can not finish assimilating the concept. I try to input messages, according to their DID. Once it enters an INVITE message treatment with alias_db for its user, but I want some AVP for each DID. I can think of three cases. The first I have no very clear if possible and if it were, I think is not optimal. 1) Given the configuration of the module: modparam("avpops","avp_url","mysql://user:passwd@host/database") Had thought if I can use regular expressions to get the "prs" in the database (DID_IN, DID_DEST, etc). USR_PREFERENCES table: | id | uuid | username | domain | attribute | type | value | modified | | 1 | XXX | user1 | dmn.tld | 571XXX_IN | 1 | XXX | | | 2 | XXX | user2 | dmn.tld | 571XXX_DEST | 1 | XXX | | 2) Maybe better to use the module configuration schemes: modparam("avpops","db_scheme","scheme1:uuid_col=uid;value_col=job;value_type=string;table=emp") modparam("avpops","db_scheme","scheme2:username_col=user;domain_col=domain;value_col=email;table=users") 3) Or use avp_db_query() function. Can anyone guide me? I'm pretty lost :-S. The first case, I know if possible and possibly more difficult to maintain. Thanks very much. Best regards Anto

1 0

problems since upgrading mysql and php
by Nelson Pereira 14 Feb '12

14 Feb '12

Getting the bellow error after upgrading php and mysql as requested: Access forbidden! You don't have permission to access the requested directory. There is either no index document or the directory is read-protected. If you think this is a server error, please contact the webmaster <mailto:root@cbnhmr01plc> . Error 403 172.20.25.149 <http://172.20.25.149/> Tue Feb 14 13:37:07 2012 Apache/2.2.10 (Linux/SUSE) Regards, Nelson Pereira Sr. Network Administrator, Information Systems Canadian Bank Note Company 18 Auriga Drive Ottawa, Ontario K2E 7T9 Phone: (613) 225-6566 Ext 2347 Cell: (613) 410-7608

2 1

Record-route and high avaibility
by Anto 14 Feb '12

14 Feb '12

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

2 2

creating DB in MySQL for Homer Capture server gives errors
by Nelson Pereira 14 Feb '12

14 Feb '12

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

2 1

get server parameters from DB when kamailio starts
by Uri Shacked 14 Feb '12

14 Feb '12

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

3 8

London Meetup in March, at UC Expo
by Daniel-Constantin Mierla 14 Feb '12

14 Feb '12

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.com http://linkedin.com/in/miconda -- http://twitter.com/miconda

1 0

get myself ip address on start
by Uri Shacked 14 Feb '12

14 Feb '12

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

1 0

Is there something like "silence detect hangup"
by Stoyan Mihaylov 13 Feb '12

13 Feb '12

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

2 2

Is exec module ignoring time_to_kill parameter?
by Miguel Baptista 13 Feb '12

13 Feb '12

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

2 2

TCP keepalive on server and client
by Yufei Tao 13 Feb '12

13 Feb '12

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

3 2

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