sr-users

sr-users@lists.kamailio.org

4 participants
37456 discussions

Re: [Users] openser+postgresql
by 赵俊杰 15 Mar '07

15 Mar '07

Hello,klaus First thank for your suggest! My OS I FC4,postgresql client is 8.0.3,openser 1.2.0 I try to update libpq to libpq4.It cann't work when I start the opener.The postgres.so is cann't be loaded. But using the mysql it works well. Before now when I execute openser_postgresql.sh it occurs the following error ~./pgpass does not exist, please create this file and support proper credentials for user postgres. Note: you need at least postgresql>= 7.3 And I write a .pgpass file to solve the problem.Following is the content of file: *:*:*:postgres:"" Do you have other suggestion? Thank you! Best Regards Junjie Zhao 2007-03-15

3 3

RE: Re: [Users] SIP supplementary service
by 김형선 15 Mar '07

15 Mar '07

thanks. I took a look at onsip.org. But I could not find script files for other supplementary service. There are config files for 'getting started' and just 'call forward'. Are there config files for other supplementary services? Can OpenSER support supplementary services? thank you. -----Original Message----- From: "Bogdan-Andrei Iancu"<bogdan(a)voice-system.ro> To: "김형선"<liotliol(a)naver.com> Cc: users(a)openser.org Sent: 07-03-15(목) 02:44:58 Subject: Re: [Users] SIP supplementary service Hi, you may take a look at onsip.org for more samples. regards, bogdan 김형선 wrote: > > Hi. > > > > I saw the example script of openser.cfg for 'call forwarding'. > > Are other SIP supplementary services possible with OpenSER, by script? > > (call parking, call pickup, hold, conference, etc...) > > > > If it is possible, how can I get these script files? > > > > thanks > 새로운 기부문화의 씨앗, 해피빈

2 2

[Users] auth_db and load_credentials question
by Klaus Darilion 15 Mar '07

15 Mar '07

Hi! When I load AVPs during authentication - what type is the content of the AVP? string? integer? Is it automatically derived from the column type (like avp_db_query)? My problem is: I want to load an integer value and compare it against an integer: modparam("auth_db", "load_credentials", "s:maxcalls=maxcalls") ... if(avp_check("$avp(i:40)", "ge/$avp(s:maxcalls)/g") { Does this work? What happens if I compare an integer with a string - will there be a conversion? thanks klaus -- Klaus Darilion nic.at

2 3

[Users] Question about changing an coming call destination.
by Howard Tang 15 Mar '07

15 Mar '07

Hi All, I am having a problem to do the following. A call recevied from PSTN Caller is 1234 Callee is 5678 Normally, the UA 5678 that registered on the openser will receive the call and have caller id display 1234. What i want to do is the UA 1234 will recevice the call instead 5678, i don't care about the callid (basically, caller id will remain 1234). where should i preform the modification? I dont need Callerid. so i just want to send the incoming call to the account that match the caller id. My logic will be if sip_to = 5678, then change sip_to(5678) to sip_from(1234). send the call to the user 1234. However, i am not familiar with the code. Can someone show me how i can do that please? Regards, Howard

2 3

[Serusers] Max number of routing blocks in ser 0.9.6
by Cesc 15 Mar '07

15 Mar '07

Hi, I just hit the max number of routing blocks in my config file ... I use the route blocks as "functions", to have a cleaner config or so I hope. The problem is that in config.h, RT_NO is set to 20 ... so, max num of routing blocks is 20. Can I just change it? or will it have unexpected side effects? Tks! Cesc

2 1

Re: [Users] openser +ipv6
by 赵俊杰 15 Mar '07

15 Mar '07

Hello,Bernard Thank you very much! I follow you suggestion.Add listen=udp:[ipv6_adresss]5060 in the file opener.cfg.when I restart the service it works. Best regards Junjie Zhao 2007-03-15

1 0

[Users] OpenSER 1.2 debs available for Debian stable
by Bogdan-Andrei Iancu 15 Mar '07

15 Mar '07

Hi, packages for Debian stable were uploaded both on the web download section http://www.openser.org/pub/openser/latest/packages/deb-stable/ and on the project debian repository deb http://www.openser.org/debian sarge main Regards, bogdan

1 0

[Users] Re: Info Permissions - Trusted IP
by Dan-Cristian Bogos 15 Mar '07

15 Mar '07

Hi, my fault there, I was checking as ussually on the wrong place. Trusted module based on ip works fine no matter of the port of the originator. Cheers, Dan

1 0

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

15 Mar '07

I see what you mean. However, how is this avoided if you use query() instead of raw_query()? Function query() will also write the same string as the value of the User-Agent column. Both functions will construct the same query and at the end they will call submit_query(). No? best regards George > -----Original Message----- > From: Klaus Darilion [mailto:klaus.mailinglists@pernau.at] > Sent: Wednesday, March 14, 2007 2:28 PM > To: Papadopoulos Georgios > Cc: users(a)openser.org > Subject: Re: [Users] Openser and Oracle > > Papadopoulos Georgios wrote: > > 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. > > > Just an example. The save() function writes the User-Agent > header into the DB. If the usrloc would use a raw SQL query, > and the User-Agent header would be something like > User-Agent: foobar'; delete from subscriber; ' > > then the delete query would be executed. This is an SQL injection. > > regards > klaus > > > > > 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 > >> > >> > > > -- > Klaus Darilion > nic.at > >

2 1

[Users] openser+postgresql
by 赵俊杰 15 Mar '07

15 Mar '07

Hello,everyone I configure the openser with postgres.But I cann't start the openser .When I execute the command /usr/local/sbin/openser I occurs the following errors: 0(28102) ERROR: load_module: could not open module </usr/local/lib/openser/modules/postgres.so>: /usr/local/lib/openser/modules/postgres.so: undefined symbol: PQescapeStringConn 0(28102) parse error (42,13-14): failed to load module ERROR: bad config file (1 errors) 0(28102) INFO:mi_fifo:mi_destroy:memory for the child's mi_fifo_pid was not allocated -> nothing to destroy And the file postgres.so exists and the path in the file openser.cfg is corrcet.Who can help me ,thank you! Junjie Zhao 2007-03-15

2 1

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