zabbix-1.1alpha install & upgrade issues

[LEM]

Upgrading (from 1.0 to 1.1alpha1) issue:
Hi, I tried to upgrade a 1.0 plateform to 1.1alpha1 doing : mysql --user=root --password=mypreferedpass zabbix < patch.sql.

I've got this error:
ERROR 13 at line 53: Can't get stat of 'Hub.png' (Errcode: 2)

My MySQL release is mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686).

Where is the error?

Install 1.1alpha1 from scratch:
Unable to upgrade my 1.0 test
release, I decided to install from scratch the new 1.1alpha1 release, doing:
. creating database zabbix_11alpha1
. go to create/
. mysql -u root --password=mypreferedpasswd zabbix_11alpha1 < mysql/schema.sql
. mysql -u root --password=mypreferedpasswd zabbix_11alpha1 < data/data.sql
. mysql -u root --password=mypreferedpasswd zabbix_11alpha1 < mysql/images.sql

And I've got the following error for this last command:
ERROR 13 at line 24: Can't get stat of 'Hub.png' (Errcode: 2)

Where is my error?

tia for any clues :-)

[Alexei]

Modify images.sql to have full pathnames in all occurencies of load_file(). Unfortunately MySQL does not accept relative paths.

[LEM]

Modify images.sql to have full pathnames in all occurencies of load_file(). Unfortunately MySQL does not accept relative paths.

Ok, using full pathname is ok. Thx!

Anyway, it lacks two images in the 1.1alpha1 distribution which are 'europe.png' and 'europe2.png'.

Having no background images seems to make it impossible to create new map:
ERROR EXECUTING: insert into sysmaps (name,width,height,background) values ('testmap',800,600,''))

Btw, is it possible to ask for "No background image"? How (a quick and dirty no-baground.png with transparency?)?

[Alexei]

Anyway, it lacks two images in the 1.1alpha1 distribution which are 'europe.png' and 'europe2.png'.

Having no background images seems to make it impossible to create new map:
ERROR EXECUTING: insert into sysmaps (name,width,height,background) values ('testmap',800,600,''))

Do not worry about the europe images, just ignore them.

I'll fix the map problem asap.

[LEM]

Do not worry about the europe images, just ignore them.

I'll fix the map problem asap.

Ok. just some infos before switching to other tests:
. europe.png is in upgrades/dbpatches/1.0_to_1.1alpha1/mysql/ and should be also in create/data/images/
. europe2.jpg does not exist, but seems to be europe.jpg instead (in upgrades/dppatches/1.0_to_1.1alpha1/mysql/ too)

Even if the images are correctly injected in the mysql database, the creation of a new map just fail:
ERROR EXECUTING: insert into sysmaps (name,width,height,background) values ('Test',800,600,'Europe B&W'))
[ERROR:Cannot add network map]
Array ( )

[Alexei]

Patch

Hi all,

Here is fix for the issue with network maps:

replace

$sql="insert into sysmaps (name,width,height,background) values
    ('$name',$width,$height,'$background'))";

by

$sql="insert into sysmaps (name,width,height,background) values
    ('$name',$width,$height,'$background')";

in frontends/php/include/config.inc.php

[LEM]

Hi all,
Here is fix for the issue with network maps:
[...]

ok fixed for me. Thx!

Cheers,

[Alexei]

Note that the fix does not eliminate strange debug output appearing on the screen, so please ignore it for now. I'm working on 1.1alpha2 which will fix all reported issues.

[dimi]

Error in Add new Host in MAPS

Dear Alexei
i have found this error when i try to add a new host in Map:
insert into sysmaps_hosts (sysmapid,hostid,label,x,y,icon,url) values (1,10017,'KVox Server',200,100,'Server','','Server')

i fix it in this mode, but i dont know if is right?
insert into sysmaps_hosts (sysmapid,hostid,label,x,y,icon,url,icon_on) values (1,10017,'KVox Server',200,100,'Server','','Server')

Thanks for your great Application!!! Good Work!

[Alexei]

i have found this error when i try to add a new host in Map:
insert into sysmaps_hosts (sysmapid,hostid,label,x,y,icon,url) values (1,10017,'KVox Server',200,100,'Server','','Server')

i fix it in this mode, but i dont know if is right?
insert into sysmaps_hosts (sysmapid,hostid,label,x,y,icon,url,icon_on) values (1,10017,'KVox Server',200,100,'Server','','Server')

Thanks for your message! I cannot confirm if it's right now. Will check it later today.

I plan to fix all reported issues and release 1.1alpha2 as soon as I can.

Please, keep reporting any issues.