Ad Widget

Collapse

missing server.sql.gz in installation

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Zod
    Junior Member
    • Jun 2022
    • 2
    #1

    missing server.sql.gz in installation

    Cannot perform for install:
    zcat /usr/share/doc/zabbix-sql-scripts/mysql/server.sql.gz | mysql -uzabbix -p zabbix
    Ubuntu 20.04.4 server
    Zabbix 6.0.5
    The server.sql.gz does not exist anywhere. Some posts were indicating the problem is in the exclude file. I have no exclude file.
    Need to create the templates and cannot move forward. All packages are installed.
    Any idea?


    List of packages:
    $ apt list | grep -i zabbix

    WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

    pcp-export-zabbix-agent/focal 5.0.3-1 amd64
    python3-pyzabbix/focal 0.7.4-1 all
    zabbix-agent-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-agent2-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-agent2/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-agent/focal,now 1:6.0.5-1+ubuntu20.04 amd64 [installed]
    zabbix-apache-conf/focal,now 1:6.0.5-1+ubuntu20.04 all [installed]
    zabbix-frontend-php/focal,now 1:6.0.5-1+ubuntu20.04 all [installed]
    zabbix-get-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-get/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-java-gateway/focal 1:6.0.5-1+ubuntu20.04 all
    zabbix-js-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-js/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-nginx-conf/focal 1:6.0.5-1+ubuntu20.04 all
    zabbix-proxy-mysql-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-proxy-mysql/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-proxy-pgsql-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-proxy-pgsql/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-proxy-sqlite3-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-proxy-sqlite3/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-release/focal,now 1:6.0-1+ubuntu20.04 all [installed]
    zabbix-sender-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-sender/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-server-mysql-dbgsym/focal,now 1:6.0.5-1+ubuntu20.04 amd64 [installed]
    zabbix-server-mysql/focal,now 1:6.0.5-1+ubuntu20.04 amd64 [installed]
    zabbix-server-pgsql-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-server-pgsql/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-sql-scripts/focal,now 1:6.0.5-1+ubuntu20.04 all [installed]
    zabbix-web-service/focal 1:6.0.5-1+ubuntu20.04 amd64


    $ dpkg -l | grep -i zabbix
    ii zabbix-agent 1:6.0.5-1+ubuntu20.04 amd64 Zabbix network monitoring solution - agent
    ii zabbix-apache-conf 1:6.0.5-1+ubuntu20.04 all Zabbix network monitoring solution - apache configuration for front-end
    ii zabbix-frontend-php 1:6.0.5-1+ubuntu20.04 all Zabbix network monitoring solution - PHP front-end
    ii zabbix-release 1:6.0-1+ubuntu20.04 all Zabbix official repository configuration
    ii zabbix-server-mysql 1:6.0.5-1+ubuntu20.04 amd64 Zabbix network monitoring solution - server (MySQL)
    ii zabbix-server-mysql-dbgsym 1:6.0.5-1+ubuntu20.04 amd64 debug symbols for zabbix-server-mysql
    ii zabbix-sql-scripts 1:6.0.5-1+ubuntu20.04 all Zabbix network monitoring solution - sql-scripts


    ~$ apt list | grep -i mysql

    WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

    akonadi-backend-mysql/focal 4:19.12.3-0ubuntu2 all
    asterisk-mysql/focal 1:16.2.1~dfsg-2ubuntu1 amd64
    automysqlbackup/focal 2.6+debian.4-2 all
    bacula-common-mysql/focal 9.4.2-2ubuntu5 amd64
    bacula-director-mysql/focal 9.4.2-2ubuntu5 all
    cl-sql-mysql/focal 6.7.0-1.1build2 amd64
    courier-authlib-mysql/focal 0.69.0-2build3 amd64
    cvm-mysql/focal 0.97-0.1build2 amd64
    dbconfig-mysql/focal 2.0.13 all
    dbf2mysql/focal 1.14a-5.1build2 amd64
    default-libmysqlclient-dev/focal 1.0.5ubuntu2 amd64
    default-mysql-client-core/focal 1.0.5ubuntu2 all
    default-mysql-client/focal 1.0.5ubuntu2 all
    default-mysql-server-core/focal 1.0.5ubuntu2 all
    default-mysql-server/focal 1.0.5ubuntu2 all
    diaspora-installer-mysql/focal 0.7.6.1+debian1 all
    dovecot-mysql/focal-updates 1:2.3.7.2-1ubuntu3.5 amd64
    erlang-p1-mysql/focal 1.0.12-1 amd64
    freeradius-mysql/focal-updates 3.0.20+dfsg-3ubuntu0.1 amd64
    gambas3-gb-db-mysql/focal 3.14.3-2ubuntu3.1 amd64
    gambas3-gb-mysql/focal 3.14.3-2ubuntu3.1 amd64
    gnokii-smsd-mysql/focal 0.6.31+dfsg-2ubuntu10 amd64
    golang-github-go-sql-driver-mysql-dev/focal 1.4.1-1 all
    golang-github-vividcortex-mysqlerr-dev/focal 0.0~git20170204.6c6b55f-2 all
    golang-github-ziutek-mymysql-dev/focal 1.5.4+git20170206.23.0582bcf-2 all
    groonga-normalizer-mysql/focal 1.1.4-2 amd64
    homer-api-mysql/focal 5.0.6+dfsg2-3.1 amd64
    icinga2-ido-mysql/focal 2.11.2-1ubuntu3 amd64
    kamailio-mysql-modules/focal 5.3.2-1build3 amd64
    kexi-mysql-driver/focal 1:3.2.0-2build1 amd64
    libapache2-mod-log-sql-mysql/focal 1.100-16.3build2 amd64
    libaprutil1-dbd-mysql/focal 1.6.1-4ubuntu2 amd64
    libclass-dbi-mysql-perl/focal 1.00-4 all
    libcppdb-mysql0/focal 0.3.1+dfsg-8ubuntu2 amd64
    libcrypt-mysql-perl/focal 0.04-6build5 amd64
    libdatetime-format-mysql-perl/focal 0.06-1 all
    libdbd-mysql-perl/focal 4.050-3 amd64
    libdbd-mysql/focal 0.9.0-8ubuntu1 amd64
    libgda-5.0-mysql/focal 5.2.9-2ubuntu1 amd64
    libkdb3-driver-mysql/focal 3.2.0-4build2 amd64
    libmysql++-dev/focal 3.2.5-1build1 amd64
    libmysql++-doc/focal 3.2.5-1build1 all
    libmysql++3v5/focal 3.2.5-1build1 amd64
    libmysql-diff-perl/focal 0.60-1 all
    libmysql-ocaml-dev/focal 1.2.1-1ubuntu3 amd64
    libmysql-ocaml/focal 1.2.1-1ubuntu3 amd64
    libmysqlclient-dev/focal-updates,focal-security 8.0.29-0ubuntu0.20.04.3 amd64
    libmysqlclient21/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 amd64 [installed,automatic]
    libmysqlcppconn-dev/focal 1.1.12-4ubuntu2 amd64
    libmysqlcppconn7v5/focal 1.1.12-4ubuntu2 amd64
    libodb-mysql-2.4/focal 2.4.0-5ubuntu2 amd64
    libodb-mysql-dev/focal 2.4.0-5ubuntu2 amd64
    libopendbx1-mysql/focal 1.4.6-13build4 amd64
    libpam-mysql/focal 0.8.1-1ubuntu1 amd64
    libpocodatamysql62/focal 1.9.2-3ubuntu3 amd64
    libpreludedb7-mysql/focal 5.1.0-4build1 amd64
    libqt5sql5-mysql/focal-updates,focal-security 5.12.8+dfsg-0ubuntu2.1 amd64
    librdf-storage-mysql/focal 1.0.17-1.1ubuntu1 amd64
    libreoffice-mysql-connector/focal-updates,focal-security 1:6.4.7-0ubuntu0.20.04.4 amd64
    libreoffice-sdbc-mysql/focal-updates,focal-security 1:6.4.7-0ubuntu0.20.04.4 amd64
    librust-mysqlclient-sys-dev/focal 0.2.4-1 amd64
    libsoci-mysql3.2v5/focal 3.2.3-2ubuntu4 amd64
    libtime-piece-mysql-perl/focal 0.06-2 all
    lighttpd-modules-mysql/focal-updates 1.4.55-1ubuntu1.20.04.1 amd64
    lua-dbi-mysql-dev/focal 0.7.2-1ubuntu1 amd64
    lua-dbi-mysql/focal 0.7.2-1ubuntu1 amd64
    lua-sql-mysql-dev/focal 2.3.4-1build2 amd64
    lua-sql-mysql/focal 2.3.4-1build2 amd64
    mha4mysql-manager/focal 0.58-1 all
    mha4mysql-node/focal 0.58-1 all
    mysql-client-8.0/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 amd64 [installed,automatic]
    mysql-client-core-8.0/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 amd64 [installed,automatic]
    mysql-client/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 all [installed,automatic]
    mysql-common/focal,now 5.8+1.0.5ubuntu2 all [installed,automatic]
    mysql-router/focal-updates,focal-security 8.0.29-0ubuntu0.20.04.3 amd64
    mysql-sandbox/focal 3.2.05-1 all
    mysql-server-8.0/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 amd64 [installed,automatic]
    mysql-server-core-8.0/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 amd64 [installed]
    mysql-server/focal-updates,focal-security,now 8.0.29-0ubuntu0.20.04.3 all [installed]
    mysql-source-8.0/focal-updates,focal-security 8.0.29-0ubuntu0.20.04.3 amd64
    mysql-testsuite-8.0/focal-updates,focal-security 8.0.29-0ubuntu0.20.04.3 amd64
    mysql-testsuite/focal-updates,focal-security 8.0.29-0ubuntu0.20.04.3 all
    mysqltcl/focal 3.052-3ubuntu1 amd64
    mysqltuner/focal 1.7.13-1 all
    node-mysql/focal 2.18.1-1 all
    oar-server-mysql/focal 2.5.8-2 amd64
    oar-user-mysql/focal 2.5.8-2 amd64
    opendnssec-enforcer-mysql/focal 1:2.1.5-1ubuntu1 amd64
    orthanc-mysql/focal 2.0-2ubuntu5 amd64
    parser3-mysql/focal 10.7-4ubuntu2 amd64
    pdns-backend-mysql/focal 4.2.1-1build2 amd64
    perdition-mysql/focal 2.2-3.1 amd64
    php-mdb2-driver-mysql/focal 1.5.0b4-2 all
    php-mysql/focal,now 2:7.4+75 all [installed,automatic]
    php7.4-mysql/focal-updates,focal-security,now 7.4.3-4ubuntu2.12 amd64 [installed,automatic]
    pike8.0-mysql/focal 8.0.702-1ubuntu1 amd64
    postfix-mysql/focal-updates 3.4.13-0ubuntu1.2 amd64
    postgresql-12-mysql-fdw/focal 2.5.3-1 amd64
    proftpd-mod-mysql/focal 1.3.6c-2 amd64
    prometheus-mysqld-exporter/focal 0.11.0+ds-1 amd64
    puppet-module-puppetlabs-mysql/focal 8.1.0-2ubuntu1 all
    pure-ftpd-mysql/focal 1.0.49-4 amd64
    python-aiomysql-doc/focal 0.0.20-2 all
    python-pymysql-doc/focal 0.9.3-2ubuntu3 all
    python3-aiomysql/focal 0.0.20-2 all
    python3-mysql.connector/focal 8.0.15-2build1 all
    python3-mysqldb-dbg/focal 1.4.4-2build1 amd64
    python3-mysqldb/focal 1.4.4-2build1 amd64
    python3-pymysql/focal 0.9.3-2ubuntu3 all
    python3-testing.mysqld/focal 1.4.0-4 all
    r-cran-rmysql/focal 0.10.19-1 amd64
    redmine-mysql/focal 4.0.6-2 all
    roundcube-mysql/focal 1.4.3+dfsg.1-1 all
    rsyslog-mysql/focal-updates,focal-security 8.2001.0-1ubuntu1.3 amd64
    rt4-db-mysql/focal 4.4.3-2 all
    ruby-dataobjects-mysql/focal 0.10.17-1ubuntu1 amd64
    ruby-mysql2/focal 0.5.2-1ubuntu3 amd64
    tarantool-lts-mysql-module/focal 1.5.5.37.g1687c02-1build3 amd64
    tcl8.6-tdbc-mysql/focal 1.1.1-1ubuntu1 amd64
    tntdb-mysql4v5/focal 1.3-4ubuntu1 amd64
    ulogd2-mysql/focal 2.0.7-1build1 amd64
    voms-mysql-plugin/focal 3.1.7-2ubuntu1 amd64
    w1retap-mysql/focal 1.4.4-3ubuntu2 amd64
    zabbix-proxy-mysql-dbgsym/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-proxy-mysql/focal 1:6.0.5-1+ubuntu20.04 amd64
    zabbix-server-mysql-dbgsym/focal,now 1:6.0.5-1+ubuntu20.04 amd64 [installed]
    zabbix-server-mysql/focal,now 1:6.0.5-1+ubuntu20.04 amd64 [installed]
    Tags: None
    • Atsushi
      Senior Member
      • Aug 2013
      • 2028
      #2
      Have you set your apt or dpkg settings to not install the documentation?

        Comment

        • Zod
          #2.1
          Zod commented
          22-06-2022, 03:33
          Editing a comment
          I re-installed server and front-end. It appeared
        • themactech
          Junior Member
          • Dec 2022
          • 7
          #3
          I have the same issue, and I do NOT have any document ignore rule in apt. I have done an install of the latest 6.4 in a VM and copied over the file from there, but now get a DB mismatch error. Can I please get a source to just download this file, don't really care at this point to fix the installer, just need to grab a hold of this file...

            Comment

            • Atsushi
              Senior Member
              • Aug 2013
              • 2028
              #4
              Hi themactech,
              Have you installed the zabbix-sql-scripts package? And have you checked the contents of the /usr/share/zabbix-sql-scripts directory?
              Also, Zabbix 6.4 has not been officially released yet, so it is better not to use it in a production environment yet.​

                Comment

                • Cláudio Ribeiro
                  Junior Member
                  • May 2023
                  • 1
                  #5
                  Saudações! Equipe Eu também estou tendo o mesmo problema que eu instalei a versão 6.0 no ubuntu18.4 e vem um erro bash quando eu coloquei o comando para importar o banco de dados. zcat/usr/share/zabbix-sql-scripts/mysql/server.sql.gz, diante dessa situação, o que devo fazer?

                    Comment

                    • Admin031
                      Junior Member
                      • Oct 2023
                      • 1
                      #6
                      In some versions the path is a different one. Search for the file to locate it and then run the command with updated path.


                      #find / -iname <file name>

                      This path was different for my installation. It was

                      /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz
                      /usr/share/zabbix-sql-scripts/mysql/server.sql.gz​
                      ​

                        Comment

                        Previous template Next
                        Working...