[OpenSIPS-Users] Blind call forwarding in OpenSIPS

[Bogdan-Andrei Iancu]

Yes, the note about the AVP name is 100% correct. Even if at the 
opensips cfg level it is ok and the actual name of the AVP will be 
"s:callfwd", it will not match the naming from the DB table.

So just drop the "s:" prefix in the avp name at the script level.

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com
OpenSIPS Summit 2020 online
   https://www.opensips.org/events/Summit-2020Distributed/

On 9/9/20 5:08 PM, Brett Nemeroff wrote:
> Hello Nayani,
> Your avp spec is for a much older version of OpenSIPs. I'm not sure if 
> that's your problem or not, but the "s:" syntax is dated for 2.4.x.
>
> Here's the documentation you should reference for your version of 
> OpenSIPs:
> https://opensips.org/html/docs/modules/2.4.x/avpops.html#func_avp_db_load
>
> Also, see Bogdan's comment above, did avp_db_load return false?
>
> Just my perspective, but for these kinds of "DB Loads", I almost 
> always prefer a avp_db_query over a avp_db_load. The syntax is clearer 
> for me, but I also just really like SQL to begin with. The original 
> avp_db_load syntax was more inline with how OpenSIPs/OpenSER works 
> from "back in the day". Would love other's feedback on that. Perhaps 
> avp_db_load is easier for simple matches, but I think under the hood 
> it's just doing a simple query anyway. avp_db_query just gives you 
> full access to the actual SQL if you are into that kind of thing.
>
> -Brett
>
>
>
>
>
> On Wed, Sep 9, 2020 at 12:25 AM Nayani Nikeshala via Users 
> <users at lists.opensips.org <mailto:users at lists.opensips.org>> wrote:
>
>     Hi!
>
>     I'm using OpenSIPS 2.4.7. With the below script, call was not
>     forwarded as configured. Is there any issue with my script or is
>     there an alternative method to do this ?
>
>
>
>     On Tuesday, September 8, 2020, 10:48:27 PM GMT+5:30, Bogdan-Andrei
>     Iancu <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>
>     Hi,
>
>     What version of OpenSIPS do you use ? And your experience is that
>     the avp_db_load fails ?
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>
>     OpenSIPS Founder and Developer
>        https://www.opensips-solutions.com
>     OpenSIPS Summit 2020 online
>        https://www.opensips.org/events/Summit-2020Distributed/
>
>     On 9/7/20 1:51 PM, Nayani Nikeshala via Users wrote:
>     Hello,
>
>     I'm trying to do a simple blind call forwarding with the below
>     script added into "main request routing logic". (123 dials 789 and
>     789 is forwarded to 456)
>
>
>     if(avp_db_load("$ru","$avp(s:callfwd)")) {
>
>     $ru = $avp(s:callfwd);
>
>     xlog("forwarded to: $avp(s:callfwd)");
>
>     route(1);
>
>     exit;
>
>     }
>
>
>     My usr_preferences table is as below.
>
>     opensips=> select * from usr_preferences;
>
>     id | uuid | username | domain | attribute | type |value|last_modified
>
>     ----+------+----------+--------+-----------+------+------------------------+---------------------
>
>     1 || 789|| callfwd|0 | sip:456 at xxxxxxxxxxx| 1900-01-01 00:00:01
>
>     (1 row)
>
>     opensips=>
>
>     I have added the avpops module as below.
>
>     #AVPOPS module
>
>     loadmodule "avpops.so"
>
>     modparam("avpops",
>     "db_url","postgres://opensips:xxxxxxxx@localhost/opensips")
>
>     modparam("avpops","avp_table","usr_preferences")
>
>     Anyways, this script does not do the call forwarding task. Anyone
>     could help on this please. Could there be a problem of the
>     position that I have added the script in "main request routing
>     logic".
>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200910/cb3bc6f9/attachment-0001.html>