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

Thu May 14 11:15:30 CEST 2020

This should be definitely better documented, as embedded Tomcat is
recommended, and in the near future the only one supported option.

--

s pozdravem

*Petr Gašparík*
konzultant IT bezpečnosti

gsm: [+420] 603 523 860
e‑mail: petr.gasparik at ami.cz

*AMI Praha a.s.*
Pláničkova 11, 162 00 Praha 6

tel.: [+420] 274 783 239 | web: www.ami.cz

[image: AMI Praha a.s.]

Textem tohoto e‑mailu podepisující neslibuje uzavřít ani neuzavírá
za společnost AMI Praha a.s.
jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně
písemnou formu.

Tento e‑mail je určen výhradně pro potřeby jeho adresáta/ů a může obsahovat
důvěrné nebo osobní
informace. Nejste‑li zamýšleným příjemcem, je zakázáno jakékoliv
zveřejňování, zprostředkování
nebo jiné použití těchto informací. Pokud jste obdrželi e‑mail neoprávněně,
informujte o tom prosím
odesílatele a vymažte neprodleně všechny kopie tohoto e‑mailu včetně
všech jeho příloh. Nakládáním
s neoprávněně získanými informacemi se vystavujete riziku právního postihu.

čt 14. 5. 2020 v 11:02 odesílatel Pavol Mederly <mederly at evolveum.com>
napsal:

> Richard,
>
> I believe that even for embedded Tomcat (used when running in standalone
> mode) you can configure data sources, probably by setting up things in
> application.yml file.
>
> Best regards,
>
> Pavol Mederly
> Software developerevolveum.com
>
> On 13/05/2020 19:22, Jason Everling wrote:
>
> Yeah that was kind of what I meant by container, I believe its using
> Tomcat as the backend, or Jetty? In any case, you should still be able to
> create them, we don’t use that method so someone else would have to chime
> in on configuring them.
>
>
>
> *From: *Richard Frovarp <richard.frovarp at ndsu.edu>
> *Sent: *Tuesday, May 12, 2020 12:07 PM
> *To: *midpoint at lists.evolveum.com
> *Subject: *Re: [midPoint] Where does one configure datasources in
> midPoint 4.0.2?
>
>
>
> 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
>
> _______________________________________________
>
> midPoint mailing list
>
> midPoint at lists.evolveum.com
>
> https://lists.evolveum.com/mailman/listinfo/midpoint
>
>
>
> _______________________________________________
> midPoint mailing listmidPoint at lists.evolveum.comhttps://lists.evolveum.com/mailman/listinfo/midpoint
>
> _______________________________________________
> midPoint mailing list
> 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/20200514/d0cd5a6a/attachment.htm>