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