[Serusers] Can anyone explain this error?

[nick]

After a lot of work, and also installing openser to discover the reason 
why my ser was segfaulting (make sure the tm.so module loads before the 
acc.so one... ) I've got a mostly functional ser install.

However, ser seems to have problems connecting to Mysql. I created the 
ser database with the ser_mysql.sh script, I modified the default 
password in the script and set it to be the same as the one in my 
ser.cfg, I set the realm to be localhost (since they're on the same 
machine) and I've confirmed the existence of both the ser user and ser 
database inside mysql. I've even confirmed the password is valid 
connecting directly as ser :

mysql -u ser -p

entering the password that I have in both the ser.cfg and ser_mysql.sh I 
can connect without a problem.

When ser tries to connect, it ends up with an error.

Jul  6 12:25:57 sipserver ser: Maxfwd module- initializing
Jul  6 12:25:57 sipserver ser: INFO: udp_init: SO_RCVBUF is initially 135168
Jul  6 12:25:57 sipserver ser: INFO: udp_init: SO_RCVBUF is finally 262142
Jul  6 12:25:57 sipserver ser: INFO: fifo process starting: 3478
Jul  6 12:25:57 sipserver ser: new_connection(): Access denied for user 
'ser'@'localhost' (using password: YES)
Jul  6 12:25:57 sipserver ser: db_init(): Could not create a connection
Jul  6 12:25:57 sipserver ser: ERROR: acc_db_init: unable to connect to 
the database
Jul  6 12:25:57 sipserver ser: init_mod_child(): Error while 
initializing module acc
Jul  6 12:25:57 sipserver ser: timer: init_child failed
Jul  6 12:25:57 sipserver ser: new_connection(): Access denied for user 
'ser'@'localhost' (using password: YES)
Jul  6 12:25:57 sipserver ser: db_init(): Could not create a connection
Jul  6 12:25:57 sipserver ser: ERROR: acc_db_init: unable to connect to 
the database
Jul  6 12:25:57 sipserver ser: init_mod_child(): Error while 
initializing module acc


This is my ser.cfg:


fork=no
log_stderror=no # (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
#listen=192.168.1.93
#children=4
fifo="/tmp/ser_fifo"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"

# ----------------- setting module-specific parameters ---------------

# -- usrloc params --

modparam("usrloc", "db_mode", 2)
modparam("auth_db|usrloc","db_url","mysql://ser:heslo@localhost/ser")

modparam("auth_db", "calculate_ha1", yes)

modparam("auth_db", "password_column", "password")

modparam("rr", "enable_full_lr", 1)



I've obviously changed the password back here to heslo but I can assure 
you that I've copied and pasted, typed by hand and pretty much confirmed 
multiple times that my password is valid..