Skip to content

Instantly share code, notes, and snippets.

@walterheck

walterheck/gist:42abc7f19e035b75860ea6c8bbc20e56

Last active January 24, 2017 08:10
Show Gist options
  • Save walterheck/42abc7f19e035b75860ea6c8bbc20e56 to your computer and use it in GitHub Desktop.
Save walterheck/42abc7f19e035b75860ea6c8bbc20e56 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
[root@icinga2 icinga2]# cat /etc/icingaweb2/resources.ini
[icingaweb_db]
type = db
db = "mysql"
host = "10.20.1.60"
port = "3306"
dbname = "icinga2_web"
username = "icinga2_web"
password = "password"
[icinga_ido]
type = db
db = "mysql"
host = "10.20.1.60"
port = "3306"
dbname = "icinga2_data"
username = "icinga2"
password = "password"
[ldap]
type = ldap
hostname = "localhost"
port = "389"
root_dn = "dc=example,dc=com"
bind_dn = "johndoe@example.com"
bind_pw = "abc123"
[root@icinga2 icinga2]# mysql -uicinga2 -ppassword -D icinga2_data -h10.20.1.60
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 5217
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [icinga2_data]> Bye
[root@icinga2 icinga2]# mysql -uicinga2_web -ppassword -D icinga2_web -h10.20.1.60
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 5221
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Raw
gistfile2.txt
[2017-01-24 08:02:40 +0000] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!
[2017-01-24 08:02:50 +0000] critical/IdoMysqlConnection: Connection to database 'icinga2_data' with user 'icinga2' on '10.20.1.60:3306' failed: "Access denied for user 'icinga2'@'10.20.1.20' (using password: YES)"
Context:
(0) Reconnecting to MySQL IDO database 'ido-mysql'
[2017-01-24 08:02:50 +0000] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!
[2017-01-24 08:03:00 +0000] critical/IdoMysqlConnection: Connection to database 'icinga2_data' with user 'icinga2' on '10.20.1.60:3306' failed: "Access denied for user 'icinga2'@'10.20.1.20' (using password: YES)"
Context:
(0) Reconnecting to MySQL IDO database 'ido-mysql'
[2017-01-24 08:03:00 +0000] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!
Raw
gistfile3.txt
[root@icinga2 icinga2]# mysql -uicinga2 -ppassword -D icinga2_data -h10.20.1.60
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 5263
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [icinga2_data]> show grants;
+-----------------------------------------------------------------------------+
| Grants for icinga2@10.20.1.% |
+-----------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'icinga2'@'10.20.1.%' IDENTIFIED BY PASSWORD <secret> |
| GRANT ALL PRIVILEGES ON `icinga2_data`.* TO 'icinga2'@'10.20.1.%' |
+-----------------------------------------------------------------------------+
2 rows in set (0.04 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment