[OpenSIPS-Users] Issues with avp_db_query in opensips 2.2.2

Ahmed Munir ahmedmunir007 at gmail.com
Mon Jan 16 10:20:28 EST 2017


Hi,

I've currently upgraded opensips from 1.8.8 to 2.2.2. The issue currently
facing after upgrade as getting error messages and failed to start to
opensips service when using avp_db_query () function like;

$var(res) = avp_db_query("SELECT Outpulse_number,setid FROM
Prefix_data where Program_prefix = $var(pg_prefix)", "$avp(outpluse),
$avp(trunkid)");

Errors below;

ERROR:avpops:__fixup_db_query_avp: no db url defined to be used by
this function
ERROR:core:fix_actions: fixing failed (code=-6) at
//etc/opensips/opensips.cfg:207
CRITICAL:core:fix_expr: fix_actions error
ERROR:core:main: failed to fix configuration with err code -6


Whereas, variable $var(res) is storing return code after executing DB query.

If I add this line: avp_db_query("SELECT 1"); above to my $var(res) db
query, opensips service starts successfully and don't see the errors.

Please advise the steps do I need to take to fix above issues.

BTW, declared avpops 'db_url' in module parameters.

modparam("dispatcher|avpops","db_url","mysql://opensips:opensipsrw@localhost
/opensips")

-- 
Regards,

Ahmed Munir Chohan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20170116/f25a9c40/attachment.html>


More information about the Users mailing list