New subject: [Serusers] SER got error during the start due to MySQL connection 2

3 Aug 2005

Hi all.

I have configured ProxySER for my test clients and connected they via 
SER, but... I can't configure SER - MySQL interoperability. I've read 
"SIP.edu Cookbook" by ProxySER afterward I made the changes into ser.cfg 
and db configuration. After SER startup I've got the next log:

Aug  2 19:21:21 fwd ser[11846]: Maxfwd module- initializing
Aug  2 19:21:21 fwd ser[11849]: new_connection(): Access denied for user 
'serro'@'localhost' (using password: YES)
Aug  2 19:21:21 fwd ser[11849]: db_init(): Could not create a connection
Aug  2 19:21:21 fwd ser[11849]: ERROR: auth_db_bind: unable to connect 
to the database
Aug  2 19:21:21 fwd ser[11849]: init_mod_child(): Error while 
initializing module auth_db
Aug  2 19:21:21 fwd ser[11849]: ERROR: open_uac_fifo: init_child failed
Aug  2 19:21:21 fwd ser[11849]: starting fifo server failed

I've had the next config:

#
# $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $
#
# simple quick-start config script
#
# ----------- global configuration parameters ------------------------

# debug=7         # debug level (cmd line: -dddddddddd)
# fork=yes
# log_stderror=yes      # (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 "//lib/ser/modules/mysql.so"
loadmodule "//lib/ser/modules/sl.so"
loadmodule "//lib/ser/modules/tm.so"
loadmodule "//lib/ser/modules/rr.so"
loadmodule "//lib/ser/modules/maxfwd.so"
loadmodule "//lib/ser/modules/usrloc.so"
loadmodule "//lib/ser/modules/registrar.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "//lib/ser/modules/auth.so"
loadmodule "//lib/ser/modules/auth_db.so"
loadmodule "//lib/ser/modules/acc.so"
loadmodule "//lib/ser/modules/exec.so"
# loadmodule "//lib/ser/modules/group.so"
# loadmodule "//lib/ser/modules/msilo.so"
loadmodule "//lib/ser/modules/print.so"
loadmodule "//lib/ser/modules/textops.so"
loadmodule "//lib/ser/modules/uri.so"
# loadmodule "//lib/ser/modules/uri_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)

modparam("usrloc", "db_url",
"mysql://ser:mypass@fwd.serout.com/myserdb")
modparam("auth", "secret", "myphrase")

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

# -------------------------  request routing logic -------------------
skipped...

Where I can dig for solving this trouble?

Thank you in advance.

Alexander Naumov.