<HTML><BODY>thank .IT works. <br><br><br><blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
Пятница, 17 июня 2016, 14:59 +03:00 от Ivan Noris <ivan.noris@evolveum.com>:<br>
<br>
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div>
<base target="_self" href="https://e.mail.ru/">
<div id="style_14661647700000000485_BODY">
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>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 href="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/bundle/com.evolveum.polygon.connector-databasetable/org.identityconnectors.databasetable.DatabaseTableConnector" target="_blank">"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></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
evolveum.com evolveum.com/blog/
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</div>
<div>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</div>
<base target="_self" href="https://e.mail.ru/">
</div>
</div>
</div>
</blockquote>
<br></BODY></HTML>