sr-users June 2009

sr-users@lists.kamailio.org

80 participants
112 discussions

[Kamailio-Users] Avoid encoding of CDR's written to database by Radius
by CSB 23 Jun '09

23 Jun '09

When a CDR is written that contains certain characters (e.g. +, ;) it is encoded (like a URL gets encoded). The SQL insert statement query is produced by OpenSER/Radius: 10625 Query INSERT INTO radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, AcctStartTime, AcctStopTime, AcctSessionTime, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay, SipResponseCode, SipMethod, SipTranslatedRequestURI, SipToTag, SipFromTag, SipRPID, SourceIP, SourcePort, CanonicalURI) VALUES (NULL, '149a4cbd403b071e109d89b50a17b3a5(a)202.180.1.1', 'e04d0b07ab2eca3e', SUBSTRING_INDEX('sip:094455667@202.180.1.1',':',-1), SUBSTRING_INDEX('sip:094455667@202.180.1.1', '@',-1), '127.0.0.1', '5060', '2009-06-20 11:44:49', '0', '0', '0', '0', SUBSTRING_INDEX('sip:=2B6012345678@147.202.1.1',':',-1), SUBSTRING_INDEX('sip:094455667@202.180.1.1',':',-1), '200', 'SIP', '', '', '0', '0', '200', 'Invite', SUBSTRING_INDEX('',':',-1), 'as03a3d864', 'as69938f56', '', '', '', SUBSTRING_INDEX('',':',-1)) However the records written to the file system by OpenSER/Radius are not encoded: Sat Jun 20 11:44:49 2009 Acct-Status-Type = Start Service-Type = SIP Sip-Response-Code = 200 Sip-Method = Invite Event-Timestamp = "Jun 20 2009 11:44:49 NZST" Sip-From-Tag = "as69938f56" Sip-To-Tag = "as03a3d864" Acct-Session-Id = "149a4cbd403b071e109d89b50a17b3a5(a)202.180.1.1" Called-Station-Id = "sip:+6012345678@147.202.1.1" Calling-Station-Id = "sip:094455667@202.180.1.1" User-Name = "sip:094455667@202.180.1.1" NAS-Port = 5060 Acct-Delay-Time = 0 NAS-IP-Address = 127.0.0.1 Client-IP-Address = 127.0.0.1 Acct-Unique-Session-Id = "e04d0b07ab2eca3e" Timestamp = 1245455089 So how can I write +6012345678 to the database, rather than =2B6012345678? Any advice appreciated. Regards Cameron

2 2

[Serusers] SER Groups
by Shahbaz Ali 23 Jun '09

23 Jun '09

plz help me in setting the ser group mangment... how i add this feature....

1 0

[Kamailio-Users] Siputils error
by Carlos A. Alvarez 22 Jun '09

22 Jun '09

Hello, I keep getting this error when I try to setup ring_timeout ERROR:core:set_mod_param_regex: parameter <ring_timeout> not found in module <utils> I tried setting the modparam for siputils as well to no avail. I already read throught the documentation and I made sure that I am loading all pre requisites for this module. Also the command options is recorded wrong in the 1.5.1 documentation: modparam("options", "options_accept", "application/*") <-according to docs Looking through the source I found out that the correct command is modparam("siputils", "options_accept", "application/*") I wonder is the same is the issue with ring_timeout. Please help

5 8

[Kamailio-Users] Question about manually manipulating RURI
by Geoffrey Mina 22 Jun '09

22 Jun '09

I have a need to perform some manipulation of the user part of the RURI. I have some dialers which send INVITES with the RURI in the following format: d15555551212@123.345.123.345:5060 I need to check for the existence of the "d" and strip it off if it is present. Basically what I want is pseduo code is: if(left($ruri),1 == "d"){ $ruri = right($ruri,len($ruri)-1); } Thanks!

4 5

[Kamailio-Users] Cancel messes with ACC
by Mark Kent 22 Jun '09

22 Jun '09

Oops, found it... there is a typo in the example config file: # ALTER TABLE missed_call ADD COLUMN dst_user VARCHAR(64) NOT NULL DEFAULT ''; See the missing 's' on the table name... I guess I didn't see the error message when entering this. Thanks, -mark

2 1

[Kamailio-Users] Sending from 1 of N ip address
by Stagg Shelton 21 Jun '09

21 Jun '09

I have a requirement from an upstream provider that is providing multiple termination only gateways to me. The requirement is that I have to have a unique source ip address for each gateway that I will be terminating calls to. I would like to use only one kamailio system bound to multiple ip addresses to meet this requirement. I have my LCR built with the various routes to the gateways. I have identified the function force_send_socket([proto:]address[:port]) which seems like it can be used to meet this functional requirement. I am a little confused how to implement this function with LCR. My basic requirement is that if upstream gateway ip address == 1.2.3.4 then originate and maintain the dialog from my source ip 4.3.2.1 else if gateway ip == 6.7.8.9 then originate and maintain dialog using soure ip 9.8.7.6, else if ... N upstream gateways Is force_send_socket([proto:]address[:port]) the function that I need to be trying to use to meet this requirement? Is there a simpler method that can be used instead? Any help will be appreciated. Stagg

3 5

[Kamailio-Users] Cancel messes with ACC
by Mark Kent 19 Jun '09

19 Jun '09

I've been using openser 1.1.0 in a small pstn gateway config for a few years. I recently upgraded to kamailio 1.5.1. I started completely from scratch, with no DB, no users, and started with the example kamailio.cfg file. I made a few changes mostly at the bottom of the main request routing logic to ship things off to my pstn gateway, and re-entered things into the db. Works fine. Then I tried to enable accounting, with mysql, and this works when calls complete, but on a CANCEL I get this: kamailio[87208]: ACC: call missed: timestamp=1245456629;method=INVITE;from_tag=6343AD47-243F70A2;to_tag=2486;call_id=4529cab6-c7e08a51-dd349b2c(a)192.0.2.214;code=487;reason=Request Terminated;src_user=foouser;src_domain=sip.example.net;dst_ouser=18005551212;dst_user=18005551212;dst_domain=172.16.16.16 kamailio[87208]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'dst_user' in 'field list' kamailio[87208]: ERROR:core:db_do_insert: error while submitting query kamailio[87208]: ERROR:acc:acc_db_request: failed to insert into database My CANCEL processing is still the generic processing in the example kamailio.cfg file. Any hints? Thanks, -mark

1 0

Re: [Kamailio-Users] Question about manually manipulating RURI
by Carlos A. Alvarez 19 Jun '09

19 Jun '09

I don't know if this is what you are looking for, but I do something similar to process the From and To message based on a dialed prefix. Please note below my if statement and feel free to modify it for your own use: if ( search("To: <[Ss][Ii][Pp]:56011") ) { subst('/^To:(.*)sip:56011([0-9]+)@(.*)$/To:\1sip:+\2@\3/ig'); subst('/^From: "(.*)sip:([0-9]+)@(.*)$/From: "+\1sip:+\2@\3/ig'); }; On Fri, 2009-06-19 at 15:43 +0000, Geoffrey Mina wrote: Thanks, but I believe I just found the simpler way to strip, but I'm still not sure how I would check for the existence of the "d". http://www.kamailio.org/dokuwiki/doku.php/core-cookbook:1.5.x#strip_int I need to do something like: if(left($ruri,1) == "d"){ //how do i write this statement? strip(1); } t_relay(); is that correct? thanks, Geoff On Fri, Jun 19, 2009 at 3:23 PM, Pascal Maugeri<pascal.maugeri(a)gmail.com<mailto:pascal.maugeri@gmail.com>> wrote: > Hi Geoffrey > > Why don't you try: > http://www.kamailio.org/docs/modules/1.5.x/textops.html#id2467793 > > Regards, > Pascal > > On Fri, Jun 19, 2009 at 9:01 PM, Geoffrey Mina <geoffreymina(a)gmail.com<mailto:geoffreymina@gmail.com>> > wrote: >> >> I have a need to perform some manipulation of the user part of the >> RURI. I have some dialers which send INVITES with the RURI in the >> following format: >> >> d15555551212(a)123.345.123.345<mailto:d15555551212@123.345.123.345>:5060 >> >> I need to check for the existence of the "d" and strip it off if it is >> present. Basically what I want is pseduo code is: >> >> if(left($ruri),1 == "d"){ >> $ruri = right($ruri,len($ruri)-1); >> } >> >> Thanks! >> >> _______________________________________________ >> Kamailio (OpenSER) - Users mailing list >> Users(a)lists.kamailio.org<mailto:Users@lists.kamailio.org> >> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users >> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ Kamailio (OpenSER) - Users mailing list Users(a)lists.kamailio.org<mailto:Users@lists.kamailio.org> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users

1 0

[Kamailio-Users] Dialog from 1 of N IP Addresses
by Stagg Shelton 19 Jun '09

19 Jun '09

2 1

[Kamailio-Users] [OT] SIP ALG Detector released
by Iñaki Baz Castillo 19 Jun '09

19 Jun '09

Hi, as part of my personal battle against SIP ALG routers, I've created an utility to detect such routers: http://dev.sipdoc.net/wiki/sip-stuff/SIP-ALG-Detector It has two parts: client and server: Basically, the client node running into the LAN sends an INVITE to the server node (running in a host with public IP). The request could be modified by the LAN router if SIP ALG is enabled. The server encodes the received request in Base64 and appends it to the SIP response. The client receives the response, decodes the body and gets the request as it arrived to the server. Then it creates a diff between the original request and the the request the server node received. These differences are displayed in the screen. Both, UDP and TCP, tests are performed. The client node is coded in Ruby and should work in any operating system (if Ruby is installed). The server node is also coded in Ruby. For those interested in try it, I have a server node running in my personal server: 87.98.230.161:5060 You can test the client against my server. Feedback is welcome :) Regards. -- Iñaki Baz Castillo <ibc(a)aliax.net>

4 13

← Newer
1
2
3
4
5
6
7
8
...
12
Older →

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 June 2009