[OpenSIPS-Devel] [opensips] mi_fifo / mi_http fail to reload data (#321)

[Alberto Rinaudo]

Hi,
I'm using version 1.11, from the yum repo.
I tried changing the data in load_balancer and address table, then reload with:
opensipsctl fifo lb_reload
opensipsctl fifo address_reload

result was:
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: INFO:load_balancer:mi_lb_reload: "lb_reload" MI command received!
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: ERROR:db_unixodbc:db_unixodbc_submit_query: rv=-1. Query= select id,group_id,dst_uri,resources,probe_mode from load_balancer 
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: ERROR:core:db_do_query: error while submitting query - [select id,group_id,dst_uri,resources,probe_mode from load_balancer ]
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: ERROR:load_balancer:lb_db_load_data: DB query failed
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: ERROR:load_balancer:load_lb_data: failed to load data from DB
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: CRITICAL:load_balancer:lb_reload_data: failed to load load-balancing info
Sep  4 08:38:15 opensipstest /usr/sbin/opensips[2276]: CRITICAL:load_balancer:mi_lb_reload: failed to load load balancing data


Sep  4 08:38:28 opensipstest /usr/sbin/opensips[2276]: ERROR:db_unixodbc:db_unixodbc_submit_query: rv=-1. Query= select ip,grp,mask,port,proto,pattern,cprefix,id from address 
Sep  4 08:38:28 opensipstest /usr/sbin/opensips[2276]: ERROR:core:db_do_query: error while submitting query - [select ip,grp,mask,port,proto,pattern,cprefix,id from address ]
Sep  4 08:38:28 opensipstest /usr/sbin/opensips[2276]: ERROR:permissions:reload_address_table: failed to query database

Using mi_http produces the same output.
I can see that the db is not hit at all, let me know if I you need any other informations.

---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/issues/321
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20140904/cbd56d13/attachment.htm>