If your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN) the ports and access privileges need to be set. For this issue the following commands (where 5432 is the port that MySQL can be reached on):
+
You will need to make some additional adjustments if your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN). Privileges for the ports and access privileges need to be set. Use the following commands to modify the configuration. This example uses port 3307 as the port to connect to MySQ; you may need to use a different port for your specific set up.
+
config setprop mysql55-mysqld TCPPort 3307
config setprop mysql55-mysqld TCPPort 3307
config setprop mysql55-mysqld UDPPort 3307
config setprop mysql55-mysqld UDPPort 3307
config setprop mysql55-mysqld access private
config setprop mysql55-mysqld access private
−
followed by the event to update the firewall rules:
+
+
Follow that with event signals to update the SME configuration.
+
signal-event remoteaccess-update
signal-event remoteaccess-update
−
You can toggle between private and public access followed by the remoteaccess-update command.
+
+
You can toggle between private and public access by changing the value of the "mysql55-mysqld access" property. Remember to follow any change with the remoteaccess-update command.