Symptoms
A customer cannot install or reconfigure APS application (e.g. WordPress) in their subscription in POA Customer Control Panel, corresponding POA task fails with the following error message
Unable to connect to DB: Can't connect to MySQL server on 'ip_address' (10048)
More detailed error message in the failed POA task is provided below:
Last execution output Destination host 'PSAWINWEB1.hosting.local' (#161), IP '10.16.44.114' : Provisioning request failed.
Unspecified error [<response><errorContext description="Error 1(Incorrect function) at execute '$tmp$configure$batch$.bat' on server 'PSAWINWEB1.hosting.local'
Output:
Unable to connect to DB: Can't connect to MySQL server on '10.16.44.42' (10048)
As a result the application stays in the 'Configuring' or 'Installing' status in Customer Control Panel.
Cause
Access from the hosting server where the APS application is being installed to the MySQL server where database is located is not available, as a result script executed during application installation/reconfiguration fails.
The problem may happen due to the following reasons:
- Hosting server where MySQL server is installed is down
- MySQL server is down
- No routing between servers
- Firewall blocks connections between hosting server and MySQL server
- Etc.
Resolution
The IP address and/or hostname of the shared hosting server where the APS application is going to be installed/reconfigured is provided in the failed POA task, it is 'PSAWINWEB1.hosting.local 10.16.44.114' in the example above.
The IP address of the MySQL server is provided in the failed task as well, it is 10.16.44.42 in the example above.
Make sure that MySQL server is up and running; enable access from the affected hosting server to the MySQL server to the needed port (default port 3306) to resolve the issue.