ZABBIX is temporary unavailable!

[c1malabar]

Hello,

I am testing Zabbix on a virtual machine and when I try to access the web interface of zabbix (on IE or firefox) it marks the following message: ZABBIX is temporary unavailable!

So I would like to know how can I solve this problem.

I specify that Zabbix was already installed in this virtual machine when I began to use it because an other personn have already test Zabbix in this virtual machine. I think that it could be Zabbix which is not correctly installed.

The Operating System of the virtual machine is RedHat and I access to this virtual machine because of the software Putty.

Thanks

[richlv]

most likely database access information is incorrect (or database is having problems). check conf/zabbix.conf.php file in the frontend directory.

[c1malabar]

In the file /var/www/html/zabbix/conf/zabbix.conf.php, I have:

global $DB;

$DB["TYPE"] = "MYSQL";

$IMAGE_FORMAT_DEFAULT = ;IMAGE_FORMAT_PNG
?>
$DB["DATABASE"] = "zabbix";
$DB["USER"] = "root";
$DB["PASSWORD"] = "";
$ZBX_SERVER_PORT = "10051";


$IMAGE_FORMAT_DEFAULT = ;IMAGE_FORMAT_PNG
QL";
$DB["SERVER"] = "localhost";
$DB["PORT"] = "0";
$DB["DATABASE"] = "zabbix";

[richlv]

that looks like a seriously broken file, if you copied the contents correctly

[c1malabar]

Excuse me I badly copied the contents:

<?php
/*
** ZABBIX
** Copyright (C) 2000-2005 SIA Zabbix
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
**/

global $DB;

$DB["TYPE"] = "MYSQL";
$DB["SERVER"] = "localhost";
$DB["PORT"] = "0";
$DB["DATABASE"] = "zabbix";
$DB["USER"] = "root";
$DB["PASSWORD"] = "";
$ZBX_SERVER = "localhost";
$ZBX_SERVER_PORT = "10051";


$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
?>

[richlv]

is your database named 'zabbix' ?
is your database really accessible for root user without any password ?

verify access to it matches with credentials and details in config file.

[MrKen]

Is there also a message at the top which says: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[/usr/local/share/zabbix/include/db.inc.php:56] or similar?

Try starting mysql

MrKen

[c1malabar]

I can start MySQL (I did " service mysql start " and it's OK) and I don't really understand richlv what do you want to say with " verify access to it matches with credentials and details in config file ".

[richlv]

you have configured frontend to access a specific database using some user and password. you should verify that it is indeed possible to do so.

[MrKen]

$DB["TYPE"] = "MYSQL";
$DB["SERVER"] = "localhost";
$DB["PORT"] = "0";
$DB["DATABASE"] = "zabbix";
$DB["USER"] = "root";
$DB["PASSWORD"] = "";
$ZBX_SERVER = "localhost";
$ZBX_SERVER_PORT = "10051";

What richlv is saying is that according to the above you have a database called "zabbix", with a user called "root", and no password.

Run this command: mysql -u root

If you successfully connect with mysql, then do: show databases;
and confirm that there is a database called "zabbix".

Next check your zabbix_server.conf, near the end of that file you will see details about DBHost, DBName, DBUser, DBPassword, check that these details are the same as what you have in /var/www/html/zabbix/conf/zabbix.conf.php

Note: probably not a good idea to have a db user called 'root' with no password!

Also check zabbix_server.log, if zabbix fails to connect to the db it will show in the log.

HTH
MrKen

[c1malabar]

When I write " mysql -u root " I have " -bash: mysql: command not found " ...

[MrKen]

When I write " mysql -u root " I have " -bash: mysql: command not found " ...

You will need to be logged in as root.

Have a look in /usr/bin/ for mysql, then try (in that directory)

mysql -u root

or

./mysql -u root

Check that mysql is running. > ps -ef | grep mysql

MrKen

[c1malabar]

But I'm logged in root, that's all the problem...
In /usr/bin I have these files mysql:
/usr/bin/mysql_setpermission
/usr/bin/mysql_convert_table_format
/usr/bin/mysql_fix_privilege_tables
/usr/bin/mysql_secure_installation
/usr/bin/mysqld_multi
/usr/bin/mysqlbug
/usr/bin/mysql_zap
/usr/bin/mysqldumpslow
/usr/bin/mysql_fix_extensions
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysqlhotcopy
/usr/bin/mysqld_safe
/usr/bin/mysqltest
/usr/bin/mysql_install_db
/usr/bin/mysql_upgrade

But not mysql like you can see...

[MrKen]

The 'ZABBIX is temporary unavailable!' message usually means that mysql and/or zabbix_server is not running.

I specify that Zabbix was already installed in this virtual machine when I began to use it because an other personn have already test Zabbix in this virtual machine. I think that it could be Zabbix which is not correctly installed.

Considering the output of your /usr/bin directory, and the fact that another person had installed zabbix, there is a good chance that it is not correctly installed - as suggested by yourself.

I can start MySQL (I did " service mysql start " and it's OK)

What is the output of ps -ef?
Any clues in the zabbix_server.log?
Any idea which version of Zabbix?

Perhaps it would be easier for you to start from scratch. Here is a link to a great script which will install Zabbix on CentOS: http://blog.brendon.com/unix/install...-the-easy-way/

MrKen

[c1malabar]

The version of Zabbix is the 1.6.

Here is the output of ps -ef:

UID PID PPID C STIME TTY TIME CMD
root 1 0 0 Feb10 ? 00:00:05 init [3]
root 2 1 0 Feb10 ? 00:00:00 [migration/0]
root 3 1 0 Feb10 ? 00:00:00 [ksoftirqd/0]
root 4 1 0 Feb10 ? 00:00:00 [watchdog/0]
root 5 1 0 Feb10 ? 00:00:00 [events/0]
root 6 1 0 Feb10 ? 00:00:00 [khelper]
root 7 1 0 Feb10 ? 00:00:00 [kthread]
root 10 7 0 Feb10 ? 00:00:01 [kblockd/0]
root 11 7 0 Feb10 ? 00:00:00 [kacpid]
root 67 7 0 Feb10 ? 00:00:00 [cqueue/0]
root 70 7 0 Feb10 ? 00:00:00 [khubd]
root 72 7 0 Feb10 ? 00:00:00 [kseriod]
root 131 7 0 Feb10 ? 00:00:00 [pdflush]
root 132 7 0 Feb10 ? 00:00:23 [pdflush]
root 133 7 0 Feb10 ? 00:00:00 [kswapd0]
root 134 7 0 Feb10 ? 00:00:00 [aio/0]
root 285 7 0 Feb10 ? 00:00:00 [kpsmoused]
root 315 7 0 Feb10 ? 00:00:00 [scsi_eh_0]
root 320 7 0 Feb10 ? 00:00:00 [kmirrord]
root 325 7 0 Feb10 ? 00:00:00 [ksnapd]
root 328 7 0 Feb10 ? 00:00:22 [kjournald]
root 359 7 0 Feb10 ? 00:00:00 [kauditd]
root 391 1 0 Feb10 ? 00:00:00 /sbin/udevd -d
root 1016 7 0 Feb10 ? 00:00:00 [kjournald]
root 1018 7 0 Feb10 ? 00:00:23 [kjournald]
root 1020 7 0 Feb10 ? 00:00:11 [kjournald]
root 1022 7 0 Feb10 ? 00:00:07 [kjournald]
root 1028 1 0 Feb10 ? 00:00:00 [vmhgfs]
root 1571 1 0 Feb10 ? 00:00:00 /usr/sbin/restorecond
root 1586 1 0 Feb10 ? 00:00:00 auditd
root 1588 1586 0 Feb10 ? 00:00:00 python /sbin/audispd
root 1605 1 0 Feb10 ? 00:00:00 syslogd -m 0
root 1608 1 0 Feb10 ? 00:00:00 klogd -x
root 1641 1 0 Feb10 ? 00:00:00 mcstransd
rpc 1660 1 0 Feb10 ? 00:00:00 portmap
root 1677 1 0 Feb10 ? 00:00:16 /usr/bin/python -E /usr/sbin/set
root 1701 1 0 Feb10 ? 00:00:00 rpc.statd
root 1740 1 0 Feb10 ? 00:00:00 rpc.idmapd
root 1805 1 0 Feb10 ? 00:00:00 [vmmemctl]
root 1840 1 0 Feb10 ? 00:16:22 /usr/sbin/vmware-guestd --backgr
dbus 1862 1 0 Feb10 ? 00:00:00 dbus-daemon --system
root 1909 1 0 Feb10 ? 00:00:01 pcscd
root 1928 1 0 Feb10 ? 00:00:13 automount
root 1950 1 0 Feb10 ? 00:00:00 /opt/microsoft/scx/bin/scxcimser
root 1962 1 0 Feb10 ? 00:02:16 ./guestAgent --start
root 1976 1 0 Feb10 ? 00:00:02 /opt/microsoft/scx/bin/scxopenws
root 1992 1 0 Feb10 ? 00:00:00 cupsd
root 2010 1 0 Feb10 ? 00:00:00 /usr/sbin/sshd
root 2075 1 0 Feb10 ? 00:00:00 xinetd -stayalive -pidfile /var/
ntp 2097 1 0 Feb10 ? 00:00:00 ntpd -u ntp:ntp -p /var/run/ntpd
root 2110 1 0 Feb10 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --d
root 2175 1 0 Feb10 ? 00:00:00 sendmail: accepting connections
smmsp 2203 1 0 Feb10 ? 00:00:00 sendmail: Queue runner@01:00:00
root 2218 1 0 Feb10 ? 00:00:00 gpm -m /dev/input/mice -t exps2
mysql 2233 2110 0 Feb10 ? 00:00:15 /usr/sbin/mysqld --basedir=/ --d
root 2259 1 0 Feb10 ? 00:00:01 /usr/sbin/httpd
root 2274 1 0 Feb10 ? 00:00:00 crond
xfs 2319 1 0 Feb10 ? 00:00:00 xfs -droppriv -daemon
root 2346 1 0 Feb10 ? 00:00:00 /usr/sbin/atd
root 2379 1 0 Feb10 ? 00:00:45 /usr/bin/python /usr/sbin/yum-up
avahi 2396 1 0 Feb10 ? 00:00:00 avahi-daemon: running [supervisi
avahi 2397 2396 0 Feb10 ? 00:00:00 avahi-daemon: chroot helper
68 2411 1 0 Feb10 ? 00:00:16 hald
root 2412 2411 0 Feb10 ? 00:00:00 hald-runner
68 2418 2412 0 Feb10 ? 00:00:00 hald-addon-acpi: listening on ac
68 2423 2412 0 Feb10 ? 00:00:00 hald-addon-keyboard: listening o
root 2435 2412 0 Feb10 ? 00:05:20 hald-addon-storage: polling /dev
root 2458 1 0 Feb10 tty1 00:00:00 /sbin/mingetty tty1
root 2459 1 0 Feb10 tty2 00:00:00 /sbin/mingetty tty2
root 2462 1 0 Feb10 tty3 00:00:00 /sbin/mingetty tty3
root 2465 1 0 Feb10 tty4 00:00:00 /sbin/mingetty tty4
root 2466 1 0 Feb10 tty5 00:00:00 /sbin/mingetty tty5
root 2467 1 0 Feb10 tty6 00:00:00 /sbin/mingetty tty6
root 3298 1 0 Feb15 ? 00:00:00 /usr/sbin/avahi-dnsconfd -D
root 3403 1 0 Feb15 ? 00:00:14 /usr/bin/python /usr/sbin/yum-up
4294967295 4365 1 0 Feb15 ? 00:00:05 nrpe -c /etc/nagios/nrpe.cfg -d
adm 9898 1 0 Feb10 ? 00:00:00 /scripts/zabbix_agentd
adm 9901 9898 0 Feb10 ? 00:00:19 /scripts/zabbix_agentd
adm 9902 9898 0 Feb10 ? 00:00:00 /scripts/zabbix_agentd
adm 9903 9898 0 Feb10 ? 00:00:00 /scripts/zabbix_agentd
adm 9904 9898 0 Feb10 ? 00:00:00 /scripts/zabbix_agentd
adm 9905 9898 0 Feb10 ? 00:00:00 /scripts/zabbix_agentd
root 10663 1 0 Feb10 ? 00:00:39 /usr/sbin/snmpd -Lsd -Lf /dev/nu
apache 24773 2259 0 Feb14 ? 00:00:13 /usr/sbin/httpd
apache 24774 2259 0 Feb14 ? 00:00:13 /usr/sbin/httpd
apache 24775 2259 0 Feb14 ? 00:00:15 /usr/sbin/httpd
apache 24776 2259 0 Feb14 ? 00:00:13 /usr/sbin/httpd
apache 24777 2259 0 Feb14 ? 00:00:14 /usr/sbin/httpd
apache 24782 2259 0 Feb14 ? 00:00:11 /usr/sbin/httpd
apache 24783 2259 0 Feb14 ? 00:00:12 /usr/sbin/httpd
apache 24784 2259 0 Feb14 ? 00:00:11 /usr/sbin/httpd
root 29807 1 0 Feb12 ? 00:00:00 /usr/sbin/snmptrapd -Lsd -p /var
root 32477 2010 0 13:51 ? 00:00:00 sshd: root@pts/0
root 32483 32477 0 13:51 pts/0 00:00:00 -bash
root 32741 32483 0 13:54 pts/0 00:00:00 ps -ef