| View previous topic :: View next topic |
| Author |
Message |
rado3105
Apprentice
Joined: 14 Jul 2007
Posts: 293
|
 Posted: Sun Apr 24, 2011 10:51 am Post subject: zabbix installation problem - ERROR 1452 (23000) at line 122 |
 |
|
| Code: | gentoo-desktop ~ # mysql -u zabbix -p zabbix < /usr/share/zabbix/database/create/data/data.sql
Enter password:
ERROR 1452 (23000) at line 12215: 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`)) |
Can anybody know how to solve it?
Edit: Seems like zabbix bug: https://support.zabbix.com/browse/ZBX-3020 |
|
| Back to top |
|
 |
rado3105
Apprentice
Joined: 14 Jul 2007
Posts: 293
|
| Posted: Sun Apr 24, 2011 10:57 am Post subject: |
|
|
using this manual for 1.9x versions:
http://en.gentoo-wiki.com/wiki/Zabbix
| Code: | mysql -uzabbix -p zabbix < /usr/share/zabbix/database/create/schema/mysql.sql
mysql -uzabbix -p zabbix < /usr/share/zabbix/database/create/data/data.sql
mysql -uzabbix -p zabbix < /usr/share/zabbix/database/create/data/images_mysql.sql |
there is mistake it should be all 3 separated like this: .
another mistake: | Code: | | mysql -u zabbix -p zabbix < /usr/share/zabbix/database/create/data/images_mysql.sql |
should be executed before
| Code: | | mysql -u zabbix -p zabbix < /usr/share/zabbix/database/create/data/data.sql |
be careful of this. This was the problem that showed me.
Then when I did it it showed me error:
| Code: | | ERROR 1062 (23000) at line 24: Duplicate entry '1' for key 'PRIMARY' |
but it should be ok, or? |
|
| Back to top |
|
|
|
Networking & Security
