6 Jul
2006
6 Jul
'06
7:19 a.m.
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..