DIR=/usr/src/cacti; \
mkdir -p ${DIR}; \
DocumentRoot=`cat /etc/apache2/sites-enabled/000-*.conf |grep DocumentRoot|awk '{print $2}'`; \
wget -P ${DIR} https://www.cacti.net/downloads/cacti-latest.tar.gz; \
tar -zxvf ${DIR}/cacti-latest.tar.gz -C /home/www/; \
mv /home/www/cacti* ${DocumentRoot}; \
mysqladmin -ujsql -p create cacti; \
password=`openssl rand -hex 12`; \
mysql -u jsql -p -e "grant all on cacti.* to 'cactiuser'@'localhost' identified by '${password}'"; \
mysql -u jsql -p -e "grant select on mysql.time_zone_name to 'cactiuser'@'localhost' identified by '${password}'"; \
mysql -u jsql -p -e "ALTER DATABASE cacti CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; FLUSH PRIVILEGES;"; \
mysql -u jsql -p cacti < ${DocumentRoot}/cacti.sql; \
mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -u jsql -p mysql; \
sed -i "s|database_password = 'cactiuser';|database_password = '${password}';|" ${DocumentRoot}/include/config.php; \
sed -i "s|url_path = '/cacti/';|url_path = '/';|" ${DocumentRoot}/include/config.php; \
chown -R www-data.www-data ${DocumentRoot}/rra ${DocumentRoot}/log; \
chown -R www-data.www-data ${DocumentRoot}/resource/snmp_queries/; \
chown -R www-data.www-data ${DocumentRoot}/resource/script_server/; \
chown -R www-data.www-data ${DocumentRoot}/resource/script_queries/; \
chown -R www-data.www-data ${DocumentRoot}/scripts/; \
chown -R www-data.www-data ${DocumentRoot}/cache/boost/; \
chown -R www-data.www-data ${DocumentRoot}/cache/mibcache/; \
chown -R www-data.www-data ${DocumentRoot}/cache/realtime/; \
chown -R www-data.www-data ${DocumentRoot}/cache/spikekill/; \
sed -i "s|;date.timezone =|date.timezone = Europe/Warsaw|" /etc/php/7.3/apache2/php.ini; \
sed -i "s|;date.timezone =|date.timezone = Europe/Warsaw|" /etc/php/7.3/cli/php.ini; \
apt-get -y install php7.3-gmp php7.3-ldap rrdtool; \
service apache2 restart; \
echo "*/5 * * * * www-data php ${DocumentRoot}/poller.php > /dev/null 2>&1" > /etc/cron.d/cacti;