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:[email protected]/opensips")
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
modparam("auth_db", "db_url", "mysql://opensips:[email protected]/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:[email protected]/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
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
