image sql error on install

[woger]

Hi there,

I am trying to install 1.1 on a Fedora 4 server. I allready managed to install version 1.0 earlier this week, but offcourse wants the latest version ;)
So i dumped the database and filled it with schema.sql and data.sql, but with images.sql I get an "ERROR 1048 (23000) at line 24: Column 'image' cannot be null" error. I copied the images to the directory mentioned in the images.sql and chowned them but i still get this error. I found another thread in this forum but that didn't work out either. Does anyone knows how to handle this?

Woger

[woger]

Extra info.
I have also webmin installed and can see that the image table is empty. Can anyone tell me what should be on the image part of the table? (where the image file should be loaded). Maybe I can put them in manually.

[elkor]

if you look at the images.sql file you'll see that it contains a directory path to the icons. This must be edited to correctly identify the path to the files contianed in the tarball, after that the images should load correctly

[woger]

Nope,

Isn't working either. I tried to copy the files to the directory mentioned in the sql file and that didn't work either. Still the same error.

[elkor]

Odd.

have you triple checked everything?

the sql statement in question is

insert into images values(1,1,"hub",load_file("/path/to/icon/Hub.png"));

the images collumn in table images is in position 4 (the load_file field), for this to be null it indicates that the file is either not found or not readable.

[woger]

Well,

I tried this and it seemed to be working. So it must have been a rights problem:

mysql -u root -p zabbix < images.sql

Thanks,

Woger

[elkor]

no problem, long as you're working now :D