<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div style="color: black; font-family: arial, helvetica, sans-serif; font-size: 10pt; ">Hello,</div><div style="color: black; font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="color: black; font-family: arial, helvetica, sans-serif; font-size: 10pt; ">Very likely this is the problem, is the only one possibility to have an unset user trying to connect to the db.</div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif" size="2">I notice that is a strange </font><font class="Apple-style-span" face="arial, helvetica, sans-serif" size="2">design to have some default DB connection params. </font></div><div></div><div style="color: black; font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="color: black; font-family:
arial, helvetica, sans-serif; font-size: 10pt; ">Thanks,</div><div style="color: black; font-family: arial, helvetica, sans-serif; font-size: 10pt; ">Liviu<br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Nethra Chander <netchander@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> OpenSIPS users mailling list <users@lists.opensips.org><br><b><span style="font-weight: bold;">Sent:</span></b> Fri, June 10, 2011 3:54:32 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [OpenSIPS-Users] MySQL connection error<br></font><br>
<i style="font-family:arial, helvetica, sans-serif;">Hello,<br>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?<br>
<br>By default, the db_url parameter for the modules have the value</i><span style="font-family:arial, helvetica, sans-serif;"> "</span><span class="emphasis"><em><span class="quote"><span style="font-family:arial, helvetica, sans-serif;">mysql://opensips:opensipsrw@localhost/opensips"</span><br style="font-family:arial, helvetica, sans-serif;">
<br style="font-family:arial, helvetica, sans-serif;"><span style="font-family:arial, helvetica, sans-serif;">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</span><br style="font-family:arial, helvetica, sans-serif;">
<br>I ran into similar issue and was able to resolve by explicitly configuring db_url params for all the applicable modules.<br><span style="font-family:arial, helvetica, sans-serif;"></span><br style="font-family:arial, helvetica, sans-serif;">
<span style="font-family:arial, helvetica, sans-serif;">Thanks.</span><br><br></span></em></span><br><br><br><br><br><div class="gmail_quote">On Fri, Jun 10, 2011 at 3:22 PM, Barsan Liviu <span dir="ltr"><<a rel="nofollow" ymailto="mailto:barsanl@yahoo.com" target="_blank" href="mailto:barsanl@yahoo.com">barsanl@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div style="font-family:arial, helvetica, sans-serif;font-size:10pt;color:#000000;"><div style="color:rgb(0, 0, 0);font-family:arial, helvetica, sans-serif;font-size:10pt;">
Hello,</div><div style="color:rgb(0, 0, 0);font-family:arial, helvetica, sans-serif;font-size:10pt;"><br></div><div><font size="2" face="arial, helvetica, sans-serif">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.</font></div>
<div><font size="2" face="arial, helvetica, sans-serif">When I start the server with opensips start then we receive the error in the log:</font></div><div><font size="2" face="arial, helvetica, sans-serif"><br></font></div>
<div><font size="2" face="arial,
helvetica, sans-serif"><div>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)</div><div>Jun 10 18:03:12 P4302 opensips[18307]: ERROR:db_mysql:db_mysql_new_connection: initial connect failed</div>
<div>Jun 10 18:03:12 P4302 opensips[18307]: ERROR:core:db_do_init: could not add connection to the pool</div><div><br></div><div><br></div><div>For sure we do not have db_url in opensips.cfg or other files which contains username 'opensips'.</div>
<div>Checked and from command line we can connect from mysql with the credentials we set in opensips.cfg.</div><div><br></div><div>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.</div>
<div><br></div><div>Do you have any suggestion?</div><div><br></div><div>Thanks,</div><div>Liviu</div></font></div><div style="color:rgb(0, 0, 0);font-family:arial, helvetica, sans-serif;font-size:10pt;"></div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a rel="nofollow" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><span>
<a target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></span><br>
<br></blockquote></div><br>
</div></div><div style="color: black; font-family: arial, helvetica, sans-serif; font-size: 10pt; position: fixed; "></div>
</div></body></html>