can't load images into database

[Khach]

I add the following line to /etc/my.cnf

set-variable = max_allowed_packet=16M

and restart mysqld (service mysqld restart)
copy all the images to /tmp
chmod 777 -R /tmp

but still have the following error

[root@wa05ids data]# cat images.sql |mysql -u root -p zabbix
Enter password:
ERROR 13 (HY000) at line 24: Can't get stat of '/tmp/Hub.png' (Errcode: 13)

[root@wa05ids data]# ls -al /tmp/Hub.png
-rwxrwxrwx 1 root root 1960 Oct 27 12:08 /tmp/Hub.png

[acceleratebiz]

Here is my /etc/my.cnf file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable=max_allowed_packet=100M


[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[acceleratebiz]

[root@wa05ids data]# cat images.sql |mysql -u root -p zabbix
Enter password:
ERROR 13 (HY000) at line 24: Can't get stat of '/tmp/Hub.png' (Errcode: 13)

[root@wa05ids data]# ls -al /tmp/Hub.png
-rwxrwxrwx 1 root root 1960 Oct 27 12:08 /tmp/Hub.png

no idea what that error is all about, sorry. Not experienced with mysql myself.

[lofouk]

ERROR 13 (HY000) at line 24: Can't get stat of

Hi,

I ve got the same trouble when i begin the installation of Zabbix

ERROR 13 (HY000) at line 24: Can't get stat of /home/zabbix/zabbix/create/data/images/hub.png

I create a user with the same privilege of the ROOT user

i am using Fedora Core 4.
Mysql 4.1.11

you know what is wrong ?

Regards

lofouk

[felipegeek]

I had exactly the same problem with the 'images.sql' part. I, like most users, put the Zabbix application in /home/zabbix. By default when the 'zabbix' user was created with 'useradd' the /home/zabbix folder was assigned '700' rights so no other user could read the contents of the '/home/zabbix' folder. After granting '755' rights it worked just fine. Another note: After extracting the current zabbix tar image make sure to rename the directory that was created which has the version number information on it to just 'zabbix'.

BTW: This happened to me on CentOS 4.2 (RHEL4 GPL variant)

-felipe