sr-users

sr-users@lists.kamailio.org

4 participants
37456 discussions

[Users] postgres
by Mark Price 20 Dec '06

20 Dec '06

Hi, What is the best way to use postgres with openser? Is postgres a viable option? I ask, because the install script appears to be broken. If I am able to fix it well enough create the necessary tables, will it be fit for use? As an example, there are several errors in the openser_postgres.sh that comes with openser 1.1 In particular, there are instances where the following is done: create table a ( field type, index a_idx(field) ); However, postgres requires syntax like this: create table a ( field type ); create index a_idx on a (field); Thanks.

2 1

[Serusers] How to change charset in SER for IM
by Killer 20 Dec '06

20 Dec '06

Hi ! Can someone tell how to change the charset in SER ? I want to send IMs which also shows german letters like "ß" ... I also get these Errors and even google couldnt help me :-( , how to erase these erros WARNING: run_actions: null action list (rec_level=1) 2(4154) ERROR: fifo_server: command must have at least 3 chars 2(4154) ERROR: fifo_server: command must have at least 3 chars Thanks a lot for your answers Ahsen ___________________________________________________________ Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de

2 1

[Users] Mysql reconnect problem
by Dimo 20 Dec '06

20 Dec '06

Hi All, I have a problem with openser reconnecting to my redundant mysql servers which hold the openser database. The database servers are in a cluster and if one fails the other takes over its IP address. In openser however the connection to the database is established only (i think) at the beginning. So when openser is running and one of my sql servers drops, and the other takes over the IP, i get an error in openser saying that the mysql connection does not exist. Is there a way to make openser reconnect to mysql automatically without restarting it or some other way I can make this work? Best, Dimo

4 6

[Serusers] cannot find directory /src/sip_router/tools/serct
by Franz-Ferdinand Lehnert 20 Dec '06

20 Dec '06

Hello fellows I was looking for the 'magic' scripts (http://ftp.iptel.org/pub/ser/presence/presence-handbook/ar01s07.html) to initialize the postgres data base for ser 0.10xxx (latest snapshot from today) quite some time, but could not find the folder 'src/sip_router/tools' to use the new serctl. Even my search with google gave no result. Can someone help me please? Kind regards leffe

3 3

Re: [Serusers] Help! Run SER with MySQL to do authentication
by Greger V. Teigre 20 Dec '06

20 Dec '06

Copy the list. Well, "libmysqlclient.so.14: cannot open shared object file: No such file or directory" pretty much says it all, right? Your LD_LIBRARY_PATH environment variable must include your library dirs before starting ser (cumbersome) or you need to add /usr/lib/mysql to your /etc/ld.so.conf file (which btw should have been updated when installing mysql, I don't know why it didn't happen for you). g-) Tako Chang wrote: > Thanks!! > I ran make_and_install script > But i still can't run 'auth-mysql.cfg' > Error message : > load_module: could not open module > </usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.14: cannot > open shared object file: No such file or directory > > but I have libmysqlclient.so.14 at "/usr/local/lib/mysql" > What should I do?? > > Thanks for your help <(_ _)> > > I mentioned that someone talked about the version of mysql > So, i download the older version 4.1.22 > 2006/12/6, Greger V. Teigre < greger(a)teigre.com > <mailto:greger@teigre.com>>: > > Look at the make_and_install script in the scripts package (same > place). It does this for you. mysql-devel must be installed. > g-) > > Tako Chang wrote: >> Hi, all >> >> First of all, I read [SER - Getting Started >> <http://siprouter.onsip.org/doc/gettingstarted/>] and downloaded >> [ SER Source package >> <ftp://siprouter.onsip.org/pub/gettingstarted/packages/ser-0.9.7-pre1.Gettin…>] >> >> after I make the package under debug mode, it runs well. >> Now, I can receive REGISTER requests and send 200 OK Responses >> and play a SIP proxy server >> >> I want to test "auth_mysql.cfg" in Chapter 7.... so, >> i remove "exclude_modules?= jabber mysql\" in Makefile >> but i still can't compile the mysql.so >> >> Is there some more detail documents or suggestions for me? >> >> Thank! >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Serusers mailing list >> Serusers(a)lists.iptel.org <mailto:Serusers@lists.iptel.org> >> http://lists.iptel.org/mailman/listinfo/serusers >> > >

2 2

[Users] (PR)ACK problem with uac_replace_from
by Jeff Williams 20 Dec '06

20 Dec '06

I seem to have an issue with uac_replace_from. I am using openser as a media proxy. For invites I replace the numbers with leading 0's with 61 for Australia and forward the call to our LCR box which then forwards the call to the correct voice to pstn gateway. I am trying to use uac_replace_from to set the from address so the callerid appears correct on the outgoing calls. This seems to work fine for the INVITE request, but on subsequent PRACKs and ACKs (which just get loose routed), something strange happens to the from address. On invite, the From get re-written: From: Jeff <sip:610089001@proxy.sipone.com;user=phone>;tag=1790577941 to From: Jeff <sip:0892209080@sipone.com>;tag=1790577941 For the PRACKs and ACKs, this happens: From: Jeff <sip:610089001@proxy.sipone.com;user=phone>;tag=1790577941 to From: Jeff <\032\317\352S\232\222B\230\234K\231*BV\300\030\303\332\ah\303\306i\365\005\016\200\250\000\000\230\016\200\252j\200\002`\000\000\016>;tag=1790577 941 There shouldn't be anything happening to the From address on the (PR)ACKs at all. Anyone have any ideas? I have attached a ethereal dump of the call setup. Jeff

2 2

[Users] RE: [Serusers] Recommend ATA adaptor ?
by johnk＠koreanet.us 19 Dec '06

19 Dec '06

Thanks for quick reponse. Actually I agree with you fully but the only reason for looking at other choice is that I ran out of ideas to resolve this Sipura "hang up" situations where OpenSER logs "forward_reply" error and Mediaproxy's missing stop-time for the call. The only way of getting around was to setup Sipura to use Outbound proxy of same server, which I dearly want to avoid in production. Any idea how to resolve the issue? > You won't find anything better than Sipura/ Linksys. I tried a lot and it > is > worth it to make a script to configure instead of looking for others. > There > is a lot of trash around also. > > Regards CFM > > -----Original Message----- > From: serusers-bounces(a)lists.iptel.org > [mailto:serusers-bounces@lists.iptel.org] On Behalf Of johnk(a)koreanet.us > Sent: Tuesday, December 19, 2006 3:04 PM > To: serusers(a)iptel.org > Subject: [Serusers] Recommend ATA adaptor ? > > Hi, > > Can someone recommend ATA models that work easy with Openser, based on > experience? > > I am currently using Sipura SPA3000 and PAP2 which are highly configurable > but at the same time, need much works with trial and error fashion to get > them work with Openser, Freeradius, Mediaproxy and CDRTool combination. > > Especially, I am not quite sure if these are handling "VIA" header > correctly. Because setting up Outbound proxy was the only solution I > found > to get these units send "BYE" to the server, otherwise it will send "BYE" > directly to PSTN gateway, resulting forward_reply error, killing a child > process and mediaproxy never had a chance to mark "stop time" for acc. > > Can anyone suggest ATAs that imposes least burden of configuration to work > with the setting above? > > Thanks mush in advance. > > John K. > > > > > > > _______________________________________________ > Serusers mailing list > Serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.15.24/592 - Release Date: > 12/18/2006 > 1:45 PM > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.15.24/592 - Release Date: > 12/18/2006 > 1:45 PM > > >

1 0

[Users] Recommend ATA adaptor ?
by johnk＠koreanet.us 19 Dec '06

19 Dec '06

Hi, Can someone recommend ATA model that works easy with Openser, based on experience? I am currently using Sipura SPA3000 and PAP2 which are highly configurable but at the same time, need much works with trial and error fashion to get them work with Openser, Freeradius, Mediaproxy and CDRTool combination. Especially, I am not quite sure if these are handling "VIA" header correctly. Because setting up Outbound proxy was the only solution I found to get these units send "BYE" to the server, otherwise it will send "BYE" directly to PSTN gateway, resulting forward_reply error, killing a child process and mediaproxy never had a chance to mark "stop time" for acc. Can anyone suggest ATAs that imposes least burden of configuration to work with the setting above? Thanks mush in advance. John K.

1 0

[Users] re: how to pass the Caller ID into uac_replace_from function ?
by don lin 19 Dec '06

19 Dec '06

Hi there, We have a Postgres Database to store the users' informations before we use Openser. To integrate between Postgres and Openser, we write external C programs and call them from Openser with exec_dset function. The issue we have now is with the Caller ID. When the user makes a call to PSTN number from SIP devices (soft phone or hard phone), the telco carrier requests us to send a numerical Caller ID, not the SIP format (such as john.dow(a)abc.com). What I am doing is to add the Caller ID field into the Postgres for each user and write a C program to query the Caller ID field, then Openser calls it with exec_dset functioin. However, I did not find a way to define a variable in Openser to store this Caller ID and pass it to uac_replace_from function. Appreciate for any suggestions. Jeff, You mentioned that you replaced the From Header, may I ask how you do it ? Thanks and Regards, Don ------------------------------ <Message: 4 <Date: Tue, 19 Dec 2006 11:11:09 +0900 <From: Jeff Williams <jeffw(a)globaldial.com> <Subject: [Users] (PR)ACK problem with uac_replace_from <To: users(a)openser.org <Message-ID: <45874A3D.5070206(a)globaldial.com> <Content-Type: text/plain; charset="iso-8859-1" <I seem to have an issue with uac_replace_from. <I am using openser as a media proxy. For invites I replace the numbers <with leading 0's with 61 for Australia and forward the call to our LCR <box which then forwards the call to the correct voice to pstn gateway. <I am trying to use uac_replace_from to set the from address so the <callerid appears correct on the outgoing calls. <This seems to work fine for the INVITE request, but on subsequent PRACKs <and ACKs (which just get loose routed), something strange happens to <the from address. <On invite, the From get re-written: <From: Jeff <sip:610089001@proxy.sipone.com;user=phone>;tag=1790577941 <to <From: Jeff <sip:0892209080@sipone.com>;tag=1790577941 <For the PRACKs and ACKs, this happens: <From: Jeff <sip:610089001@proxy.sipone.com;user=phone>;tag=1790577941 <to <From: Jeff <<\032\317\352S\232\222B\230\234K\231*BV\300\030\303\332\ah\303\306i\365\005\016\200\250\000\000\230\016\200\252j\200\002`\000\000\016>;tag=1790577 <941 <There shouldn't be anything happening to the From address on the <(PR)ACKs at all. <Anyone have any ideas? <I have attached a ethereal dump of the call setup. <Jeff __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

[Users] How can we do Calling Card System with OpenSER
by raviprakash sunkara 19 Dec '06

19 Dec '06

Hello Users First of All Advance "Marry Chrimas " Is How can we do the Calling Card System with OpenSER, I don't want the route every call to Asterisk ( PBX feature ) and other How can we perform the Billing System in OpenSER for Post Paid anf PrePaid Billing Systeem In Asterisk it can do it... by thrid party open Source .... My main intension is with OpenSER with Calling Card System -- Thanks and Regards Ravi Prakash Sunkara ravi.sunkara(a)hyperion-tech.com M:+91 9985077535 O:+91 40 23114549 F:+91 40 40208727 ravi.sunkara(a)hyperion-tech.com www.hyperion-tech.com

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