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

TOPIC:

Database user permissions on clean install 5 years 2 months ago #5611

  • jtoomey
  • jtoomey's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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 5 years 2 months ago #5612

  • ronm
  • ronm's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 840
  • Thank you received: 244
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
Note: Support here is voluntary and meant for users to support each other.
Need direct commercial support with Xerte? mitchellmedia.co.uk/contact/

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

Database user permissions on clean install 5 years 2 months ago #5613

  • tom
  • tom's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 1281
  • Thank you received: 305
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 5 years 2 months ago #5614

  • ronm
  • ronm's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 840
  • Thank you received: 244
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
Note: Support here is voluntary and meant for users to support each other.
Need direct commercial support with Xerte? mitchellmedia.co.uk/contact/

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

Database user permissions on clean install 5 years 2 months ago #5615

  • jtoomey
  • jtoomey's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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.

Database user permissions on clean install 3 years 9 months ago #6610

  • jim.lowe
  • jim.lowe's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thank you received: 0
Dear Tom and Community

Has the use of - in database name been fixed in the latest code?
The reason I ask is because I cannot get past the page2 of the setup as it generates an error as "Please investigate the error messages and return to the previous page by pressing the button below! Failed to execute query line 89 page2.php"

All permissions required are in place and checked. The database name issue is the only thing I have found so far that might explain things as the server I use automatically adds an extension to the database user-provided name of -123456 where 123456 is a unique number added to prevent clashes of database name in the database server...

Any update would be greatly appreciated

Many thanks

Jim

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

  • Page:
  • 1
  • 2
Time to create page: 0.092 seconds
Copyright © 2024 The Xerte Project.
Xerte logo Apereo logo OSI Logo

Search