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

[Pavol Mederly]

Hello Petr,

you're right. But you know the (usual) limitations :-)

Pavol Mederly
Software developer
evolveum.com

On 14/05/2020 11:15, Petr Gašparík - AMI Praha a.s. wrote:
> 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 <mailto: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 <https://www.ami.cz>
>
> 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 
> <mailto: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 developer
>     evolveum.com  <http://evolveum.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 <mailto:richard.frovarp at ndsu.edu>
>>     *Sent: *Tuesday, May 12, 2020 12:07 PM
>>     *To: *midpoint at lists.evolveum.com
>>     <mailto: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
>>     <mailto: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
>>     <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 <mailto: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
>>
>>     >
>>
>>     >
>>
>>     >
>>
>>     > _______________________________________________
>>
>>     > midPoint mailing list
>>
>>     > midPoint at lists.evolveum.com <mailto: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
>>
>>
>>     _______________________________________________
>>     midPoint mailing list
>>     midPoint at lists.evolveum.com  <mailto: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
>
>
> _______________________________________________
> 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/6451f0a7/attachment.htm>