[OpenSIPS-Users] Another error in Opensips 1.5

2009-02-18 Thread bay2x1
I have no idea on how to solve this problem. Below is the error log Feb 19 15:20:02 ws16 cdrtool[4390]: Normalize datasource asterisk_vm, database DB_radius, table asterisk_cdr Feb 19 15:20:02 ws16 cdrtool[4390]: Normalize lock id 96 aquired for asterisk_vm:asterisk_cdr Feb 19 15:20:02 ws16 cd

Re: [OpenSIPS-Users] opensips 1.5 crashes during start up with openxcap

2009-02-18 Thread bay2x1
Thanx Anca Vamanu-2 your info was a great help for me... bay2x1 wrote: > > Thanx for your immediate response. May I know on what database would I be > looking? As of now I am confused on what database to look at... > > > > Anca Vamanu-2 wrote: >> >> Hi, >> >> As you can see from the erro

Re: [OpenSIPS-Users] opensips 1.5 crashes during start up with openxcap

2009-02-18 Thread bay2x1
Thanx for your immediate response. May I know on what database would I be looking? As of now I am confused on what database to look at... Anca Vamanu-2 wrote: > > Hi, > > As you can see from the error messages - there is a table version error. > You can go and fix this in the database - tabl

Re: [OpenSIPS-Users] opensips 1.5 crashes during start up with openxcap

2009-02-18 Thread Anca Vamanu
Hi, As you can see from the error messages - there is a table version error. You can go and fix this in the database - table version ( update version set table_version=table_version+1 where table_name="presentity") or you can drop the database and rebuild it with the script. I warn you that the

Re: [OpenSIPS-Users] OpenSIPS libmysqlclient.so segfault after MySQL restart

2009-02-18 Thread Om Bikram Thapa
Hi Bogdan, Just updated to latest svn, but I still see crashes after MySQL restart. The syslog shows following 3 lines after MySQL restart and registration attempt: -- Feb 19 12:17:43 proxy /usr/local/sbin/opensips[2333]: ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed: (1)

Re: [OpenSIPS-Users] What is wrong with my client.conf file for radius?

2009-02-18 Thread bay2x1
This is the error log Feb 19 14:44:27 [3402] INFO:xlog:mod_init: initializing... Feb 19 14:44:27 [3402] INFO:siptrace:mod_init: initializing... Feb 19 14:44:27 [3402] INFO:acc:mod_init: initializing... Feb 19 14:44:27 [3402] ERROR:acc:init_acc_rad: acc: can't get code for the Sip-Response-Code at

Re: [OpenSIPS-Users] OpenSIPS libmysqlclient.so segfault after MySQL restart

2009-02-18 Thread Om Bikram Thapa
Thanks Bogdan. I will update and let you know. Regards, Om. On Thu, Feb 19, 2009 at 2:48 AM, Bogdan-Andrei Iancu wrote: > Hi Om, > > There is a fix available on SVN - please update and see if it works now. > > Thanks and regards, > Bogdan > > Om Bikram Thapa wrote: >> >> Hi Bogdan, >> >> I have

Re: [OpenSIPS-Users] Regarding opensipsctl error

2009-02-18 Thread Ranganath B
Hi Bogdan, Finally I was able to solve the issue by downloading and installing the no-tls version which is "opensips-1.4.4-notls_src.tar.gz" from opensips.orgwebsite. So I feel that scripts located or packaged with "opensips-1.4.4-tls_src.tar.gz" might still have issues. Also I would like to admit

[OpenSIPS-Users] opensips 1.5 crashes during start up with openxcap

2009-02-18 Thread bay2x1
I have recently upgraded to version opensips 1.5 and encountered this error with openxcap Feb 19 09:43:36 [16111] INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected) Feb 19 09:43:36 [16113] NOTICE:core:main: version: opensips 1.5.0dev5-tls (i386/linux) Feb 19 09:43:36 [1

[OpenSIPS-Users] What is wrong with my client.conf file for radius?

2009-02-18 Thread bay2x1
Please tell me what is wrong with my client.conf configuration... every time I run opensips it crashes and status error appear opensips dead but subsys locked. Thanx in advance for your help! # General settings # maximum login tries a user has login_tries 4 # timeout for all login tries #

Re: [OpenSIPS-Users] ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed: Unknown prepared statement handler (1) given to mysql_stmt_execute

2009-02-18 Thread Bogdan-Andrei Iancu
Hi John, A bug that may cause your problem also was fixed on SVN - please update from SVN trunk and test again. Regard, Bogdan john li wrote: > Hi, > I have install opensips-1.5.0-1 on the Feb 11. > my client can't register and i fonud the follow the line in the syslog: > ERROR:db_mysql:db_mysq

Re: [OpenSIPS-Users] OpenSIPS libmysqlclient.so segfault after MySQL restart

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Om, There is a fix available on SVN - please update and see if it works now. Thanks and regards, Bogdan Om Bikram Thapa wrote: > Hi Bogdan, > > I have submitted the bug on the tracker. > > Thanks, > Om. > > On Tue, Feb 17, 2009 at 3:50 AM, Bogdan-Andrei Iancu > wrote: > >> Hi Om, >> >> Th

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Adam Long
Hey Brett, I used the Memcached::libmemcached (C library wrapper) instead of its pure perl brother Cache::Memcached seems perform about twice as fast for what I'm doing. From: Brett Nemeroff [mailto:br...@nemeroff.com] Sent: Wednesday, February 18, 2009 2:46 PM To: Adam Long Cc: users@

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Brett Nemeroff
Adam, This is great! so in the perl script you were just using the standard memcache libraries? Nice! On Wed, Feb 18, 2009 at 1:01 PM, Adam Long wrote: > Hi Brett, > > > > It was tested with very simple sip signaling. > > I benched with sipp with a very simple stateless script expecting a MESS

[OpenSIPS-Users] OT: Re: millions of routes? what module?

2009-02-18 Thread Brett Nemeroff
Yes you do have to pay.. For North American destinations, the TRA (Traffic Routing Administation) maintains a database called LERG (Local Exchange Routing Guide). This has a lot more information than you really need, but in the very first and seventh of the database tables (they are numbered) you c

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Adam Long
Hi Brett, It was tested with very simple sip signaling. I benched with sipp with a very simple stateless script expecting a MESSAGE req and essentially just replying with 200 OK if lookup was successful and 404 if not. I was actually approaching 2cps with 2 sipp clients but somewhere

Re: [OpenSIPS-Users] Help proxy authentication/www_authroize

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Khan, do you set the "calculate_ha1" parameter in auth_db? because the default value indicates that you have in DB a HA1 and not a plain text password. (see: http://www.opensips.org/html/docs/modules/1.4.x/auth_db.html#id228159). So, if you have the plain-text passwords in the "password" fi

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Noel R. Morais
Hi Brett, I'm out of topic here. I'm curious about local number portability in US. How do I know what the provider of a number is? Do I have to pay to know that? Thanks, Noel On Wed, Feb 18, 2009 at 12:24 PM, Brett Nemeroff wrote: > So are you putting in full DIDs for the ported numbers? > >

[OpenSIPS-Users] Help proxy authentication/www_authroize

2009-02-18 Thread Khan
Hello everyone, Can someone help me or point me in direction to resolve some authenticaion errors. Currently I m having problems with UAC outside network, it gives me authentication problem. I need to understand the followings: 1. www_authorize("", "subscriber") checks in subscriber table but wha

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Brett Nemeroff
Great! Thanks for the stats... Are those lookups independent of SIP signalling? I know memcache supports well over 10K/sec.. Just curious if you'll get that performance with the perl libs in the middle. -Brett On Wed, Feb 18, 2009 at 12:11 PM, Adam Long wrote: > I currently do this with 1.4.4

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Adam Long
I currently do this with 1.4.4 via perl and I use perl's libmemcached wrapper to vastly improve performance. I benched over 1 lookups per sec on a QC with mostly cached hits. With a full stateful routing script I would expect only a 1/10th that but still very good. I'm sure the 1.5 c bas

Re: [OpenSIPS-Users] Lawful intercept

2009-02-18 Thread Adrian Georgescu
Hi Mauro, MSRP is used for NAT traversal of Instant Messaging sessions and not for RTP streams. Adrian On Feb 18, 2009, at 6:22 PM, Mauro Davi' wrote: Hi All, I need to introduce in my architecture a network element that can permit the lawful interceptions. I see that there is an AG P

Re: [OpenSIPS-Users] Profile feature not working

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Mayama, Yes, I noticed that the function was not documented, so I just updated the docs (also put some note for all the functions that require create_dialog() before): http://www.opensips.org/html/docs/modules/devel/dialog.html#id272005 Thanks and regards, Bogdan mayamatakeshi wrote: > > On

Re: [OpenSIPS-Users] Lawful intercept

2009-02-18 Thread Brett Nemeroff
In a pure opensips/rtpproxy environment I don't think there isn anything that can do that today. However, there is a start_recording feature that works with rtpproxy to send rtp to a file.. That's the closest I can think of. And that hardly would meet CALEA requirements.. -Brett On Wed, Feb 18, 2

Re: [OpenSIPS-Users] Profile feature not working

2009-02-18 Thread mayamatakeshi
On Thu, Feb 19, 2009 at 2:18 AM, Bogdan-Andrei Iancu wrote: > Hi, > > in 1.5, do "create_dialog();" before using the profiling functions > Hello, Bogdan, thanks, it worked. But this is not yet documented. The page below still says a dialog is created using the "dlg_flag": http://www.opensips.org

[OpenSIPS-Users] Lawful intercept

2009-02-18 Thread Mauro Davi'
Hi All, I need to introduce in my architecture a network element that can permit the lawful interceptions. I see that there is an AG Projects MSRP Relay. The goal is to send the mixed received RTP Audio stream from the two parties to an another PSTN gateway... Is there somebody that had res

Re: [OpenSIPS-Users] Profile feature not working

2009-02-18 Thread Bogdan-Andrei Iancu
Hi, in 1.5, do "create_dialog();" before using the profiling functions Regards, Bogdan mayamatakeshi wrote: > Hello, > I just got the latest svn revision 5330. > I'm trying to use the profile feature of the dialog module to limit > the number of simultaneous calls for a given subscriber. > I go

[OpenSIPS-Users] Profile feature not working

2009-02-18 Thread mayamatakeshi
Hello, I just got the latest svn revision 5330. I'm trying to use the profile feature of the dialog module to limit the number of simultaneous calls for a given subscriber. I got these errors: Feb 19 01:28:37 ipx029 /usr/local/sbin/opensips[23050]: ERROR:dialog:set_dlg_profile: dialog was not yet

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Adrian Georgescu
Besides ported numbers, which are exception based and for which, you need to have some database, the LCR however is something that can be optimized. I have clients who confronted with same problem simply prefer to throw more data at the database and look for improving the algorithms rather

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Brett Nemeroff
So are you putting in full DIDs for the ported numbers? In the US, the incumbant providers perform the LNP (Local Number Portability) lookups and there are large national databases that store this information. I've worked with a couple of independent LNP data providers to route based on an XML qu

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Jeff Pyle
We're running into the same situation here in the states. In fact, we can't know the true "home" of a number because of porting until we do an expensive LRN dip in an external database. Once we know that, we'll have to compute the costs of all the potential carriers (I have 6 at the moment), sort

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Noel R. Morais
I'm pretty sure. I'm from Brazil and here we have number portability "feature". Today we have 140 millions of cell phone numbers and 100 millions of landline numbers, so, 240 millions of numbers that can be ported to another provider. if only 5% of the people decide to port their numbers, I will

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Noel, As Brett already recommended, use the Drouting module as it is the only one able to cope with so large amount of data in an efficient way. See here some performance considerations: http://www.opensips.org/html/docs/modules/devel/drouting.html#id227252 Actually there was a guy on t

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Gustavo Mistrinelli
Thanks Brett, I'll take a look at the new module :) On Wed, Feb 18, 2009 at 12:47 PM, Brett Nemeroff wrote: > Hi Gustavo,I'm doing something similar, being that I need a lookup per > INVITE. Bogdan's recommendation for me was to use the memcaching functions > in 1.5: > http://www.opensips.org/in

Re: [OpenSIPS-Users] Module Question - Memory Lookup

2009-02-18 Thread Brett Nemeroff
Great.. got it.. I look forward to trying it out.. Thanks! -Brett On Wed, Feb 18, 2009 at 8:58 AM, Bogdan-Andrei Iancu wrote: > Hi Brett, > > sorry for not being more explicit :). > > The "memcache" is a generic support provided by the core, so the functions > to use this functionality are in c

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Ovidiu Sas
If you mix up ratedecks from at least three different NA carriers (NPA/NXX/B) you can easily end up with 1.5 mil routes ... Regards, Ovidiu Sas On Wed, Feb 18, 2009 at 9:49 AM, Brett Nemeroff wrote: > I am curious, tho, why it's so big. I've done large, multi-carrier LCR > tables with some prefi

Re: [OpenSIPS-Users] Regarding opensipsctl error

2009-02-18 Thread Bogdan-Andrei Iancu
When setting the "DBENGINE=MYSQL ", what is the output on opensipsctl ? Regards, Bogdan Ranganath B wrote: > Hi Bogdan, > > I have already configured the DBENGINE=MYSQL in the opensipsctlrc > file. Not sure why these parameters are not being read from that file? > Any pointers? > > Regards, > Ra

Re: [OpenSIPS-Users] Module Question - Memory Lookup

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Brett, sorry for not being more explicit :). The "memcache" is a generic support provided by the core, so the functions to use this functionality are in core. This support is implemented by the localcache module and in the future by other modules. See: http://www.opensips.org/index.p

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Brett Nemeroff
I am curious, tho, why it's so big. I've done large, multi-carrier LCR tables with some prefixes down to like 7 digits and it never seems to get bigger than 700,000 to 1,000,000 routes.. Are you sure your routing is "sane" :) -Brett On Wed, Feb 18, 2009 at 8:46 AM, Adrian Georgescu wrote: > Wow!

Re: [OpenSIPS-Users] User inbound rules

2009-02-18 Thread Brett Nemeroff
Hi Gustavo,I'm doing something similar, being that I need a lookup per INVITE. Bogdan's recommendation for me was to use the memcaching functions in 1.5: http://www.opensips.org/index.php?n=Resources.DocsTutMemcache On Wed, Feb 18, 2009 at 8:45 AM, Gustavo Mistrinelli wrote: > Hi all, I'm tryi

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Adrian Georgescu
Wow! The mother of all LCR tables. I though is just a myth. Can it get even bigger? Just kidding :-) Adrian On Feb 18, 2009, at 3:43 PM, Noel R. Morais wrote: Hi Guys, I need to build a proxy that should be able to handle millions of routes, something near 10 millions :D What is the be

[OpenSIPS-Users] User inbound rules

2009-02-18 Thread Gustavo Mistrinelli
Hi all, I'm trying to figure out if we can use or add functionalities to dynamic routing module to do "incoming routing" based on callee destination ($ru) per user The idea is to have inbound rules per user (username/domain or user aliases i.e. numbers ) Each user will set their incoming rules, i.e

Re: [OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Brett Nemeroff
I'm pretty sure the going recommendation is droute. Let us know how that goes. I don't think anyone has actually used it with that many.. -Brett On Wed, Feb 18, 2009 at 8:43 AM, Noel R. Morais wrote: > Hi Guys, > > I need to build a proxy that should be able to handle millions of > routes, some

[OpenSIPS-Users] millions of routes? what module?

2009-02-18 Thread Noel R. Morais
Hi Guys, I need to build a proxy that should be able to handle millions of routes, something near 10 millions :D What is the best module to use in this case? carrierroute or droute? does anybody have experience in installations like that? thanks, Noel

Re: [OpenSIPS-Users] R: Missing call control module!

2009-02-18 Thread Adrian Georgescu
There is no reason not to work. Is just that 1.4 was frozen for new features like this, this is why it was added to 1.5.0. Adrian On Feb 18, 2009, at 2:44 PM, Mauro Davi' wrote: I compile the call_control module against the 1.4.2 and 1.4.4 opensips version, and seems to work... I create a s

Re: [OpenSIPS-Users] Module Question - Memory Lookup

2009-02-18 Thread Brett Nemeroff
Ok, I hadn't seen the module for memcache in the docs. I did see localcache, but it doesn't export the caching functions. So I wasn't sure it was ready yet. Is the localcache module just the standard memcache server daemon built into opensips? And, if I'm using my own memcache server, how do I spe

[OpenSIPS-Users] R: Missing call control module!

2009-02-18 Thread Mauro Davi'
I compile the call_control module against the 1.4.2 and 1.4.4 opensips version, and seems to work... I create a server application that communicate with the call_controll module and I receive the INIT, START and STOP messages. Is it only an impression? -Messaggio originale- Da: users-bo

Re: [OpenSIPS-Users] SipSimpleClient-Issues

2009-02-18 Thread JayaPrakash
Adrian, Thank you. Thanks & Regards, JayaPrakash.Manchu. On Wed, Feb 18, 2009 at 4:50 PM, Adrian Georgescu wrote: > On Feb 18, 2009, at 12:11 PM, JayaPrakash wrote: > > Hi All, > > Sip Simple Client is installed. > Creating accounts at sip2sip.info, When tested sip_register, > sip_subscriber_

Re: [OpenSIPS-Users] SipSimpleClient-Issues

2009-02-18 Thread Adrian Georgescu
On Feb 18, 2009, at 12:11 PM, JayaPrakash wrote: Hi All, Sip Simple Client is installed. Creating accounts at sip2sip.info, When tested sip_register, sip_subscriber_presence, sip_subscriber_winfo, xcap_pres_rules, xcap_rls_services are properly functioning. When try to put or delete the xml

[OpenSIPS-Users] SipSimpleClient-Issues

2009-02-18 Thread JayaPrakash
Hi All, Sip Simple Client is installed. Creating accounts at sip2sip.info, When tested sip_register, sip_subscriber_presence, sip_subscriber_winfo, xcap_pres_rules, xcap_rls_services are properly functioning. When try to *put* or *delete* the xml rules like, pres_rules, rls_services it is giving t

Re: [OpenSIPS-Users] Regarding opensipsctl error

2009-02-18 Thread Ranganath B
Hi Bogdan, I have already configured the DBENGINE=MYSQL in the opensipsctlrc file. Not sure why these parameters are not being read from that file? Any pointers? Regards, Ranga On 2/18/09, Bogdan-Andrei Iancu wrote: > Hi Ranga, > > You must not force manually the DBENGINELOADED !! you have to s

Re: [OpenSIPS-Users] OpenSIPS libmysqlclient.so segfault after MySQL restart

2009-02-18 Thread Bogdan-Andrei Iancu
I see Let me try to reproduce thisThanks for the update! Regards, bogdan Om Bikram Thapa wrote: > Hi Bogdan, > > Just to follow up on this issue, the crash is happening even without > restarting MySQL server. It seems to show up every morning when > registration (or maybe any db operatio

Re: [OpenSIPS-Users] Regarding opensipsctl error

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Ranga, You must not force manually the DBENGINELOADED !! you have to set DBENGINE=MYSQL in the opensipsctlrc file. Regards, Bogdan Ranganath B wrote: > Hi Bogdan, > > I am using MySQL as the backend DB and I am trying to run the > following commands: > > 1) /usr/local/sbin/opensipsctl doma

Re: [OpenSIPS-Users] Module Question - Memory Lookup

2009-02-18 Thread Bogdan-Andrei Iancu
Hi Brett, You can use the memcache module for 1.5 - but for 1.4 there is nothing similar in there. Anyhow, the module, even new (memcache) should be quite stable as it was well tested and the complexity is not too high. Regards, Bogdan Brett Nemeroff wrote: > Hi All, > Sorry for such simp

Re: [OpenSIPS-Users] ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute() failed: Unknown prepared statement handler (1) given to mysql_stmt_execute

2009-02-18 Thread Bogdan-Andrei Iancu
Hi john, It may be the same problem as reported on the project tracker about prepared statements crashing after a disconnect from the mysql server. See: https://sourceforge.net/tracker/index.php?func=detail&aid=2608188&group_id=232389&atid=1086410 Regards, Bogdan john li wrote: > Hi, > I h

Re: [OpenSIPS-Users] Regarding opensipsctl error

2009-02-18 Thread Ranganath B
Hi Bogdan, If we don't hardcode the DBENGINELOADED=1 value we receive the following error: WARNING: database engine not found - tried 'MYSQL' ERROR: This command requires a database engine - none was loaded Thanks in advance, Ranga On 2/18/09, Ranganath B wrote: > Hi Bogdan, > > I am using MyS