Hi, Jeff!
Indeed, db_virtual makes perfect sense for what you need. However, we
don't support unixodb in async mode, but I will look into this to see if
the library supportsit.
Regarding REST, does MSSQL support it, or you're thinking of writing a
REST server that converts queries to SQL?
Best regards,
Răzvan Crainea
OpenSIPS Solutions
www.opensips-solutions.com
On 09/07/2016 02:18 PM, Jeff Pyle wrote:
Hi Răzvan ,
Ok. I found this on the 2.2 release info page:
2.27 DB_VIRTUAL module
added async raw query support
I thought I might be able to wrap db_virtual around unixodbc and get
it to work. Apparently not! Or, at least not yet.
My application is to attempt to replace an aging Kamailio proxy with
an OpenSIPS one in async mode. Unfortunately I don't have control
over the data or where it lives; it's stuck in an MSSQL server.
Actually, in a few geographically distributed but otherwise equal
MSSQL servers so the db_virtual layer was perfect.
rest_get is mentioned as an available to async. I don't know much
about rest but I'll look at writing a wrapper of sorts to get to the
stored procedure that way. I'm open to any suggestions!
- Jeff
*From:*[email protected]
[mailto:[email protected]] *On Behalf Of *Razvan Crainea
*Sent:* Wednesday, September 07, 2016 4:07 AM
*To:* [email protected]
*Subject:* Re: [OpenSIPS-Users] 2.2 crash with async, db_virtual and
unixodbc
Hi, Jeff!
Unfortunately async operations are only supported by the MySQL
backend, therefore it won't work with unixodbc or other backends. Now
it crashes because of a mishandling in the db_virtual module. We are
working on a fix for the crash, but even after the fix, you will still
be unable to run async queries with unixodbc.
If you really want to do it async, then you should use MySQL backend.
Also, don't forget to open a feature request on the issues page[1] to
support async queries for unixodbc.
[1] https://github.com/OpenSIPS/opensips/issues
Best regards,
Răzvan Crainea
OpenSIPS Solutions
www.opensips-solutions.com <http://www.opensips-solutions.com>
On 09/07/2016 04:16 AM, Jeff Pyle wrote:
Hello,
I'm working from the 2.2 nightly build repo on Debian Jessie,
64-bit, specifically, 2.2.1~20160830~7261cf0-1.
I have a simple test script that runs a stored procedure on a
Microsoft SQL 2014 server and xlogs the returned AVPs. This works
fine. When I break it up into an async() function and a return
route block, I get a crash every time.
Script:
route {
xlog("L_INFO", "Sending query...\n");
async(avp_db_query("exec dbo.doStuff '1','2','3','4'",
"$avp(db1);$avp(db2);$avp(db3)"), post_db_dip);
}
route [post_db_dip] {
xlog("L_INFO", "Back from query.\n");
while (is_avp_set("$avp(db1)") &&
is_avp_set("$avp(db2)") && is_avp_set("$avp(db3)")) {
xlog("L_INFO", "db1=$avp(db1), db2=$avp(db2), db3=$avp(db3)\n");
avp_delete("$avp(db1)");
avp_delete("$avp(db2)");
avp_delete("$avp(db3)");
}
xlog("L_INFO", "End of processing.\n");
sl_send_reply("600", "Road Closed");
exit;
}
The debug=6:
...
/usr/sbin/opensips[19887]: DBG:avpops:ops_async_dbquery: query
[exec dbo.doStuff '1','2','3','4']
/usr/sbin/opensips[19887]:
DBG:db_virtual:db_virtual_async_raw_query: f call handle size = 1
/usr/sbin/opensips[19887]: DBG:db_virtual:try_reconnect: try reconnect
/usr/sbin/opensips[19887]:
DBG:db_virtual:db_virtual_async_raw_query: flags1 = 3
/usr/sbin/opensips[19883]: DBG:core:handle_sigs: status = 11
/usr/sbin/opensips[19883]: INFO:core:handle_sigs
<INFO:core:handle_sigs>: child process 19887 exited by a signal 11
/usr/sbin/opensips[19883]: INFO:core:handle_sigs
<INFO:core:handle_sigs>: core was not generated
/usr/sbin/opensips[19883]: INFO:core:handle_sigs
<INFO:core:handle_sigs>: terminating due to SIGCHLD
/usr/sbin/opensips[19890]: INFO:core:sig_usr: signal 15 received
/usr/sbin/opensips[19889]: INFO:core:sig_usr: signal 15 received
/usr/sbin/opensips[19888]: INFO:core:sig_usr: signal 15 received
/usr/sbin/opensips[19886]: INFO:core:sig_usr: signal 15 received
/usr/sbin/opensips[19885]: INFO:core:sig_usr: signal 15 received
/usr/sbin/opensips[19884]: INFO:core:sig_usr: signal 15 received
/usr/sbin/opensips[19883]: INFO:core:cleanup: cleanup
...and so forth.
The process that crashes, 19887 in this particular case, is a
listener process. I never see the "Back from xlog" xlog appear.
OpenSIPS immediately respawns but I suspect that's systemd.
Am I doing something wrong, or is this a bug?
- Jeff
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
