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

[Richard Frovarp]

Not running in a container. Just did the download and run using the
start.sh script in the tarball.

On Tue, 2020-05-12 at 11:51 -0500, Jason Everling wrote:
> Are you running container? I thought there was settings for them if
> using container, maybe someone here has examples for containers. We
> still use tomcat with global datasources so I cant speak to
> container’d deployment
>  
> From: Richard Frovarp
> Sent: Tuesday, May 12, 2020 11:18 AM
> To: midpoint at lists.evolveum.com
> Subject: Re: [midPoint] Where does one configure datasources in
> midPoint 4.0.2?
>  
> 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 (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.SqlRe
> > positoryFactory</repositoryServiceFactoryClass>
> >       <database>sqlserver</database>
> >       <jdbcUsername>midpoint</jdbcUsername>
> >       <jdbcPassword>password</jdbcPassword>
> >      
> > <jdbcUrl>jdbc:sqlserver://localhost:1433;database=midpoint</jdbcUrl
> > >
> >     </repository>
> >  
> > From: Richard Frovarp
> > Sent: Tuesday, May 12, 2020 9:40 AM
> > To: 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
> > https://lists.evolveum.com/mailman/listinfo/midpoint
> 
>  
>  
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint