<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>thank you very much, the resource definition worked.<div>Now I am getting errors when I try to create, modify or delete users from MidPoint to MySQL. Sometimes the modification is applied in MySQL but MidPoint gives an error.</div><div>thank you,</div><div>Aram<br><br><div><hr id="stopSpelling">Date: Tue, 11 Jun 2013 14:54:48 +0200<br>From: ivan.noris@evolveum.com<br>To: midpoint@lists.evolveum.com<br>Subject: Re: [midPoint] MySQL connector<br><br>
Hi Aram,<br>
<br>
please try this<br>
<br>
CREATE USER 'midpointadmin'@'%' IDENTIFIED BY 'secret';<br>
CREATE USER 'midpointadmin'@'localhost' IDENTIFIED BY 'secret';<br>
GRANT ALL on *.* TO 'midpointadmin'@'%' WITH GRANT OPTION;<br>
GRANT ALL on *.* TO 'midpointadmin'@'localhost' WITH GRANT OPTION;<br>
<br>
i've just dropped midpointadmin user(s) and recreated using this
script, and it seems to work (I can log in using mysql -u
midpointadmin -p)<br>
<br>
Ivan<br>
<br>
<div class="ecxmoz-cite-prefix">On 06/11/2013 02:18 PM, Aram Somoundji
wrote:<br>
</div>
<blockquote cite="mid:DUB122-W18F14BB7EDC2453D4056E8CD850@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">yes I applied the example. And this is what I have
in the phpMyAdmin! (attached image)
<div><br>
</div>
<div>Could the error be from the JDBC drive?</div>
<div><br>
</div>
<div>Aram<br>
<br>
<div>
<hr id="ecxstopSpelling">Date: Tue, 11 Jun 2013 14:09:53 +0200<br>
From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:ivan.noris@evolveum.com">ivan.noris@evolveum.com</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
Subject: Re: [midPoint] MySQL connector<br>
<br>
Hi Aram,<br>
<br>
seems your mysql user permissions are not set correctly.<br>
<br>
Have you checked/applied the
samples/resources/mysqluser/init-mysql.sql example?<br>
<br>
For example:<br>
<br>
CREATE USER 'midpointadmin'@'%' IDENTIFIED BY 'secret';<br>
GRANT ALL on *.* TO 'midpointadmin'@'%' WITH GRANT OPTION;<br>
<br>
Regards,<br>
Ivan<br>
<br>
<div class="ecxmoz-cite-prefix">On 06/11/2013 01:46 PM, Aram
Somoundji wrote:<br>
</div>
<blockquote cite="mid:DUB122-W32D6DB54F49462C9A66D11CD850@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">Hi,
<div>Sorry for bothering! </div>
<div>I have this problem (attached image) while trying
to test the connection between MidPoint and MySQL.</div>
<div>Can anyone help me?</div>
<div>thank you,</div>
<div>Aram</div>
<div><br>
<br>
<div>
<hr id="ecxstopSpelling">From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:aramso89@hotmail.com">aramso89@hotmail.com</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
Date: Mon, 10 Jun 2013 18:52:52 +0300<br>
Subject: Re: [midPoint] MySQL connector<br>
<br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">thank you very much. Your mails were
very helpful! :)
<div>Aram<br>
<br>
<div>
<hr id="ecxstopSpelling">Date: Mon, 10 Jun
2013 17:45:51 +0200<br>
From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:ivan.noris@evolveum.com">ivan.noris@evolveum.com</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
Subject: Re: [midPoint] MySQL connector<br>
<br>
Hi Aram,<br>
<br>
as Paul and Vilo already pointed out, you
probably want DBTable connector.<br>
<br>
If you for whatever reason, need to manage
MySQL *users*, you can download the connector
from Forgerock. This is the best download link
I was able to find now:<br>
<br>
<a class="ecxmoz-txt-link-freetext" href="http://maven.forgerock.org/repo/repo/org/forgerock/openicf/connectors/db/openicf-mysqluser-connector/1.1.0.0-SNAPSHOT/" target="_blank">http://maven.forgerock.org/repo/repo/org/forgerock/openicf/connectors/db/openicf-mysqluser-connector/1.1.0.0-SNAPSHOT/</a><br>
<br>
Namely: <a class="ecxmoz-txt-link-freetext" href="http://maven.forgerock.org/repo/repo/org/forgerock/openicf/connectors/db/openicf-mysqluser-connector/1.1.0.0-SNAPSHOT/openicf-mysqluser-connector-1.1.0.0-SNAPSHOT.jar" target="_blank">http://maven.forgerock.org/repo/repo/org/forgerock/openicf/connectors/db/openicf-mysqluser-connector/1.1.0.0-SNAPSHOT/openicf-mysqluser-connector-1.1.0.0-SNAPSHOT.jar</a><br>
<br>
You copy the file to your
$midpoint.home/icf-connectors directory and
restart midPoint (application server).<br>
<br>
Then you can import the sample resource
configuration <a class="ecxmoz-txt-link-freetext" href="https://svn.evolveum.com/midpoint/trunk/samples/resources/mysqluser/mysqluser-localhost-advanced-nosync.xml" target="_blank">https://svn.evolveum.com/midpoint/trunk/samples/resources/mysqluser/mysqluser-localhost-advanced-nosync.xml</a>
(for midPoint 2.2-trunk).<br>
<br>
But as far as you need to manage different
users than mysql internal system users, you
would wish to use the DBTable connector and
the information written earlier today.<br>
<br>
Regards,<br>
Ivan<br>
<br>
<div class="ecxmoz-cite-prefix">On 06/10/2013
02:58 PM, Aram Somoundji wrote:<br>
</div>
<blockquote cite="mid:DUB122-W370FF148F71A40BBF3FF81CD840@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr"><br>
And from I can download this connector?
<div><strong style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">Framework:</strong><span style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;"> ICF</span><br style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">
<strong style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">Bundle:</strong><span style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;"> org.forgerock.openicf.connectors.db.mysqluser</span><br style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">
<strong style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">Version:</strong><span style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;"> 1.1.0.0.6162</span><br style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">
<strong style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;">Connector:</strong><span style="color:rgb(51, 51, 51);font-family:Arial, sans-serif;font-size:13.63636302947998px;line-height:18.18181800842285px;"> org.identityconnectors.mysqluser.MySQLUserConnector</span></div>
<div><font color="#333333" face="Arial, sans-serif"><span style="font-size:14px;line-height:18.171875px;"><br>
</span></font></div>
<div><font color="#333333" face="Arial, sans-serif"><span style="font-size:14px;line-height:18.171875px;">thank
you,</span></font></div>
<div><font color="#333333" face="Arial, sans-serif"><span style="font-size:14px;line-height:18.171875px;">Aram<br>
</span></font>
<div>
<hr id="ecxstopSpelling">From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:aramso89@hotmail.com">aramso89@hotmail.com</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
Date: Mon, 10 Jun 2013 15:53:10 +0300<br>
Subject: Re: [midPoint] MySQL
connector<br>
<br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">Hi,
<div><br>
</div>
<div>how can I install the jar file
link: <a href="https://wiki.evolveum.com/display/midPoint/DatabaseTable" target="_blank">https://wiki.evolveum.com/display/midPoint/DatabaseTable</a><br>
<br>
Thank you,</div>
<div><br>
</div>
<div>Aram<br>
<div>> Date: Sun, 9 Jun 2013
19:37:44 +0100<br>
> From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:lists@pheaney.co.uk">lists@pheaney.co.uk</a><br>
> To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br>
> Subject: Re: [midPoint]
MySQL connector<br>
> <br>
> Hi Aram,<br>
> <br>
> On 09/06/13 17:26, Aram
Somoundji wrote:<br>
> ><br>
> > Can anyone give me the
connector for MySQL because the
link of the <br>
> > connector in the wiki
is unavailable.<br>
> ><br>
> ><br>
> I've corrected the link on
the wiki for the MySQL user
resource sample, <br>
> the resource is available
at <br>
> <a class="ecxmoz-txt-link-freetext" href="https://svn.evolveum.com/midpoint/trunk/samples/resources/mysqluser/mysqluser-localhost-advanced-nosync.xml" target="_blank">https://svn.evolveum.com/midpoint/trunk/samples/resources/mysqluser/mysqluser-localhost-advanced-nosync.xml</a>.<br>
> <br>
> Are you looking to create
MySQL users (people who are able
to log into <br>
> MySQL) or users within a
MySQL table? If its the latter
then its the <br>
> database table resource <br>
> (<a class="ecxmoz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/DatabaseTable" target="_blank">https://wiki.evolveum.com/display/midPoint/DatabaseTable</a>)
you need.<br>
> <br>
> Cheers<br>
> Paul<br>
>
_______________________________________________<br>
> midPoint mailing list<br>
> <a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
> <a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</div>
</div>
</div>
<br>
_______________________________________________
midPoint mailing list <a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a></div>
</div>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="ecxmoz-signature">--
Ing. Ivan Noris
Consultant
Evolveum, s.r.o
___________________________________________________
"Semper cautus - semper paratus - semper idem Vix."
</pre>
<br>
_______________________________________________
midPoint mailing list <a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a></div>
</div>
</div>
<br>
_______________________________________________
midPoint mailing list <a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a></div>
</div>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="ecxmoz-signature">--
Ing. Ivan Noris
Consultant
Evolveum, s.r.o
___________________________________________________
"Semper cautus - semper paratus - semper idem Vix."
</pre>
<br>
_______________________________________________
midPoint mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a></div>
</div>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="ecxmoz-signature">--
Ing. Ivan Noris
Consultant
Evolveum, s.r.o
___________________________________________________
"Semper cautus - semper paratus - semper idem Vix."
</pre>
<br>_______________________________________________
midPoint mailing list
midPoint@lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint</div></div> </div></body>
</html>