{"id":43898,"date":"2020-03-04T11:44:25","date_gmt":"2020-03-04T18:44:25","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?page_id=43898"},"modified":"2021-11-01T14:37:57","modified_gmt":"2021-11-01T21:37:57","slug":"install-and-migrate-to-mariadb-for-linux","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/","title":{"rendered":"Install and Migrate to MariaDB for Linux"},"content":{"rendered":"<h2><a id=\"post-43898-_heading=h.30j0zll\"><\/a>Introduction<\/h2>\n<p>This document provides information on important changes related to MariaDB and MySQL on Linux. The following changes affect Ephesoft Transact 2019.2 or above:<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>The Ephesoft Transact installer no longer installs any database management systems (DBMS).<\/li>\n<li>Ephesoft Transact no longer supports MySQL databases.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Refer to <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/platform-configurations-and-third-party-integrations\/\">Platform Configurations and Third-Party Integrations <\/a>and reference your version of Ephesoft Transact to find more information on supported database versions.<\/p>\n<h2><a id=\"post-43898-_heading=h.1fob9te\"><\/a>Prerequisites<\/h2>\n<p>To perform the steps listed in this document, you will need super-user (root) permissions. If you are not a super-user, execute the following command to login as the root user:<\/p>\n<pre>sudo su root<\/pre>\n<h2><a id=\"post-43898-_heading=h.3znysh7\"><\/a>Installing Ephesoft Transact<\/h2>\n<p>Follow these instructions if you are installing Ephesoft Transact 2019.2 or above for the first time.<\/p>\n<h3><a id=\"post-43898-_heading=h.2et92p0\"><\/a>Check for MariaDB<\/h3>\n<ol>\n<li>Check your system for an existing instance of MariaDB before installing Ephesoft Transact, as some Linux operating systems include MariaDB.<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>If you do not have an existing instance of MariaDB, proceed to <a href=\"#post-43898-_heading=h.2s8eyo1\">Install MariaDB<\/a>.<\/li>\n<li>If you have an existing instance of MariaDB that is supported for Ephesoft Transact 2019.2 or above, you can return to the Linux install guide for your version.<\/li>\n<li>If you have an existing instance of MariaDB that is not supported for Ephesoft Transact 2019.2 or above, you will need to uninstall your instance of MariaDB and install a supported version.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Important: <\/strong>This will remove all data from your database. It is recommended to take a backup of your database by running the following command:<\/p>\n<pre>mysqldump --all-databases --single-transaction --quick --lock-tables=false &gt; full-backup.sql -uroot -p<strong><em>&lt;password&gt;<\/em><\/strong><\/pre>\n<ol>\n<li style=\"list-style-type: none\">\n<ol start=\"1\" type=\"a\">\n<li>Refer to your operating system below and run the listed command.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><strong>Ubuntu<\/strong>:<\/p>\n<pre>sudo apt-get remove MariaDB-server<\/pre>\n<p><strong>CentOS <\/strong>or <strong>RHEL<\/strong>:<\/p>\n<pre>sudo yum remove MariaDB-server<\/pre>\n<ol start=\"2\" type=\"a\">\n<li style=\"list-style-type: none\">\n<ol start=\"2\" type=\"a\">\n<li>Proceed to <a href=\"#post-43898-_heading=h.2s8eyo1\">Install MariaDB<\/a>.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h2><a id=\"post-43898-_heading=h.tyjcwt\"><\/a>Upgrading Ephesoft Transact<\/h2>\n<p>Follow these instructions if you are upgrading to Ephesoft Transact 2019.2 or above. This section provides instructions on how to upgrade or migrate your database in the following cases:<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Existing MariaDB<\/li>\n<li>Existing MySQL<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><a id=\"post-43898-_heading=h.3dy6vkm\"><\/a>Existing MariaDB<\/h3>\n<p>If you have an existing instance of MariaDB, ensure that your instance of MariaDB is a supported version before upgrading Ephesoft Transact. Refer to <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/platform-configurations-and-third-party-integrations\/\">Platform Configurations and Third-Party Integrations <\/a>and reference your version of Ephesoft Transact for more information.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>If your instance of MariaDB is supported for upgrade to Ephesoft Transact 2019.2 or above, you can return to the Linux upgrade guide for your version.<\/li>\n<li><a id=\"post-43898-_heading=h.1t3h5sf\"><\/a> If your instance of MariaDB is not supported for upgrade to Ephesoft Transact 2019.2 or above, proceed to <a href=\"#post-43898-_heading=h.35nkun2\">Upgrade MariaDB<\/a>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><a id=\"post-43898-_heading=h.4d34og8\"><\/a>Existing MySQL<\/h3>\n<p>Follow these steps if you are currently using MySQL with Ephesoft Transact.<\/p>\n<ol>\n<li>Back up the <strong>ephesoft<\/strong>, <strong>report<\/strong>, and <strong>report_archive<\/strong> databases from the pre-existing MySQL database.\n<ol>\n<li style=\"list-style-type: none\">\n<ol start=\"1\" type=\"a\">\n<li>Run the following command in the MariaDB installation bin folder, located in <strong>&lt;<em>Transact Installation Folder<\/em>&gt;\/Dependencies\/mariadb\/bin\/<\/strong>.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<pre>mysqldump -u<strong><em>&lt;root username&gt;<\/em> <\/strong>-p<strong><em>&lt;root user password&gt;<\/em><\/strong>\u00a0-h<strong><em>&lt;server hostname&gt;<\/em><\/strong>\u00a0-P<strong><em>&lt;database port number&gt;<\/em><\/strong>\u00a0<strong><em>&lt;Database name&gt;<\/em><\/strong> --single-transaction --routines --quick --lock-tables=false &gt; <strong><em>&lt;Folder location&gt;<\/em>.sql<\/strong><\/pre>\n<p><strong>Note<\/strong>: Text listed in angled brackets are placeholders. Replace the placeholders with the relevant information. For <strong>&lt;<em>Folder location&gt;<\/em><\/strong> include the full folder path where the backup file will be created.<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li style=\"list-style-type: none\">\n<ol start=\"2\" type=\"a\">\n<li>Run the mysqldump command for the <strong>ephesoft<\/strong>, <strong>report<\/strong>, and <strong>report-archive<\/strong> databases. Below are sample commands for each:<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<pre>mysqldump -uroot -p ephesoft \u2013-single-transaction \u2013-routines -\u2013quick -\u2013locktables=false &gt; \/opt\/database_backup\/ephesoft.sql\r\nmysqldump -uroot -p report \u2013-single-transaction --routines --quick \u2013-lock-tables=false &gt; \/opt\/database_backup\/report.sql\r\nmysqldump -uroot -p report --single-transaction --routines --quick-lock-tables=false &gt; \/opt\/database_backup\/report_archive.sql<\/pre>\n<ol start=\"2\">\n<li>Stop and disable the service for the MySQL database to prevent it from running.<\/li>\n<li>Install a supported version of MariaDB. You can install MariaDB on the same server where Ephesoft Transact will be installed or choose a dedicated database server. Continue to <a href=\"#post-43898-_heading=h.2s8eyo1\">Install MariaDB<\/a> to proceed.<\/li>\n<\/ol>\n<h2><a id=\"post-43898-_heading=h.2s8eyo1\"><\/a>Install MariaDB<\/h2>\n<p>This section provides information on how to install MariaDB on different Linux distributions: Ubuntu, CentOS, and Red Hat Enterprise Linux (RHEL). Refer to <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/platform-configurations-and-third-party-integrations\/\">Platform Configurations and Third-Party Integrations <\/a>and reference your version of Ephesoft Transact to find more information on supported operating systems.<\/p>\n<p>Follow the instructions for your specific Linux distribution, and proceed with the configuration.<\/p>\n<h3><a id=\"post-43898-_heading=h.17dp8vu\"><\/a>RHEL or CentOS<\/h3>\n<ol>\n<li>Run the following command to add a MariaDB yum repository to your server:<\/li>\n<\/ol>\n<pre>vi \/etc\/yum.repos.d\/MariaDB.repo<\/pre>\n<ol start=\"2\">\n<li>Enter the following text in the MariaDB.repo file:<\/li>\n<\/ol>\n<p><strong>Important: <\/strong>CentOS is not supported for Ephesoft Transact 2020.1 or above.<\/p>\n<h4><a id=\"post-43898-_heading=h.obcsit2d3pmh\"><\/a>On RHEL 7<\/h4>\n<pre>[MariaDB]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.3\/rhel7-amd64\r\ngpgkey=http:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1<\/pre>\n<h4><a id=\"post-43898-_heading=h.ipriyzk2vk0w\"><\/a>On CentOS 7<\/h4>\n<pre>[MariaDB]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.3\/centos7-amd64\r\ngpgkey=http:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1<\/pre>\n<ol start=\"3\">\n<li>Run the following command to manually create the cache so that future yum queries will be quicker:<\/li>\n<\/ol>\n<pre>yum makecache fast<\/pre>\n<p><img decoding=\"async\" class=\"wp-image-45734\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/a-screenshot-of-a-cell-phone-description-automati-35.png\" alt=\"A screenshot of a cell phone Description automatically generated\" width=\"571\" height=\"104\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/a-screenshot-of-a-cell-phone-description-automati-35.png 703w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/a-screenshot-of-a-cell-phone-description-automati-35-300x55.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/p>\n<p><em>Figure 1: Make Cache Fast<\/em><\/p>\n<ol start=\"4\">\n<li>Once the MariaDB YUM repository has been added, you can install MariaDB with the following command:<\/li>\n<\/ol>\n<pre>yum install MariaDB-server MariaDB-client<\/pre>\n<ol start=\"5\">\n<li>Run the following commands to start the MariaDB service and enable it to start automatically in the future:<\/li>\n<\/ol>\n<pre>systemctl start mariadb\r\nsystemctl enable mariadb<\/pre>\n<p><img decoding=\"async\" class=\"wp-image-45735\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-155.png\" width=\"768\" height=\"64\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-155.png 1128w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-155-300x25.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-155-1024x85.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-155-768x64.png 768w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><em>Figure 2: Start MariaDB Service<\/em><\/p>\n<ol start=\"6\">\n<li>Secure MariaDB by running the following command.<\/li>\n<\/ol>\n<pre>mysql_secure_installation<\/pre>\n<p><img decoding=\"async\" class=\"wp-image-45736\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-156.png\" width=\"510\" height=\"71\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-156.png 647w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-156-300x42.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/p>\n<p><em>Figure 3: Secure Installation<\/em><\/p>\n<p>This will prompt you to set the root password, disable remote root login, remove the test database and anonymous users, and reload privileges.<\/p>\n<ol start=\"7\">\n<li>Use the table below to respond to the prompts as they are displayed.<\/li>\n<\/ol>\n<table style=\"width: 95%\">\n<tbody>\n<tr bgcolor=\"#1f3864\">\n<td><span style=\"color: #ffffff\"><strong>Prompt<\/strong><\/span><\/td>\n<td><span style=\"color: #ffffff\"><strong>Description<\/strong><\/span><\/td>\n<td><span style=\"color: #ffffff\"><strong>Response<\/strong><\/span><\/td>\n<\/tr>\n<tr>\n<td>Set root password? [y\/n]<\/td>\n<td>Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorization.<\/p>\n<p><strong>Important<\/strong>: This password will be used to configure your MariaDB connection when installing or upgrading Ephesoft Transact.<\/td>\n<td>y<\/td>\n<\/tr>\n<tr>\n<td>Remove anonymous users? [y\/n]<\/td>\n<td>By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without needing a user account created for them. This is intended only for testing, and to make the installation smoother.<\/p>\n<p>You should remove them before moving into a production environment.<\/td>\n<td>y<\/td>\n<\/tr>\n<tr>\n<td>Disallow root login remotely? [y\/n]<\/td>\n<td>Normally, root should only be allowed to connect from \u2018localhost\u2019. This ensures that someone cannot guess at the root password from the network.<\/td>\n<td>y<\/td>\n<\/tr>\n<tr>\n<td>Remove test database and access to it? [y\/n]<\/td>\n<td>By default, MariaDB comes with a database named \u2018test\u2019 that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment.<\/td>\n<td>y<\/td>\n<\/tr>\n<tr>\n<td>Reload privilege tables now? [y\/n]<\/td>\n<td>Reloading the privilege tables will ensure that all changes made so far will take effect immediately.<\/td>\n<td>y<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol start=\"8\">\n<li>Verify that a supported version of MariaDB was installed with one of the following:\n<ul>\n<li>Run the following command:<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<pre>mysql -v<\/pre>\n<p>This will return the server version as a response.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-45737\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-157.png\" width=\"555\" height=\"70\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-157.png 793w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-157-300x38.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-157-768x97.png 768w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/p>\n<p><em>Figure 4: Verify Version<\/em><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Login to the MariaDB command shell by running following command and entering the root password:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre>mysql -u root -p<\/pre>\n<p>This will login as the root user and return the server version as a response.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-45738\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-158.png\" width=\"567\" height=\"316\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-158.png 1077w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-158-300x167.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-158-1024x570.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-158-768x428.png 768w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/p>\n<p><em>Figure 5: Root Login<\/em><\/p>\n<ol start=\"9\">\n<li>If you are performing a fresh installation of Ephesoft Transact, you have completed the MariaDB installation. Return to the <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/\">install guide for your version<\/a>. Otherwise, proceed to <a href=\"#post-43898-_heading=h.26in1rg\">Create a New Database<\/a> to migrate an existing MariaDB environment.<\/li>\n<\/ol>\n<h3><a id=\"post-43898-_heading=h.3rdcrjn\"><\/a>Ubuntu<\/h3>\n<p><strong>Note<\/strong>: Ubuntu is not supported for Ephesoft Transact 2020.1 or above. You must have the <strong>software-properties-common<\/strong> library installed prior to installing MariaDB on Ubuntu. If the library is not installed, run the following command:<\/p>\n<pre>sudo apt-get install software-properties-common.<\/pre>\n<ol>\n<li>Run the following command to install GNU Privacy Guard (GPG) to Ubuntu:<\/li>\n<\/ol>\n<pre>sudo apt install gnupg.<\/pre>\n<ol start=\"2\">\n<li>Run the following command to add the MariaDB GPG key:<\/li>\n<\/ol>\n<pre>sudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:800xF1656F24C74CD1D8<\/pre>\n<ol start=\"3\">\n<li>Run the following command to add an APT repository to your server:<\/li>\n<\/ol>\n<pre>sudo add-apt-repository \u2018deb [arch=amd64,arm64,i386,ppc64el] http:\/\/sfo1.mirrors.digitalocean.com\/mariadb\/repo\/10.3\/ubuntu\/ xenial main\u2019<\/pre>\n<ol start=\"4\">\n<li>Run the following commands to install a supported version of MariaDB:<\/li>\n<\/ol>\n<pre>sudo apt-get update\r\nsudo apt-get install mariadb-server mariadb-client<\/pre>\n<ol start=\"5\">\n<li>When prompted, create a MariaDB root password. Keep the password in a safe location for future use.<\/li>\n<\/ol>\n<p><img decoding=\"async\" width=\"679\" height=\"283\" class=\"wp-image-45739\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/https-computingforgeeks-com-wp-content-uploads-2-4.png\" alt=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2018\/06\/mariadb-ubuntu-set-password-01.png\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/https-computingforgeeks-com-wp-content-uploads-2-4.png 679w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/https-computingforgeeks-com-wp-content-uploads-2-4-300x125.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/p>\n<p><em>Figure 6: Create Password<\/em><\/p>\n<ol start=\"6\">\n<li>Re-enter the password and select <strong>&lt;Ok&gt;<\/strong> to confirm.<\/li>\n<\/ol>\n<p><img decoding=\"async\" width=\"671\" height=\"269\" class=\"wp-image-45740\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/https-computingforgeeks-com-wp-content-uploads-2-5.png\" alt=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2018\/06\/mariadb-ubuntu-set-password-02.png\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/https-computingforgeeks-com-wp-content-uploads-2-5.png 671w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/https-computingforgeeks-com-wp-content-uploads-2-5-300x120.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/p>\n<p><em>Figure 7: Confirm Password<\/em><\/p>\n<ol start=\"7\">\n<li>Verify that a supported version of MariaDB was installed with one of the following:\n<ul>\n<li>Run the following command:<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<pre>select version();<\/pre>\n<p>This will return the server version as a response.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Login to the MariaDB command shell by running following command and entering the root password:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre>mysql -u root -p.<\/pre>\n<p>This will login as the root user and return the server version as a response.<\/p>\n<ol start=\"8\">\n<li>If you are performing a fresh installation of Ephesoft Transact, you have completed the MariaDB installation. Return to the <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/\">install guide for your version<\/a>. Otherwise, proceed to <a href=\"#post-43898-_heading=h.26in1rg\">Create a New Database<\/a> to migrate an existing MariaDB environment..<\/li>\n<\/ol>\n<h2><a id=\"post-43898-_heading=h.26in1rg\"><\/a>Create a New Database<\/h2>\n<p><strong>Note<\/strong>: Follow the steps in this section if you are migrating an existing MariaDB or MySQL environment into your new MariaDB environment.<\/p>\n<p>Once you have installed MariaDB, you will need to create the following three databases for Ephesoft Transact: <strong>ephesoft<\/strong>, <strong>report<\/strong>, and <strong>report_archive<\/strong>.<\/p>\n<ol>\n<li>Run the following commands on any MariaDB client tool, replacing the <strong><em>&lt;username&gt;<\/em><\/strong> with your username:<\/li>\n<\/ol>\n<pre>CREATE DATABASE IF NOT EXISTS ephesoft ;\r\nCREATE DATABASE IF NOT EXISTS report ;\r\nCREATE DATABASE IF NOT EXISTS report_archive ;\r\nGRANT ALL PRIVILEGES ON ephesoft.* TO '<strong><em>&lt;username&gt;<\/em><\/strong>'@'%';\r\nGRANT ALL PRIVILEGES ON report.* TO '<strong><em>&lt;username&gt;<\/em><\/strong>'@'%';\r\nGRANT ALL PRIVILEGES ON report_archive.* TO '<strong><em>&lt;username&gt;<\/em><\/strong>'@'%';\r\nGRANT ALL PRIVILEGES ON ephesoft.* TO '<strong><em>&lt;username&gt;<\/em><\/strong>'@'localhost';\r\nGRANT ALL PRIVILEGES ON report.* TO '<strong><em>&lt;username&gt;<\/em><\/strong>'@'localhost';\r\nGRANT ALL PRIVILEGES ON report_archive.* TO '<strong><em>&lt;username&gt;<\/em><\/strong>'@'localhost';\r\nFLUSH PRIVILEGES;<\/pre>\n<p><strong>Note<\/strong>: When the IF NOT EXISTS clause is used, MariaDB will return a warning instead of an error if the specified database already exists.<\/p>\n<ol start=\"2\">\n<li>Update the database details in all three resource tags in the <strong>&lt;Ephesoft Installation Folder&gt;\\JavaAppServer\\conf\\server.xml <\/strong>file. Refer to the image below for an example:<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"wp-image-45741\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-159.png\" width=\"663\" height=\"166\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-159.png 963w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-159-300x75.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/word-image-159-768x192.png 768w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/p>\n<p><em>Figure 8: Update Resource Tags<\/em><\/p>\n<ol start=\"3\">\n<li>You have successfully installed MariaDB. Continue to <a href=\"#post-43898-_heading=h.lnxbz9\">Restore MySQL Backup<\/a> if you previously performed a backup of your MySQL database. Otherwise, return to the Linux guide for your version of Ephesoft Transact to complete your installation or upgrade.<\/li>\n<\/ol>\n<h2><a id=\"post-43898-_heading=h.lnxbz9\"><\/a>Restore MySQL Backup<\/h2>\n<p>Perform these steps if you are migrating your database from MySQL. This section outlines how to restore your <strong>ephesoft<\/strong>, <strong>report<\/strong>, and <strong>report_archive<\/strong> databases that you backed up in the section titled <a href=\"#post-43898-_heading=h.4d34og8\">Pre-existing MySQL<\/a>.<\/p>\n<p><strong>Important<\/strong>: Ensure that the original MySQL database is stopped and disabled, and the new MariaDB database is running.<\/p>\n<ol>\n<li>Use the following command to restore each database, replacing the placeholders in the angled brackets (<strong><em>&lt; &gt;<\/em><\/strong>) with the relevant details:<\/li>\n<\/ol>\n<pre>mysql -u<strong><em>&lt;root username&gt;<\/em><\/strong> -p<strong><em>&lt;root user password&gt;<\/em><\/strong> -P<strong><em>&lt;database server port&gt;<\/em><\/strong> <strong><em>&lt;Database name&gt;<\/em><\/strong> &lt; <strong><em>&lt;Folder location&gt;<\/em><\/strong>\\database_backup.sql<\/pre>\n<p>Below is a sample to restore each database:<\/p>\n<pre>mysql -uroot -ppassword -P3306 ephesoft &lt; ephesoft.sql\\database_backup.sql\r\nmysql -uroot -ppassword -P3306 report &lt; report.sql\\database_backup.sql\r\nmysql -uroot -ppassword -P3306 report_archive &lt; report_archive.sql\\database_backup.sql<\/pre>\n<ol start=\"2\">\n<li>You have successfully restored the <strong>ephesoft<\/strong>, <strong>report<\/strong>, and <strong>report_archive<\/strong> databases in MariaDB. Return to the Linux guide for your version of Ephesoft Transact to complete your upgrade.<\/li>\n<\/ol>\n<h2><a id=\"post-43898-_heading=h.35nkun2\"><\/a>Upgrade MariaDB<\/h2>\n<p>This section provides instructions on how to upgrade your current MariaDB instance to a supported version. Refer to <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/system-requirements\/platform-configurations-and-third-party-integrations\/\">Platform Configurations and Third-Party Integrations<\/a> and reference your version of Ephesoft Transact to find more information on supported database versions.<\/p>\n<p><strong>Note: <\/strong>Ephesoft Transact 2020.1 currently supports MariaDB 10.3.x (10.3.18 tested).<\/p>\n<ol>\n<li>Download a supported version of MariaDB from the MariaDB Foundation.<\/li>\n<li>Run the following commands to stop the <strong>ephesoft<\/strong> and <strong>mysql<\/strong> services:<\/li>\n<\/ol>\n<pre>service ephesoft stop\r\nservice mysql stop<\/pre>\n<ol start=\"3\">\n<li>Rename the existing MariaDB folder:<\/li>\n<\/ol>\n<pre>mv \/opt\/mariadb \/opt\/mariadb-backup<\/pre>\n<ol start=\"4\">\n<li>Move the <strong>.tar<\/strong> file to the <strong>\/opt<\/strong> folder:<\/li>\n<\/ol>\n<pre>mv mariadb-<strong><em>xx.x.xx<\/em><\/strong>-linux-x86_64.tar.gz \/opt\/<\/pre>\n<p><strong>Note<\/strong>: <strong><em>xx.x.xx<\/em><\/strong> has been added as a placeholder. Replace with your current version of MariaDB.<\/p>\n<ol start=\"5\">\n<li>Extract the <strong>.tar <\/strong>file:<\/li>\n<\/ol>\n<pre>tar -xvzf mariadb-<strong><em>xx.x.xx<\/em><\/strong>-linux-x86_64.tar.gz<\/pre>\n<p><strong>Note<\/strong>: <strong><em>xx.x.xx<\/em><\/strong> has been added as a placeholder. Replace with your current version of MariaDB.<\/p>\n<ol start=\"6\">\n<li>Rename the <strong>mariadb-<em>xx.x.xx<\/em>-linux-x86_64 <\/strong>folder to <strong>mariadb<\/strong>:<\/li>\n<\/ol>\n<pre>mv mariadb-<strong><em>xx.x.xx<\/em><\/strong>-linux-86_64 mariadb<\/pre>\n<p><strong> Note<\/strong>: <strong><em>xx.x.xx <\/em><\/strong>has been added as a placeholder. Replace with your current version of MariaDB<\/p>\n<ol start=\"7\">\n<li>Rename the <strong>my.cnf<\/strong> file to <strong>my.cnf.backup<\/strong>:<\/li>\n<\/ol>\n<pre>mv \/etc\/my.cnf \/etc\/my.cnf.backup<\/pre>\n<ol start=\"8\">\n<li>Remove the <strong>mysql<\/strong> service:<\/li>\n<\/ol>\n<pre>rm -rf \/etc\/init.d\/mysqld<\/pre>\n<ol start=\"9\">\n<li>Open the <strong>mariadb <\/strong>folder:<\/li>\n<\/ol>\n<pre>cd \/opt\/mariadb<\/pre>\n<ol start=\"10\">\n<li>Run the mysql_install_db script:<\/li>\n<\/ol>\n<pre>.\/scripts\/mysql_install_db --basedir=\/opt\/mariadb --datadir=\/opt\/mariadb\/data<\/pre>\n<ol start=\"11\">\n<li>Restore the <strong>my.cnf <\/strong>file:<\/li>\n<\/ol>\n<pre>cp \/opt\/mariadb-backup\/support-files\/my.cnf \/etc\/<\/pre>\n<ol start=\"12\">\n<li>Restore the service:<\/li>\n<\/ol>\n<pre>cp \/opt\/mariadb-backup\/support-files\/mysqld \/etc\/init.d\/<\/pre>\n<ol start=\"13\">\n<li>Remove the old links:<\/li>\n<\/ol>\n<pre>rm -rf \/usr\/bin\/mysql\r\nrm -rf \/usr\/bin\/mysqldump\r\nrm -rf \/usr\/bin\/mysqladmin<\/pre>\n<ol start=\"14\">\n<li>Create new links:<\/li>\n<\/ol>\n<pre>ln -s \/opt\/mariadb\/bin\/mysql \/usr\/bin\/mysql\r\nln -s \/opt\/mariadb\/bin\/mysqldump \/usr\/bin\/mysqldump\r\nln -s \/opt\/mariadb\/bin\/mysqladmin \/usr\/bin\/mysqladmin<\/pre>\n<ol start=\"15\">\n<li>Run the following command to add MariaDB to the list of services that will start after system reboot. This command differs based on your Linux distribution:<\/li>\n<\/ol>\n<p><strong>Ubuntu: <\/strong><\/p>\n<pre>update-rc.d mysqld defaults<\/pre>\n<p><strong>CentOS <\/strong>or <strong>RHEL: <\/strong><\/p>\n<pre>chkconfig --add mysqld<\/pre>\n<ol start=\"16\">\n<li>Restore the data backups:<\/li>\n<\/ol>\n<pre>mv \/opt\/mariadb\/data \/opt\/mariadb\/data-backup\r\ncp -r \/opt\/mariadb-backup\/data \/opt\/mariadb\/\r\nrm -rf \/var\/lock\/subsys\/mysql<\/pre>\n<ol start=\"17\">\n<li>Allow permissions within the <strong>my.cnf<\/strong> file:<\/li>\n<\/ol>\n<pre>chmod -R 0777 \/etc\/my.cnf<\/pre>\n<ol start=\"18\">\n<li>Open the <strong>my.cnf <\/strong>file and insert the following comments:<\/li>\n<\/ol>\n<pre>#innodb_large_prefix=on\r\n#innodb_file_format=barracuda\r\n#innodb_file_per_table=true<\/pre>\n<ol start=\"19\">\n<li>Adjust the permissions within the <strong>my.cnf<\/strong> file:<\/li>\n<\/ol>\n<pre>chmod -R 0755 \/etc\/my.cnf<\/pre>\n<ol start=\"20\">\n<li>Start the database service:<\/li>\n<\/ol>\n<pre>service mysqld start<\/pre>\n<ol start=\"21\">\n<li>Run the upgrade:<\/li>\n<\/ol>\n<pre>.\/bin\/mysql_upgrade -uroot \u2013p<strong><em>&lt;password&gt;<\/em><\/strong><\/pre>\n<p>The upgrade process is complete. Return to the Linux guide for your version of Ephesoft Transact to complete your installation or upgrade.<\/p>\n<h2><a id=\"post-43898-_heading=h.1ksv4uv\"><\/a>Conclusion<\/h2>\n<p>You have successfully configured MariaDB for Ephesoft Transact.<\/p>\n","protected":false},"featured_media":0,"parent":44680,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Install and Migrate to MariaDB for Linux | Ephesoft Docs<\/title>\n<meta name=\"description\" content=\"The installer for Ephesoft Transact 2019.2 and above no longer installs any database management systems (DBMS) and no longer supports MySQL databases.\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install and Migrate to MariaDB for Linux\" \/>\n<meta property=\"og:description\" content=\"The installer for Ephesoft Transact 2019.2 and above no longer installs any database management systems (DBMS) and no longer supports MySQL databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-01T21:37:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/a-screenshot-of-a-cell-phone-description-automati-35.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/\",\"name\":\"Install and Migrate to MariaDB for Linux | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2020-03-04T18:44:25+00:00\",\"dateModified\":\"2021-11-01T21:37:57+00:00\",\"description\":\"The installer for Ephesoft Transact 2019.2 and above no longer installs any database management systems (DBMS) and no longer supports MySQL databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Install and Upgrade\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Additional Resources\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Linux\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Install and Migrate to MariaDB for Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Install and Migrate to MariaDB for Linux | Ephesoft Docs","description":"The installer for Ephesoft Transact 2019.2 and above no longer installs any database management systems (DBMS) and no longer supports MySQL databases.","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Install and Migrate to MariaDB for Linux","og_description":"The installer for Ephesoft Transact 2019.2 and above no longer installs any database management systems (DBMS) and no longer supports MySQL databases.","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/","og_site_name":"Ephesoft Docs","article_modified_time":"2021-11-01T21:37:57+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2020\/03\/a-screenshot-of-a-cell-phone-description-automati-35.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/","name":"Install and Migrate to MariaDB for Linux | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2020-03-04T18:44:25+00:00","dateModified":"2021-11-01T21:37:57+00:00","description":"The installer for Ephesoft Transact 2019.2 and above no longer installs any database management systems (DBMS) and no longer supports MySQL databases.","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/install-and-migrate-to-mariadb-for-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Install and Upgrade","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/"},{"@type":"ListItem","position":4,"name":"Additional Resources","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/"},{"@type":"ListItem","position":5,"name":"Linux","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/"},{"@type":"ListItem","position":6,"name":"Install and Migrate to MariaDB for Linux"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/43898"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=43898"}],"version-history":[{"count":1,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/43898\/revisions"}],"predecessor-version":[{"id":49665,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/43898\/revisions\/49665"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/44680"}],"next":[{"title":"Linux Installer Update - Silent","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/linux-installer-update\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31653"}],"prev":[{"title":"Installing Ephesoft on Ubuntu 14.10","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/install-and-upgrade\/additional-resources\/linux\/installing-ephesoft-on-ubuntu-14-10\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31657"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=43898"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=43898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}