Can't upload images

[jcduss59]

Dear all,


I've got troubles since I upgrade zabbix 1.8.3 to 1.8.8 on debian squeeze.

I can't upload anymore any backgrounds images.

When I want to update a file or create a new image, it gaves me a green messages with "images updated" ... but the image name appear with no image.

The mysql blob in table images remains empty...

If I dump I can see the images uploaded fine.

I think there's trouble between php and mysql storage... but I haven't got any logs from apache..

Can you help me please?

Thank you.

[jcduss59]

Can someone help me about it ?

[nelsonab]

Have you searched the support database for similar issues? Also as a test point, have you tried both PNG and JPEG?

[jcduss59]

I'm having a look at the support web site. But no solution for the moment.
If I can't find something, I'll create a case there.

I tried with PNG and JPG and have the same problem.

My database and table are both in utf8 on mysql 5.1.49

[eskytthe]

This may or may not help you:
There is this short blog on a generel problem:

http://blog.zabbix.com/storing-images-in-the-zabbix-database/563/

The blog links to 2 support cases.
(From the IRC I have seen this:"make sure to use utf8" as you do ...)
Br
Erik

[jcduss59]

I was not aware that dealing with images and databases was such an hard job!

I'll take a look at this post :

http://www.zabbix.com/forum/showthread.php?p=58066#post58066

It seems that my DB is not on the correct format for all info.

But I need to dump, backup etc.. before changing my DB structure.

I'll post feedback here.

[keul]

Try that :

USE zabbix;
ALTER DATABASE zabbix charset=utf8;
ALTER TABLE images charset=utf8;

(just make a backup before)

EDIT : ah, it was the same thing on your link.
BTY, have you finished your backups? Does it works now?