Could someone PLEASE help me with this, it's driving me nuts!
Having a strange one since I put voicemail module in. For some unknown reason it fails to connect to the MYSQL database. The original config works fine.
Loading ser reports the following:
0(2369) DBT:dbt_cache_get_db:dbtext cache is not initialized! 0(2369) DBT:dbt_init: cannot get the link to database 0(2369) mod_init(): Error while connecting database 0(2369) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules 0(2369) DBT:destroy ... 0(2369) DEBUG: tm_shutdown : start 0(2369) DEBUG: tm_shutdown : empting DELETE list 0(2369) DEBUG: tm_shutdown : empting hash table 0(2369) DEBUG: tm_shutdown: releasing timers 0(2369) DEBUG: tm_shutdown : removing semaphores 0(2369) DEBUG: tm_shutdown : done 0(2369) shm_mem_destroy
The mod loads from the ser.cfg are as follows:
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/registrar.so" loadmodule "/usr/local/lib/ser/modules/textops.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so" loadmodule "/usr/local/lib/ser/modules/nathelper.so"
# Load accounting loadmodule "/usr/local/lib/ser/modules/acc.so"
# load the voicemail module #loadmodule "/usr/local/lib/ser/modules/vm.so"
# ----------------- setting module-specific parameters ---------------
# -- registrar parameter # special NAT flag indicates that a registered client is behind NAT modparam("registrar", "nat_flag", 6)
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database # for persistent storage and comment the previous line modparam("usrloc", "db_mode", 2)
Many thanks.
Mike
It seems that you try to connect to a text DB intead of the MySQL. Check if you have the line: modparam("group", "db_url", "mysql://ser:heslo@localhost/ser")
Juan ----- Original Message ----- From: "Mike Fallows" mike.fallows@netsquaregroup.com To: serusers@lists.iptel.org Sent: Tuesday, March 02, 2004 11:01 AM Subject: [Serusers] Voicemail question
Could someone PLEASE help me with this, it's driving me nuts!
Having a strange one since I put voicemail module in. For some unknown reason it fails to connect to the MYSQL database. The original config
works
fine.
Loading ser reports the following:
0(2369) DBT:dbt_cache_get_db:dbtext cache is not initialized! 0(2369) DBT:dbt_init: cannot get the link to database 0(2369) mod_init(): Error while connecting database 0(2369) init_mod(): Error while initializing module usrloc ERROR: error while initializing modules 0(2369) DBT:destroy ... 0(2369) DEBUG: tm_shutdown : start 0(2369) DEBUG: tm_shutdown : empting DELETE list 0(2369) DEBUG: tm_shutdown : empting hash table 0(2369) DEBUG: tm_shutdown: releasing timers 0(2369) DEBUG: tm_shutdown : removing semaphores 0(2369) DEBUG: tm_shutdown : done 0(2369) shm_mem_destroy
The mod loads from the ser.cfg are as follows:
# ------------------ module loading ----------------------------------
# Uncomment this if you want to use SQL database loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so" loadmodule "/usr/local/lib/ser/modules/tm.so" loadmodule "/usr/local/lib/ser/modules/rr.so" loadmodule "/usr/local/lib/ser/modules/maxfwd.so" loadmodule "/usr/local/lib/ser/modules/usrloc.so" loadmodule "/usr/local/lib/ser/modules/registrar.so" loadmodule "/usr/local/lib/ser/modules/textops.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "/usr/local/lib/ser/modules/auth.so" loadmodule "/usr/local/lib/ser/modules/auth_db.so" loadmodule "/usr/local/lib/ser/modules/nathelper.so"
# Load accounting loadmodule "/usr/local/lib/ser/modules/acc.so"
# load the voicemail module #loadmodule "/usr/local/lib/ser/modules/vm.so"
# ----------------- setting module-specific parameters ---------------
# -- registrar parameter # special NAT flag indicates that a registered client is behind NAT modparam("registrar", "nat_flag", 6)
# -- usrloc params --
#modparam("usrloc", "db_mode", 0)
# Uncomment this if you want to use SQL database # for persistent storage and comment the previous line modparam("usrloc", "db_mode", 2)
Many thanks.
Mike
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers