All,
I've been trying to chase down an issue with db_cluster and permissions in combination
with something else, where with my full configuration using the same cluster in multiple
modules has failures. I've been trying to create a simplified configuration to
consistently reproduce the problem without much success, however I did stumble upon THIS
particular problem. The configuration here works fine as is - avpops uses the cluster
URL, and carrierroute uses the direct SQLite URL. If I define WITH_DBCLUSTER, then
carrierroute fails fetching rows using the cluster connection. Note that AVPOPS is only
used as a general test to see if the cluster config works. If I remove references to
avpops , carrierroute still fails loading from the cluster URL. Thoughts?
#!KAMAILIO
loadmodule "db_sqlite"
loadmodule "pv"
loadmodule "db_cluster"
loadmodule "carrierroute"
loadmodule "avpops"
modparam("db_cluster", "connection",
"db1=>sqlite:////etc/db.sqlite")
modparam("db_cluster", "cluster", "cl1=>db1=9s9s")
modparam("db_cluster", "inactive_interval", 30)
#!ifdef WITH_DBCLUSTER
modparam("carrierroute", "db_url", "cluster://cl1")
#!else
modparam("carrierroute", "db_url",
"sqlite:////etc/db.sqlite")
#!endif
modparam("carrierroute", "config_source", "db")
modparam("avpops", "db_url", "cluster://cl1")
modparam("avpops", "avp_table", "usr_preferences")
request_route {
exit;
}
Failure log:
0(1) ERROR: carrierroute [cr_db.c:345]: load_route_data_db(): Fetching rows failed
0(1) ERROR: carrierroute [cr_data.c:179]: reload_route_data(): could not load routing
data
0(1) ERROR: carrierroute [carrierroute.c:240]: mod_init(): could not prepare route data
0(1) ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing
module carrierroute (/usr/lib/kamailio/modules/carrierroute.so)
Kaufman