Ad Widget

Collapse

Zabbix proxy 3.0 : "zabbix proxy cannot work with a zabbix server database"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mmacpuguy
    Junior Member
    • Sep 2015
    • 20

    #1

    Zabbix proxy 3.0 : "zabbix proxy cannot work with a zabbix server database"

    In the 3.0 install there aren't the (3) separate files schema.sql, data.sql and images.sql

    Just one command to set up the database from one file:

    # zcat create.sql.gz | mysql -uroot zabbix



    So does anyone have the secret sauce to setting up the proxy database? The official docs don't seem to have it.

    Thanks
  • roberts.andzans
    Junior Member
    • Feb 2016
    • 20

    #2
    Hi,

    Please, try to use command below in /usr/share/doc/zabbix-server-mysql-3.0.x directory:

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

    Rob

    Comment

    • ftwmdp
      Junior Member
      • Mar 2016
      • 17

      #3
      I am having this same problem.

      I just install zabbix server 2.4.7 on my freebsd 10.3

      and i get this error in zabbix log.

      cd /usr/local/share/zabbix2/server/database/mysql
      cat schema.sql images.sql data.sql |mysql -u zabbix -p zabbix

      And i cant start zabbix service
      1607:20160412:130545.278 cannot use database "zabbix": Zabbix server cannot work with a Zabbix proxy database"

      Help please

      Comment

      • ftwmdp
        Junior Member
        • Mar 2016
        • 17

        #4
        #cd /usr/local/share/zabbix2/server/database/mysql
        # mysql -u root -p zabbix < schema.sql
        # mysql -u root -p zabbix < images.sql
        # mysql -u root -p zabbix < data.sql

        it works now

        Comment

        Working...