|
|
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| '''Install MariaDB Server 10.0 on Ubuntu 16.04.''' | | '''Install MariaDB Server 10.0 on Ubuntu 16.04.''' |
|
| |
|
| 09APR16
| | See this: https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.30.0_the_easy_way#Optional_Upgrade_to_MariaDB_Server_10.0._before_installing_Zoneminder |
| | |
| As of this writing, Ubuntu 16.04 has included MySQL 5.7. The easy replacement of MySQL with Mariadb does not work. Therefore you should start with a basic Ubuntu 16.04 server install with no LAMP.
| |
| | |
| To manually install LAMP
| |
| | |
| Become root
| |
| | |
| sudo su
| |
| | |
| Install Apache
| |
| | |
| apt-get install apache2
| |
| | |
| Install Mariadb server
| |
| | |
| apt-get install mariadb-server
| |
| | |
| Install PHP
| |
| | |
| apt-get install php libapache2-mod-php php7.0-mysql
| |
| | |
| Secure Mariadb, create root password et. al.
| |
| | |
| mysql_secure_installation
| |
| | |
| '''Note:''' The MySQL/MariaDB configuration file is located at: /etc/mysql/mysql.conf.d/mysqld.cnf
| |
| To better manage the MariaDB server I recommend you move the config file and replace the default my.cnf symbolic link (this also works for MySQL 5.6).
| |
| | |
| rm /etc/mysql/my.cnf (this removes the current symbolic link)
| |
| | |
| cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/my.cnf
| |
| | |
| To change Mariadb settings:
| |
| | |
| nano /etc/mysql/my.cnf
| |
| | |
| Ctrl+o Enter to save
| |
| | |
| CTRL+x to exit
| |
| | |
| A tool that you may want to install is mysqltuner. This is handy to see what database paramaters need to be adjusted as your ZM system builds up events.
| |
| | |
| apt-get install mysqltuner
| |
| | |
| Once installed, run mysqltuner from a command prompt as root (sudo). Edit the configuration file and make the recommended changes. Stop zoneminder, restart the database server then start zoneminder.
| |
| | |
| Continue installing Zoneminder
| |
| Back to 16.04/1.29.0 setup: https://wiki.zoneminder.com/Ubuntu_Server_16.04_64-bit_with_Zoneminder_1.29.0_the_easy_way
| |
