[OpenSIPS-Users] Mysql connection problem

[Felipe R. Pasa]

Hi Folks,

 I am new  in opensips and i have making some tests with this greate software,

 my objective is make all UA  register in a mysql database,  for this
i set some modparam in /etc/opensips/opensips.cfg

=================
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url", "mysql://opensips:passwordsql@127.0.0.1/opensips")

modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
modparam("auth_db", "db_url", "mysql://opensips:passwordsql@127.0.0.1/opensips")
modparam("auth_db", "load_credentials", "")
===============

in a manual connection with mysql  the user and password are correct.
stoping and starting with openserctl start the log says...

================
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]:
DBG:textops:fixup_method: using id for method [CANCEL/2]
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions:
fixing t_check_trans, line 174
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions:
fixing t_relay, line 175
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions:
fixing t_check_trans, line 179
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:fix_actions:
fixing proxy_authorize, line 184
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: DBG:core:db_do_init:
connection 0x735568 not found in pool
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]:
DBG:db_mysql:db_mysql_new_connection: opening connection:
mysql://xxxx:xxxx@127.0.0.1/opensips
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]:
ERROR:db_mysql:db_mysql_new_connection: driver error: Access denied
for user 'opensips'@'localhost' (using password: YES)
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: ERROR:core:db_do_init:
could not add connection to the pool
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]:
ERROR:auth_db:auth_fixup: unable to open database connection
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: ERROR:core:fix_actions:
fixing failed (code=-1) at cfg line 184
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: CRITICAL:core:fix_expr:
fix_actions error
Feb  6 12:58:33 sip /usr/sbin/opensips[8058]: ERROR:core:main: failed
to fix configuration with err code -1
==================

Thanks in advance.




-- 
Felipe R. Pasa
Instrutor certificado dCAP

visite nosso site!!!!
http://www.voipexperts.com.br