Home Print  

Installing and Configuring MySQL as Backend Database on Linux

Overview

uses MySQL as the backend database in Backup Server and Replication Server installations to store all the backup metadata information. To get to work with MySQL as a backend database, you need to install MySQL Server either in the same machine where backup server is installed or in another dedicated machine.

Note : The following steps are applicable to Backup Server and Replication Server installations.

Install and Configure MySQL Server

provides you an utility to install and customize the MySQL Server components for backend. This utility will download, install and customizes the MySQL Server v5.5.20, unixODBC v2.2.14, MySQL ODBC Driver v3.51.27 components, creates database and system DSNs for . As this utility downloads MySQL Server components from Internet, the backup/replication server should have Internet connectivity.

  1. Download 's Online MySQL Components installer. The installer is typically available in the same source location from where the other builds you downloaded from.
  2. Execute the downloaded script file "MySQLSetup_Simple_Web.sh" with root user privilege.
  3. Read the instructions carefully and provide the suitable options.

    NOTE: MySQL Server components installer will check the missing packages for running MySQL Server in the Linux machine, and will ask confirmation to install missing packages. If you wish to install the missing packages, enter 'yes' to continue the installation. Otherwise, enter 'no' to abort the installation.

  4. At the end of the installation, to check the database connectivity of the created DSN setting, the script will prompt for MySQL Server root user's password. Enter the correct MySQL Server root user password to check the created DSN setting.

Specify the attributes during installation

After installing MySQL Server components, you need to specify DSN name, database name, user name and password during the installation in the backup server.

Troubleshooting Tips

is not started (or) repeatedly crashes after startup Show/Hide

Solution : Stop application and start in command line by executing './bin/' from [_Home] folder. Note the console print from the terminal. Please follow the solutions when the console print are as follows :


  1. Can't connect to local MySQL server...

    Make sure that the MySQL server is running in the machine where MySQL is installed. Execute 'netstat -an | grep 3306' (for linux) or 'netstat -an | find "3306"' (for Windows) in the machine where MySQL server is running and check if the MySQL port 3306 (default mysql port) is in LISTEN state. If MySQL is not running, please start the MySQL Server and then try starting .

  2. Data source name not found...

    Make sure that you have given the correct DSN name during the installation. Please check the DSN by executing the command 'isql -v [dsn name] [user name] [password]' and check if you are able to connect to the MySQL server with the DSN name.

  3. Access denied for user...

    Check if you have given the correct user name and password for the MySQL Server during installation. Please check this by executing the command 'isql -v [dsn name] [user name] [password]' and check if you are able to connect to the MySQL server with the user name and password.

  4. Host 'xxxxx' is not allowed to connect to this MySQL server...

    Provide the required permission in the MySQL to allow the backup server to connect the database. You can do this by executing 'GRANT ALL PRIVILEGES ON *.* TO '[user name]'@'[backup server machine name]' IDENTIFIED BY '[password]' WITH GRANT OPTION;' in the MySQL prompt in the machine where MySQL Server is installed.

    NOTE: If you are deploying the backup servers in a cluster, you need to execute the above command for each of the backup server in the cluster replacing the 'backup server machine name' with the machine name of the backup server. If you find it cumbersome to execute this for each backup server, you could replace the 'backup server machine name' with '%' like:
    'GRANT ALL PRIVILEGES ON *.* TO '[user name]'@'[%]'
Error: Starting MySQL...Manager of pid-file quit without updating. Show/Hide

Cause: If SELinux is enabled in your Linux system then you could get this error when SELinux aborts MySQL manager while it is updating the pid file. To confirm that SELinux is enabled, execute the command '/usr/sbin/sestatus' as a root user.

Solution : Execute the command 'setsebool -P mysqld_disable_trans=1 allow_user_mysql_connect=1' as root user and restart the MySQL server.
Print  
Technical support-