[midPoint] Where does one configure datasources in midPoint 4.0.2?

[Richard Frovarp]

So unless I'm running this directly through Tomcat I can't do datasource how it comes normally?

I'm getting these:

2020-05-12 11:11:52,084 [REPOSITORY] [midPointScheduler_Worker-3] WARN (com.zaxxer.hikari.pool.PoolBase): HikariPool-1 - Failed to validate connection com.mysql.jdbc.JDBC4Connection at 5bce37af<mailto:com.mysql.jdbc.JDBC4Connection at 5bce37af> (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

Which I don't see a setting on how to address that via config.xml. I know that 4.1 deprecates MariaDB and I'll need to change to PostgreSQL. I was kind of hoping to use datasource so that I can skip providing passwords to a lot of resources that will be reading data in from the same DB.

On Tue, 2020-05-12 at 11:04 -0500, Jason Everling wrote:
Those examples are for tomcat native datasource configuration, standard configuration is done in config.xml in midpoint.home directory,

    <repository>
      <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
      <database>sqlserver</database>
      <jdbcUsername>midpoint</jdbcUsername>
      <jdbcPassword>password</jdbcPassword>
      <jdbcUrl>jdbc:sqlserver://localhost:1433;database=midpoint</jdbcUrl>
    </repository>

From: Richard Frovarp<mailto:richard.frovarp at ndsu.edu>
Sent: Tuesday, May 12, 2020 9:40 AM
To: midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>
Subject: [midPoint] Where does one configure datasources in midPoint 4.0.2?

I've read the documentation here:

https://wiki.evolveum.com/display/midPoint/Repository+Configuration#Rep
ositoryConfiguration-Datasourceconfiguration

But that doesn't give a current answer. Grepping through everything
looking for the bits I think might exist in files doesn't give me a
result.

I'm getting a variety of connection problems, likely due to timeouts,
and it looks like the only way to set those is via a datasource.

Thanks,
Richard
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
https://lists.evolveum.com/mailman/listinfo/midpoint


_______________________________________________

midPoint mailing list

midPoint at lists.evolveum.com<mailto:midPoint at lists.evolveum.com>

https://lists.evolveum.com/mailman/listinfo/midpoint

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200512/da499d90/attachment.htm>