compatibility test fails

Thanks Rachel. I'm running 12 domains on this server, each of them with a MySQL DB and I can connect fine with all of them.

Testing the connection with this method works (same credentials):

<?php

$link = mysql_connect('localhost', 'zonech_mysql', 'password', 'zonech_perch');
if (!$link) {
    die('Connection failed: ' . mysql_error());
}
echo 'Connection successful';
mysql_close($link);

?>

Perch is using PDO to connect. Can you help me to narrow down the issue? As the code above works, it can't be MySQL.

Rachel, since I can connect to the database by creating a new PDO object like in the code provided above, a mysql error can be ruled out, otherwise that code would fail too.

For testing, I've opened PerchDB_MySQL.class.php and did hard code the credentials and got PASS: you're all set!

Thus, definitely not a connection problem. I hope you agree.

In retrospect, the first hint is already there in the error message by which I've opened this thread:

'PERCH_DB_USERNAME'@'localhost'

It puts out PERCH_DB_USERNAME which is the name string of the variable, not the value I've entered.

Obviously the values I enter in step1.php are not passed on to PerchDB_MySQL.class.php, despite step1.php checks for the input. That's something your PHP code has to handle. Of course if Perch tries to connect to the db with an empty string, it throws an error. It's just not my mysql configuration that's to blame for then.

So, how do we go on from here? Are you willing to look into it now? Is it even important, is Perch using the same method to pass on input from text boxes to the database as the compatibility tool?

Hi Drew - no htaccess, no rewrite rules.

No error messages, nothing in the error_log on the server. Output when loading step2.php directly:

The test has been unsuccessful

Reason Please provide a full set of database details. Server is the name or IP address of the server that runs MySQL. This is often localhost but not always. Check with your host. Database is the name of the database to use. When adding a new database, some hosting control panels prepend the account name to the name you specify, so double check. Username is the login name of a database user with permissions to use that database. Password is that user's password.

As we see, by loading it directly it complains not getting any input.

Hm, interesting result, in order to take a screenshot I was opening Internet Explorer, and it passed the test. My standard browser is Google Chrome (Version 35.0.1916.153 m, on Windows 8.1, 64 bit), and there it fails. I disabled all extensions, repeated the test, and it still fails.

I guess screenshots are unnecessary, as they display nothing dubious anyway.

Since I was on it, also checking with Firefox, it passes the test too.

Testing on a VM with Windows 7 32-bit / Google Chrome (Version 35.0.1916.153 m too) passes the test.

Clearing Cache and Cookies on Chrome / Win 8.1 doesn't change anything.

Really strange.

By the way, what irritates is also that I've tested the compatibility on another server, using the same Chrome Browser from my Windows 8.1 machine, and it passed. I just can't wrap my mind around how Chrome can interact differently with another server.

And on a third server, I got a different error message with localhost, but passed the test when I've used 127.0.0.1 instead, also with Chrome. That was definitely related to how mysql/php is configured on that server.

It's getting weirder: Chrome 35.0.1916.141 on my Android Nexus 7 v2 Tablet fails the test too.

Google Chrome on OS X 10.9.2 passes, as Safari on iPad does too.