Installation of Zabbix in Centos 7

Lakshmana

I can access both root and user from the terminal.
MariaDB is able to login from the terminal

scottalanmiller

I can access both root and user from the terminal.
MariaDB is able to login from the terminal

Sure, access isn't an issue. The only issue I see is that you are trying to use a file that does not exist. Check the path, your path has a typo.

Lakshmana

I can see the files here in the path also
There are three files which can be accessed from the nano or vi editor

[lakshmana@dny-lnx-zabbix create]$ cd /usr/share/doc/zabbix-server-mysql-2.4.6/create/
[lakshmana@dny-lnx-zabbix create]$ ls
data.sql images.sql schema.sql
[lakshmana@dny-lnx-zabbix create]$

scottalanmiller

@Lakshmana said:

I can see the files here in the path also
There are three files which can be accessed from the nano or vi editor

[lakshmana@dny-lnx-zabbix create]$ cd /usr/share/doc/zabbix-server-mysql-2.4.6/create/
[lakshmana@dny-lnx-zabbix create]$ ls
data.sql images.sql schema.sql
[lakshmana@dny-lnx-zabbix create]$

That's a different path than the one you used in the command! Use tab completion in your commands to help you get the paths correct.

Lakshmana

Yes,I have used the tab command only to search the path present.
I have also found the file which is inside the path specified.
Whether I need to copy the file in any /tmp path??

scottalanmiller

@Lakshmana said:

Whether I need to copy the file in any /tmp path??

Just use the correct path. This isn't complex. The path you used had a typo, fix the typo and all should be fine.

Lakshmana

@scottalanmiller said:

, fix the typo and a

What is typo means?

scottalanmiller

@Lakshmana said:

@scottalanmiller said:

, fix the typo and a

What is typo means?

You have the wrong path when you run the command. When you look for the file, you have the right path. Compare the two and see what is different between them. You are not using tab completion for the command because the file you are trying to run does not exist.

scottalanmiller

Don't try to do anything else. The issue is that your file path is wrong by one character. Do nothing else until you figure out where that is wrong. You have all the information that you need just in this thread to know what the problem is. Trust the error, trust me when I tell you the error is correct. Fix the error. Don't go down a rabbit hole. This is the simplest problem that I can think of to have (getting a file name wrong). Don't look for complex answers to the simplest possible problems.

Lakshmana

@scottalanmiller said:

This

ok.I will find the issue in the path as well as the issue

Lakshmana

I have got help from Dafre for the issue in the template.I have used the command said by him and tried to do but there also came some error

mysql -u root -p
(enter the root password)
then...
use zabbixdb;
source schema.sql;

The error I got after typing source schema.sql is given below
OR 1005 (HY000) at line 1420 in file: 'schema.sql': Can't create table 'zabbixdb.#sql-6d18_57' (errno: 121)
ERROR 1005 (HY000) at line 1421 in file: 'schema.sql': Can't create table 'zabbixdb.#sql-6d18_57' (errno: 121)
ERROR 1005 (HY000) at line 1422 in file: 'schema.sql': Can't create table 'zabbixdb.#sql-6d18_57' (errno: 121)
ERROR 1005 (HY000) at line 1423 in file: 'schema.sql': Can't create table 'zabbixdb.#sql-6d18_57' (errno: 121)
ERROR 1005 (HY000) at line 1424 in file: 'schema.sql': Can't create table 'zabbixdb.#sql-6d18_57' (errno: 121)
ERROR 1005 (HY000) at line 1425 in file: 'schema.sql': Can't create table 'zabbixdb.#sql-6d18_57' (errno: 121)

Why this error comes here ? Any idea

Lakshmana

I have configured other things either that the importing process where there is no issue came and the zabbix installation page comes in the browser.

I have not configured the firewall for allowing the connection

Lakshmana

When I done the service restart i got these output,whether any issues arises by these kind of outputs mentioned below

[lakshmana@dny-lnx-zabbix create]$ sudo nano /etc/httpd/conf.d/zabbix.conf
[lakshmana@dny-lnx-zabbix create]$ sudo systemctl start zabbix-server
[lakshmana@dny-lnx-zabbix create]$ sudo systemctl start zabbix-agent
[lakshmana@dny-lnx-zabbix create]$ sudo systemctl restart httpd
[lakshmana@dny-lnx-zabbix create]$ sudo systemctl restart mariadb
[lakshmana@dny-lnx-zabbix create]$ sudo systemctl enable zabbix-server
ln -s '/usr/lib/systemd/system/zabbix-server.service' '/etc/systemd/system/multi-user.target.wants/zabbix-server.service'
[lakshmana@dny-lnx-zabbix create]$ sudo systemctl enable zabbix-agent
ln -s '/usr/lib/systemd/system/zabbix-agent.service' '/etc/systemd/system/multi-user.target.wants/zabbix-agent.service'

dafyre

It looks like he's using the right path now...

The error it is showing is that it can't create the tables... That seems like a MySQL error or something else. I'm not sure what to check next.

Lakshmana

The Zabbix Installation page came in the browser after configuring the other things also

dafyre

Can you check the Permissions of /var/lib/mysql ?

Make sure it is owned by mysql?

ls -ohrd /var/lib/mysql

Lakshmana

The output for the above command is
drwxr-xr-x 5 mysql 4.0K Sep 9 01:57 /var/lib/mysql/

Lakshmana

Then I have used this command as per teh Dafyre suggestion
ls -ohrd /var/lib/mysql/*

thereare many files are present in it

dafyre

Are they all owned by mysql or root or what?

scottalanmiller

@Lakshmana said:

Then I have used this command as per teh Dafyre suggestion
ls -ohrd /var/lib/mysql/*

thereare many files are present in it

Always provide the output, not just your summary of what you feel you see.