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: XOT v3.0 MySQL Database Creation User rights

XOT v3.0 MySQL Database Creation User rights 4 years 1 month ago #3118

  • 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
On page1.php of the XOT installation the MySQL user account is quoted as needing Create and Insert rights - however I can see from the basic.sql script that gets run that DROP is now also required in V3.0 of XOT.

Is DROP only required for installation purposes? I'd be keen to revoke DROP permissions once installation is complete (for security).

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

XOT v3.0 MySQL Database Creation User rights 4 years 1 month ago #3119

  • ronm
  • ronm's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 532
  • Thank you received: 129
The basic.sql is only used during initial installation and not when upgrading so for a new clean install drop permissions shouldn't be needed anyway and once the installation is complete the setup folder should be removed. Obviously sometimes people hit issues and try to re-run setup over an existing database so drop may be needed in those instances. Setup should never be used on an existing install with projects that need to be kept. We have the separate upgrade script for upgrades. We also try to minimise database changes between versions and I can't recall an occasion where the upgrade script ever needed to drop a table. (But could be wrong. ;-))
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.

XOT v3.0 MySQL Database Creation User rights 4 years 1 month ago #3120

  • 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
Hi Ron,

That's useful background information, thanks.

This is a clean install of XOT 3.0; our solution so far has been to edit the basic.sql file to remove the drop table commands (since as you say they are not needed).

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

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

Search