HI,

I am pretty new to ser and I have got a quiet unsolvable problem.. I am running ser with mysql support and sems.

While trying to load the vm.so module, ser stops with this debug messages: --------------------------------- Nov 28 13:59:41 asterisk /usr/local/sbin/ser[3268]:ERROR: vm_mod_init: unable to bind db Nov 28 13:59:41 asterisk /usr/local/sbin/ser[3268]: init_mod(): Error while initializing module voicemail

-----------------------------------

Here is my ser.cfg :

# # $Id: ser.cfg,v 1.24 2003/11/11 11:1:11 Oliver Exp $ # # simple quick-start config script #

# ----------- global configuration parameters ------------------------

#debug=3 # debug level (cmd line: -dddddddddd) #fork=yes #log_stderror=no # (cmd line: -E)

/* Uncomment these lines to enter debugging mode fork=no log_stderror=yes */

check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) #port=5060 #children=4 fifo="/tmp/ser_fifo"

# ------------------ 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"

#Voicemail support loadmodule "/usr/local/lib/ser/modules/vm.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"

# ----------------- setting module-specific parameters ---------------

# -- 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)

# -- auth params -- # Uncomment if you are using auth module # #modparam("auth_db", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes (which true in this config), # uncomment also the following parameter) # #modparam("auth_db", "password_column", "password")

# -- rr params -- # add value to ;lr param to make some broken UAs happy modparam("rr", "enable_full_lr", 1)

# VOICEMAIL params modparam("voicemail", "db_url","sql://root:heslo@localhost/ser")

# ------------------------- request routing logic -------------------

# main routing logic

route{

# initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); break; }; if (msg:len >= max_len ) { sl_send_reply("513", "Message too big"); break; };

# we record-route all messages -- to make sure that # subsequent messages will go through our proxy; that's # particularly good if upstream and downstream entities # use different transport protocol if (!method=="REGISTER") record_route(); andrei # VOICEMAIL ROUTING if (uri == myself) {

# Voicemail specific configuration - begin

if(method=="ACK" || method=="INVITE" || method=="BYE" || method=="REFER"){

if(t_newtran()){

t_reply("100","Trying -- just wait a minute !");

if(method=="INVITE" || method=="REFER"){ log("**************** vm start- begin ******************\n"); if( uri =~ "conference" ){

if(!vm("/tmp/am_fifo","conference")){ log("could notcontact conference server\n");

t_reply("500","could not contact conference server"); }; } else if( uri =~ "echo" ){

if(!vm("/tmp/am_fifo","echo")){ log("could notcontact echo\n");

t_reply("500","could not contact echo"); }; } else {

if(!vm("/tmp/am_fifo","voicemail")){ log("could notcontact voicemail\n");

t_reply("500","could not contact voicemail"); }; }; log("**************** vm start- end ******************\n"); break; };

if(method=="BYE"){ log("**************** vm end/refer - begin ******************\n"); if(!vm("/tmp/am_fifo","bye")){ log("could not contactthe media server\n"); t_reply("500","could not contact the media server"); }; log("**************** vm end/refer - end ********************\n"); break; }; } else { log("could not create new transaction\n"); sl_send_reply("500","could not create newtransaction"); }; };

# Voicemail specific configuration - end }

# subsequent messages withing a dialog should take the # path determined by record-routing if (loose_route()) { # mark routing logic in request append_hf("P-hint: rr-enforced\r\n"); route(1); break; };

if (!uri==myself) { # mark routing logic in request append_hf("P-hint: outbound\r\n"); route(1); break; };

# if the request is for other domain use UsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri==myself) {

if (method=="REGISTER") {

# Uncomment this if you want to use digest authentication # if (!www_authorize("iptel.org", "subscriber")) { # www_challenge("iptel.org", "0"); # break; # };

save("location"); break; };

lookup("aliases"); if (!uri==myself) { append_hf("P-hint: outbound alias\r\n"); route(1); break; };

# native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; append_hf("P-hint: usrloc applied\r\n"); route(1); }

route[1] { # send it out now; use stateful forwarding as it works reliably # even for UDP2TCP if (!t_relay()) { sl_reply_error(); }; }

-------------------------------------------------------------------------------------

I am wondering if the error is about this line: # VOICEMAIL params modparam("voicemail", "db_url","sql://root:heslo@localhost/ser")

... I don't know....

Greets, Oliver