Ad Widget

Collapse

zabbix 2.0.3 New installation trouble (data.sql, line 2691)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ManJak
    Member
    • Nov 2009
    • 42

    #1

    zabbix 2.0.3 New installation trouble (data.sql, line 2691)

    Step-by-step:

    mysql> create database zabbix;
    Query OK, 1 row affected (0.00 sec)

    mysql> grant all privileges on zabbix.* to user@localhost identified by 'password';

    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

    # cat schema.sql | mysql -u zabbix -p zabbix
    Enter password:
    # cat data.sql | mysql -u zabbix -p zabbix
    Enter password:
    ERROR 1452 (23000) at line 2691: 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`))
    #

    Thats all

    Tried to download the files from the site (Zabbix Sources 2.0.3 03 October, 2012). The result is the same.

    # pkg_info | grep zabbix
    zabbix2-agent-2.0.3 Enterprise-class open source distributed monitoring (agent)
    zabbix2-frontend-2.0.3_1 Enterprise-class open source distributed monitoring (fronte
    zabbix2-server-2.0.3 Enterprise-class open source distributed monitoring (server
    # pkg_info | grep mysql
    mysql-client-5.5.28 Multithreaded SQL database (client)
    mysql-server-5.5.28 Multithreaded SQL database (server)
  • ManJak
    Member
    • Nov 2009
    • 42

    #2
    Solved!

    # cat schema.sql | mysql -u zabbix -p zabbix
    Enter password:
    # cat images_mysql.sql | mysql -u zabbix -p zabbix
    Enter password:
    # cat data.sql | mysql -u zabbix -p zabbix
    Enter password:

    I'm sorry

    Comment

    Working...