changed mysql password; unable to log into ccm
Posted: Tue Mar 04, 2014 11:19 am
I've attempted to change the default mysql password and clearly missed something since when I attempted to apply the changes from the core configuration manager, I've get the error "Backend login to the Core Config Manager failed".
Below are the changes I made to update the mysql password. Can you please help me determine what I missed? Thanks!
Below are the changes I made to update the mysql password. Can you please help me determine what I missed? Thanks!
Code: Select all
# mysqladmin -u root -pnagiosxi password <newpass>
# cd ~root
# diff automysqlbackup.original automysqlbackup
31c31,32
< PASSWORD=nagiosxi
---
> #PASSWORD=nagiosxi
> PASSWORD=<newpass>
# diff restore_xi.sh restore_xi.sh.original
12,13c12
< #mysqlpass="nagiosxi"
< mysqlpass="<newpass>"
---
> mysqlpass="<newpass>"
diff restore_xi.sh restore_xi.sh.original
12,13c12
< #mysqlpass="nagiosxi"
< mysqlpass="<newpass>"
---
> mysqlpass="<newpass>"
# diff xi-sys.cfg xi-sys.cfg.original
33c33
< mysqlpass='<newpass>'
---
> mysqlpass='nagiosxi'
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30551
Server version: 5.1.71 Source distribution
Copyright (c) 2000, 2013, 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> use mysql;
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
mysql> set password for 'ndoutils'@'localhost' = password('<newpass>');
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
# pwd
/usr/local/nagiosxi/html
# diff config.inc.php config.inc.php.original
52,53c52
< // "pwd" => 'n@gweb',
< "pwd" => '<newpass>, // block for ndoutils user
---
> "pwd" => 'n@gweb',
74,75c73
< // "pwd" => 'n@gweb',
< "pwd" => '<newpass>', // block for nagiosql user
---
> "pwd" => 'n@gweb',
114,115c112
< // "password" => 'n@gweb', // this gets reset when security credentials are reset after installation
< "password" => '<newpass>', // this gets reset when security credentials are reset after installation – block for nagiosql user
---
> "password" => 'n@gweb', // this gets reset when security credentials are reset after installation
219c216
diff config.inc.dist config.inc.dist.original
52,53c52
< // "pwd" => 'n@gweb',
< "pwd" => '<newpass>', // block for ndoutils user
---
> "pwd" => 'n@gweb',
74,75c73
< // "pwd" => 'n@gweb',
< "pwd" => '<newpass>', // block for nagiosql user
---
> "pwd" => 'n@gweb',
114,115c112
< // "password" => 'n@gweb', // this gets reset when security credentials are reset after installation
< "password" => '<newpass>', // this gets reset when security credentials are reset after installation – block for nagiosql user
---
> "password" => 'n@gweb', // this gets reset when security credentials are reset after installation
219c216
# pwd
/usr/local/nagiosxi/etc/components
# diff config.inc.saved config.inc.saved.original
52,53c52
< // "pwd" => 'n@gweb',
< "pwd" => '<newpass>', // block for nodutils user
---
> "pwd" => 'n@gweb',
74,75c73
< // "pwd" => 'n@gweb',
< "pwd" => '<newpass>', // block for nagiosql user
---
> "pwd" => 'n@gweb',
114,115c112
< // "password" => 'n@gweb', // this gets reset when security credentials are reset after installation
< "password" => '<newpass>', // this gets reset when security credentials are reset after installation - block for nagiosql user
---
> "password" => 'n@gweb', // this gets reset when security credentials are reset after installation
219c216
# pwd
/usr/local/nagiosxi/html/includes/components/ccm
# diff config.inc.php config.inc.php.original
22,23c22
< // 'password' => 'n@gweb',
< 'password' => '<newpass>', // block for nagisql user
---
> 'password' => 'n@gweb',
35c34
# diff ccm.inc.php ccm.inc.php.original
130,131c130
< // $password = grab_array_var($cfg['db_info']['nagiosql'],'pwd','n@gweb');
< $password = grab_array_var($cfg['db_info']['nagiosql'],'pwd','<newpass>');
---
> $password = grab_array_var($cfg['db_info']['nagiosql'],'pwd','n@gweb');
705c704
# pwd
/usr/local/nagios/etc
# diff ndo2db.cfg ndo2db.cfg.original
26,27c26
< #db_pass=n@gweb
< db_pass=<newpass> // block for nodutils
---
> db_pass=n@gweb
# pwd
/usr/local/nagvis/etc
# diff nagvis.ini.php.original nagvis.ini.php
312c312,313
< dbpass="n@gweb"
---
> ;dbpass="n@gweb"
> dbpass="<newpass>"