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

From: "ser(a)ipcb.net" <ser(a)ipcb.net> To: serusers(a)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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers