Server zabbix down

[c1malabar]

Hello,

I am testing Zabbix 1.6 on a virtual machine (with VMWare) and I have a

colleague who made a script to start the zabbix server (sudo -u zabbix /usr/loca

/sbin/zabbix_server) but when I see the status of this server I have " server

zabbix down ".

How can I solve this problem ?

Thanks in advance

[zabbix_zen]

Well,
you should start looking at zabbix_server.log for what it's complaining about.

[c1malabar]

In /tmp/zabbix_server.log I have:

/usr/local/sbin/zabbix_server [14831]: Warning: ZABBIX semaphores already exist, trying to recreate.
14831:20100302:143512 Starting zabbix_server. ZABBIX 1.6.
14831:20100302:143512 **** Enabled features ****
14831:20100302:143512 SNMP monitoring: YES
14831:20100302:143512 WEB monitoring: YES
14831:20100302:143512 Jabber notifications: YES
14831:20100302:143512 ODBC: NO
14831:20100302:143512 IPv6 support: NO
14831:20100302:143512 **************************
14831:20100302:143512 Failed to connect to database: Error: Access denied for user ''@'localhost' to database 'zabbix' [1044]
/usr/local/sbin/zabbix_server [14835]: Warning: ZABBIX semaphores already exist, trying to recreate.
14835:20100302:143520 Starting zabbix_server. ZABBIX 1.6.
14835:20100302:143520 **** Enabled features ****
14835:20100302:143520 SNMP monitoring: YES
14835:20100302:143520 WEB monitoring: YES
14835:20100302:143520 Jabber notifications: YES
14835:20100302:143520 ODBC: NO
14835:20100302:143520 IPv6 support: NO
14835:20100302:143520 **************************
14835:20100302:143520 Failed to connect to database: Error: Access denied for user ''@'localhost' to database 'zabbix' [1044]
/usr/local/sbin/zabbix_server [14839]: Warning: ZABBIX semaphores already exist, trying to recreate.
14839:20100302:143522 Starting zabbix_server. ZABBIX 1.6.
14839:20100302:143522 **** Enabled features ****
14839:20100302:143522 SNMP monitoring: YES
14839:20100302:143522 WEB monitoring: YES
14839:20100302:143522 Jabber notifications: YES
14839:20100302:143522 ODBC: NO
14839:20100302:143522 IPv6 support: NO
14839:20100302:143522 **************************
14839:20100302:143522 Failed to connect to database: Error: Access denied for user ''@'localhost' to database 'zabbix' [1044]

And it's continue like that.

[zabbix_zen]

Alter the following parameters in zabbix_server.conf,

DBName=
DBUser=
DBPassword=

so they mirror the correspondent credentials of your Zabbix DB.

[c1malabar]

I have change them but when I check the zabbix server status with the script of my colleague I have still server zabbix down... (I just have not change DBName because I believe it's the good name)

[MrKen]

Deja Vu or what?

Zabbix_zen already gave you the answer last month

http://www.zabbix.com/forum/showpost.php?p=60037&postcount=18

But here is the part you need (copied from muck.net):

Start MySQL, and change the root password.

/etc/init.d/mysqld start

/usr/bin/mysqladmin -u root password YourFancyNewRootPassword

Connect to the DB using your newly created root password. Create the zabbix DB, and assign a new user (zabbixmysqluser) with privileges to that DB. You may want to change “zabbixmysqlpassword” to something else. But it should not be the same as any other “critical” password because it will be stored plain text in a config file.

mysql -u root -p
mysql> CREATE DATABASE zabbix;
mysql> GRANT DROP,INDEX,CREATE,SELECT,INSERT,UPDATE,ALTER,DELET E ON zabbix.* TO zabbixmysqluser@localhost IDENTIFIED BY ‘zabbixmysqlpassword’;
mysql> quit;

______________________
Edit: You might need this too

Create the DB Schema

cd zabbix-1.4.1
cat create/schema/mysql.sql | mysql -u zabbixmysqluser -pzabbixmysqlpassword zabbix

cat create/data/data.sql | mysql -u zabbixmysqluser -pzabbixmysqlpassword zabbix

cat create/data/images_mysql.sql | mysql -u zabbixmysqluser -pzabbixmysqlpassword zabbix

___________________________

Your problem is not your friend's script, the problem is zabbix cannot connect to the database.

MrKen

[zabbix_zen]

Thanks MrKen.

Just opened a thread about having cookbooks like this as a sticky in this subForum