Just to make sure, try:

mysql -u ser -h localhost -p

And see if you still get access denied. Connecting directly via the socket and connecting as though to an external host (in this case, localhost) actually give you different results. If that works, we can ensure that's not part of the equation.

N.

On Thu, 06 Jul 2006 13:19:31 +0200, nick wrote

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..

---

Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers