Hello Nethra,

Your suggestion worked, indeed wasn't set the db_url. I mention again that in 
my 
opinion the design should be changed, a module db connection should not have 
default credentials.

Thanks,
Liviu



________________________________
From: Nethra Chander <[email protected]>
To: OpenSIPS users mailling list <[email protected]>
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@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 <[email protected]> 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
>[email protected]
>http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to