ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Installation of Zabbix in Centos 7

    Scheduled Pinned Locked Moved IT Discussion
    linuxzabbixcentos 7centos
    126 Posts 6 Posters 58.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • LakshmanaL
      Lakshmana
      last edited by

      @scottalanmiller said:

      This

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

      1 Reply Last reply Reply Quote 0
      • LakshmanaL
        Lakshmana
        last edited by

        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

        1 Reply Last reply Reply Quote 0
        • LakshmanaL
          Lakshmana
          last edited by

          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

          1 Reply Last reply Reply Quote 0
          • LakshmanaL
            Lakshmana
            last edited by

            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'

            1 Reply Last reply Reply Quote 0
            • dafyreD
              dafyre
              last edited by

              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.

              scottalanmillerS 1 Reply Last reply Reply Quote 0
              • LakshmanaL
                Lakshmana
                last edited by

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

                1 Reply Last reply Reply Quote 0
                • dafyreD
                  dafyre
                  last edited by dafyre

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

                  Make sure it is owned by mysql?

                  ls -ohrd /var/lib/mysql

                  1 Reply Last reply Reply Quote 0
                  • LakshmanaL
                    Lakshmana
                    last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • LakshmanaL
                      Lakshmana
                      last edited by

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

                      thereare many files are present in it

                      scottalanmillerS 1 Reply Last reply Reply Quote 0
                      • dafyreD
                        dafyre
                        last edited by

                        Are they all owned by mysql or root or what?

                        1 Reply Last reply Reply Quote 0
                        • scottalanmillerS
                          scottalanmiller @Lakshmana
                          last edited by

                          @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.

                          1 Reply Last reply Reply Quote 0
                          • scottalanmillerS
                            scottalanmiller @dafyre
                            last edited by

                            @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.

                            1 Reply Last reply Reply Quote 1
                            • LakshmanaL
                              Lakshmana
                              last edited by

                              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 ~]$

                              1 Reply Last reply Reply Quote 0
                              • scottalanmillerS
                                scottalanmiller
                                last edited by

                                Looks healthy from a permissions standpoint.

                                1 Reply Last reply Reply Quote 1
                                • LakshmanaL
                                  Lakshmana
                                  last edited by

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

                                  1 Reply Last reply Reply Quote 0
                                  • scottalanmillerS
                                    scottalanmiller
                                    last edited by

                                    Okay, so SELinux is off.

                                    1 Reply Last reply Reply Quote 0
                                    • dafyreD
                                      dafyre
                                      last edited by

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

                                      What happens if you:

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

                                      ?

                                      1 Reply Last reply Reply Quote 0
                                      • LakshmanaL
                                        Lakshmana
                                        last edited by

                                        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

                                        Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

                                        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)

                                        1 Reply Last reply Reply Quote 0
                                        • dafyreD
                                          dafyre
                                          last edited by

                                          Okay... now...

                                          select userid,name from users;

                                          1 Reply Last reply Reply Quote 2
                                          • LakshmanaL
                                            Lakshmana
                                            last edited by

                                            MariaDB [zabbixdb]> select userid,name from users;
                                            +--------+--------+
                                            | userid | name |
                                            +--------+--------+
                                            | 1 | Zabbix |
                                            | 2 | |
                                            +--------+--------+
                                            2 rows in set (0.00 sec)

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 6
                                            • 7
                                            • 5 / 7
                                            • First post
                                              Last post