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:[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.
>
>
>
>
>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
