Ad Widget

Collapse

New Installation Zabbix 1.9.6 fails as well

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • frater
    Senior Member
    • Oct 2010
    • 340

    #1

    New Installation Zabbix 1.9.6 fails as well

    root@zabbix:/opt# mysql -e"create database zabbix;"
    root@zabbix:/opt# mysql -e"grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';"
    root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/schema/mysql.sql
    Enter password:
    root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/data/data.sql
    Enter password:
    ERROR 1452 (23000) at line 12212: Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))
    Zabbix agents on Linux, FreeBSD, Windows, AVM-Fritz!box, DD-WRT and QNAP
  • frater
    Senior Member
    • Oct 2010
    • 340

    #2
    The answer:

    root@zabbix:/opt# mysql -e"create database zabbix;"
    root@zabbix:/opt# mysql -e"grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';"
    root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/schema/mysql.sql
    Enter password:
    root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/data/images_mysql.sql
    Enter password:

    root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/data/data.sql
    Enter password:
    Zabbix agents on Linux, FreeBSD, Windows, AVM-Fritz!box, DD-WRT and QNAP

    Comment

    Working...