Mysql connection problem

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Mysql connection problem

feliperp3
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

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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.
>
>
>
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]>:
>  
>> 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.
>>>
>>>
>>>
>>>
>>>
>>>      
>>    
>
>
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users