Team D
[ZBX-19451] zabbix-proxy-mysql schema file missing in version 5.4 Created: 2021 May 25 Updated: 2024 Apr 10 Resolved: 2021 May 31 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Documentation (D) |
| Affects Version/s: | 5.4.0 |
| Fix Version/s: | 6.0 (plan) |
| Type: | Problem report | Priority: | Major |
| Reporter: | Damian Vermeulen | Assignee: | Marina Generalova |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | mysql, proxy, ubuntu | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Ubuntu 20.04 |
||
| Team: | Team D |
| Sprint: | Sprint 76 (May 2021) |
| Story Points: | 0.5 |
| Description |
|
Steps to reproduce:
Result: dpkg -c zabbix-proxy-mysql_5.4.0-1+ubuntu20.04_amd64.deb drwxr-xr-x root/root 0 2021-05-14 11:08 ./ drwxr-xr-x root/root 0 2021-05-14 11:08 ./etc/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./etc/init.d/ -rwxr-xr-x root/root 1591 2021-05-14 11:08 ./etc/init.d/zabbix-proxy drwxr-xr-x root/root 0 2021-05-14 11:08 ./etc/logrotate.d/ -rw-r--r-- root/root 152 2021-05-14 11:08 ./etc/logrotate.d/zabbix-proxy-mysql drwxr-xr-x root/root 0 2021-05-14 11:08 ./etc/zabbix/ -rw------- root/root 24172 2021-05-14 11:08 ./etc/zabbix/zabbix_proxy.conf drwxr-xr-x root/root 0 2021-05-14 11:08 ./lib/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./lib/systemd/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./lib/systemd/system/ -rw-r--r-- root/root 491 2021-05-14 11:08 ./lib/systemd/system/zabbix-proxy.service drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/lib/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/lib/tmpfiles.d/ -rw-r--r-- root/root 37 2021-05-14 11:08 ./usr/lib/tmpfiles.d/zabbix-proxy.conf drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/lib/zabbix/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/lib/zabbix/externalscripts/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/sbin/ -rwxr-xr-x root/root 4346976 2021-05-14 11:08 ./usr/sbin/zabbix_proxy drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/share/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/share/doc/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/share/doc/zabbix-proxy-mysql/ -rw-r--r-- root/root 3513 2021-05-14 11:08 ./usr/share/doc/zabbix-proxy-mysql/changelog.Debian.gz -rw-r--r-- root/root 980 2021-05-14 11:08 ./usr/share/doc/zabbix-proxy-mysql/copyright drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/share/man/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./usr/share/man/man8/ -rw-r--r-- root/root 1530 2021-05-14 11:08 ./usr/share/man/man8/zabbix_proxy.8.gz drwxr-xr-x root/root 0 2021-05-14 11:08 ./var/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./var/log/ drwxr-xr-x root/root 0 2021-05-14 11:08 ./var/log/zabbix/ Expected: ./usr/share/doc/zabbix-proxy-mysql/schema.sql.gz Or similar.
Thank you. Damian |
| Comments |
| Comment by Anthony Somerset [ 2021 May 25 ] |
|
I also am experiencing this issue the important thing to note here is that while upgrades have no issue because pre-existing schema will just upgrade without problems. New installs need the schema to be manually sourced and imported to mysql which potentially breaks automation systems like Puppet that are expecting the schema file to exist in a specific location as previously was the case |
| Comment by Edgars Melveris [ 2021 May 25 ] |
|
Hello! This is because the sql schema files have been split in separate package called zabbix-sql-scripts Just install that and it contains all the schemas you need. If you followed installation instructions form the downloads page, you might already have it installed, check here: |
| Comment by Damian Vermeulen [ 2021 May 25 ] |
|
Thanks Edgars. I was using the official Zabbix documentation which seems to be a bit out dated regarding this topic as well.
|
| Comment by Edgars Melveris [ 2021 May 25 ] |
|
Looks like it, places like this: https://www.zabbix.com/documentation/current/manual/installation/install_from_packages/rhel_centos are still referring to old location: zcat /usr/share/doc/zabbix-server-pgsql*/timescaledb.sql.gz | sudo -u zabbix psql zabbix This should be fixed. |
| Comment by Marina Generalova [ 2021 May 27 ] |
|
Thank you for reporting, updated documentation: |
| Comment by Damian Vermeulen [ 2021 Jun 04 ] |
|
Thank you Marina. |