[OpenSIPS-Users] MySQL connection error

[Nethra Chander]

*Hello,
Can you check the default parameter values for the modules that you load in
the opensips.cfg file and for which you have not explicitly configured
modparams?

By default, the db_url parameter for the modules have the value* "*
mysql://opensips:opensipsrw@localhost/opensips"

So, in your case, the opensips at localhost and the password used might not be
from your opensips.cfg but rather coming from the default parameter values
atleast for one of the modules

I ran into similar issue and was able to resolve by explicitly configuring
db_url params for all the applicable modules.

Thanks.

*




On Fri, Jun 10, 2011 at 3:22 PM, Barsan Liviu <barsanl at yahoo.com> wrote:

> Hello,
>
> We re-installed from sources the OpenSIPs server to Debian and copied back
> to /etc/opensips the configuration files saved from the previous working
> OpenSIPs.
> When I start the server with opensips start then we receive the error in
> the log:
>
> Jun 10 18:03:12 P4302 opensips[18307]: ERROR:db_mysql:db_mysql_connect:
> driver error(1045): Access denied for user 'opensips'@'localhost' (using
> password: YES)
> Jun 10 18:03:12 P4302 opensips[18307]:
> ERROR:db_mysql:db_mysql_new_connection: initial connect failed
> Jun 10 18:03:12 P4302 opensips[18307]: ERROR:core:db_do_init: could not add
> connection to the pool
>
>
> For sure we do not have db_url in opensips.cfg or other files which
> contains username 'opensips'.
> Checked and from command line we can connect from mysql with the
> credentials we set in opensips.cfg.
>
> To be sure we put back the initial opensips.cfg comming with the sources,
> changed the db credentials to ours and still receive this error.
>
> Do you have any suggestion?
>
> Thanks,
> Liviu
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110610/b39bd3a8/attachment.htm>