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?

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.

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?

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.

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.

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.

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

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.

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

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.

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.

From “Setup wizard - Access denied for user”, 11th Mar 2016

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

Thanks!

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.

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…

Whoops, add # to the list. The issue was we weren't applying URL encoding when generating our AJAX URL.

Good job .