The Certificate bound to port ‘18,443’ will expire on Mar 6, 2018 2:40:17 PM.

it’s been a year since i configured our MySQL Enterprise Monitoring… now i’m getting below error.

The Certificate bound to port '18,443' will expire on Mar 6, 2018 2:40:17 PM.

mem01

below are the steps i did..
– Backup the keystore

[oracle@lnxmemmonitoring ~]$ cd /u01/db/mysql/apache-tomcat/conf/
[oracle@lnxmemmonitoring conf]$ ls -lrt
total 224
-rw------- 1 oracle oinstall   2293 Mar  6  2017 keystore
-rw------- 1 oracle oinstall 169371 Oct 10 17:21 web.xml
-rw------- 1 oracle oinstall   2633 Oct 10 17:21 tomcat-users.xsd
-rw------- 1 oracle oinstall   3622 Oct 10 17:21 logging.properties
-rw------- 1 oracle oinstall   2358 Oct 10 17:21 jaspic-providers.xsd
-rw------- 1 oracle oinstall   1149 Oct 10 17:21 jaspic-providers.xml
-rw------- 1 oracle oinstall  13824 Oct 10 17:21 catalina.policy
-rw------- 1 oracle oinstall   1466 Oct 13 17:29 context.xml
-rw------- 1 oracle oinstall   7437 Jan 25 06:21 catalina.properties
-rw------- 1 oracle oinstall   2131 Feb  8 09:22 server.xml
drwx--x--x 3 oracle oinstall   4096 Feb  8 09:22 Catalina

[oracle@lnxmemmonitoring conf]$ cp keystore keystore_bak

– execute the config with renew parameter.

[oracle@lnxmemmonitoring apache-tomcat]$ cd ../bin
[oracle@lnxmemmonitoring bin]$ ls -lrt
total 8
drwxr-xr-x 3 oracle oinstall 4096 Feb  8 09:22 bootstrap
-rwxr-xr-x 1 oracle oinstall  629 Feb  8 09:22 config.sh

[oracle@lnxmemmonitoring bin]$ ./config.sh --renew

– now restart the MEM.

[oracle@lnxmemmonitoring bin]$ /u01/db/mysql/mysqlmonitorctl.sh status
MySQL Enterprise MySQL is running
MySQL Enterprise Tomcat is running

[oracle@lnxmemmonitoring bin]$ /u01/db/mysql/mysqlmonitorctl.sh stop
Stopping tomcat service . [ OK ]
Stopping mysql service .......... [ OK ]

[oracle@lnxmemmonitoring bin]$ /u01/db/mysql/mysqlmonitorctl.sh start
Starting mysql service  [ OK ]
2018-03-09T00:49:51.896022Z mysqld_safe Logging to '/u01/db/mysql/mysql/data/lnxmemmonitoring.err'.
2018-03-09T00:49:51.947440Z mysqld_safe Starting mysqld daemon with databases from /u01/db/mysql/mysql/data
Starting tomcat service  [ OK ]
[oracle@lnxmemmonitoring bin]$

now clear all alerts..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s