Ad Widget

Collapse

2.2.3rc2 Installation Problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Yello
    Senior Member
    • Apr 2011
    • 309

    #1

    2.2.3rc2 Installation Problem

    Hi,
    I'm trying to apply schema, data and images to postgresql 9.1 on ubuntu 12.04. I'm following the instructions at:

    https://www.zabbix.com/wiki/howto/in...8_on_debian_50)

    I'm hitting an error when running:

    $ cat database/postgresql/data.sql | psql zabbix

    Error (truncated):

    INSERT 0 1
    INSERT 0 1
    ERROR: insert or update on table "sysmaps_elements" violates foreign key constraint "c_sysmaps_elements_2"
    DETAIL: Key (iconid_off)=(185) is not present in table "images".
    ERROR: current transaction is aborted, commands ignored until end of transaction block


    if someone can help me to move past this error that will be great


    Regards,
    Dave
  • Yello
    Senior Member
    • Apr 2011
    • 309

    #2
    Hi,
    I fixed this by applying the image.sql file before data.sql. The instructions are in a different order.


    Regards,
    Dave

    Comment

    Working...