Installation of Zabbix in Centos 7

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.

scottalanmiller

@dafyre said:

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.

Turn off SELinux to be sure it is not blocking the creation of new database files.

Lakshmana

the output of the command given below is provided here
ls -ohrd /var/lib/mysql/*

[lakshmana@dny-lnx-zabbix ~]$ sudo ls -ohr /var/lib/mysql/*
srwxrwxrwx 1 mysql 0 Sep 9 01:57 /var/lib/mysql/mysql.sock
-rw-rw---- 1 mysql 5.0M Sep 9 08:28 /var/lib/mysql/ib_logfile1
-rw-rw---- 1 mysql 5.0M Sep 9 08:28 /var/lib/mysql/ib_logfile0
-rw-rw---- 1 mysql 26M Sep 9 08:28 /var/lib/mysql/ibdata1
-rw-rw---- 1 mysql 52 Sep 9 01:56 /var/lib/mysql/aria_log_control
-rw-rw---- 1 mysql 16K Sep 9 01:56 /var/lib/mysql/aria_log.00000001

/var/lib/mysql/zabbixdb:
total 1.4M
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 valuemaps.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 usrgrp.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 users_groups.frm
-rw-rw---- 1 mysql 9.0K Sep 8 09:20 users.frm
-rw-rw---- 1 mysql 17K Sep 8 09:20 user_history.frm
-rw-rw---- 1 mysql 17K Sep 8 09:20 triggers.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 trigger_discovery.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 trigger_depends.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 trends_uint.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 trends.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 timeperiods.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 sysmap_url.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 sysmaps_link_triggers.frm
-rw-rw---- 1 mysql 13K Sep 8 09:20 sysmaps_links.frm
-rw-rw---- 1 mysql 14K Sep 8 09:20 sysmaps.frm
-rw-rw---- 1 mysql 18K Sep 8 09:20 sysmaps_elements.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 sysmap_element_url.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 slideshows.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 slides.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 sessions.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 services_times.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 services_links.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 services.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 service_alarms.frm
-rw-rw---- 1 mysql 13K Sep 8 09:20 scripts.frm
-rw-rw---- 1 mysql 9.1K Sep 8 09:20 screens_items.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 screens.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 rights.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 regexps.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 proxy_history.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 proxy_dhistory.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 proxy_autoreg_host.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 profiles.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 optemplate.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 opmessage_usr.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 opmessage_grp.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 opmessage.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 opgroup.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 operations.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 opconditions.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 opcommand_hst.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 opcommand_grp.frm
-rw-rw---- 1 mysql 8.8K Sep 8 09:20 opcommand.frm
-rw-rw---- 1 mysql 13K Sep 8 09:20 media_type.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 media.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 mappings.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 maintenances_windows.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 maintenances_hosts.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 maintenances_groups.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 maintenances.frm
-rw-rw---- 1 mysql 27K Sep 8 09:20 items.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 items_applications.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 item_discovery.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 item_condition.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 interface.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 interface_discovery.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 images.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 ids.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 icon_mapping.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 icon_map.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 httptestitem.frm
-rw-rw---- 1 mysql 14K Sep 8 09:20 httptest.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 httpstepitem.frm
-rw-rw---- 1 mysql 17K Sep 8 09:20 httpstep.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 housekeeper.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 hosts_templates.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 hosts_groups.frm
-rw-rw---- 1 mysql 14K Sep 8 09:20 hosts.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 hostmacro.frm
-rw-rw---- 1 mysql 28K Sep 8 09:20 host_inventory.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 host_discovery.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 history_uint.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 history_text.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 history_str.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 history_log.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 history.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 groups.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 group_prototype.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 group_discovery.frm
-rw-rw---- 1 mysql 9.1K Sep 8 09:20 graph_theme.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 graphs_items.frm
-rw-rw---- 1 mysql 9.1K Sep 8 09:20 graphs.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 graph_discovery.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 globalvars.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 globalmacro.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 functions.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 expressions.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 events.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 escalations.frm
-rw-rw---- 1 mysql 8.8K Sep 8 09:20 dservices.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 drules.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 dhosts.frm
-rw-rw---- 1 mysql 13K Sep 8 09:20 dchecks.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 dbversion.frm
-rw-rw---- 1 mysql 61 Sep 7 14:21 db.opt
-rw-rw---- 1 mysql 16K Sep 8 09:20 config.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 conditions.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 autoreg_host.frm
-rw-rw---- 1 mysql 8.7K Sep 8 09:20 auditlog.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 auditlog_details.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 application_template.frm
-rw-rw---- 1 mysql 8.5K Sep 8 09:20 applications.frm
-rw-rw---- 1 mysql 13K Sep 8 09:20 alerts.frm
-rw-rw---- 1 mysql 13K Sep 8 09:20 actions.frm
-rw-rw---- 1 mysql 8.6K Sep 8 09:20 acknowledges.frm

/var/lib/mysql/performance_schema:
total 208K
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 threads.frm
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 setup_timers.frm
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 setup_instruments.frm
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 setup_consumers.frm
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 rwlock_instances.frm
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 performance_timers.frm
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 mutex_instances.frm
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 file_summary_by_instance.frm
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 file_summary_by_event_name.frm
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 file_instances.frm
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 events_waits_summary_global_by_event_name.frm
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 events_waits_summary_by_thread_by_event_name.frm
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 events_waits_summary_by_instance.frm
-rw-rw---- 1 mysql 9.1K Sep 7 13:23 events_waits_history_long.frm
-rw-rw---- 1 mysql 9.1K Sep 7 13:23 events_waits_history.frm
-rw-rw---- 1 mysql 9.1K Sep 7 13:23 events_waits_current.frm
-rw-rw---- 1 mysql 61 Sep 7 13:23 db.opt
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 cond_instances.frm

/var/lib/mysql/mysql:
total 1000K
-rw-rw---- 1 mysql 2.0K Sep 9 01:56 user.MYI
-rw-rw---- 1 mysql 532 Sep 8 06:18 user.MYD
-rw-rw---- 1 mysql 11K Sep 7 13:23 user.frm
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 time_zone_transition_type.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 time_zone_transition_type.MYD
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 time_zone_transition_type.frm
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 time_zone_transition.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 time_zone_transition.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 time_zone_transition.frm
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 time_zone_name.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 time_zone_name.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 time_zone_name.frm
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 time_zone.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 time_zone.MYD
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 time_zone_leap_second.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 time_zone_leap_second.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 time_zone_leap_second.frm
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 time_zone.frm
-rw-rw---- 1 mysql 4.0K Sep 7 13:23 tables_priv.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 tables_priv.MYD
-rw-rw---- 1 mysql 8.8K Sep 7 13:23 tables_priv.frm
-rw-rw---- 1 mysql 8.8K Sep 7 13:23 slow_log.frm
-rw-rw---- 1 mysql 0 Sep 7 13:23 slow_log.CSV
-rw-rw---- 1 mysql 35 Sep 9 01:56 slow_log.CSM
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 servers.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 servers.MYD
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 servers.frm
-rw-rw---- 1 mysql 5.0K Sep 7 13:23 proxies_priv.MYI
-rw-rw---- 1 mysql 1.4K Sep 7 13:23 proxies_priv.MYD
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 proxies_priv.frm
-rw-rw---- 1 mysql 4.0K Sep 7 13:23 procs_priv.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 procs_priv.MYD
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 procs_priv.frm
-rw-rw---- 1 mysql 4.0K Sep 7 13:23 proc.MYI
-rw-rw---- 1 mysql 292 Sep 7 13:23 proc.MYD
-rw-rw---- 1 mysql 9.8K Sep 7 13:23 proc.frm
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 plugin.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 plugin.MYD
-rw-rw---- 1 mysql 8.4K Sep 7 13:23 plugin.frm
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 ndb_binlog_index.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 ndb_binlog_index.MYD
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 ndb_binlog_index.frm
-rw-rw---- 1 mysql 2.0K Sep 7 13:23 host.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 host.MYD
-rw-rw---- 1 mysql 9.3K Sep 7 13:23 host.frm
-rw-rw---- 1 mysql 20K Sep 7 13:23 help_topic.MYI
-rw-rw---- 1 mysql 440K Sep 7 13:23 help_topic.MYD
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 help_topic.frm
-rw-rw---- 1 mysql 19K Sep 7 13:23 help_relation.MYI
-rw-rw---- 1 mysql 9.1K Sep 7 13:23 help_relation.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 help_relation.frm
-rw-rw---- 1 mysql 16K Sep 7 13:23 help_keyword.MYI
-rw-rw---- 1 mysql 90K Sep 7 13:23 help_keyword.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 help_keyword.frm
-rw-rw---- 1 mysql 3.0K Sep 7 13:23 help_category.MYI
-rw-rw---- 1 mysql 1.1K Sep 7 13:23 help_category.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 help_category.frm
-rw-rw---- 1 mysql 8.6K Sep 7 13:23 general_log.frm
-rw-rw---- 1 mysql 0 Sep 7 13:23 general_log.CSV
-rw-rw---- 1 mysql 35 Sep 9 01:56 general_log.CSM
-rw-rw---- 1 mysql 1.0K Sep 7 13:23 func.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 func.MYD
-rw-rw---- 1 mysql 8.5K Sep 7 13:23 func.frm
-rw-rw---- 1 mysql 2.0K Sep 7 13:23 event.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 event.MYD
-rw-rw---- 1 mysql 10K Sep 7 13:23 event.frm
-rw-rw---- 1 mysql 5.0K Sep 9 01:56 db.MYI
-rw-rw---- 1 mysql 880 Sep 7 14:21 db.MYD
-rw-rw---- 1 mysql 9.4K Sep 7 13:23 db.frm
-rw-rw---- 1 mysql 4.0K Sep 7 13:23 columns_priv.MYI
-rw-rw---- 1 mysql 0 Sep 7 13:23 columns_priv.MYD
-rw-rw---- 1 mysql 8.7K Sep 7 13:23 columns_priv.frm
[lakshmana@dny-lnx-zabbix ~]$

scottalanmiller

Looks healthy from a permissions standpoint.

Lakshmana

[lakshmana@dny-lnx-zabbix ~]$ sestatus -v
SELinux status: disabled
[lakshmana@dny-lnx-zabbix ~]$

scottalanmiller

Okay, so SELinux is off.

dafyre

Curious... It looks like all the tables are there now.

What happens if you:

mysql -u root -p
use zabbixdb;
describe users;

?

Lakshmana

The output is provided below

[lakshmana@dny-lnx-zabbix ~]$ sudo mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 423
Server version: 5.5.44-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use zabbixdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [zabbixdb]> describe users;
+----------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| userid | bigint(20) unsigned | NO | PRI | NULL | |
| alias | varchar(100) | NO | UNI | | |
| name | varchar(100) | NO | | | |
| surname | varchar(100) | NO | | | |
| passwd | char(32) | NO | | | |
| url | varchar(255) | NO | | | |
| autologin | int(11) | NO | | 0 | |
| autologout | int(11) | NO | | 900 | |
| lang | varchar(5) | NO | | en_GB | |
| refresh | int(11) | NO | | 30 | |
| type | int(11) | NO | | 1 | |
| theme | varchar(128) | NO | | default | |
| attempt_failed | int(11) | NO | | 0 | |
| attempt_ip | varchar(39) | NO | | | |
| attempt_clock | int(11) | NO | | 0 | |
| rows_per_page | int(11) | NO | | 50 | |
+----------------+---------------------+------+-----+---------+-------+
16 rows in set (0.00 sec)

dafyre

Okay... now...

select userid,name from users;

Lakshmana

dafyre

It looks like the data has loaded right... let's check one more...

select imageid,imagetype,name from images limit 10;