need help with Zabbix server

Mike Davis

coliver

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

Mike Davis

I think we have a bingo.

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

Mike Davis

Shouldn't this work:

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

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.

Mike Davis

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?

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?

coliver

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

travisdh1

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

Mike Davis

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

coliver

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

dafyre

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.

Mike Davis

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

DustinB3403

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

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

Enter in your servers' IP address not the literal "xx.xx.14.212"

Mike Davis

I did enter the real IP address.

DustinB3403

Did you fill in the user password?

coliver

I wonder if Firewalld is blocking this. Zabbix should really be using 'zabbix'@'localhost' instead of the IP address.

dafyre

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

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

I'm assuming that this mysql server is not on the same server as Zabbix?

So check your firewall, and check /etc/mysql/my.cnf and make sure that it's set to listen on the IP address and not 127.0.0.1.

DustinB3403

I just tested this on my zabbix system and got

He received 2005

Mike Davis

it is on the same server.
I just edited:
sudo vi /etc/zabbix/zabbix_server.conf
and set :
DBhost=localhost