[Serusers] SER got error during the start due to MySQL connection 2
ser at ipcb.net
ser at ipcb.net
Wed Aug 3 10:37:45 CEST 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.
More information about the sr-users
mailing list