Install Zabbix on OpenShift v43

1 Tested with

• Server Version: 4.3.18
• Kubernetes Version: v1.16.2

1.1 zabbix

PROJECT=zabbix-dev
oc new-project $PROJECT
oc process -n openshift mariadb-persistent MYSQL_DATABASE=zabbix MYSQL_USER=zabbix MYSQL_PASSWORD=zabbix VOLUME_CAPACITY=5Gi | oc create -f -
sleep 3
oc logs -f dc/mariadb
sleep 3
oc logs -f dc/mariadb

• recreate database with proper settings

oc rsh dc/mariadb
MYSQL_PWD="$MYSQL__ROOT_PASSWORD" mysql -h 127.0.0.1 -u root -e "show databases ; drop database $MYSQL_DATABASE ; show databases ; create database $MYSQL_DATABASE character set utf8 collate utf8_bin; show databases;"

• or recreate database with proper settings automated

oc rsh dc/mariadb <<EOF
MYSQL_PWD="\$MYSQL__ROOT_PASSWORD" mysql -h 127.0.0.1 -u root -e "show databases ; drop database \$MYSQL_DATABASE ; show databases ; create database \$MYSQL_DATABASE character set utf8 collate utf8_bin; show databases;"
EOF

oc create serviceaccount anyuid
oc adm policy add-scc-to-user anyuid -z anyuid

oc new-app --docker-image=christian773/zabbix-server-mysql:alpine-latest MYSQL_DATABASE=zabbix MYSQL_USER=zabbix MYSQL_PASSWORD=zabbix DB_SERVER_HOST=mariadb
oc rollout pause dc/zabbix-server-mysql
oc patch dc/zabbix-server-mysql --patch '{"spec":{"template":{"spec":{"serviceAccountName": "anyuid"}}}}'

oc set volume dc/zabbix-server-mysql --add --name=zabbix-server-mysql-vol -t pvc --claim-size=5G --claim-mode=ReadWriteMany --claim-name=zabbix-server-mysql-claim

oc get pvc
oc set volume dc --all
oc set volume dc/zabbix-server-mysql | grep mounted\ at | awk '{print $3}' | tee /tmp/mounts

cat /tmp/mounts | while read m
do
   oc set volume dc/zabbix-server-mysql --remove --mount-path=$m --confirm
done

cat /tmp/mounts | while read m
do
   oc set volume dc/zabbix-server-mysql --add --name=zabbix-server-mysql-vol --mount-path=$m --claim-name=zabbix-server-mysql-claim --sub-path=$(basename $m)
done

oc set volume dc --all

oc rollout resume dc/zabbix-server-mysql
oc logs -f dc/zabbix-server-mysql

oc new-app --docker-image=docker.io/zabbix/zabbix-web-nginx-mysql:alpine-latest MYSQL_DATABASE=zabbix MYSQL_USER=zabbix MYSQL_PASSWORD=zabbix DB_SERVER_HOST=mariadb ZBX_SERVER_HOST=zabbix-server-mysql PHP_TZ="Europe/Zurich"
oc patch dc/zabbix-web-nginx-mysql --patch '{"spec":{"template":{"spec":{"serviceAccountName": "anyuid"}}}}'
sleep 3
oc logs -f dc/zabbix-web-nginx-mysql
sleep 3
oc logs -f dc/zabbix-web-nginx-mysql

oc expose svc/zabbix-web-nginx-mysql --port=8080 --hostname=zabbix.app.domain.com

or

oc create route edge zabbix-web-nginx-mysql --service=zabbix-web-nginx-mysql --port=8080 --hostname=zabbix.app.domain.com --key=/home/chris/MySsl/star.domain.com/servers/star.domain.com_privkey.pem --cert=/home/chris/MySsl/star.domain.com/servers/star.domain.com_cert.pem --ca-cert=/home/chris/MySsl/star.domain.com/servers/star.domain.com_ca_chain.pem

• firefox zabbix.app.domain.com

Admin / zabbix