Supporting each other

Community forums

Welcome, Guest
Username: Password: Remember me
Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.
  • Page:
  • 1

TOPIC: MySQL port configuration on XOT v3.0

MySQL port configuration on XOT v3.0 4 years 1 month ago #3114

  • Martin.Baker@bristol.ac.uk
  • Martin.Baker@bristol.ac.uk's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
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...

Please Log in or Create an account to join the conversation.

Last edit: by Martin.Baker@bristol.ac.uk.

MySQL port configuration on XOT v3.0 4 years 1 month ago #3116

  • ronm
  • ronm's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 532
  • Thank you received: 129
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
Xerte developer & trainer
e-learning & m-learning consultant
mitchellmedia.co.uk | xerteacademy.com | learningapps.co.uk
Need direct commercial support? mitchellmedia.co.uk/contact/

Please Log in or Create an account to join the conversation.

MySQL port configuration on XOT v3.0 4 years 1 month ago #3117

  • Martin.Baker@bristol.ac.uk
  • Martin.Baker@bristol.ac.uk's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 0
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)

Please Log in or Create an account to join the conversation.

MySQL port configuration on XOT v3.0 3 years 7 months ago #3581

  • navhash
  • navhash's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
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

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.050 seconds
Copyright © 2019 The Xerte Project.
Xerte logo Apereo logo OSI Logo

Search