Zabbix Ubuntu MySQL

[markclark]

hi there,

sorry a bit of a new character to Ubuntu. Trying to setup Zabbix as per documention but when i get as far as a few steps i get stuck. This is probably something quite simple for others that I am hoping that they can assist with please.

Ubuntu 10.10 Server
MySQL 5.1.49

Im installing version 1.8.5 as per the link below
http://www.zabbix.com/wiki/howto/ins.../ubuntuinstall

Everything is fine so far until i get to the commands

3 - Create a zabbix database and populate it:

sudo mysql -e"create database zabbix;"
sudo mysql -e"grant all privileges on zabbix.* to zabbix@localhost identified by 'enter-password-here';"

When i try to do so i get the following error. Ive tried it as sudo su and su - zabbix but no joy.

root@ubuntu:/home/zabbix# sudo mysql -e"create database zabbix;"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

thanks

[JBo]

Hi,

root@ubuntu:/home/zabbix# sudo mysql -e"create database zabbix;"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

It means the Mysql root account has a password.
You should use:
sudo mysql -p -e"create database zabbix;"
You will be prompted for myql root password (this is the password you have defined during mysql installation).

Regards,
JBo

[markclark]

Thanks that worked like a charm!

Further down ive tried to complete the following steps -

5 - Prepare the rest of the system:

sudo nano /etc/services

Add at the end:

zabbix_agent 10050/tcp # Zabbix ports
zabbix_trap 10051/tcp

Save and exit.

When i run the above it opens a blank window to enter the above, so take it this should be the only 2 lines of data in there? Then when save it, it says 'Save Modified buffer' which i choose YES. Then it comes back 'File Name to Write:' but not sure what here as gives me a list of options.

Few steps down when i try run the command below.

cp misc/conf/zabbix_* /etc/zabbix/

i get a response of

cp: cannot stat `misc/conf/zabbix_*': No such file or directory

do i need to create some directories? The commands above that worked fine which were...

sudo mkdir /etc/zabbix
sudo chown -R zabbix.zabbix /etc/zabbix/