Error creating dSource for MYSQL on CentOS 6.7 with Delphix Express 4.3.3

  • 0
  • 1
  • Problem
  • Updated 2 years ago
  • Solved
Hi there

I am trying to set up Delphix Express 4.3.3 to work with MYSQL on Centos 6.

I installed 2 VMs from scratch on VMWare Workstation 11 running Centos and installed MySQL using yum.

I have (hopefully) followed the prerequisite steps for source and target hosts for MySQL.

I have added the Environment and it connects when I test the connection.

When I go to Manage -> Environments -> Add Dataset Home +

I use the following :

* Type = MySQL
*Installation = /usr/bin/mysql (output of 'which mysql' command)


I get the following error :

The host "192.168.102.133" of type "Linux" is not supported for repository "/usr/bin/mysql".

Error Code
exception.environment.host.not.compatible



Please help - what am I doing wrong ? Why is this not compatible / supported? Where do I start troubleshooting ?

Thank You

--s

versions
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Linux localhost.localdomain 2.6.32-504.el6.x86_64 #1 SMP Wed Oct 15 04:27:16 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Photo of suikoalston

suikoalston

  • 130 Points 100 badge 2x thumb
  • lost

Posted 2 years ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Official Rep

  • 2,392 Points 2k badge 2x thumb
Official Response
Hello,

It does not look like you are running a supported flavor of Linux or a supported version of MySQL:

https://docs.delphix.com/display/DOCS43/_Supported+Operations+Systems+and+Versions+for+MySQL

Thanks,
  Neal
(Edited)
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Official Response
CentOS 6 should be fine, but the MySQL version is too low. (needs to be 5.5+) Once you have updated your MySQL to a supported version, you should be able to refresh your environments in Delphix and the dataset homes will automatically be discovered and set for you.