Hi there,<br><br> I saw all of you discussed about the postgres and I do have a question which somewhat related to postgres as well (please refer to the end of this email for detail). <br> My question is that I have Caller ID (regular phone number) mapping to a SIP account stored in postgres, when I call from SIP device to a PSTN phone, telco carrier does not accept the SIP From field and requested to use regular phone number. I use exec_msg to call the external C program which read the Caller ID mapping to SIP account. However, I do not know how to pass this Caller ID into uac_replace_from. <br> Were the postgres version work for this purpose ? Please advise if you have any suggestion. Thanks in advance,<br><br>Don<br>------------------------------<br><br>Message: 5<br>Date: Thu, 21 Dec 2006 12:20:47 +0200<br>From: Daniel-Constantin Mierla <daniel@voice-system.ro><br>Subject: Re: [Users] postgres<br>To: Klaus Darilion
<klaus.mailinglists@pernau.at><br>Cc: users@openser.org<br>Message-ID: <458A5FFF.4060003@voice-system.ro><br>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br><br>Hello Klaus,<br><br>On 12/21/06 12:05, Klaus Darilion wrote:<br>> Hi Daniel!<br>><br>> I've checked the postgres script: rel_1_1_0 works fine, but there is <br>a <br>> problem in unstable: The domain for the default admin user is asked <br>> not for serweb tables but for the plain openser tables as well. Also <br>> the subscriber table includes all the serweb columns even if serweb <br>> tables are not installed.<br>I think a merge with mysql version, with an option to say the <br>underlaying DB engine is the right solution, to be easy to maintain -- <br>same as we did with openserctl. I will have that in mind, but the best <br>will be to register it to tracker.<br><br>Cheers,<br>Daniel<br><br>><br>> regards<br>> klaus<br>><br>><br>>
Daniel-Constantin Mierla wrote:<br>>> Hello,<br>>><br>>> On 12/20/06 19:36, Mark Price wrote:<br>>>><br>>>><br>>>> On 12/20/06, *Klaus Darilion* < klaus.mailinglists@pernau.at <br>>>> <mailto:klaus.mailinglists@pernau.at>> wrote:<br>>>><br>>>> Hi Mark!<br>>>><br>>>> Postgres should work well - I use it since ser 0.8. Just make <br>sure<br>>>> that<br>>>> the hard disk does not get full, because this breaks the index <br>>>> inside<br>>>> postgres and postgres is getting real slow (re-create the index <br>>>> if it<br>>>> happens).<br>>>><br>>>> Last time I tested openser_postgres.sh it worked fine. If you
<br>find<br>>>> a bug<br>>>> please let us know.<br>>>><br>>>> Please check to use the latest versions from CVS (for 1.1 use <br>CVS<br>>>> rel_1_1_0)<br>>>><br>>>><br>>>> The latest version from cvs doesn't work out of the box with <br>openser <br>>>> build from the release tarball, because the release tarball doesn't <br>>>> included /usr/sbin/openser_gen_ha1 (although I could get past this <br>>>> by replacing it with the md5sum equivelant).<br>>>><br>>>> However, the release tarball doesn't work because of this bug:<br>>>> <br>https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1518732&group_id=139143 <br>>>> <br><https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1518732&group_id=139143>
<br>>>><br>>>><br>>>> So, 1. is the cvs version of rel_1_1_0 considered safe for <br>>>> production use?<br>>><br>>> yes, it is the most recommended version to use -- several issues <br>were <br>>> found and fixed since 1.1.0 release.<br>>><br>>>> 2. if so and there are important fixes such as this in CVS, <br>>>> would openser.org <http://openser.org> consider<br>>>> releasing a point release containing such changes? <br>>> It is an option, and perhaps should be taken in consideration, as <br>>> patch release with not so much packaging.<br>>><br>>> This may help some which want to maintain platforms updated, it is <br>>> exampled with 1.0.x, bust just replace the version with 1.1.0 in the <br>>> document and should work (rel_1_0_0 => rel_1_1_0)<br>>>
http://openser.org/dokuwiki/doku.php/install:openser-from-cvs<br>>><br>>> Cheers,<br>>> Daniel<br>>><br>>><br>>>> Thanks,<br>>>><br>>>> Mark Price<br><br><b><i>don lin <don12lin@yahoo.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Hi there, <br><br> 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. <br> 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@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. <br> 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. <br> Appreciate for any suggestions.<br><br>Jeff,<br> You mentioned that you replaced the From Header, may I ask how you do it ? <br>Thanks and Regards,<br><br>Don<br><br>------------------------------<br><br><Message: 4<br><Date: Tue, 19 Dec 2006 11:11:09 +0900<br><From: Jeff Williams <jeffw@globaldial.com><br><Subject: [Users] (PR)ACK problem with uac_replace_from<br><To: users@openser.org<br><Message-ID: <45874A3D.5070206@globaldial.com><br><Content-Type: text/plain; charset="iso-8859-1"<br><br><I seem to have an issue with uac_replace_from.<br><br><I am using openser as a media proxy. For invites I replace the numbers<br><with leading 0's with 61 for
Australia and forward the call to our LCR<br><box which then forwards the call to the correct voice to pstn gateway. <br><I am trying to use uac_replace_from to set the from address so the<br><callerid appears correct on the outgoing calls.<br><br><This seems to work fine for the INVITE request, but on subsequent PRACKs <br><and ACKs (which just get loose routed), something strange happens to <br><the from address.<br><br><On invite, the From get re-written:<br><br><From: Jeff <sip:610089001@proxy.sipone.com;user=phone>;tag=1790577941<br><to<br><From: Jeff <sip:0892209080@sipone.com>;tag=1790577941<br><br><For the PRACKs and ACKs, this happens:<br><br><From: Jeff <sip:610089001@proxy.sipone.com;user=phone>;tag=1790577941<br><to<br><From:
Jeff<br><<\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<br><941<br><br><There shouldn't be anything happening to the From address on the<br><(PR)ACKs at all.<br><br><Anyone have any ideas?<br><br><I have attached a ethereal dump of the call setup.<br><br><Jeff<div> __________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </div></blockquote><br><p> __________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com