Mailing-List: contact connectors-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: connectors-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of daddywri@gmail.com designates
 209.85.217.175 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAGXi7oPdfd77oSbLqj1-_sE26hjp+SEcerUO=P-737kDUxHhUw@mail.gmail.com>
References: 
 <CAGXi7oPdfd77oSbLqj1-_sE26hjp+SEcerUO=P-737kDUxHhUw@mail.gmail.com>
Date: Mon, 21 May 2012 05:51:46 -0400
Message-ID: 
 <CALUFAGAnJ_gYz3+DXBiOZ5PR_HhJ0wWYangmZT_p7rVSXNT2Zw@mail.gmail.com>
Subject: Re: When running on MySQL initialize.sh causes access denied error
From: Karl Wright <daddywri@gmail.com>
To: connectors-user@incubator.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

This sounds like a reasonable fix.

Would you be so kind as to create a ticket, and attach your proposed
change?  Adding a special property for mysql is also reasonable.

Karl

On Mon, May 21, 2012 at 5:34 AM, Shigeki Kobayashi
<shigeki.kobayashi3@g.softbank.co.jp> wrote:
>
> Hi guys.
>
> I suppose some pepole use multiple servers to create MCF-MySQL environtme=
nt.
> Well, I'm one of them but I found that initialize.sh causes access denied
> error if DB server is seperated from MCF's.
>
> Suppose each server's IP are like followings:
>
> MySQL Server IP: A
> MCF Server IP: B
>
> and properties.xml has the follwing parameters and values:
>
> =A0<property name=3D"org.apache.manifoldcf.databaseimplementationclass"
> value=3D"org.apache.manifoldcf.core.database.DBInterfaceMySQL"/>
> =A0<property name=3D"org.apache.manifoldcf.dbsuperusername" value=3D"root=
"/>
> =A0<property name=3D"org.apache.manifoldcf.dbsuperuserpassword"
> value=3D"<password>"/>
> =A0<property name=3D"org.apache.manifoldcf.database.name" value=3D"manifo=
ldcf"/>
> =A0<property name=3D"org.apache.manifoldcf.mysql.server" value=3D"A"/>
>
> Then, executing initialize.sh causes the follwing error:
>
> Caused by: java.sql.SQLException: Access denied for user 'manifoldcf'@'B'
> (using password: YES)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.SQLError.createSQLException(SQLError.ja=
va:1073)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3=
609)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3=
541)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:9=
43)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113=
)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)
> =A0 =A0 =A0 =A0 at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336)
> =A0 =A0 =A0 =A0 at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
> =A0 =A0 =A0 =A0 at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.ja=
va:792)
> =A0 =A0 =A0 =A0 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.=
java:47)
> =A0 =A0 =A0 =A0 at sun.reflect.NativeConstructorAccessorImpl.newInstance0=
(Native
> Method)
> =A0 =A0 =A0 =A0 at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAc=
cessorImpl.java:39)
>
> The problem is that MCF requests MySQL to create a new "manifoldcf" user
> with localhost access.
> In this case, of course, MCF is on the server with IP B, MySQL should cre=
ate
> a new user with IP Address B.
>
> The following method is the one creating a new MySQL user in the user
> table.
> Modifying the part where IP information is added solves this problem.
>
>
> JAR NAME =A0 :mcf-core.jar
> PACKAGE =A0 =A0:org.apache.manifoldcf.core.database
> CLASS NAME :DBInterfaceMySQL
> METHOD NAME: public void createUserAndDatabase
>
> =A0 =A0 =A0 =A0 =A0 =A0 if(userName !=3D null)
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 try
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 {
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 list.clear();
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 list.add(userName);
> =A0 =A0 =A0 =A0 =A0 =A0 =A0// =A0 =A0 list.add("localhost");
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 list.add(IP_ADDRESS_B);
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 list.add(password);
> ...
> ...
> }
>
>
> I guess it would be nice if properties.xml can have a new property taking
> MCF server IP to
> have MySQL create a "manifoldcf" user with that IP. What do you think?
>
>
> Regards,
>
> Shigeki
>
>