<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Oleg,<br>
<br>
in our samples we are using:<br>
<br>
<icscdbtable:jdbcDriver>com.mysql.jdbc.Driver</icscdbtable:jdbcDriver><br>
<br>
Please put mysql jdbc driver to Tomcat lib directory. I have:<br>
<br>
/usr/local/apache-tomcat/lib/mysql-connector-java-5.1.33.jar<br>
<br>
Then restart Tomcat.<br>
<br>
Regards,<br>
Ivan<br>
<br>
<div class="moz-cite-prefix">On 06/17/2016 01:35 PM, oleg okunev
wrote:<br>
</div>
<blockquote cite="mid:1466163306.305308884@f367.i.mail.ru"
type="cite">
<br>
hi everyone!<br>
<br>
your project is very good)<br>
<br>
but i have some problems. may be my english is not very well sory/<br>
<br>
so<br>
i have:<br>
<p>About midPoint<br>
Version 3.3.1<br>
Git describe git-v3.3.1</p>
and<br>
ICF org.identityconnectors.databasetable.DatabaseTableConnector
v1.4.0.49 <br>
<br>
i want to connect to other host with mysql<br>
i take sample from git <br>
<br>
<p><span style="font-size: 12px;"><connectorRef
type="ConnectorType"></span><br>
<span style="font-size: 12px;"> <filter></span><br>
<span style="font-size: 12px;"> <q:equal></span><br>
<span style="font-size: 12px;">
<q:path>c:connectorType</q:path></span><br>
<span style="font-size: 12px;">
<q:value>org.identityconnectors.databasetable.DatabaseTableConnector</q:value></span><br>
<span style="font-size: 12px;"> </q:equal></span><br>
<span style="font-size: 12px;"> </filter></span><br>
<span style="font-size: 12px;"> </connectorRef></span></p>
<p><span style="font-size: 12px;"><!-- Configuration section
contains configuration of the connector,</span><br>
<span style="font-size: 12px;"> such as hostnames and passwords
--></span><br>
<span style="font-size: 12px;"> <connectorConfiguration></span></p>
<p><span style="font-size: 12px;"><!-- Configuration specific
for the DBTable connector --></span><br>
<span style="font-size: 12px;"> <icfc:configurationProperties</span><br>
<span style="font-size: 12px;">
xmlns:icscdbtable=<a class="moz-txt-link-rfc2396E" href="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/bundle/com.evolveum.polygon.connector-databasetable/org.identityconnectors.databasetable.DatabaseTableConnector">"http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/bundle/com.evolveum.polygon.connector-databasetable/org.identityconnectors.databasetable.DatabaseTableConnector"</a>></span><br>
<span style="font-size: 12px;">
<icscdbtable:port>3306</icscdbtable:port></span><br>
<span style="font-size: 12px;">
<icscdbtable:quoting></icscdbtable:quoting></span><br>
<span style="font-size: 12px;">
<icscdbtable:host>192.168.10.208</icscdbtable:host></span><br>
<span style="font-size: 12px;">
<icscdbtable:user>midpoint_tests</icscdbtable:user></span><br>
<span style="font-size: 12px;">
<icscdbtable:password><clearValue>secret</clearValue></icscdbtable:password></span><br>
<span style="font-size: 12px;">
<icscdbtable:database>midpoint_tests</icscdbtable:database></span><br>
<span style="font-size: 12px;">
<icscdbtable:table>idrepo</icscdbtable:table></span><br>
<span style="font-size: 12px;">
<icscdbtable:keyColumn>userId</icscdbtable:keyColumn></span><br>
<span style="font-size: 12px;">
<icscdbtable:passwordColumn>password</icscdbtable:passwordColumn><br>
</span><br>
<span style="font-size: 15px; color: rgb(254, 94, 94);">
<icscdbtable:jdbcDriver>org.gjt.mm.mysql.Driver</icscdbtable:jdbcDriver>
and try com.mysql.jdbc.Driver</span><br>
<span style="font-size: 12px;"> <br>
<icscdbtable:jdbcUrlTemplate>jdbc:mysql://%h:%p/%d?useUnicode=true&characterEncoding=utf8&connectionCollation=utf8_bin</icscdbtable:jdbcUrlTemplate></span><br>
<span style="font-size: 12px;">
<icscdbtable:enableEmptyString>false</icscdbtable:enableEmptyString></span><br>
<span style="font-size: 12px;">
<icscdbtable:rethrowAllSQLExceptions>true</icscdbtable:rethrowAllSQLExceptions></span><br>
<span style="font-size: 12px;">
<icscdbtable:nativeTimestamps>false</icscdbtable:nativeTimestamps></span><br>
<span style="font-size: 12px;">
<icscdbtable:allNative>false</icscdbtable:allNative></span><br>
<span style="font-size: 12px;">
<icscdbtable:changeLogColumn>change_timestamp</icscdbtable:changeLogColumn></span><br>
<span style="font-size: 12px;">
<icscdbtable:datasource></icscdbtable:datasource></span><br>
<span style="font-size: 12px;">
</icfc:configurationProperties></span></p>
BUT<br>
i have error <br>
<span style="color: #b94a48; font-family: 'Source Sans Pro',
'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px;
font-weight: bold; line-height: 20px; background-color:
#eed3d7;" data-mce-style="color: #b94a48; font-family: 'Source
Sans Pro', 'Helvetica Neue', Helvetica, Arial, sans-serif;
font-size: 14px; font-weight: bold; line-height: 20px;
background-color: #eed3d7;"> Configuration error: JDBC Driver is
not found on classpath.<br>
<br>
</span>where i have mistake?<br>
<br>
-- <br>
oleg okunev
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
evolveum.com evolveum.com/blog/
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</body>
</html>