blob: 998c30c07ec6e57f77e15873d6397859266f66cb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
# INSTALLATION NOTES
On CentOS 7.5 - fresh install - June 2018
## 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
## Apache HTTP Server and PHP 7.2
GLPI requires PHP >= 5.6, so default version 5.4 in base repository is not compatible, so using the latest version 7.2 for performance (7.1 is also OK, 5.6 and 7.0 are close to EOL).
### Install
# yum-config-manager --enable remi-php72
# yum install httpd php php-opcache php-apcu
# php -v
PHP 7.2.6 (cli) (built: May 23 2018 09:50:51) ( NTS )
### 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
# cd /usr/share/glpi/scripts/
# php cliinstall.php --db=glpi --user=glpi --pass=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
|
