ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
API Gateway: MySQL DB Not Running
Article ID: 185808
CA API GatewayAPI SECURITYSTARTER PACK-7
On one of our processing nodes, when we check the status of the MySQL DB, it shows the database isn't running.
API Gateway: 9.3
First, check the following:
1. the ssg log for any outstanding MySQL errors 2. the /var/log/mysqld.log for any outstanding MySQL errors 3. make sure the /var/lib/mysql directory isn't full 4. make sure the permissions on the /var/lib/mysql directory, files and sub-directories are set properly
If everything above checks out, run the following command:
mysqld_safe --user=root &
After a few seconds, you can hit CTRL +C to break out of the command and check the status of the MySQL DB.