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

[Pat wang]

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