Where to point Connect to external MySQL Instance after installation

OL Connect Professional General
1

Hi,

Connect was installed with local MySQL database. If I wanted to point Connect to an external MySQL database, where exactly would I do that?

Thank you!

2

Hello shootace,

Unfortunately at this point there is no way to change the database that Connect uses once it is installed - this has to be done during installation. In order to point to MySQL externally, you will need to uninstall Connect and re-install it.

During installation, you may choose to uncheck the MySQL option from the components, and later on in the wizard, enter the credentials for your own server.

Please refer to the followign pages for more details:

Regards,
Evie

3

Hi Evie,

I have uninstalled and reinstalled Connect, but this time selecting the external MySQL instance. I clicked on test connection and it was successful.

I am now trying to run a test. At first I received an unauthorized error on the execute data mapping error. I opened Server Configuration and unchecked the security box. When I run in debug again the process stays on the Execute Data Mapping step for over 10 minutes, before I have to force debug to quit. Previously it was only taking seconds. If I enter the username and password of the external MySQL instance in Server Configuration; I receive the unauthorized error once again. Any ideas on what I could check for this issue?

Thank you!

4

I entered MySQL username/password from external instance into the OL Connect section in the Workflow Preferences. I used port 3306. When I run a test in debug I receive a “Connection reset by peer” socket error. It sounds like MySQL on the other server is blocking access to it. I am working with the DB Admin. on this issue. Anything we should be aware of other than the My.ini settings in the installation guide?

Thank you!

5

Hello again,

The technical requirements for the MySQL instance are indicated in the page I linked to, Database Considerations. This is generally enough for a DB Admin to figure things out.

The settings in the OL Connect section and the Server Preferences have nothing to do with the MySQL DB. In the Server Configuration screen, you are actually setting a username and password for the Connect server. This information is needed for any client (Connect Designer, as well as Workflow) to use the Server. In Designer, this is set in the General Print Preferences (and automatically set at install unless you change them). In Workflow, this is set in the OL Connect section. The credentials set in the Server Preferences and the OL Connect and Print PReferences MUST match, but they do not need to (and probably should not) be identical to your MySQL settings. This means in the OL Connect section, the “server address” should be localhost (the Connect Server instance), port 9340, and the username and password should match the Server config.

Hope that clarifies things.