ncc.zabbix_templates

Yohn Y. 2025-05-15 Parent:ca9cdec2f51e

36:bc85d53acc6e Go to Latest

ncc.zabbix_templates/pgBouncer/install.sh

. PGBouncer: Изменение работы со статистикой времени

History
awgur@7 1 #!/bin/bash
awgur@7 2 # devel.a0fs.ru -- ncc.zabbix_templates/pgbouncer/install.sh -- v0.r202310.1 #
awgur@7 3
awgur@7 4 export PATH="/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin"
awgur@7 5 appdir="$(dirname "$(readlink -f "$0")")"
awgur@7 6
awgur@7 7 install -d -o zabbix -g zabbix -m u=rwx,g=rx,o-rwx \
awgur@7 8 /etc/zabbix/scripts/ \
awgur@7 9 /etc/zabbix/scripts-data \
awgur@7 10 /etc/zabbix/scripts-data/pgbouncer
awgur@7 11
awgur@7 12 echo "PGBOUNCER PORT"
awgur@7 13 read -p "Port: " pgb_port
awgur@7 14
awgur@7 15 echo "MONITRONG USER CREDENTIALS"
awgur@7 16 read -p "User: " uid_name
awgur@7 17 read -p "Passwd: " -r -s uid_passwd
awgur@7 18
awgur@7 19 cat > /etc/zabbix/scripts-data/pgbouncer/.pgpass << EOF
awgur@7 20 127.0.0.1:${pgb_port:-6432}:*:${uid_name:-zbx_mon}:${uid_passwd}
awgur@7 21 EOF
awgur@7 22
awgur@7 23 chown zabbix:zabbix /etc/zabbix/scripts-data/pgbouncer/.pgpass
awgur@7 24 chmod go-rwx /etc/zabbix/scripts-data/pgbouncer/.pgpass
awgur@7 25
awgur@7 26 install -o zabbix -g zabbix ${appdir}/res/pgbouncer.sh ${PREFIX}etc/zabbix/scripts/
awgur@7 27
awgur@7 28 for fle in /etc/zabbix/zabbix_agentd.d/ /etc/zabbix/zabbix_agentd2.d/ \
awgur@7 29 /etc/zabbix/zabbix_agent.d/ /etc/zabbix/zabbix_agent2.d/ ; do
awgur@7 30
awgur@7 31 if ! [ -d "$fle" ] ; then
awgur@7 32 continue
awgur@7 33
awgur@7 34 fi;
awgur@7 35
awgur@7 36 install -o zabbix -g zabbix -m u=rw,go=r ${appdir}/res/pgbouncer.conf ${fle}
awgur@7 37
awgur@7 38 done