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.