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
  • 2

TOPIC: Stuck at Database Creation

Stuck at Database Creation 4 years 1 month ago #3079

  • EleanorVT
  • EleanorVT's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Hello,
I hope someone can help. I am trying to install XOT for a personal project. I have very little experience with this sort of thing and I am stuck. I am trying to install XOT onto my web sever using cPanel, but I get stuck at page1 creating the mySql database.

I have made an empty database called xertedb, the username is cl42-xertedb.
I've used localhost as the name of the host
I've tried root amd cl42-xertedb with and without '' as the account username
I've used the correct password for the database
I've tried xertedb and cl42-xertedb with and without ''

And I cannot get this step to work. I mostly get "Access deined for user 'root'" errors. I have no idea what I'm doing wrong, I don't know how to edit permissons for things and I don't know where to look to find out. It is probably something really simple that I don't know about. Can anybody help?

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

Stuck at Database Creation 4 years 1 month ago #3080

  • tom
  • tom's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 863
  • Thank you received: 159
Please use username cl42-xertedb without quotes, and then let me know what the errormessage is please.

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

Stuck at Database Creation 4 years 1 month ago #3083

  • EleanorVT
  • EleanorVT's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
This is the error message I get using that

Failed to connect to db: SQLSTATE[28000] [1045] Access denied for user 'cl42-xertedb '@'10.0.44.95' (using password YES)

Thank you for any help!

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

Stuck at Database Creation 4 years 1 month ago #3084

  • tom
  • tom's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 863
  • Thank you received: 159
Two observations:

1. You probably did a copy-paste of the username, because there is an extra space after the username. Please remove that, and try again. (I filed an issue to remove leading and trainling spaces for a future version.)

2. Why does it mention 10.0.44.95? I thought you used localhost for the hostname?

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

Stuck at Database Creation 4 years 1 month ago #3085

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

Tried again tying everything in to avoid extra spaces

If I use cl42-xertedb as the username and xertedb as the name of the database I get:

SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'cl42-xertedb'@'%' to database 'xertedb'

I'm afraid I don't know what 10.0.44.95 is refering to, I'm using localhost....

I tried setting up xot on a completley different hosting package on a different domain, in case I has somehow already made a mistake, and managed to get different error messages on that one, despite following the same steps:

Failed to connect to db: SQLSTATE[HY000] [2002] Connection refused

Any ideas? Thank you for helping, I don't really have the skill to be doing this myself but I am trying to learn!

Best Regards

Eleanor

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

Stuck at Database Creation 4 years 1 month ago #3087

  • tom
  • tom's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 863
  • Thank you received: 159
There are three reasons why you can get this error:
1. The password is wrong
2. The specific user doesn't have permission on the database
3. You're referring to the worng database host

From what I gather, it probably is caused by 2.

Please verify that user cl42-xertedb has full access to xertedb.

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

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

Search