Contents 1 What does OpenApp Mysql include? 2 Installing OpenApp Mysql 3 Updating OpenApp Mysql 4 Backing up OpenApp Mysql 5 Building an image

What does OpenApp Mysql include?

OpenApp Mysql consists of the following software:

• Mysql
• Lighttpd with mod-fcgi
• PhpMyAdmin
• Mysql server
• Postfix
• OpenPanel with mod-mysql, mod-backup, mod-smtp
• OpenApp-tuning
• OpenApp-backup

Installing OpenApp Mysql

• Please note that OpenApp always expects a clean install! /var/www/, /var/lib/mysql and directories like that might be deleted by OpenApp
• Make sure that you have the OpenPanel sources in your sources.list and your softwarelist is up to date. Follow instructions on OpenPanel_and_APT
• Now install OpenApp Mysql

apt-get install OpenApp-mysql

• During the install, you will get some questions:
  • Mysql-server
    • The password that the user root should use to login to Mysql (Twice)
  • Postfix
    • The type of configuration you want. Select 'Internet Site' (press enter). OpenApp will configure postfix later on
    • System mail name. This should be the hostname of your system and should already be entered (press enter). OpenApp can configure this later on
• Set a password for OpenPanel

openpanel-cli "update user password=<your password>"

• You can now login at https://<your ipaddress>:4089/ with the password entered in the previous step
• You are now in the OpenPanel-interface of your machine. Here, you can easily configure backups, outgoing email and the basic settings needed to be able to login on the PhpMyAdmin-interface.
  • In the Mysql-tab, you need to make sure that you enter a password. Do not touch the Backup Method yet.
  • Configure your SMTP-settings in the SMTP-tab. If you do not know which smarthost you should be using, you can leave it disabled. That should work in most of the situations.
  • Configure your backups! That will make sure that your machine creates a backup each day/week/month, and will enable you to easily recover from disasters
• Login to the PhpMyAdmin-interface at http://your_hostname/phpmyadmin/ (note the trailing /!). You can login with user 'OpenApp' and the password you entered in the Mysql-tab.

Updating OpenApp Mysql

OpenApp will run apt-get update and apt-get dist-upgrade every night if you enable it in the 'Upgrades'-tab. That will upgrade all the software on the machine and may install new packages when needed.

Backing up OpenApp Mysql

When you configure backups via OpenPanel, OpenApp-backup will run daily/weekly/montly and leave a executable file in /var/backups/. To restore from this file, please read about OpenApp-backup. In addition to other OpenApp installs, OpenApp-mysql can use xtrabackup. This is useful when you have large (InnoDB) databases that you want to backup. Because xtrabackup doesn't dump the databases like mysqldump does, you do not suffer from locking of large table. To use xtrabackup, you must install it manually. Please see the instructions on the instructions on the Percona website. After you configured the sources of Percona's xtrabackup, type:

apt-get install openapp-xtrabackup

When apt-get is done, you can configure it in the Mysql-tab. OpenApp-backup will then automatically start using it.

Building an image

To build an image for OpenApp Mysql (so that you have pre-configured everything for your user) take the following steps:

• Follow OpenApp Mysql#Installing OpenApp Mysql
• Run

echo "<password>" | OpenApp-mysql-passwd stdin

• Run

/var/openpanel/tools/OpenApp-smtp-configure-postfix "<hostname of the machine>" "<true|false smarthost>" "<smarthost, if former value is true>" "<admin emailaddress>"

• Run

openpanel-cli "update user password=<password>"