# INSTALLATION NOTES On CentOS 7.6 - fresh install - April 2019 ## Repositories # yum install centos-release-scl # yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm # yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm # yum install yum-utils ## MariaDB 10.2 GLPI requires MariaDB >= 10, and default version 5.5 in base repository is not compatible, so using the SCL of the latest MariaDB 10.2 (10.1 is also OK). ### Install # yum install rh-mariadb102-mariadb-server ### Start and enable the service # systemctl enable --now rh-mariadb102-mariadb ### Secure it # scl enable rh-mariadb102 bash # mysql --version mysql Ver 15.1 Distrib 10.2.8-MariaDB... # mysql_secure_installation ### Create GLPI database and account # mysql -uroot -prootsecret MariaDB> CREATE USER 'glpi'@'%' IDENTIFIED BY 'glpisecret'; MariaDB> GRANT USAGE ON *.* TO 'glpi'@'%' IDENTIFIED BY 'glpisecret'; MariaDB> CREATE DATABASE IF NOT EXISTS `glpi` ; MariaDB> GRANT ALL PRIVILEGES ON `glpi`.* TO 'glpi'@'%'; MariaDB> FLUSH PRIVILEGES; MariaDB> exit Bye ### Check connection # mysql -uglpi -pglpisecret glpi MariaDB [glpi]> exit Bye ## Apache HTTP Server and PHP 7.3 GLPI requires PHP >= 5.6, so default version 5.4 in base repository is not compatible, so using the latest version 7.3 for performance (7.2 is also OK, 7.1 is close to EOL). ### Install # yum-config-manager --enable remi-php73 # yum install httpd php php-opcache php-apcu # php --version PHP 7.3.4 (cli) (built: Apr 2 2019 13:48:50) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies with Zend OPcache v7.3.4, Copyright (c) 1999-2018, by Zend Technologies ### Allow access to webserver # firewall-cmd --zone=public --add-service=http --permanent # firewall-cmd --reload ### Start and enable the service # systemctl enable --now httpd ## GLPI 9.3 ### Install # yum-config-manager --enable remi # yum-config-manager --enable remi-glpi93 # yum install glpi ### Populate the DB # glpi-console glpi:database:install \ --db-host=localhost \ --db-name=glpi \ --db-user=glpi \ --db-password=glpisecret ## Done Browse http://servername/glpi/ (login=glpi, password=glpi) --------------- ## Mariadb upgrade from 5.5 to 10.2 If you have some DB, created with default mariadb 5.5 ### Install # yum install rh-mariadb102-mariadb-server If needed, create a new FS for /var/opt/rh/rh-mariadb102/lib/mysql ### Lazy way # systemctl stop mariadb # systemctl disable mariadb # rsync -av /var/lib/mysql/ /var/opt/rh/rh-mariadb102/lib/mysql/ # systemctl start rh-mariadb102-mariadb # systemctl enable rh-mariadb102-mariadb # mysql_upgrade -pxxx ### Long way dump Change /etc/opt/rh/rh-mariadb102/my.cnf.d/mariadb-server.cnf to use a different port [server] socket=/var/lib/mysql/mysql2.sock port=3307 # systemctl start rh-mariadb102-mariadb # scl enable rh-mariadb102 bash # mysqldump -h127.0.0.1 -pxxx --all-databases | mysql -h127.0.0.1 -P3307 # systemctl stop mariadb # systemctl disable mariadb # systemctl stop rh-mariadb102-mariadb Restore /etc/opt/rh/rh-mariadb102/my.cnf.d/mariadb-server.cnf [server] socket=/var/lib/mysql/mysql.sock port=3306 # systemctl start rh-mariadb102-mariadb # systemctl enable rh-mariadb102-mariadb