<div dir="ltr">This problem was solved. There was a problem with how mySQL was set up. Feel free to discard this from the mailing list. <div><br></div><div>Thanks, </div><div>-F </div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 19, 2016 at 1:45 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">Alternatively, I also tired using the guide <a href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-SQLschemascripts" target="_blank">here</a>, to configure it using datasources. The error with this method is very similar:<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">ERROR (org.springframework.web.context.ContextLoader): Context initialization failed</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">org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryService' defined in class path resource [ctx-configuration.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating be</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">an with name 'dataSource' defined in URL [jar:file:/var/lib/tomcat7/webapps/midpoint/WEB-INF/lib/repo-sql-impl-3.3.1.jar!/ctx-repository-session.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public </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">javax.sql.DataSource com.evolveum.midpoint.repo.sql.DataSourceFactory.createDataSource() throws com.evolveum.midpoint.repo.api.RepositoryServiceFactoryException] threw exception; nested exception is com.evolveum.midpoint.repo.api.RepositoryServiceFactoryException: Couldn't initialize dat</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">asource, reason: Access denied for user 'midpoint'@'100.80.134.132' (using password: YES)</blockquote></blockquote><div><br></div><div> </div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 19, 2016 at 12:58 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">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>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" target="_blank">v-midpdb-001-example.net:3306/midpoint</a></span></blockquote><p>However for some reason, it seems to trying to connect to the localhost (100.80.134.132) instead of jdbcUrl.</p>
</div></div><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><font color="#888888"><div>-F </div></font></span></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>