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.
SER uses default password "heslo". Make sure your password matchs both in MySQL and in your configuration file: modparam("usrloc", "db_url", "mysql://ser:mypass@fwd.serout.com/myserdb")
Also if MySQL is running on the same Linux then try to use "localhost" instead "fwd.serout.com" and "ser" instead "myserdb". Unless you make everything matchs then you are going to see this kind of access database failed message. good luck.
Pat
From: "ser@ipcb.net" ser@ipcb.net To: serusers@lists.iptel.org Subject: [Serusers] SER got error during the start due to MySQL connection 2 Date: Wed, 03 Aug 2005 12:37:45 +0400
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.
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Pat wang -
ser＠ipcb.net