Ad Widget

Collapse

Zabbix 6 - missing timescaledb.sql.gz

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Spectator
    Member
    • Sep 2021
    • 71

    #1

    Zabbix 6 - missing timescaledb.sql.gz

    I wanted to try Zabbix 6 with PostgreSQL and TimescaleDB but unfortunately I couldn't find the timescaledb.sql.gz file anywhere. According to the version 6 documentation, you should be here:
    /usr/share/doc/zabbix-sql-scripts/postgresql/timescaledb.sql.gz

    The documentation: https://www.zabbix.com/documentation...ll/timescaledb

    Is this accidentally missing, or should TimescaleDB be built differently than in previous versions of Zabbix?
    (Of course, I installed the zabbix-server-pgsql and zabbix-sql-scripts packages.)
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    that file has no .gz extention... Docs also do not mention any .gz....

    from rpm
    Code:
    rpm2cpio zabbix-sql-scripts-6.0.0-1.el8.noarch.rpm | cpio -idmv
    ./usr/share/doc/zabbix-sql-scripts
    ./usr/share/doc/zabbix-sql-scripts/AUTHORS
    ./usr/share/doc/zabbix-sql-scripts/COPYING
    ./usr/share/doc/zabbix-sql-scripts/ChangeLog
    ./usr/share/doc/zabbix-sql-scripts/NEWS
    ./usr/share/doc/zabbix-sql-scripts/README
    ./usr/share/doc/zabbix-sql-scripts/mysql/double.sql
    ./usr/share/doc/zabbix-sql-scripts/mysql/history_pk_prepare.sql
    ./usr/share/doc/zabbix-sql-scripts/mysql/proxy.sql
    ./usr/share/doc/zabbix-sql-scripts/mysql/server.sql.gz
    ./usr/share/doc/zabbix-sql-scripts/postgresql/double.sql
    ./usr/share/doc/zabbix-sql-scripts/postgresql/history_pk_prepare.sql
    ./usr/share/doc/zabbix-sql-scripts/postgresql/proxy.sql
    ./usr/share/doc/zabbix-sql-scripts/postgresql/server.sql.gz
    ./usr/share/doc/zabbix-sql-scripts/postgresql/timescaledb.sql
    ./usr/share/doc/zabbix-sql-scripts/sqlite3/proxy.sql
    from deb
    Code:
    ar x zabbix-sql-scripts_6.0.0-1+ubuntu20.04_all.deb
    
    tar xvf data.tar.xz
    ./
    ./usr/
    ./usr/share/
    ./usr/share/doc/
    ./usr/share/doc/zabbix-sql-scripts/
    ./usr/share/doc/zabbix-sql-scripts/changelog.Debian.gz
    ./usr/share/doc/zabbix-sql-scripts/copyright
    ./usr/share/doc/zabbix-sql-scripts/mysql/
    ./usr/share/doc/zabbix-sql-scripts/mysql/double.sql
    ./usr/share/doc/zabbix-sql-scripts/mysql/history_pk_prepare.sql
    ./usr/share/doc/zabbix-sql-scripts/mysql/proxy.sql
    ./usr/share/doc/zabbix-sql-scripts/mysql/server.sql.gz
    ./usr/share/doc/zabbix-sql-scripts/postgresql/
    ./usr/share/doc/zabbix-sql-scripts/postgresql/double.sql
    ./usr/share/doc/zabbix-sql-scripts/postgresql/history_pk_prepare.sql
    ./usr/share/doc/zabbix-sql-scripts/postgresql/proxy.sql
    ./usr/share/doc/zabbix-sql-scripts/postgresql/server.sql.gz
    ./usr/share/doc/zabbix-sql-scripts/postgresql/timescaledb.sql
    ./usr/share/doc/zabbix-sql-scripts/sqlite3/
    ./usr/share/doc/zabbix-sql-scripts/sqlite3/proxy.sql

    Comment

    • joostdeheer
      Junior Member
      • Feb 2022
      • 7

      #3
      Originally posted by cyber
      Code:
      rpm2cpio zabbix-sql-scripts-6.0.0-1.el8.noarch.rpm | cpio -idmv
      A bit easier:
      Code:
      rpm -qlp zabbix-sql-scripts-6.0.0-1.el8.noarch.rpm

      Comment


      • cyber
        cyber commented
        Editing a comment
        Yeah, Never had to extract any rpm-s, so I just followed first example from google search..
    • Wilmer9577
      Junior Member
      • Mar 2022
      • 1

      #4
      Originally posted by joostdeheer
      A bit easier:
      Code:
      rpm -qlp zabbix-sql-scripts-6.0.0-1.el8.noarch.rpm
      The solution worked for me thanks to the community and the members for the solution.

      Comment

      Working...