problem images.sql

[debora]

I install zabbix 1,1 alpha7, by means of howto_zabbix in gentoo, but does not exist images.sql, my question is that if I must create this file or comes predetermined with zabbix?

[gadget]

I install zabbix 1,1 alpha7

SQL image file is located in /create/data/images.sql

[Nate Bell]

You posted this question in 3 seperate threads. Please do not do this again.

You could have also done a search to see if your question has already been answered. A simple search of the forums sent me to a post with a link to the Zabbix documentation detailing exactly how to find images.sql.
http://www.zabbix.com/manual/v1.1/install_server.php

Nate

[debora]

I to follow the instructions of manual v 1,1, but says:

"cat: images.sql: The file or the directory does not exist".

I am created schema.sql and data.sql, but it does not create images.sql, what's the problem?, I to follow the instructions of the page www.gentoo-wiki.com/Howto_zabbix, I need something, because they are the isntruccions to install in gentoo!;


Create the database
Log on to mysql and give zabbix access to its database

# mysql -u <your MySQL root account> -p<MySQL password>
mysql> create database zabbix;
mysql> grant all on zabbix.* to zabbix@localhost identified by '<some password for zabbix>';
mysql> flush privileges;
mysql> \q

Populate the database with initial Zabbix tables and data.

mysql -u zabbix -p<MySql zabbix password> zabbix < /usr/share/zabbix/dbms/schema.sql
mysql -u zabbix -p<MySql zabbix password> zabbix < /usr/share/zabbix/dbms/data.sql

but to create images.sql, it does not do anything

[Nate Bell]

It sounds like you are still unable to find the file. cd to your Zabbix installation directory (where you compiled Zabbix from) that looks like zabbix-1.1alpha7/. Once there, you should be able to cd create/data/. If you look in that directory then there should be a file named images.sql. You can then cat that file into your database as outlined in the manual.

If the file isn't there, you might want to download a fresh copy of Zabbix and try looking again. I have an old copy of 1.1alpha7 lying around, and I can confirm the images.sql files is there. It should be in the same directory as where you found data.sql. Also, you say you are creating these files, but that's not accurate. They come with the Zabbix installation package premade. You just have to apply them to your database. Just wanted to make sure you weren't trying to find the process for building one yourself.

Also, if you're desperate to find the file, just use locate images.sql.

Nate

[debora]

Thanks for the recommendation, but do not exist images.sql, but that is in this direction:
/var/www/localhost/htdocs/zabbix/images/sysmaps,and what it seems he is this:

drwxr-xr-x 3 root root 4096 dic 20 16:30 .
drwxr-xr-x 5 root root 4096 dic 20 16:30 ..
-rw-r--r-- 1 root root 1960 dic 20 16:30 Hub.png
-rw-r--r-- 1 root root 992 dic 20 16:30 Hub_small.png
-rw-r--r-- 1 root root 1960 dic 20 16:30 Network.png
-rw-r--r-- 1 root root 992 dic 20 16:30 Network_small.png
-rw-r--r-- 1 root root 1923 dic 20 16:30 Notebook.png
-rw-r--r-- 1 root root 920 dic 20 16:30 Notebook_small.png
drwxr-xr-x 2 root root 4096 dic 20 16:30 old
-rw-r--r-- 1 root root 3386 dic 20 16:30 Phone.png
-rw-r--r-- 1 root root 1315 dic 20 16:30 Phone_small.png
-rw-r--r-- 1 root root 1762 dic 20 16:30 Printer.png
-rw-r--r-- 1 root root 951 dic 20 16:30 Printer_small.png
-rw-r--r-- 1 root root 161 dic 20 16:30 README
-rw-r--r-- 1 root root 1960 dic 20 16:30 Router.png
-rw-r--r-- 1 root root 992 dic 20 16:30 Router_small.png
-rw-r--r-- 1 root root 2703 dic 20 16:30 Satellite.png
-rw-r--r-- 1 root root 1187 dic 20 16:30 Satellite_small.png
-rw-r--r-- 1 root root 1596 dic 20 16:30 Server.png
-rw-r--r-- 1 root root 820 dic 20 16:30 Server_small.png
-rw-r--r-- 1 root root 2276 dic 20 16:30 UPS.png
-rw-r--r-- 1 root root 861 dic 20 16:30 UPS_small.png
-rw-r--r-- 1 root root 2326 dic 20 16:30 Workstation.png
-rw-r--r-- 1 root root 1056 dic 20 16:30 Workstation_small.png

my question is the following one I must load them in a file images.sql or images.sql this created?

[SAT QPass]

Debora,

As a gentoo user myself I highly recommend you switch to the latest beta and install by hand from source, a trival operation. You can then follow the instructions in the manual and the source has all the necessary files.

My guess is there is a problem with the ebuild in gentoo (I do not use it for this package), so I cannot be certain. You should issue a bug to ebuild maintainer as it is a build problem using a customized build process which is not supported by Zabbix created by a 3rd party of rather old build (Mar-2005 instead of Jan-2006).

As I mentioned earlier, your best best is to install from source and follow the instructions in the documentation linked above.

[Nate Bell]

Ah, good call. I hadn't even considered you might be installing from anything other than source. Yeah, I second what SAT Qpass said; download a copy of the source and you're sure to find everything you need.

Nate

[debora]

How?

How I can do that?,they can take the steps to me of like doing it, because I'm new in all this the zabbix!, please help me

[Nate Bell]

Go to www.zabbix.com, click on Download, find the latest Beta and click Download. Installing Zabbix is outlined (somewhat) in the manual, but basically you do a ./configure and a make install. Or you could just unzip and untar the source code, find the images.sql file, and use that with your current install.

Nate

[elkor]

I'm slightly dismayed that we have a few gentoo users here who need to be walked through this. Don't get me wrong, it's right to ask for help when you don't understand, but if you are running gentoo and you don't understand the concepts of compiling from source you are going to run into a LOT of problems in the future.

In the intrest of assisting, yes.. Nate is correct. Download the archive, unpack it. then change to that directory and run ./configure --enable-client --enable-server;make;make install.

I urge you, if this seems overly complicated switch to another platform for your zabbix needs. Gentoo is a terrific distro, I use it myself, but you need to know a little bit about it to keep it in top shape over the long haul for something like this.

[debora]

But

And does not exist another option? images.sql can be created, because I do not want to lose all the work that done until the moments, please understand me!,

[elkor]

sure, download the most recent source tarball, extract it, and use the images.sql file from there to finish your incomplete installation.

alternatively.. zabbix functions just fine without sticking the images in the database.

and finally you can always use the gui to manually add the images in yourself.

you have more than a few options debora, this is not a very complicated issue to have been going on for this long.

[debora]

But dont´s easy you say; I have created images.sql manually with NANO and moved the file of images to /tmp; and edited images.sql and inserts ICONS the in the table IMAGES but it does not show the icon

mysql> select * from images;

+---------+-----------+------+---------+
| imageid | imagetype | name | image |
+---------+-----------+------+---------+
| 1 | 1 | Hub | Hub.png |
+---------+-----------+------+---------+
1 row in set (0.00 sec)

WHAT'S WRONG?