I have used the application installer to install wordpress to websites successfully, but if I try doing this with joomla, it fails, there is no where to specify the database server name to use and the installer fails to connect to the database server.
I have the feeling the installer is using localhost as the server name, but we use dedicated database servers and there is no place to specify the database server name..
Hello,
In app installer i see the same options for WP and Joomla.
However it does depend on the hosting plan / servers specified in the hosting plan and the External Mysql details specified in the mysql service.
In general you can't quite specify the mysql server per setup, it uses the one included in your hosting plan.
regards,
Marco
Hi,
ok this is an issue now, multiple customers are all complaining about the same issue, setup their website, use the webapp gallery install either joomla or wordpress using the use existing database option, select the db, dbuser and insert the password, and click next and the installer fails with "- DatabaseUserCannotAccessDatabase:bestsolusr" or whatever the username is that was specified. However you can access the dbserver remotely, with the usename and password, etc, phpmyadmin access the db with that user as well from the cp.
However if you use the create database option it works 100% ok.. it is only when selecting the use existing db that it fails. Please help this is now getting out of hand..
After investigating further, I came across this issue with mysql, in the event viewer was this issue could not connect to server with ssl, I searched solidcp forum and there is an issue with mysql and had to be set to none, I then proceeded to goto the mysql settings and checked this was enabled, I unticked it and solidcp said it could not connect, I reenabled it and it saved fine.
I then went to the mysql server and cleared the log files, I then tried the installer again and when it failed it had 3 lines in the logfile.
[2/15/2019 2:53:43 PM] START: 'MySQL Server 5.6' CheckConnectivity
then had the error of The host xx.xx.xx.xx does not support SSL connections.[2/15/2019 2:53:43 PM] END: 'MySQL Server 5.6' CheckConnectivity
I cleared the log file and tested this again and same result, so it looks like the installer tries to do a mysql connectivity test, fails and then the error occurs. There must be an option in the webapp gallery settings where this can also be set or bypassed.
Hello,
I have made a change of code which will fix this bug in the next release.
We have not set an release date but we will post on the forum once we make one.
Thanks,
Trevor Robinson
