Details
-
Type: Improvement
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: 4.6.0
-
Fix Version/s: 4.8.0-b1
-
Component/s: Staff Interface
-
Labels:None
Description
During Blesta installation in both the UI and CLI environment, a MySQL port should be set. In both environments, this should default to 3306. In the UI, 3306 can be set in the input field by default. In CLI mode, it can default to 3306. A port should be required and validated as a port number similar to other fields during installation. This will allow users to specify non-standard MySQL ports during installation that they cannot currently set.
- Create a new input field/option for a MySQL server Port
- The Port field should appear beneath/after the Host field as a separate field atogether. It should not be given as a socket to the host field (e.g. not "domain.com:3306")
- The configuration file should then have a 'port' field set for the database profile
- When performing a backup in Blesta, a mysqldump command is run. This needs to be given the port for backups to work
- Test Blesta works on a non-standard port set from installation and that a database dump can be downloaded
When installing Blesta, the default port of 3306 is used for the MySQL server specified. We should allow this port to be overridden. For one, some MySQL hosting instances work on non-standard ports
Suggestion is to allow the port be specified in the hostname field as such:
localhost
localhost:3306
localhost:8712
mysql.domain.com
mysql.domain.com:3306
mysql.domain.com:8712
If no port is specified, then we use the default port 3306. If a port is specified, then we use that port. During installation, when the config file is written we must then also specify the port in the /config/blesta.php config file. Currently there is an option for port that is commented out.
A different field should be set for the port, which can default to port 3306