[midPoint] MySQL/MariaDB resource can't be reached by its DataSource name

[Ivan Noris]

Hi Ramón,

the configuration for datasource is for making midPoint repository use
the datasource instead of jdbc host/port/user/password in config.xml.
That actually works even if I don't use it very often.

But I think we have never used DBTable connector with datasource
configuration ;-)

It seems like the connector is unable to find the datasource. Have you
configured the <tomcat>/conf/context.xml as in the Data source
configuration here
https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-Datasourceconfiguration?
Might be that this is somehow changed for Tomcat 8, I was only trying
datasource for Tomcat 7.

But as I've said, I have never used datasource for DBTable connector yet.

I will try to setup similar setup on my side, but it will probably take
a few days.

Best regards,
Ivan

On 06/17/2016 10:27 AM, Ramón Cahenzli wrote:
> Hi Ivan,
>
> Thanks for the response.
>
>> OK so maybe I was reacting too soon. It seems you are doing
>> provisioning to MySQL/MariaDB using datasource...
> Yes, that sounds about right (I'm not quite fluent in midPoint lingo
> yet) :)
>
>  
>> Could you please share the MySQL resource configuration?
> I've adapted the config with the first two steps from here:
>
> https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-Datasourceconfiguration
>
> The last step isn't necessary because I don't want to keep using H2 for
> now in midPoint, but it can't hurt to set up the data sources this way,
> correct? The source still works under the name jdbc/peeps when used
> from my test JSP.
>
> The config files are in this gist:
>
> https://gist.github.com/psy-q/8c0d931ea53eb35bf5098b59dd38a76d
>
> Cheers,
>

-- 
  Ing. Ivan Noris
  Senior Identity Management Engineer & IDM Architect
  evolveum.com                     evolveum.com/blog/
  ___________________________________________________
  "Semper ID(e)M Vix."