[midPoint] MySQL connector
Ivan Noris
ivan.noris at evolveum.com
Tue Jun 11 14:54:48 CEST 2013
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 <mailto:aramso89 at hotmail.com>
> To: midpoint at lists.evolveum.com <mailto: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 <mailto:ivan.noris at evolveum.com>
> To: midpoint at lists.evolveum.com <mailto: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 <mailto:aramso89 at hotmail.com>
> To: midpoint at lists.evolveum.com
> <mailto: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 <mailto:lists at pheaney.co.uk>
> > To: midpoint at lists.evolveum.com
> <mailto: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 <mailto:midPoint at lists.evolveum.com>
> > http://lists.evolveum.com/mailman/listinfo/midpoint
>
> _______________________________________________ midPoint
> mailing list midPoint at lists.evolveum.com
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com <mailto: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
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
> _______________________________________________ midPoint mailing
> list midPoint at lists.evolveum.com
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com <mailto: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."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20130611/e8553955/attachment.htm>
More information about the midPoint
mailing list