Installing zabbix ondebian r.03

[bennethos]

Hi all,

this monitoring soft looks great ! I was absolutely certain of using NAGIOS until I saw this soft. It looks very promising !

If I just could get it installed...

I use debian r.03, kernel 2.6.8, can't seem to find a debian package on the download site.
So I downloaded the source, did a ./configure, make, make install

all ok, unitl make install, I get following error :

make: *** No rule to make target `install-recursive', needed by `install'. Stop.

i'm a bit lost here, maybe I forgot something ?

Hope you can help me out

If I could get this work and show it at my work (an ISP) I will do my best to implement it over there and make a donation

Keep up the good work !

[avenger]

make: *** No rule to make target `install-recursive', needed by `install'. Stop.

i'm a bit lost here, maybe I forgot something ?

Hi,
alpha version of Zabbix does not have correct "make install".
You just need to copy needed executables from <zabbix_source>/bin/ directory to any place you want (lets say /usr/local/bin/ ), then copy <zabbix_source>/misc/conf/zabbix_*.conf (only needed) to /etc/zabbix/ (default location) and copy startup scripts for your operating system from <zabbix_source>/misc/init.d/

Then change config files and startup scripts to reflect changes.
Please make zabbix executables owned by "zabbix" user (or any non-root you want ) and make sure that all directories zabbix need to write to are writable by this user (ex. /var/log/zabbix/ /var/run/zabbix/ etc.)

Please refer to following URL for official install manual
http://www.zabbix.com/manual/v1.1/install_server.php

With best regards,
Dmitry Zamaruev,
System administrator,
NIX Solutions LTD.

[bennethos]

mysql

Hi,

thx for the fast reply !

I got another slight problem now :

I'm at the mysql part

I made a zabbix db, did a quit and then cat schema.sql | mysql -u root -p zabbix

I get following error :

ERROR 1064 at line 24: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '/connect zabbix
CREATE TABLE hosts (
hostid serial,
host

I have mysql installed and it works out fine for people working with it ...
the version is :

mysql-server 4.0.21-7 mysql database server binaries

Could you help me again ? I'm not a pro in mysql syntax, maybe your syntax is for another verision ?

grtZ

[avenger]

ERROR 1064 at line 24: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '/connect zabbix
CREATE TABLE hosts (
hostid serial,
host

I've just tried to reproduce that error on MySQL 3.23.52 & MySQL 4.1.8 (I don't have an 4.0.21 )
The .sql file works fine for me.
Error 1064 means that there are reserved words used not right.
As of code fragment I can see that table host has wrong structure (or I do not understand something).
Please check that in file schema.sql hosts table has following structure:

CREATE TABLE hosts (
        hostid          int(4)          NOT NULL auto_increment,
        host            varchar(64)     DEFAULT '' NOT NULL,
        useip           int(1)          DEFAULT '1' NOT NULL,
        ip              varchar(15)     DEFAULT '127.0.0.1' NOT NULL,
        port            int(4)          DEFAULT '0' NOT NULL,
        status          int(4)          DEFAULT '0' NOT NULL,
-- If status=UNREACHABLE, host will not be checked until this time
        disable_until   int(4)          DEFAULT '0' NOT NULL,
        network_errors  int(4)          DEFAULT '0' NOT NULL,
        error           varchar(128)    DEFAULT '' NOT NULL,
        PRIMARY KEY     (hostid),
        UNIQUE          (host),
        KEY             (status)
) type=InnoDB;

[LEM]

Hi all,
this monitoring soft looks great ! I was absolutely certain of using NAGIOS until I saw this soft. It looks very promising !
If I just could get it installed...
I use debian r.03, kernel 2.6.8, can't seem to find a debian package on the download site.

Greetings,

Debian packages are done for sarge (and tested ok on x86). You should grab the source and rebuild package for woody.

You'll find the package there (will probably move to the zabbix web site soon): http://olivier-lemaire.org/debian/di...e/main/source/

Let me know of any problem on woody.

[bennethos]

thx again for helping me out this fast

Avenger :

Following line was missing in my hosts table :

error varchar(128) DEFAULT '' NOT NULL,

I added it, and did a cat schema.sql | mysql -u xxxx -p

and it worked !!! all tables were created without a problem !

See you later, am going to config it following instructions after the mysql part :-)... If I have a problem you'll hear about me

thx

[Alexei]

ERROR 1064 at line 24: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '/connect zabbix
CREATE TABLE hosts (
hostid serial,
host

I think you are using PostgreSQL's schema.sql. Use MySQL one instead.

[bennethos]

debian source

LEM:

I downloaded your zabbix-1.0.orig.tar.gz package , did a configure with mysql and net-snmp :
./configure --with-mysql --with-net-snmp

and I get following message :

checking for NET-SNMP support... no
configure: error: Invalid NET-SNMP directory - unable to find net-snmp-includes.h

I did an apt get install snmp and snmpd but still the file is missing ... I know it's a C file of some kind...

any idea's ?

One more thing, I'm installing it on my server that has to do the monitorring, so I think it's correct I included mysql support and snmp support.

thx for helping me out once more

[bennethos]

I think you are using PostgreSQL's schema.sql. Use MySQL one instead.

Alexei, this is a copy of the original create/mysql/schema.sql :

--
-- Table structure for table 'hosts'
--

CREATE TABLE hosts (
hostid int(4) NOT NULL auto_increment,
host varchar(64) DEFAULT '' NOT NULL,
useip int(1) DEFAULT '1' NOT NULL,
ip varchar(15) DEFAULT '127.0.0.1' NOT NULL,
port int(4) DEFAULT '0' NOT NULL,
status int(4) DEFAULT '0' NOT NULL,
-- If status=UNREACHABLE, host will not be checked until this time
disable_until int(4) DEFAULT '0' NOT NULL,
network_errors int(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (hostid),
UNIQUE (host),
KEY (status)
) type=InnoDB;

as you can see the error line is missing here, I wasn't using the postgresql's, double checked it by deleting the untarred package and untarring it again...

grtZ

[Alexei]

as you can see the error line is missing here, I wasn't using the postgresql's, double checked it by deleting the untarred package and untarring it again...

You were! The string /connect zabbix exists only in PostgreSQL schema. Nevermind...

[bennethos]

You were! The string /connect zabbix exists only in PostgreSQL schema. Nevermind...

I double checked everything again, and you were right Alexei, for some bizar reason I was in postgresql dir...

thx that solved the mysql problem ;-)

[esisa]

See: http://www.zabbix.com/forum/showthread.php?t=1220

LEM:

I downloaded your zabbix-1.0.orig.tar.gz package , did a configure with mysql and net-snmp :
./configure --with-mysql --with-net-snmp

and I get following message :

checking for NET-SNMP support... no
configure: error: Invalid NET-SNMP directory - unable to find net-snmp-includes.h

I did an apt get install snmp and snmpd but still the file is missing ... I know it's a C file of some kind...

any idea's ?

One more thing, I'm installing it on my server that has to do the monitorring, so I think it's correct I included mysql support and snmp support.

thx for helping me out once more

[RandySpinaGE]

I case this can help I just d/l'd the software Friday june 2nd, 2006

cat schema.sql | mysql -uroot -pmysqladmin zabbix
ERROR 1064 (42000) at line 384: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mediaid int(4) NOT NULL auto_increment,
userid int(4) DEFAULT '0' NOT NULL,
' at line 2


The table create for "media" was MISSING an OPEN PARENTHESIS

[david23]

have a look at this Zabbix installation guide with screenshots in debian linux