[midPoint] MySQL connector

Tue Jun 11 14:18:12 CEST 2013

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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20130611/ee21d0bf/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled1.png
Type: image/png
Size: 114095 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20130611/ee21d0bf/attachment.png>