Urgen help required :(

[yolkie]

Ok I have installed gnutls "yum install gnutls" while trying to figure out how to configure encryption between agent and server

And then I uninstalled gnutls "yum remove gnutls"

And my Zabbix server died.
WEB UI is accessible but it is prompting me
"Zabbix server is not running: the information displayed may not be current."
Zabbix server is running: The value is set to NO

Anyone have any advice?

[batchenr]

Ok I have installed gnutls "yum install gnutls" while trying to figure out how to configure encryption between agent and server

And then I uninstalled gnutls "yum remove gnutls"

And my Zabbix server died.
WEB UI is accessible but it is prompting me
"Zabbix server is not running: the information displayed may not be current."
Zabbix server is running: The value is set to NO

Anyone have any advice?

zabbix server logs please..

[yolkie]

As attached is the log.


2269:20170222:151321.833 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
2269:20170222:151321.833 database is down: reconnecting in 10 seconds

How can I troubleshoot this?
Thank you for replying.

[batchenr]

As attached is the log.


2269:20170222:151321.833 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
2269:20170222:151321.833 database is down: reconnecting in 10 seconds

How can I troubleshoot this?
Thank you for replying.

restart mysql - check mysql_error.log or any mysql log.
try to connect to DB as zabbix user see if you can connect

[yolkie]

I can only see this mysqld.log as attached.

I can connect using zabbix user

[root@zabbix etc]# mysql -u zabbix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 246
Server version: 5.6.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> show databases
-> \g
+--------------------+
| Database |
+--------------------+
| information_schema |
| zabbixdb |
+--------------------+
2 rows in set (0.00 sec)

mysql>

[batchenr]

I can only see this mysqld.log as attached.

I can connect using zabbix user

[root@zabbix etc]# mysql -u zabbix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 246
Server version: 5.6.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> show databases
-> \g
+--------------------+
| Database |
+--------------------+
| information_schema |
| zabbixdb |
+--------------------+
2 rows in set (0.00 sec)

mysql>

look at similar issue - see if it helps do all that we suggested there :

https://www.zabbix.com/forum/showthread.php?t=56828

[yolkie]

Dear batchenr,

Thank you for trying to help. I have reinstalled the server from scratch as this is a new production server. Got it up back in about 1 to 2 hours.

Thank you again! I have learnt more about zabbix through your post in another thread.

[yolkie]

Now, I need to figure out how to do encrypting... ill do a backup first this time, before any changes