Ad Widget

Collapse

sudo apt-get install zabbix-sql-scripts do not install on zabbix 6.0.14

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hsv
    Junior Member
    • Jun 2020
    • 14

    #1

    sudo apt-get install zabbix-sql-scripts do not install on zabbix 6.0.14

    Hi
    I am in the process in of upgrading from 5.0 to 6.0 on
    Distributor ID: Ubuntu
    Description: Ubuntu 20.04.6 LTS
    Release: 20.04
    Codename: focal​

    sudo apt-get install zabbix-sql-scripts​
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following packages were automatically installed and are no longer required:
    libconfig-inifiles-perl libfwupdplugin1 libsnappy1v5 libssh2-1 libxmlb1
    Use 'sudo apt autoremove' to remove them.
    The following NEW packages will be installed:
    zabbix-sql-scripts
    0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
    Need to get 7239 kB of archives.
    After this operation, 8130 kB of additional disk space will be used.
    Get:1 https://repo.zabbix.com/zabbix/6.0/ubuntu focal/main amd64 zabbix-sql-scripts all 1:6.0.14-1+ubuntu20.04 [7239 kB]
    Fetched 7239 kB in 2s (3062 kB/s)
    Selecting previously unselected package zabbix-sql-scripts.
    (Reading database ... 116220 files and directories currently installed.)
    Preparing to unpack .../zabbix-sql-scripts_1%3a6.0.14-1+ubuntu20.04_all.deb ...
    Unpacking zabbix-sql-scripts (1:6.0.14-1+ubuntu20.04) ...
    Setting up zabbix-sql-scripts (1:6.0.14-1+ubuntu20.04) ...
    ls /usr/share/doc/zabbix-sql-scripts
    changelog.Debian.gz copyright​

    This has been a know bug which shoud have been fixed.
    [ZBX-20451] zabbix-sql-scripts package missing when install Zabbix Proxy on rpm based OS - ZABBIX SUPPORT
    [ZBX-21267] zabbix-sql-scripts installs nothing on arm64 ubuntu 22.04 - ZABBIX SUPPORT


    All the SQL scripts are missing.
    Only these 2 files has been installed
    changelog.Debian.gz
    copyright

    All the scripts are missing so it is not possible to add primary key to the History table

    Any way to get this fixed as it looks like Zabbix has not found a fix yet.

    Regards
    Henning
  • hsv
    Junior Member
    • Jun 2020
    • 14

    #2
    I have now installed 6.0, 6.2 and 6.4 on a new ubuntu 20.04

    And for alle 3 installation the same result

    zabtest:~$ ls -l /usr/share/doc/zabbix-server-mysql
    total 12
    -rw-r--r-- 1 root root 4917 Mar 3 14:35 changelog.Debian.gz
    -rw-r--r-- 1 root root 965 Mar 3 14:35 copyright


    In the Bug case I can see that the files should be for postgresql and I hope they should be the same for MariaDB:
    root@32f1da10474f:~# ls -l /usr/share/doc/zabbix-sql-scripts/postgresql/
    total 3568
    -rw-r--r-- 1 root root 413 Jul 14 11:12 double.sql
    -rw-r--r-- 1 root root 2432 Jul 14 11:12 history_pk_prepare.sql
    -rw-r--r-- 1 root root 169198 Jul 14 11:12 proxy.sql
    -rw-r--r-- 1 root root 3469265 Jul 14 11:12 server.sql.gz
    -rw-r--r-- 1 root root 3437 Jul 14 11:12 timescaledb.sql zz0.z4qmpts0yujzz

    I have found the source here:
    Download sources from Git repository or ready-to-use Zabbix distributives



    I have not found them yet.

    Regards
    Henning​

    Comment

    Working...