xchotard-talentsoft
commented
1 year ago Same issue here, looks like the files have been moved:
# find / -name "proxy.sql" -print
/usr/share/zabbix-sql-scripts/mysql/proxy.sql
/usr/share/zabbix-sql-scripts/sqlite3/proxy.sql
/usr/share/zabbix-sql-scripts/postgresql/proxy.sqlI suspect this is related to 6.2.3 because I successfully deployed zabbix proxies in 6.2.2.
Affected Puppet, Ruby, OS and module versions/distributions
How to reproduce (e.g Puppet code you use)
Installing a proxy with either Mysql or Postgresql
What are you seeing
both Zabbix::Database::mysql.pp and Zabbix::Database::postgresql.pp are looking for the schema file schema.sql.gz which no longer exists. The proxy schema uses a file called proxy.sql which is no longer a Gzip compressed file either.
https://git.zabbix.com/projects/WEB/repos/documentation/browse/en/manual/installation/install_from_packages/debian_ubuntu.md?at=refs%2Fheads%2Frelease%2F6.0
What behaviour did you expect instead
Correct schema file to be used and imported into database
Output log
Error: 'cd /usr/share/doc/zabbix-sql-scripts/postgresql && if [ -f schema.sql.gz ]; then gunzip -f schema.sql.gz ; fi && psql -h 'localhost' -U 'zabbix-proxy' -d 'zabbix_proxy' -f schema.sql && touch /etc/zabbix/.schema.done' returned 2 instead of one of [0] Error: /Stage[main]/Zabbix::Database::Postgresql/Exec[zabbix_proxy_create.sql]/returns: change from 'notrun' to ['0'] failed: 'cd /usr/share/doc/zabbix-sql-scripts/postgresql && if [ -f schema.sql.gz ]; then gunzip -f schema.sql.gz ; fi && psql -h 'localhost' -U 'zabbix-proxy' -d 'zabbix_proxy' -f schema.sql && touch /etc/zabbix/.schema.done' returned 2 instead of one of [0] (corrective)
Any additional information you'd like to impart