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: Database user permissions on clean install

Database user permissions on clean install 9 months 2 weeks ago #5611

  • jtoomey
  • jtoomey's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Hello,

trying to do a clean install of Xerte X on a public server. I get as far as the create database page and get SQLSTATE[28000] [1045] Access denied for user everytime.

I've asked our DBAs to give the user Create and Write access to the database and I can Create and Write to the database using a SQL client, but Xerte can't create a new database in the set up wizard

Does anyone know what the specific user permissions should be for the User setting up the database, or have any tips on where I might be missing something?

Cheers
Jon

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

Database user permissions on clean install 9 months 2 weeks ago #5612

  • ronm
  • ronm's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 536
  • Thank you received: 132
Hi
If you’re creating the empty database in advance just create a user just for that database and grant that user all privileges.
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.

Database user permissions on clean install 9 months 2 weeks ago #5613

  • tom
  • tom's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 869
  • Thank you received: 162
Also, sometimes the issue is not in the permissions, but the name of the database.

For example, do not use a hyphen (-) in the database name. Xerte's code is not able to handle that at the moment.

(Needs to be fixed).

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

Database user permissions on clean install 9 months 2 weeks ago #5614

  • ronm
  • ronm's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 536
  • Thank you received: 132
cant say I've ever noticed that Tom but I guess because I (or the system in use) always use underscore rather than hyphen.

Also on that note with cpanel set up etc the database name usually becomes cpanelusername_dbname so during xerte setup that needs to be the same in the form field of the setup page.

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.

Database user permissions on clean install 9 months 2 weeks ago #5615

  • jtoomey
  • jtoomey's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Ah thanks both,

I harassed our DBA a bit more and I was using the wrong password. Doh!

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

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

Search