Hi Klaus, <br> <br> Very grateful for your reply. <br> I read about the avp document and did not quite follow it. Also, it mentioned Mysql. Is there any examples for avp and Postgres ?<br> I agree it is not a nice to re-write the From header, would you suggest how to change the remote party id in Openser and I will give it a shot ?<br><br>Thanks and Regards,<br><br>Don<br><br><b><i>Klaus Darilion <klaus.mailinglists@pernau.at></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <br>The subscriber table has a column called rpid (remote party id). There <br>you can put into the number.<br><br>When a user gets authenticated, this rpid is loaded into the rpid AVP:<br>http://www.openser.org/docs/modules/1.1.x/auth.html#AEN115<br><br>Then you can use uac_replace_from with this AVP to rewrite the From header.<br><br>Nevertheless, rewriting the from header is not
very nice.<br><br>The nice solution would be to put the phone number (rpid, remote party <br>id) in the Remote-Party-ID header (e.g. for old Cisco Gateways and <br>Asterisk) or into a P-Asserted-Identity Header (newer Cisco gateways).<br><br>Usually Gateways support either one of this header to set the proper CLI <br>when sending the call into the PSTN.<br><br>regards<br>klaus<br><br>don lin wrote:<br>> 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>>> 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>>>>> 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>> <https: //sourceforge.net/tracker/?func="detail&atid=743020&aid=1518732&group_id=139143"> <br>>>>><br>>>>> So, 1. is the cvs version of rel_1_1_0 considered safe for <br>>>>> production use?<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:> 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>> don lin <don12lin@yahoo.com> wrote: 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="" call="" the="" correct="" voice="" to="" pstn="" gateway=""><br>> <i am="" trying="" use="" uac_replace_from="" to="" set="" 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="" 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 _=""><br>> Do
You Yahoo!?<br>> Tired of spam? Yahoo! Mail has the best spam protection around <br>> http://mail.yahoo.com <br>> <br>> <br>> __________________________________________________<br>> Do You Yahoo!?<br>> Tired of spam? Yahoo! Mail has the best spam protection around <br>> http://mail.yahoo.com <br><br><br>-- <br>Klaus Darilion<br>nic.at<br><br></Jeff></i></Anyone></There></From:></to></sip:610089001@proxy.sipone.com;user=phone></From:></For></sip:0892209080@sipone.com></From:></to></sip:610089001@proxy.sipone.com;user=phone></From:></On></the></and></This></callerid></i></box></with></i></i></Content-Type:></Message-ID:></To:></Subject:></jeffw@globaldial.com></From:></Date:></Message:></don12lin@yahoo.com></http:></https:></mailto:klaus.mailinglists@pernau.at></klaus.mailinglists@pernau.at></daniel@voice-system.ro></blockquote><i seem="" to="" have="" an="" issue="" with="" uac_replace_from=""><i am="" using="" openser="" as="" a="" media=""
proxy="" for="" invites="" i="" replace="" the="" numbers=""><i am="" trying="" use="" uac_replace_from="" to="" set="" from="" address="" so="" the=""><i have="" attached="" a="" ethereal="" dump="" of="" the="" call="" setup=""><br></i></i></i></i><p> __________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com