mysql: command not found error

[anoop]

I am new to Zabbix and want to test this tool for my organization. I have followed the instruction manual and installed the rpm package.

following components have been installed,

[a400726@vc2c09mmk2651 ~]$ rpm -qa | grep zabbix
zabbix-2.0.6-1.el6.x86_64
zabbix-server-mysql-2.0.6-1.el6.x86_64
zabbix-agent-2.0.6-1.el6.x86_64
zabbix-server-2.0.6-1.el6.x86_64
zabbix-web-mysql-2.0.6-1.el6.noarch
zabbix-release-2.0-1.el6.noarch
zabbix-web-2.0.6-1.el6.noarch

The next step as per documentation is,

Creating initial database
Create zabbix database and user on MySQL.

# mysql -uroot

while i enter the above command i get
-bash: mysql: command not found error message.

I am trying to install this on Red Hat Enterprise Linux, 2.6 64 bit version.

Any help would be really appreciated, i am stuck at this point and not able to proceed further..

Anoop

[Alexei]

You need to install MySQL server and client software.

[anoop]

Thanks for responding Alexei,

Let me know if this is the correct procedure or any additional steps are needed,

What i tried was, downloaded rpm package using wget

Step1:- wget http://repo.zabbix.com/zabbix/2.0/rh...el6.noarch.rpm

Step2:- rpm -ivh <installable>

Step3:- yum install zabbix-server-mysql zabbix-web-mysql

I was under the impression that mysql is installed as part of step3, looks like thats not the case. Do you have any specific set of instructions for mysql installation for zabbix?

[LenR]

Compare to this list, you're probably missing mysql-xxxxx something. The versions may be different, this is from RHEL 5,

# rpm -qa | grep -i mysql
mysql-server-5.0.95-5.el5_9
zabbix-web-mysql-1.8.15-1.el5
mysql-5.0.95-5.el5_9
zabbix-server-mysql-1.8.15-1.el5
mysql-devel-5.0.95-5.el5_9
php-mysql-5.1.6-40.el5_9
perl-DBD-MySQL-3.0007-2.el5
mysql-5.0.95-5.el5_9
mysql-devel-5.0.95-5.el5_9

[dirckcopeland]

mysql: command not found error

anoop,
I ran onto the same problem - thinking that mysql was included in the zabbix package but that is not the case. It would be helpful for the installation notes at:

https://www.zabbix.com/documentation/2.2/manual/installation/install_from_packages

to make mention of that.

Never the less, I issued the following command to install the mysql database and client apps.
yum install mysql-server.x86_64 mysql.x86_64

then make sure you start the service:
service mysqld start

before proceeding with the rest of the instructions at the above link.

[LenR]

RPM packaging should ensure that something is providing mysql, but just the client part. Zabbix can't know whether your mysql server will be local or not.