[OpenSIPS-Users] Mysql connection problem

[Bogdan-Andrei Iancu]

Hi Felipe,

If using the same values (host, username, passwd) from myql cli works, 
than be sure you are using the cfg file you are editing. be explicit and 
pass with "-f" the cfg file you are working on.

Regards,
Bogdan

Felipe R. Pasa wrote:
> 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.
>
>
>
>
>