[OpenSIPS-Users] Mysql connection problem

[Bogdan-Andrei Iancu]

Hi Felipe,

use "opensips -f cfg_file" when starting OpenSIPS.

Regards,
Bogdan

Felipe R. Pasa wrote:
> Hi Bogdan
>
> the file is /etc/opensips/opensips.cfg
> i change the opensips user to root
> and than work!, but i dont understand why the opensips user didnt.
> whatever.
>
> when you tell me about   " -f " , what is this?  where i use this option
>
> Thanks.
>
>
>
> 2009/2/6 Bogdan-Andrei Iancu <bogdan at voice-system.ro>:
>   
>> 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.
>>>
>>>
>>>
>>>
>>>
>>>       
>>     
>
>
>
>