[jira] [Commented] (CONNECTORS-842) Ambiguous documentation

["Karl Wright (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CONNECTORS-842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13850884#comment-13850884 ] 

Karl Wright commented on CONNECTORS-842:
----------------------------------------

Hi Chris,

There are two ways to address this issue.  The first would be to include mysql documentation for this property, or even include it in the example properties.xml.  The second would be to change the default value of this property to "%" in the mysql database implementation.  Which would you think was more appropriate?



> Ambiguous documentation
> -----------------------
>
>                 Key: CONNECTORS-842
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-842
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: ManifoldCF 1.4.1
>            Reporter: Chris Griffin
>            Priority: Trivial
>
> The documentation is lacking the following instructions for running the initialize.sh script when the database is located on a remote server.  For example, we created a MySQL database on a different server than where we installed manifoldCF.  When executing the initialze.sh script, the database was created, as well as the user; however, the user was created with client access of "localhost" by default.  When the script got to the "creating tables" phase as the user, instead of the admin user, it received an "access denied".  After looking through the code, I saw that the following setting should be set in properties.xml:
>  <property name="org.apache.manifoldcf.mysql.client" value="%"/>
> The % sign indicates that the user can login to the mysql host from anywhere.  I could have put the ip address of the server where I am running manifoldCF as well, but we have no particular security concerns in our dev environment.
> After setting this, the script ran successfully.
> Thanks,
> Chris Griffin



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)