Installing MySQL client for MariaDB databases
To use MariaDB as a backend database for Hue, you must install the MySQL client and other required dependencies on all the Hue hosts based on your operating system.
- SSH into the Hue host as a root user.
- Install the required dependencies as follows:
yum install -y xmlsec1 xmlsec1-openssl
- Add the path where you installed the packages to the PATH environment variable as follows:
export PATH=/usr/local/bin:$PATH
- Install the MySQL client as follows:
pip3.8 install mysqlclient
- SSH into the Hue host as a root user.
- Install the required dependencies as follows:
yum install mysql-devel yum install -y xmlsec1 xmlsec1-openssl
- Add the path where you installed the packages to the PATH environment variable as follows:
export PATH=/usr/local/bin:$PATH
- Install the MySQL client as follows: (RHEL 8)
pip3.8 install mysqlclient
(RHEL 9)pip3.9 install mysqlclient
- SSH into the Hue host as a root user.
- Install the required packages and dependencies as follows:
zypper install libmysqlclient-devel zypper install xmlsec1 zypper install xmlsec1-devel zypper install xmlsec1-openssl-devel
- Add the path where you installed the packages to the PATH environment variable as follows:
export PATH=/usr/local/bin:$PATH
- Install the MySQL client as follows:
pip3.8 install mysqlclient
- SSH into the Hue host as a root user.
- Install the required packages and dependencies as follows:
apt-get install libmysqlclient-dev apt-get install -y xmlsec1 apt-get install libxmlsec1-openssl
- Add the path where you installed the packages to the PATH environment variable as follows:
export PATH=/usr/local/bin:$PATH
- Install the MySQL client as follows:
pip3.8 install mysqlclient