<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">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 class=""><span class="">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 class=""><span class="">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">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><div>-F </div></div>