Skip to content

Instantly share code, notes, and snippets.

@reke592
Created June 12, 2023 04:37
Show Gist options
  • Save reke592/c8bf0b6a02d47c347b84ef5b7eee8aa0 to your computer and use it in GitHub Desktop.
Save reke592/c8bf0b6a02d47c347b84ef5b7eee8aa0 to your computer and use it in GitHub Desktop.
troubleshooting

MySql Display lock status

SELECT thread_id, object_name, lock_type, lock_mode, lock_data, index_name, lock_status FROM performance_schema.data_locks;

SSL Check public and private key if match

openssl x509 -noout -modulus -in certificate.crt | openssl md5
openssl rsa -noout -modulus -in private.key | openssl md5
openssl req -noout -modulus -in request.csr | openssl md5

SSL Test serve

openssl s_server -cert certificate.crt -key private.key

SSL Request new certificate using existing private key

openssl req -new -key existing_private.key -out new_req.csr

SMTP SSL Test STARTTLS

openssl s_client -starttls smtp -crlf -connect smtp.gmail.com:587
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment