Setup wizard - Access denied for user

Post

Posted
Rating:
#46 (In Topic #20)
Avatar
Standard member
Finncat is in the usergroup ‘Fan in action’

Installer Error in step 4 of 10

When running installer I get error " Could not connect to database-server (when authenticating) (access denied for user '*****'@'localhost' (using password:YES)

I have followed all the instructions, made the database, user, connected the user to database and managed the rights. I have tried the quick install and the manual install methods, but both methods crash to the same error. And I have checked & renewed  the username and password multiple time to be sure.

The database version  is libmysql - 5.1.73 (if I got the right info) ,  hosted.  I have created a few other databases and installed eg.  WP instances witout problems,  so the database-engine should be working ok as such.

 Any ideas how to proceed?
Online now: No Back to the top

Post

Posted
Rating:
#47
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Hi,

Some webhosts have the DB server separately to the web server, so it might not be localhost.

Another possibility is if MySQL is configured to only allow local or only allow HTTP connections. So try '127.0.0.1' as the hostname too.

Another possibility is if the DB or usernames have suffixes added on for you when you define them. E.g. in cpanel you might add 'bob', but it saves as 'someaccount_bob'.

Of course, as Composr is new it might be some subtle bug in the coding impacting only specific systems. But to be honest I think a more generic problem is more likely.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#54
Avatar
Standard member
Finncat is in the usergroup ‘Fan in action’
I have tried installation on two separate hosts, with same results. Both are using cPanel however.

I also tried using 127.0.0.1 instead of localhost, no help.
And when I look at phpmyAdmin -panel, it says localhost:3036. Not sure if this indicates anything. And also tried to add that port 3036, no help.

Both sites I use add prefixes using sitename added to db and usernames, I have also tried all combinations, with and without prefix, ho help either.

But in the meanwhile, the other site has Softaculous installer, and there was ocPortal, which I managed to install successfully. This is somehow odd, it asks almost the same questions, but it uses some sort of script to create database and user, they need not to be preconfigured.
I'm just thinking if it was possible to upgrade this to Composr somehow, or is it waste of time even try?
Online now: No Back to the top

Post

Posted
Rating:
Item has a rating of 5 (Liked by Adam)
#124
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
What you could do is look at the info.php's database settings for the Softaculous ocPortal install, then use these for a Composr install.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#151
Avatar
Standard member
Finncat is in the usergroup ‘Fan in action’
I inspected the contents of info.php /ocPortal installation, which I have on the same server but different subdomain. Unfortunately no help from that, db server is called  'localhost' and the database- and usernames prefixed as usual. In theory my settings should have passed right in the first time.

I even tried to read how database connection is defined in Compo.sr install.php , but it was too advanced for my skills to follow even tough I have written some php.

For the time being, I must  give up, and stick to to ocPortal.
Online now: No Back to the top

Post

Posted
Rating:
#152
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
If you want to submit a bug report ticket to us with access to the hosting control panel, and the setup details you want, we'll process for free within the next week (approximately). Either we'll fix Composr or tell you what was going wrong, depending on where the problem is.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#288
Avatar
Standard member
AnotherFoxGuy is in the usergroup ‘Fan in training’
I'm running into the same problem.

It seems to be a problem with Composr because I've tried installing a different CMS and that one installed without problems
Online now: No Back to the top

Post

Posted
Rating:
#289
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Hi,

If you like we'll do a free installation on your server, and if there's a problem fix it.

Please open a ticket if you'd like us to proceed.

We'll need the cpanel (or equivalent) details included in the ticket so that we can check all the settings to debug whatever the problem is.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#291
Avatar
Standard member
AnotherFoxGuy is in the usergroup ‘Fan in training’
I've found the problem already.
If you use a password for the database with special characters, then the setup wizard fails to connect to the database
Online now: No Back to the top

Post

Posted
Rating:
#292
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Ah. Could you let me know the exact password as a test case? It may be that our security filter is changing it, if e.g. it looks like JavaScript.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#293
Avatar
Standard member
AnotherFoxGuy is in the usergroup ‘Fan in training’

Chris Graham said

Ah. Could you let me know the exact password as a test case? It may be that our security filter is changing it, if e.g. it looks like JavaScript.

I was able to reproduce it with "password++"

Chris Graham said

Ah. Could you let me know the exact password as a test case? It may be that our security filter is changing it, if e.g. it looks like JavaScript.

I was able to reproduce it with "password++"
Online now: No Back to the top

Post

Posted
Rating:
#294
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Thanks!


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#295
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
You're right. Any of the following symbols were triggering a condition in our AJAX database details checker:

+
&
%

It happens in ocPortal too, I'm surprised it's gone so long undetected.

Thanks for reporting the issue, sorry for initial skepticism.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top

Post

Posted
Rating:
#296
Avatar
Standard member
Finncat is in the usergroup ‘Fan in action’
Strange thing, in my password there was no such characters, except # …

Good news, last night I managed to upgrade my ocPortal site to CompoSr using the upgrade wizard :) .
It was a lengthty operation, took at least a couple of hours to complete, but the result is success!!!

Now to new challenges…
Online now: No Back to the top

Post

Posted
Rating:
#297
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Whoops, add # to the list. The issue was we weren't applying URL encoding when generating our AJAX URL.

Good job :).


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Online now: No Back to the top
1 guest and 0 members have just viewed this.

Statistics

Users online:

Salman, Paul D, ManojSree, deepu_ms, Vaiva, gabriel58, babu, amit.nigam

Forum statistics:
  • 1,079 topics, 5,217 posts, 6,064 members
  • Our newest member is fubs
Birthdays:
Back to Top