[OpenSIPS-Users] MySQL connection error

[Barsan Liviu]

Hello,

Very likely this is the problem, is the only one possibility to have an unset 
user trying to connect to the db.
I notice that is a strange design to have some default DB connection params. 

Thanks,
Liviu


________________________________
From: Nethra Chander <netchander at gmail.com>
To: OpenSIPS users mailling list <users at lists.opensips.org>
Sent: Fri, June 10, 2011 3:54:32 PM
Subject: Re: [OpenSIPS-Users] MySQL connection error

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/ce6bc6b0/attachment-0001.htm>