TOPIC:

For our installation of Xerte we are required to use an installation of MySQL with a non-default port number. Does anyone have best practice on specifying this during v3.0 installation?

Appending :XXXX (where XXXX is the port number) to the database host name no longer works (after some digging the PDO mechanism does not like the port number supplied in this fashion). I've managed to append ;port=XXXX to the hostname to get this to work but this feels extremely hacky...

Have a look at /website_code/php/database_library.php around line 55. You might be able to manually add the custom port in there e.g. port=xxx;

Let us know if that works?

HTH
Ron

Thanks for the advice Ron - the existing workaround in effect performs what you suggest so I can confirm that it works.

Is there a procedure for filing an enhancement request? (To allow specification of port number within the installation UI)

Re: MySQL database install on non-default port
I've replicated this issue on our dev server with the latest Xerte install (3.1), i.e. I had to append ';port=XXXX' to the hostname on page 2 of the installer to get this to work.

Not a big deal but our security officer is a little concerned that no validation took place and perhaps other parts of the web UI are vulnerable?

Thanks.
Naveed