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

    need help with Zabbix server

    Scheduled Pinned Locked Moved IT Discussion
    centoszabbixmonitoring
    62 Posts 9 Posters 20.2k 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.
    • art_of_shredA
      art_of_shred
      last edited by

      /var/log/zabbix_agentd.log

      It said 127.0.0.1 was refusing connection. I took that to mean that something was referencing the server by localhost IP. It uses the file: /etc/zabbix/zabbix_agentd.conf for that function, and all of the srver IP's in that file show 127.0.0.1, which seemed odd to me. Shouldn't it have the public IP in there somewhere?
      Just my thoughts...

      coliverC 1 Reply Last reply Reply Quote 0
      • coliverC
        coliver @art_of_shred
        last edited by

        @art_of_shred said in need help with Zabbix server:

        /var/log/zabbix_agentd.log

        It said 127.0.0.1 was refusing connection. I took that to mean that something was referencing the server by localhost IP. It uses the file: /etc/zabbix/zabbix_agentd.conf for that function, and all of the srver IP's in that file show 127.0.0.1, which seemed odd to me. Shouldn't it have the public IP in there somewhere?
        Just my thoughts...

        From the little research I've done this looks like it could be related to SELinux. Try the following command.

        sudo setsebool httpd_can_connect_zabbix 1
        
        1 Reply Last reply Reply Quote 1
        • Mike DavisM
          Mike Davis @hobbit666
          last edited by

          from the /var/log/zabbix/zabbix_server.log file:
          ] Access denied for user 'zabbix'@'xx.xx.14.212' (using password: YES)
          1141:20161020:143621.388 cannot set MySQL character set to "utf8"
          1141:20161020:143621.388 database is down: reconnecting in 10 seconds

          coliverC 1 Reply Last reply Reply Quote 0
          • coliverC
            coliver @Mike Davis
            last edited by

            @Mike-Davis said in need help with Zabbix server:

            from the /var/log/zabbix/zabbix_server.log file:
            ] Access denied for user 'zabbix'@'xx.xx.14.212' (using password: YES)
            1141:20161020:143621.388 cannot set MySQL character set to "utf8"
            1141:20161020:143621.388 database is down: reconnecting in 10 seconds

            Ah, you need to grant either 'zabbix'@* or 'zabbix'@'xx.xx.14.212 permission to the mysql database.

            GRANT ALL TO 'zabbix'@'xx.xx.14.212' IDENTIFIED BY 'yourpassword'; 
            

            Or something similar to that.

            1 Reply Last reply Reply Quote 3
            • Mike DavisM
              Mike Davis
              last edited by

              when I run:
              sudo getenforce
              it returns:
              Disabled

              Do I need to enable it so those rules apply?

              The guide I was following said to run these commands:
              sudo setsebool -P httpd_can_network_connect=1
              sudo setsebool -P httpd_can_connect_zabbix=1
              sudo setsebool -P zabbix_can_network=1

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

                Sorry been away in meetings recently...

                @coliver is right about the GRANT command...

                Is your mysql server on the same server as Zabbix or on a different one?

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

                  @Mike-Davis said in need help with Zabbix server:

                  when I run:
                  sudo getenforce
                  it returns:
                  Disabled

                  Do I need to enable it so those rules apply?

                  The guide I was following said to run these commands:
                  sudo setsebool -P httpd_can_network_connect=1
                  sudo setsebool -P httpd_can_connect_zabbix=1
                  sudo setsebool -P zabbix_can_network=1

                  If SELinux id disabled, then those commands won't have any affect until you enable it again.

                  1 Reply Last reply Reply Quote 0
                  • Mike DavisM
                    Mike Davis
                    last edited by

                    database on the same server. If I log in to the database, and run:
                    select user, host from mysql.user;
                    it returns:
                    MariaDB [(none)]> select user, host from mysql.user;
                    +--------+--------------------+
                    | user | host |
                    +--------+--------------------+
                    | zabbix | % |
                    | root | 127.0.0.1 |
                    | root | ::1 |
                    | root | localhost |
                    | zabbix | localhost |
                    | zabbix | ​xx.xx.14.212​ |
                    +--------+--------------------+
                    6 rows in set (0.00 sec)

                    coliverC 1 Reply Last reply Reply Quote 0
                    • coliverC
                      coliver @Mike Davis
                      last edited by

                      @Mike-Davis said in need help with Zabbix server:

                      database on the same server. If I log in to the database, and run:
                      select user, host from mysql.user;
                      it returns:
                      MariaDB [(none)]> select user, host from mysql.user;
                      +--------+--------------------+
                      | user | host |
                      +--------+--------------------+
                      | zabbix | % |
                      | root | 127.0.0.1 |
                      | root | ::1 |
                      | root | localhost |
                      | zabbix | localhost |
                      | zabbix | ​xx.xx.14.212​ |
                      +--------+--------------------+
                      6 rows in set (0.00 sec)

                      The user may exist but it may not have the granted permissions. You can run:

                      SHOW GRANTS FOR 'zabbix'@'xx.xx.14.212';
                      

                      To see what that user has access to.

                      1 Reply Last reply Reply Quote 0
                      • Mike DavisM
                        Mike Davis
                        last edited by

                        I think we have a bingo.

                        ERROR 1141 (42000): There is no such grant defined for user 'zabbix' on host 'xx.xx.14.212​'

                        1 Reply Last reply Reply Quote 0
                        • Mike DavisM
                          Mike Davis
                          last edited by

                          Shouldn't this work:

                          GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@​xx.xx.14.212 IDENTIFIED BY 'mySecurePasswordHere​';

                          coliverC 1 Reply Last reply Reply Quote 0
                          • coliverC
                            coliver @Mike Davis
                            last edited by coliver

                            @Mike-Davis said in need help with Zabbix server:

                            Shouldn't this work:

                            GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@​xx.xx.14.212 IDENTIFIED BY 'mySecurePasswordHere​';

                            If the user already exists drop the IDENTIFIED BY part. But yes the syntax should work. Don't forget the single quotes around the username and IP address.

                            1 Reply Last reply Reply Quote 1
                            • Mike DavisM
                              Mike Davis
                              last edited by

                              When I run it, I get:
                              Query OK, 0 rows affected (0.00 sec)

                              MariaDB [(none)]> show grants for [email protected]​; ERROR 1141 (42000): There is no such grant defined for user 'zabbix' on host 'xx.xx.14.212​'

                              Do the single quotes matter when running these commands?

                              1 Reply Last reply Reply Quote 0
                              • Mike DavisM
                                Mike Davis
                                last edited by Mike Davis

                                MariaDB [(none)]> show grants for [email protected]​;
                                ERROR 1141 (42000): There is no such grant defined for user 'zabbix' on host 'xx.xx.14.212​'
                                MariaDB [(none)]> show grants for zabbix
                                -> ;
                                +-------------------------------------------------------------------------------------------------------+
                                | Grants for zabbix@% |
                                +-------------------------------------------------------------------------------------------------------+
                                | GRANT USAGE ON . TO 'zabbix'@'%' IDENTIFIED BY PASSWORD 'F7B59hashhereC9667D7D09DC' |
                                | GRANT ALL PRIVILEGES ON zabbix.
                                TO 'zabbix'@'%' |
                                +-------------------------------------------------------------------------------------------------------+
                                2 rows in set (0.00 sec)

                                Do I have too many zabbix users configured? Should I just have the one with the external host IP?

                                coliverC 1 Reply Last reply Reply Quote 0
                                • coliverC
                                  coliver @Mike Davis
                                  last edited by

                                  @Mike-Davis said in need help with Zabbix server:

                                  MariaDB [(none)]> show grants for [email protected]​;
                                  ERROR 1141 (42000): There is no such grant defined for user 'zabbix' on host 'xx.xx.14.212​'
                                  MariaDB [(none)]> show grants for zabbix
                                  -> ;
                                  +-------------------------------------------------------------------------------------------------------+
                                  | Grants for zabbix@% |
                                  +-------------------------------------------------------------------------------------------------------+
                                  | GRANT USAGE ON . TO 'zabbix'@'%' IDENTIFIED BY PASSWORD 'F7B59hashhereC9667D7D09DC' |
                                  | GRANT ALL PRIVILEGES ON zabbix.
                                  TO 'zabbix'@'%' |
                                  +-------------------------------------------------------------------------------------------------------+
                                  2 rows in set (0.00 sec)

                                  Do I have too many zabbix users configured? Should I just have the one with the external host IP?

                                  I'm not sure, I don't think so I thought '%' was equivalent to local host.

                                  travisdh1T Mike DavisM 2 Replies Last reply Reply Quote 0
                                  • travisdh1T
                                    travisdh1 @coliver
                                    last edited by

                                    @coliver said in need help with Zabbix server:

                                    @Mike-Davis said in need help with Zabbix server:

                                    MariaDB [(none)]> show grants for [email protected]​;
                                    ERROR 1141 (42000): There is no such grant defined for user 'zabbix' on host 'xx.xx.14.212​'
                                    MariaDB [(none)]> show grants for zabbix
                                    -> ;
                                    +-------------------------------------------------------------------------------------------------------+
                                    | Grants for zabbix@% |
                                    +-------------------------------------------------------------------------------------------------------+
                                    | GRANT USAGE ON . TO 'zabbix'@'%' IDENTIFIED BY PASSWORD 'F7B59hashhereC9667D7D09DC' |
                                    | GRANT ALL PRIVILEGES ON zabbix.
                                    TO 'zabbix'@'%' |
                                    +-------------------------------------------------------------------------------------------------------+
                                    2 rows in set (0.00 sec)

                                    Do I have too many zabbix users configured? Should I just have the one with the external host IP?

                                    I'm not sure, I don't think so I thought '%' was equivalent to local host.

                                    % is everything, like * would be in other places.

                                    1 Reply Last reply Reply Quote 0
                                    • Mike DavisM
                                      Mike Davis @coliver
                                      last edited by

                                      @coliver I think % is the wildcard from what I read. Not good practice, but I was trying to get it working.

                                      coliverC 1 Reply Last reply Reply Quote 1
                                      • coliverC
                                        coliver @Mike Davis
                                        last edited by

                                        @Mike-Davis said in need help with Zabbix server:

                                        @coliver I think % is the wildcard from what I read. Not good practice, but I was trying to get it working.

                                        Ah, that makes sense. So that should work.

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

                                          You can also attempt to log in from the CLI from the Zabbix server...

                                          mysql -u zabbix -p -h ip.add.14.212
                                          

                                          And see if it lets you connect.

                                          1 Reply Last reply Reply Quote 0
                                          • Mike DavisM
                                            Mike Davis
                                            last edited by

                                            sudo mysql -u zabbix -p -h xx.xx.14.212​
                                            Enter password:
                                            ERROR 2005 (HY000): Unknown MySQL server host 'xx.xx.14.212​' (0)

                                            DustinB3403D dafyreD 2 Replies Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 1 / 4
                                            • First post
                                              Last post