[midPoint] midpoint mysql

[Ivan Noris]

Hi Oleg,

in our samples we are using:

               
<icscdbtable:jdbcDriver>com.mysql.jdbc.Driver</icscdbtable:jdbcDriver>

Please put mysql jdbc driver to Tomcat lib directory. I have:

/usr/local/apache-tomcat/lib/mysql-connector-java-5.1.33.jar

Then restart Tomcat.

Regards,
Ivan

On 06/17/2016 01:35 PM, oleg okunev wrote:
>
> hi everyone!
>
> your project is very good)
>
> but i have some problems. may be my english is not very well sory/
>
> so
> i have:
>
> About midPoint
> Version 3.3.1
> Git describe git-v3.3.1
>
> and
> ICF org.identityconnectors.databasetable.DatabaseTableConnector v1.4.0.49 
>
> i want to connect to other host with mysql
> i take sample from git 
>
> <connectorRef type="ConnectorType">
> <filter>
> <q:equal>
> <q:path>c:connectorType</q:path>
> <q:value>org.identityconnectors.databasetable.DatabaseTableConnector</q:value>
> </q:equal>
> </filter>
> </connectorRef>
>
> <!-- Configuration section contains configuration of the connector,
> such as hostnames and passwords -->
> <connectorConfiguration>
>
> <!-- Configuration specific for the DBTable connector -->
> <icfc:configurationProperties
> xmlns:icscdbtable="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/bundle/com.evolveum.polygon.connector-databasetable/org.identityconnectors.databasetable.DatabaseTableConnector">
> <icscdbtable:port>3306</icscdbtable:port>
> <icscdbtable:quoting></icscdbtable:quoting>
> <icscdbtable:host>192.168.10.208</icscdbtable:host>
> <icscdbtable:user>midpoint_tests</icscdbtable:user>
> <icscdbtable:password><clearValue>secret</clearValue></icscdbtable:password>
> <icscdbtable:database>midpoint_tests</icscdbtable:database>
> <icscdbtable:table>idrepo</icscdbtable:table>
> <icscdbtable:keyColumn>userId</icscdbtable:keyColumn>
> <icscdbtable:passwordColumn>password</icscdbtable:passwordColumn>
>
> <icscdbtable:jdbcDriver>org.gjt.mm.mysql.Driver</icscdbtable:jdbcDriver>
>     and try com.mysql.jdbc.Driver
>
> <icscdbtable:jdbcUrlTemplate>jdbc:mysql://%h:%p/%d?useUnicode=true&characterEncoding=utf8&connectionCollation=utf8_bin</icscdbtable:jdbcUrlTemplate>
> <icscdbtable:enableEmptyString>false</icscdbtable:enableEmptyString>
> <icscdbtable:rethrowAllSQLExceptions>true</icscdbtable:rethrowAllSQLExceptions>
> <icscdbtable:nativeTimestamps>false</icscdbtable:nativeTimestamps>
> <icscdbtable:allNative>false</icscdbtable:allNative>
> <icscdbtable:changeLogColumn>change_timestamp</icscdbtable:changeLogColumn>
> <icscdbtable:datasource></icscdbtable:datasource>
> </icfc:configurationProperties>
>
> BUT
> i have error 
>  Configuration error: JDBC Driver is not found on classpath.
>
> where i have mistake?
>
> -- 
> oleg okunev
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160617/be8451e8/attachment.htm>