View Full Version : Installing zabbix ondebian r.03
bennethos
01-01-2005, 18:43
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 !
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
02-01-2005, 17:08
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
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;
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/dists/sarge/main/source/
Let me know of any problem on woody.
bennethos
04-01-2005, 17:13
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
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
04-01-2005, 17:37
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 :p
bennethos
04-01-2005, 17:42
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
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! :rolleyes: The string /connect zabbix exists only in PostgreSQL schema. Nevermind...
bennethos
04-01-2005, 18:17
You were! :rolleyes: 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 ;-)
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 :p
RandySpinaGE
05-06-2006, 23:19
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
have a look at this Zabbix installation guide with screenshots in debian linux (http://www.debianhelp.co.uk/zabbix.htm)