[Serusers] Can anyone explain this error?

[sip]

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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers