JDBC-Sync

[Rudolf Plettenberg]

Hi all,

Our users are created in an external MariaDB.
Whenever a User is created/changed there I want to sync it into OpenIAM and provision it to AD and other programs.

MariaDB ==> OpenIAM ==> AD/Applications/…

However, I am struggling to get the JDBC-Sync to work.

1. I configured the managed System (jdbc-url, username, password)
2. I configures the synchronisation (kept all default values)
However, when testing the connection it fails an internal error occurs

What am I missing? Is there any tutorial or documentation on how to properly configure a jdbc connection?

Thank you in advance
Best regards

[suneet_shah]

Hi Rudolf

We will post a tutorial this week on how to setup a JDBC synch which should help you get past this.

[Rudolf Plettenberg]

Hi,

thank your very much. This would help a lot.
I am looking forward to it.

best regards

[Rudolf Plettenberg]

Hi Suneet,

I am unable to find the tutorial. Can you please nudge me in the right direction?

Thank you,
best regards

[Tamas Galosi]

Hi,

Same here. I tried to edit the example MySQL, but I’m not sure what modifications should I do
in regards of connection URL and JDBC driver.
I always get a SQL connection parameters are wrong error message.
I installed OpenIAM with Docker Swarm. Are there any more descriptive logs that I could check,
or any examples on how to do this?

Thank you!

[Author]

Posts