Thanks Again Bogdan, To take advantage of fast db querying, and not have to worry about making sure I am immune to DoS attacks, I opted to go with "db_load":
AVPOPS: http://www.opensips.org/html/docs/modules/1.7.x/avpops.html#id250324 modparam("avpops", "avp_table", "subscriber") modparam("avpops","use_domain",0) modparam("avpops","db_scheme", "scheme0:table=subscriber;uuid_col=username;value_col=rpid") modparam("avpops", "db_url", "mysql://user:sec...@db.server.com/sipproxysdb") branch_route[1] { xlog("L_INFO","New Branch For: $ru at IP: $si\n"); if(is_present_hf("P-Asserted-Identity")) remove_hf("P-Asserted-Identity"); if(is_present_hf("Remote-Party-ID")) remove_hf("Remote-Party-ID"); if(is_present_hf("Privacy")) remove_hf("Privacy"); avp_db_load("$fU","$avp(rpid)/$scheme0"); if(is_avp_set("$avp(rpid)")) append_hf("P-Asserted-Identity: $rpid; user=phone\r\n", "Call-ID"); } In the subscriber table, I have the following for rpid: "Test User" <sip:15555555...@test.server.com>" Enriching Search Engines, Nick. On 4/29/13, Nick Khamis <sym...@gmail.com> wrote: > Get me a position at Ericsson Canada, and I will tell you ;). > > N. > > On 4/29/13, Sukanya R <sukany...@ericsson.com> wrote: >> Hey team, >> >> Do you know if 1.6.2 release of opensip has issues of hanging often, will >> upgrading to 1.8 issue can fix it ? >> >> >> Warm regards, >> Sukanya R >> >> -----Original Message----- >> From: users-boun...@lists.opensips.org >> [mailto:users-boun...@lists.opensips.org] On Behalf Of Bogdan-Andrei >> Iancu >> Sent: Monday, April 29, 2013 7:27 PM >> To: OpenSIPS users mailling list >> Subject: Re: [OpenSIPS-Users] Caller Name and P-Assterted >> >> Use avp_db_load() or avp_db_query() from the avpops module. >> >> Regards, >> >> Bogdan-Andrei Iancu >> OpenSIPS Founder and Developer >> http://www.opensips-solutions.com >> >> >> On 04/29/2013 04:21 PM, Nick Khamis wrote: >>> Hello Bogdan, >>> >>> As usual. Thank you so much! In the past year I learned so much about >>> SIP then I did in the past five using the different media servers. The >>> gateway I sent the PAI hdr seems to accept it, but I the CallID Name >>> part does not seem to be supported by the carrier. Ce la vie... >>> >>> On the question about rpid, I have: >>> "Test User"<sip:15453387...@test.server.com>;user=phone\r\n stored in >>> subscriber.rpid. In the branch and failure routes, I would like to >>> load this value into append_hf. What is the best way of doing this >>> since we do not perform any authentication for registration or invites >>> on our system, and thus no "consume_credentials" >>> >>> >>> Kind Regards, >>> >>> Nick >>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
