I don't think it worth adding C code for external SQL query needs. IIRC, during
early SER times there was a command to execute any sql query via mi/fifo, but
wasn't feasible and easy to maintain, therefore removed.
I kamctl can be added using db cli application (e.g., mysql) with a bit of
grep/sed/awk will print only the value.
Fetching the value via xmlrpc should be possible via a bit of config scripting,
inside route[XMLRPC] intercept the command before dispatch_rpc() (search over
the body or using xmlops), do appropriate sql_query(...) via sqlops and push
back a reply with a body in xmlrpc format.
I would propose to close this item here.
---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/113#issuecomment-88467639
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
