What kind of DB handler do I need for the dispatcher module?
When executing the dispatcher.reload command I'm receiving the following error:
8(10201) ERROR: dispatcher [dispatch.c:725]: ds_load_db(): invalid DB handler
root@proxy01:~# kamctl dispatcher reload
ERROR: This command requires a database engine - none was loaded
My Dispatcher table is loaded using db_unixodbc, because we are using MSSQL.
loadmodule "mi_fifo.so"
loadmodule "kex.so"
loadmodule "corex.so"
loadmodule "tm.so"
loadmodule "tmx.so"
loadmodule "sl.so"
loadmodule "rr.so"
loadmodule "pv.so"
loadmodule "maxfwd.so"
loadmodule "textops.so"
loadmodule "textopsx.so"
loadmodule "siputils.so"
loadmodule "xlog.so"
loadmodule "sanity.so"
loadmodule "db_unixodbc.so"
loadmodule "sqlops.so"
loadmodule "dispatcher.so"
loadmodule "siptrace.so"
loadmodule "avp.so"
loadmodule "cfgutils.so"
loadmodule "xhttp.so"
loadmodule "xhttp_rpc.so"
# ----- db_unixodbc params -----
modparam("db_unixodbc", "ping_interval", 600)
modparam("db_unixodbc", "auto_reconnect", 0)
modparam("db_unixodbc", "use_escape_common", 1)
modparam("dispatcher",
"db_url","unixodbc://domain\myusername:[email protected]/Kamailio")
modparam("dispatcher", "table_name", "Dispatcher")
modparam("dispatcher", "setid_col", "SetID")
modparam("dispatcher", "destination_col", "Destination")
modparam("dispatcher", "priority_col", "[Priority]")
modparam("dispatcher", "flags_col", "Flags")
modparam("dispatcher", "attrs_col", "Attributes")
modparam("dispatcher", "flags", 2)
modparam("dispatcher", "dst_avp", "$avp(dsdst)")
modparam("dispatcher", "grp_avp", "$avp(dsgrp)")
modparam("dispatcher", "cnt_avp", "$avp(dscnt)")
modparam("dispatcher", "attrs_avp", "$avp(dsattrs)")
The Dispatcher table is loaded just fine on startup of Kamailio.
kamctl fifo ds_list shows the table data.
From: [email protected]
[mailto:[email protected]] On Behalf Of Grant Bagdasarian
Sent: Friday, September 27, 2013 1:39 PM
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Communicate with Kamailio through external application
Right! Totally forgot about that.
Thanks, Kamailio is now receiving the requests!
From:
[email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Charles Chance
Sent: Friday, September 27, 2013 1:35 PM
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Communicate with Kamailio through external application
Hi,
Have you added the appropriate listen= and/or port= directive to your config?
http://www.kamailio.org/wiki/cookbooks/4.0.x/core#listen
http://www.kamailio.org/wiki/cookbooks/4.0.x/core#port
Also make sure you have not disabled TCP.
Regards,
Charles
On 27 September 2013 12:27, Grant Bagdasarian <[email protected]<mailto:[email protected]>>
wrote:
What am I doing wrong here?
# ----- xhttp params ------
modparam("xhttp", "url_match", "null")
# ----- xhttp_rpc params ------
modparam("xhttp_rpc", "xhttp_rpc_root", "http_rpc")
####### Routing Logic ########
event_route[xhttp:request] {
xlog("L_INFO", "************************************** RECEIVED NEW HTTP
REQUEST: $hu *********************************");
xhttp_reply("200", "OK", "text/html","<html><body>OK - Request
Received</body></html>");
}
It seems like Kamailio isn't receiving the HTTP requests.
Im doing a simple HTTP GET (http://192.168.1.10/http_rpc) using my browser to
see if it hits the event_route.
>From what I understand, the RCP command is in the url of the HTTP request, and
>is extracted using string transformations.
I've never done anything with RPC directly, so maybe I'm just wrong.
Also, I don't see Kamailio binding to the HTTP port.
The xhttp_rpc_root param only allows alphanumeric values, so I can't specify a
full URL.
From:
[email protected]<mailto:[email protected]>
[mailto:[email protected]<mailto:[email protected]>]
On Behalf Of Grant Bagdasarian
Sent: Friday, September 27, 2013 10:04 AM
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Communicate with Kamailio through external application
Thanks, I'll have a look at it.
Looks much easier than setting up Ssh connections programmatically.
From:
[email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Charles Chance
Sent: Wednesday, September 25, 2013 1:12 PM
To: Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Communicate with Kamailio through external application
Hi,
Take a look at
http://www.kamailio.org/docs/modules/stable/modules/xhttp_rpc.html, which
allows you to receive/handle RPC commands over HTTP.
Then use the appropriate RPC command in dispatcher module to reload table:
http://www.kamailio.org/docs/modules/stable/modules/dispatcher.html#idp16998512
Regards,
Charles
On 25 September 2013 11:40, Grant Bagdasarian <[email protected]<mailto:[email protected]>>
wrote:
Hello,
When adding rows to the dispatcher table, the table in memory needs to be
refreshed. Since we have multiple Kamailio instances running on different
machines, I'd like to automate the process of reloading the table.
Is there an easy way of doing this with an already existing module, which
provides easy connectivity from the outside?
Or do I need to write an application which basically sets up a SSH socket
connection with the machine and sends the command "kamctl dispatcher reload"
then exit? Not that hard either, but there might be a finer solution available.
Regards,
Grant
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
[email protected]<mailto:[email protected]>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
www.sipcentric.com<http://www.sipcentric.com/>
Follow us on twitter @sipcentric<http://twitter.com/sipcentric>
Sipcentric Ltd. Company registered in England & Wales no. 7365592. Registered
office: Unit 10 iBIC, Birmingham Science Park, Holt Court South, Birmingham B7
4EJ.
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
[email protected]<mailto:[email protected]>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
www.sipcentric.com<http://www.sipcentric.com/>
Follow us on twitter @sipcentric<http://twitter.com/sipcentric>
Sipcentric Ltd. Company registered in England & Wales no. 7365592. Registered
office: Unit 10 iBIC, Birmingham Science Park, Holt Court South, Birmingham B7
4EJ.
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
