sr-users March 2007

sr-users@lists.kamailio.org

192 participants
381 discussions

RE: [Users] Openser and Oracle
by Papadopoulos Georgios 14 Mar '07

14 Mar '07

What do you mean by "SQL injection"? I know it is not a pretty solution (especially changing the code) but I cannot think of an alternative. I can look into SER's oracle module. But that would mean that in the where clauses all string values should be surounded with "upper". Not a pretty solution either but it would work I guess. I briefly saw that Openser 1.2 has string transformations. So could uppercase and lowercase be included there? I am picturing something like avp_db_load("$ruri{s.lowercase}", ...) Of course this would only solve the issue with avpops. In order to solve the issue with auth_db for example, wouldn't we need new functions? Any comments about the multiple connections to the DB? > -----Original Message----- > From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] > Sent: Wednesday, March 14, 2007 12:59 PM > To: Papadopoulos Georgios > Cc: users(a)openser.org > Subject: Re: [Users] Openser and Oracle > > Papadopoulos Georgios wrote: > > Hello, > > > > First of all congratulations to everyone involved in the > new release. > > I haven't been able to get my hands on it yet, but just > reading about > > it makes me very excited. Great job! > > > > I would like to address the issue of Openser and Oracle working > > together. We are currently using Openser with a local > MySQL. Our main > > database is Oracle and we are just copying data to MySQL so that > > Openser can work. This is a little difficult to maintain so > I thought > > I would try to make Openser use directly our Oracle. Of > course I ran > > into a number of issues. > > 1. modules/acc and unixodbc. The acc_db_request() was not working > > because inserting a string in a date column does not work > with Oracle. > > So, I had to change functions time2str() and time2odbc() in > order to > > make this work. Also had to change acc.c to treat column time as > > DB_TIME instead of DB_STR (I think this could be treated as a bug). > > 2. modules/lcr. The query uses char_length() and rand() > which I had to > > replace with lengthc() and dbms_random.value. Should these > be modules > > params? > > Hi! > > I guess oracle allows the defintion of new function. Then you > could write the functions char_length() and rand() which > would be just wrappers to lengthc() and dbms_random.value. > > > 3. modules/avpops. All issues were resolved by config changes and > > replacing avp_db_load() with avp_db_query(). > > Be careful - raw queries are vulnerable to SQL injection!!! > > > 4. modules/auth_db, alias_db, uri_db, group. Since MySQL is case > > insensitive and Oracle is not, I made changes in the code to use > > raw_query() instead of query(). All queries have to be in the form > > "select ... from ... where username=upper(...)" > > Again: Be careful - raw queries are vulnerable to SQL injection!!! > > > > I would be happy to provide patches and help in any way in order to > > make this migration easier in the future. However I am not sure > > whether my changes are general enough for everybody to use. > So, do you > > have any suggestions about how to deal with these issues? > > There is a oracle module in ser - you could port it to openser ;-) > > regards > klaus > > > Another issue that came up is the number of connections > from Openser > > to the database. In our case, listening to five interfaces, > with tcp > > disabled and children=5, we get 28 connections to DB which > is a great > > waste of resources. From those five interfaces, one is > receiving the > > bulk of traffic and the rest receive minimal traffic. Since > each child > > has its own connection, then what is the purpose of > connection pooling? > > How difficult would it be to have a common connection pool for all > > children? > > > > sorry for the long email and thank you in advance for any answer. > > > > George > > > > > > > > > > > > Disclaimer > > The information in this e-mail and any attachments is > confidential. It is intended solely for the attention and use > of the named addressee(s). If you are not the intended > recipient, or person responsible for delivering this > information to the intended recipient, please notify the > sender immediately. Unless you are the intended recipient or > his/her representative you are not authorized to, and must > not, read, copy, distribute, use or retain this message or > any part of it. E-mail transmission cannot be guaranteed to > be secure or error-free as information could be intercepted, > corrupted, lost, destroyed, arrive late or incomplete, or > contain viruses. > > > > > > > > > > > ---------------------------------------------------------------------- > > -- > > > > _______________________________________________ > > Users mailing list > > Users(a)openser.org > > http://openser.org/cgi-bin/mailman/listinfo/users > > > -- > Klaus Darilion > nic.at > >

2 1

[Users] dialog module configuration question
by Andy Pyles 14 Mar '07

14 Mar '07

Hello, I have a question on how to configure the dialog module ( 1.2.x from cvs yesterday ). With my config, ( attached) I can make calls and have verified that the acc module is working correctly. My question is, when I enable the dialog module, I can see that it is incrementing call count correctly, but when a bye is received, the dialog:active_dialogs statistic is never decremented. In the debug level 9 logs, ( also attached) I see this error after the 200OK is sent to the bye: 1(969) DBUG:dialog:unref_dlg: unref dlg 0xa7ce5a98 with 1 (delete=0)-> 1 Is this a case of one of the timers being set too short? by the way using a variable call length from well under a second ( using sipp ) to 20 second call doesnt' seem to make a difference . Thanks, Andy

5 29

[Users] OpenSER-1.2 Radius Auth
by TCB 14 Mar '07

14 Mar '07

Been trying to a fresh install of OpenSER-1.2 / Radius and i keep getting the following error on authentication , find attached . Googling has send me in circles i'm dizy. -- TC

2 1

[Users] Compiling new OpenSER 1.2.0 on Solaris 8 fails
by Peter Edwards 14 Mar '07

14 Mar '07

Hi, all. I have a Solaris 8 server which happily builds a nightly CVS build I retrieved from CVS on 16/12/06. When I heard that 1.2.0 had been released, I downloaded this tarball: http://www.openser.org/pub/openser/latest/src/openser-1.2.0-tls_src.tar.gz However, I'm having difficulties compiling it. To avoid a couple of symbol referencing errors, I added: -DDBG_QM_MALLOC \ and disabled: #-DF_MALLOC \ in the DEFS variable definition in Makefile.defs. I reached this by trial and error and by comparing the differences in the file from the working nightly build I can compile and the latest release tarball. However, I'm still getting: Undefined first referenced symbol in file warn cfg.tab.o ld: fatal: Symbol referencing errors. No output written to openser collect2: ld returned 1 exit status gmake: *** [openser] Error 1 Can anyone put me out of my misery? ... I'm not a C guru and am struggling a bit. Peter.

2 2

[Users] using regular expressions in switch case
by Jayesh Nambiar 14 Mar '07

14 Mar '07

Hi, First of all congratulations to all the contributors for releasing 1.2.0. I was just wondering if regular expressions can be used inside case " ----" syntax. Example: switch($ruri.user) { case "1[0-9]" : route(10); } Any help would be appreciated. w/regards, Jayesh __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/

2 1

Fwd: [Users] NAT issue with devel version
by vallimamod abdullah 14 Mar '07

14 Mar '07

Sorry, forgot to put the list in copy :-(( -- Regards, -vma . ---------- Forwarded message ---------- From: vallimamod abdullah <vabdulla(a)gmail.com> Date: Mar 14, 2007 11:05 AM Subject: Re: [Users] NAT issue with devel version To: Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> Hi Bogdan, On 3/10/07, Bogdan-Andrei Iancu <bogdan(a)voice-system.ro> wrote: > Hi, > > could you detail a bit what is not working, as it is not clear from your > email ? Thank you for having taken time to look at my issue. I finally managed to solve it: It was not related to Openser but to my firewall who had some issues with NAT handling. -- Regards, -vma .

1 0

[Serusers] Environmental parameter
by chungyu 14 Mar '07

14 Mar '07

Dear all: Could tell me to have the environmental parameter can only get the username of from header and the domain of from header? ex: caller: john(a)iptel.org callee: mary(a)iptel2.org use $SIP_OUSER => mary $SIP_RURI => iptel2.org $xxx => john $xxx => iptel.org exec_msg("echo reguest from $XXX | mail -s 'request for you' xx(a)xx.xx.xx"); $xxx =>username of from header Thank you changyu 2007/03/14

1 0

[Users] ACK ACK ACK
by Mark Kent 14 Mar '07

14 Mar '07

Hello, It's been a little while since I last posted, but this will look familiar to those who remember: The scenario is this: Phone sends openser an invite, which tries to set things up with the PSTN gateway, which is unresponsive(*), and so it sends back to the Phone: SIP/2.0 503 Service not available and the Phone sends back an ACK. What should I do with that ACK? One possibility is to do nothing, another possibility is to t_relay() it. What suprised me was that when I do nothing then another "SIP/2.0 503 Service not available" message is automagically sent to the Phone. So, that can't be the right thing to do. Meanwhile, when I t_relay() it then things usually work. But this doesn't seem like the right thing to do, since the ACK is meant for the very box on which I'm doing the t_relay(). So, what's the story? Thanks, -mark (*)don't worry about why the PSTN gateway is unresponsive.

2 1

[Users] RTPproxy problem
by Joao Pereira 14 Mar '07

14 Mar '07

Hellos I whant to run RTPproxy separatly from my SIP router, so I tried to run it like this: [root@vox rtpproxy-0.3]# rtpproxy -s udp:xxx.xxx.xxx.xxx:22222 rtpproxy: explicit binding address has to be specified in UDP command mode [root@vox rtpproxy-0.3]# rtpproxy -l xxx.xxx.xxx.xxx: -s udp:xxx.xxx.xxx.xxx::22222 xxx.xxx.xxx.xxx: = my IP But when I run openSER, this happens 9(15400) WARNING: rtpp_test: support for RTP proxy has been disabled temporarily 11(15407) ERROR: send_rtpp_command: can't connect to RTP proxy I already tried with modparam("nathelper", "rtpproxy_sock", "unix:/var/run/rtpproxy.sock") and with modparam("nathelper", "rtpproxy_sock", "unix:/var/run/rtpproxy.sock udp:xxx.xxx.xxx.xxx:22222") But it always says: send_rtpp_command: can't connect to RTP proxy Whats the problem? Im using this configuration in sip.conf: http://siprouter.onsip.org/doc/gettingstarted/ch08s02.html Regards Joao Pereira

2 1

[Serusers] How to send ALIAS as caller ID
by Jai Rangi 14 Mar '07

14 Mar '07

Hello, I have working ser with all the db modules and lcr. I want to send useralias as caller id in place of user name. Say I have a ser account with the name testaccount, and an alias 15556667777 to the user testaccount. So if some one calls 15556667777 and the call will go to testaccount. Now if testaccount make an call then in the caller id I see testaccount. How can I send 15556667777 as caller ID when, testaccount make a PSTN call. I guess I can also use uri table and use the caller id from uri_user in place of username. But I dont know how can I do that. I tried this, modparam ("uri", uri_user_column", "uri_user") where the default is set for username. But That did not help. Thank you, -Jai

3 2

← Newer
1
...
25
26
27
28
29
30
31
...
39
Older →

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 March 2007