<div dir="ltr">Upon turning on debuging using logback.xml, I find that the jdbcUrl is actually set properly:<div><br></div><div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class="">2016-04-19 19:54:12,855 [] [localhost-startStop-1] DEBUG (com.evolveum.midpoint.init.StartupConfiguration): jdbcUrl = jdbc:mysql://<a href="http://v-midpdb-001-example.net:3306/midpoint">v-midpdb-001-example.net:3306/midpoint</a></span></blockquote><p class="">However for some reason, it seems to trying to connect to the localhost (100.80.134.132) instead of jdbcUrl.</p>
</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 19, 2016 at 12:27 PM, Florin. Stingaciu <span dir="ltr"><<a href="mailto:fstingaciu@mirantis.com" target="_blank">fstingaciu@mirantis.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello, <div><br></div><div>I'm trying to switch to a mysql DB instead of h2. Here's how my repository section looks like in config.xml:</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <repository></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <embedded>false</embedded></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <driverClassName>com.mysql.jdbc.Driver</driverClassName></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <hibernateHbm2ddl>update</hibernateHbm2ddl>--></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <hibernateDialect>org.hibernate.dialect.MySQLDialect</hibernateDialect></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <jdbcUsername>midpoint</jdbcUsername></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <jdbcPassword>password</jdbcPassword></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> <jdbcUrl>jdbc:mysql://<a href="http://v-midpdb-001-exmaple.net:3306/midpoint" target="_blank">v-midpdb-001-exmaple.net:3306/midpoint</a></jdbcUrl></blockquote><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> </repository></blockquote></blockquote><div><br></div><div> Upon starting tomcat7, I find the following error under idm.log:</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<p><span>acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:</span></p>
<p><span>java.sql.SQLException: Access denied for user 'midpoint'@'100.80.134.132' (using password: YES)</span></p></blockquote><div><br></div><div>The IP address 100.80.134.132 actually maps to the localhost, not <a href="http://v-midpdb-001-exmaple.net" target="_blank">v-midpdb-001-exmaple.net</a>. It seems that jdbcUrl reverts to the default from the SQL class: jdbc:mysql://localhost/midpoint. Any help would be greatly appreciated. </div><div><br></div><div>Thanks, </div><span class="HOEnZb"><font color="#888888"><div>-F </div></font></span></div>
</blockquote></div><br></div>