This is an old revision of the document!
server# mkdir -p /opt/clickhouse/{data,logs}
server# cat /opt/clickhouse/docker-compose.yml
services:
clickhouse:
image: clickhouse/clickhouse-server:26.10
container_name: clickhouse-otel
restart: unless-stopped
ports:
- "127.0.0.1:8123:8123"
- "127.0.0.1:9000:9000"
environment:
CLICKHOUSE_DB: otel
CLICKHOUSE_USER: zabbix
CLICKHOUSE_PASSWORD: "zabbix"
CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1
volumes:
- /opt/clickhouse/data:/var/lib/clickhouse
- /opt/clickhouse/logs:/var/log/clickhouse-server
ulimits:
nofile:
soft: 262144
hard: 262144
server# /usr/share/zabbix/sql-scripts/clickhouse/otel_all.sh -s http://127.0.0.1:8123 -d otel -u zabbix -p zabbix
server# docker exec -i clickhouse-otel clickhouse-client --user zabbix --password "zabbix" --database otel -q "SHOW TABLES"
server# apt install zabbix-proxy-sqlite3
server# cat /etc/zabbix/zabbix_proxy.conf | grep -v '^#\|^$'
Server=127.0.0.1
Hostname=Zabbix proxy
...
server# cat /etc/zabbix/zabbix_proxy.d/apm.conf
ListenPort=10061
StartAPMCollector=1
APMListenIP=127.0.0.1
APMListenPort=4317
TelemetryProvider=clickhouse;url=http://127.0.0.1:8123,db=otel,username=zabbix,password=zabbix
server# grep -E "Starting Zabbix Proxy|APM|telemetry|4317|4318|collector" /var/log/zabbix/zabbix_proxy.log | tail -n 30
server# apt install -y php8.2-dev php-pear gcc make pkg-config composer
server# pecl install opentelemetry
server# echo "extension=opentelemetry.so" > /etc/php/8.2/mods-available/opentelemetry.ini
server# phpenmod opentelemetry
server# php -m | grep opentelemetry