Cannot connect to Database - Revision history

Phenixops at 19:56, 16 April 2020

2020-04-16T19:56:44Z

← Older revision		Revision as of 19:56, 16 April 2020
Line 48:		Line 48:
	\|Log rootcause, lessons learned and pending actions		\|Log rootcause, lessons learned and pending actions
	\|}		\|}
			[[Category:MySql]]

Phenixops at 19:54, 16 April 2020

2020-04-16T19:54:13Z

← Older revision		Revision as of 19:54, 16 April 2020
Line 4:		Line 4:
	! What to do		! What to do
	\|-		\|-
	\| Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide the information needed to troubleshoot from.		\| Check if mysqld is running and if the ports are available. Both on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide the information needed to troubleshoot from.
	\|-		\|-
	! Actions		! Actions

Phenixops at 19:53, 16 April 2020

2020-04-16T19:53:31Z

← Older revision		Revision as of 19:53, 16 April 2020
Line 2:		Line 2:
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-
	! ~~Cannot connect~~ to ~~database~~		! What to do
	\|-		\|-
	\| Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide ~~some info~~ to ~~start troubleshooting~~ from.		\| Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide the information needed to troubleshoot from.
	\|-		\|-
	! Actions		! Actions

Phenixops: /* Template Example */

2020-04-16T19:51:29Z

Template Example

← Older revision		Revision as of 19:51, 16 April 2020
Line 1:		Line 1:
	=== ~~Template Example~~ ===		=== Cannot Connect to Database ===
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-

Phenixops: Created page with "=== Template Example === {| class="wikitable" |- ! Cannot connect to database |- | Check if mysqld is running and if the ports are available on the localhost and from the host..."

2020-04-16T19:51:11Z

Created page with "=== Template Example === {| class="wikitable" |- ! Cannot connect to database |- | Check if mysqld is running and if the ports are available on the localhost and from the host..."

New page

=== Template Example ===
{| class="wikitable"
|-
! Cannot connect to database
|-
| Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide some info to start troubleshooting from.
|-
! Actions
|-
|Log the start of the incident and indicators
|-
|Check monitoring
|-
|Check the logging '''''less /var/log/mysql.log'''''
|-
|Check mysqld service '''''service mysqld status'''''
|-
|Check load on database server using '''''top'''''
|-
|Check the ports using '''''nmap -Pn localhost'''''
|-
|Check the ports from remote using '''''nmap -Pn databasehost'''''
|-
|Try to login locally on the database server '''''mysql -u root -p'''''
|-
|Try to login from the remote host '''''mysql -h databasehost -u dbusername -p'''''
|-
! Fixing (you might kill the webserver/monitoring first)
|-
|Restart mysql service '''''service mysqld restart'''''
|-
|Follow the logging '''''tail -f /var/log/mysql.log'''''
|-
|Check mysql service '''''service mysqld status'''''
|-
|Last resort '''''reboot''''' perhaps check most recent backup first
|-
|Restore most recent backup, dump the database first
|-
! Post actions
|-
|Reactivate monitoring
|-
|Log actions and problem resolution
|-
|Keep an eye on monitoring and logfiles
|-
|Log rootcause, lessons learned and pending actions
|}