sr-users June 2009

sr-users@lists.kamailio.org

80 participants
113 discussions

[Kamailio-Users] [REQ, $] db_rest (or db_http) module for database access
by Konstantin Cherkasov 23 Jun '09

23 Jun '09

Hello! Our company seeking for programmer who can create module for flexible database access. I call it db_rest (or db_http). This module must provide internal database API for other modules like db_auth. For access to external data it must use HTTPS-server and use REST-style data access (http://en.wikipedia.org/wiki/Representational_State_Transfer). Instead of making query like "SELECT f1,f2,f3 FROM tableA WHERE f4 = 'somevalue'" it must call HTTPS-server like this: GET http://hostname/database/tableA&c=f1,f2,f3&k=f4&op=eq&v=somevalue Server must return delimiter-separated data. Similarly (using POST) it must implement support for insert, update and so on. Of course we would like to see this module inside the main project repository. If you are interested please contact me for details (requirements, $$). -- Konstantin

4 17

[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 20 Jun '09

20 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

← 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