[midPoint] jdbcUrl not being read from config.xml

[Florin. Stingaciu]

Alternatively, I also tired using the guide here
<https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-SQLschemascripts>,
to configure it using datasources. The error with this method is very
similar:

ERROR (org.springframework.web.context.ContextLoader): Context
>> initialization failed
>
> 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
>
> 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
>
> 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
>
> asource, reason: Access denied for user 'midpoint'@'100.80.134.132'
>> (using password: YES)
>
>


On Tue, Apr 19, 2016 at 12:58 PM, Florin. Stingaciu <fstingaciu at mirantis.com
> wrote:

> Upon turning on debuging using logback.xml, I find that the jdbcUrl is
> actually set properly:
>
> 2016-04-19 19:54:12,855 [] [localhost-startStop-1] DEBUG
>> (com.evolveum.midpoint.init.StartupConfiguration):     jdbcUrl =
>> jdbc:mysql://v-midpdb-001-example.net:3306/midpoint
>
> However for some reason, it seems to trying to connect to the localhost
> (100.80.134.132) instead of jdbcUrl.
>
> On Tue, Apr 19, 2016 at 12:27 PM, Florin. Stingaciu <
> fstingaciu at mirantis.com> wrote:
>
>> Hello,
>>
>> I'm trying to switch to a mysql DB instead of h2. Here's how my
>> repository section looks like in config.xml:
>>
>>         <repository>
>>>
>>>                 <embedded>false</embedded>
>>>
>>>
>>>> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
>>>
>>>                 <driverClassName>com.mysql.jdbc.Driver</driverClassName>
>>>
>>>                 <hibernateHbm2ddl>update</hibernateHbm2ddl>-->
>>>
>>>
>>>> <hibernateDialect>org.hibernate.dialect.MySQLDialect</hibernateDialect>
>>>
>>>                 <jdbcUsername>midpoint</jdbcUsername>
>>>
>>>                 <jdbcPassword>password</jdbcPassword>
>>>
>>>                 <jdbcUrl>jdbc:mysql://
>>>> v-midpdb-001-exmaple.net:3306/midpoint</jdbcUrl>
>>>
>>>         </repository>
>>>
>>>
>>  Upon starting tomcat7, I find the following error under idm.log:
>>
>> 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:
>>>
>>> java.sql.SQLException: Access denied for user 'midpoint'@'100.80.134.132'
>>> (using password: YES)
>>>
>>
>> The IP address 100.80.134.132 actually maps to the localhost, not
>> v-midpdb-001-exmaple.net. It seems that jdbcUrl reverts to the default
>> from the SQL class: jdbc:mysql://localhost/midpoint. Any help would be
>> greatly appreciated.
>>
>> Thanks,
>> -F
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160419/845053d7/attachment.htm>