[midPoint] MySQL connector
Aram Somoundji
aramso89 at hotmail.com
Tue Jun 11 15:27:46 CEST 2013
thank you very much, the resource definition worked.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.thank you,Aram
Date: Tue, 11 Jun 2013 14:54:48 +0200
From: ivan.noris at evolveum.com
To: midpoint at lists.evolveum.com
Subject: Re: [midPoint] MySQL connector
Hi Aram,
please try this
CREATE USER 'midpointadmin'@'%' IDENTIFIED BY 'secret';
CREATE USER 'midpointadmin'@'localhost' IDENTIFIED BY 'secret';
GRANT ALL on *.* TO 'midpointadmin'@'%' WITH GRANT OPTION;
GRANT ALL on *.* TO 'midpointadmin'@'localhost' WITH GRANT OPTION;
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)
Ivan
On 06/11/2013 02:18 PM, Aram Somoundji
wrote:
yes I applied the example. And this is what I have
in the phpMyAdmin! (attached image)
Could the error be from the JDBC drive?
Aram
Date: Tue, 11 Jun 2013 14:09:53 +0200
From: ivan.noris at evolveum.com
To: midpoint at lists.evolveum.com
Subject: Re: [midPoint] MySQL connector
Hi Aram,
seems your mysql user permissions are not set correctly.
Have you checked/applied the
samples/resources/mysqluser/init-mysql.sql example?
For example:
CREATE USER 'midpointadmin'@'%' IDENTIFIED BY 'secret';
GRANT ALL on *.* TO 'midpointadmin'@'%' WITH GRANT OPTION;
Regards,
Ivan
On 06/11/2013 01:46 PM, Aram
Somoundji wrote:
Hi,
Sorry for bothering!
I have this problem (attached image) while trying
to test the connection between MidPoint and MySQL.
Can anyone help me?
thank you,
Aram
From: aramso89 at hotmail.com
To: midpoint at lists.evolveum.com
Date: Mon, 10 Jun 2013 18:52:52 +0300
Subject: Re: [midPoint] MySQL connector
thank you very much. Your mails were
very helpful! :)
Aram
Date: Mon, 10 Jun
2013 17:45:51 +0200
From: ivan.noris at evolveum.com
To: midpoint at lists.evolveum.com
Subject: Re: [midPoint] MySQL connector
Hi Aram,
as Paul and Vilo already pointed out, you
probably want DBTable connector.
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:
http://maven.forgerock.org/repo/repo/org/forgerock/openicf/connectors/db/openicf-mysqluser-connector/1.1.0.0-SNAPSHOT/
Namely: 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
You copy the file to your
$midpoint.home/icf-connectors directory and
restart midPoint (application server).
Then you can import the sample resource
configuration https://svn.evolveum.com/midpoint/trunk/samples/resources/mysqluser/mysqluser-localhost-advanced-nosync.xml
(for midPoint 2.2-trunk).
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.
Regards,
Ivan
On 06/10/2013
02:58 PM, Aram Somoundji wrote:
And from I can download this connector?
Framework: ICF
Bundle: org.forgerock.openicf.connectors.db.mysqluser
Version: 1.1.0.0.6162
Connector: org.identityconnectors.mysqluser.MySQLUserConnector
thank
you,
Aram
From: aramso89 at hotmail.com
To: midpoint at lists.evolveum.com
Date: Mon, 10 Jun 2013 15:53:10 +0300
Subject: Re: [midPoint] MySQL
connector
Hi,
how can I install the jar file
link: https://wiki.evolveum.com/display/midPoint/DatabaseTable
Thank you,
Aram
> Date: Sun, 9 Jun 2013
19:37:44 +0100
> From: lists at pheaney.co.uk
> To: midpoint at lists.evolveum.com
> Subject: Re: [midPoint]
MySQL connector
>
> Hi Aram,
>
> On 09/06/13 17:26, Aram
Somoundji wrote:
> >
> > Can anyone give me the
connector for MySQL because the
link of the
> > connector in the wiki
is unavailable.
> >
> >
> I've corrected the link on
the wiki for the MySQL user
resource sample,
> the resource is available
at
> https://svn.evolveum.com/midpoint/trunk/samples/resources/mysqluser/mysqluser-localhost-advanced-nosync.xml.
>
> Are you looking to create
MySQL users (people who are able
to log into
> MySQL) or users within a
MySQL table? If its the latter
then its the
> database table resource
> (https://wiki.evolveum.com/display/midPoint/DatabaseTable)
you need.
>
> Cheers
> Paul
>
_______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
_______________________________________________
midPoint mailing list midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
--
Ing. Ivan Noris
Consultant
Evolveum, s.r.o
___________________________________________________
"Semper cautus - semper paratus - semper idem Vix."
_______________________________________________
midPoint mailing list midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
_______________________________________________
midPoint mailing list midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
--
Ing. Ivan Noris
Consultant
Evolveum, s.r.o
___________________________________________________
"Semper cautus - semper paratus - semper idem Vix."
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
--
Ing. Ivan Noris
Consultant
Evolveum, s.r.o
___________________________________________________
"Semper cautus - semper paratus - semper idem Vix."
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20130611/26b50f94/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled2.png
Type: image/png
Size: 126412 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20130611/26b50f94/attachment.png>
More information about the midPoint
mailing list