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
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users