Ad Widget

Collapse

Schema Files in Zabbix 3 - what to do for Proxy?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • joanypony
    Junior Member
    • Dec 2015
    • 6

    #1

    Schema Files in Zabbix 3 - what to do for Proxy?

    Hi All,
    In 2.4, the 3 schema (schema.sql, images.sql and data.sql) were provided separately. This was helpful as only 1 is allowed for Proxy servers - schema.sql.

    In the installation instructions for Zabbix 3, there is a conflict - in the db scripts post - they tell you to do it the old way - https://www.zabbix.com/documentation...all/db_scripts

    In the installation doc - https://www.zabbix.com/documentation..._from_packages they tell you to import 1 large schema file into Zabbix.

    zcat create.sql.gz | mysql -uroot zabbix

    Does the previous restriction for the proxy database still apply?

    Thanks,
    Joan
  • Atsushi
    Senior Member
    • Aug 2013
    • 2028

    #2
    Please try use schema.sql.gz.

    ex. Proxy package for CentOS 7
    /usr/share/doc/zabbix-proxy-mysql-3.0.0/schema.sql.gz

    Code:
    zcat schema.sql.gz | mysql -uroot zabbix

    Comment

    • joanypony
      Junior Member
      • Dec 2015
      • 6

      #3
      Ah. That's really obvious. Thank you so much

      Comment

      • mmacpuguy
        Junior Member
        • Sep 2015
        • 20

        #4
        Not when using Ubuntu it isn't. Still can find the file.

        Comment

        • Atsushi
          Senior Member
          • Aug 2013
          • 2028

          #5
          If you use Ubuntu 14.04, It makes use of the following file.
          /usr/share/doc/zabbix-proxy-mysql/schema.sql.gz

          Comment

          • mmacpuguy
            Junior Member
            • Sep 2015
            • 20

            #6
            That apparently imports the images.sql and data.sql as well because my proxy is complaining that "zabbix proxy cannot work with a zabbix server database"

            Comment

            • Atsushi
              Senior Member
              • Aug 2013
              • 2028

              #7
              proxy server requires only table.
              images.sql and data.sql is not required.

              Comment

              Working...