Bug #76022
closed
Database Connection don't work on 1&1 Servers
Added by Paul Kamma over 8 years ago.
Updated over 8 years ago.
Description
After filling out the Database credentials in the "Database connection" step it always returns the error.
"Database connect not successful
Connecting to the database with given settings failed. Please check."
It's a 1&1 managed server with mySql 5.5..
So there is no need to use the socket server so i used the TCP/IP connect with localhost and default port.
What I've noticed is that when I copy paste the DBConnection codefrom the DatabaseConnection.php into an empty php file and set the values it connects.
$host_name = 'localhost';
$database = null;
$user_name = "USERNAME";
$password = "PASSWORD";
$link = mysqli_init();
$test = $link->real_connect(
$host_name,
$user_name,
$password
);
var_dump($test);
// returns true
When I paste the exact same code into the DatabaseConnection.php it returns false
typo3 7.6.6.
I am not sure if this is a valid bug report. It's hard to tell what goes wrong with the 1&1 hosting servers or reproduce the issue with this information only. Maybe you should contact support first if you say it's "managed"?
I already did it. So far the DB Connect only doesn't work with typo3 7.
I think you will have to be more specific and find what is special about your setup. TYPO3 7 can certainly connect to mysql 5.5 with no issues.
That's the problem. There is nothing special.
I followed the Installation Process, created the symlinks, booted up the install tool and then stuck at the Database setup.
- Status changed from New to Needs Feedback
This is really strange, never had a problem connecting to MySQL on 1&1 Servers. Could you try changing localhost to 127.0.0.1 to force TCP/IP connections instead of auto-detection in the PHP MySQL driver.
Ok that's pretty embarrassing. Reverted all Changes I made and now it works. Maybe my Hoster changed something without telling me _
Why dies this only happens after a Bug was created or a Forum post was made.
But now I get this message after going to the backend.
Oops, an error occurred!
TYPO3 Fatal Error: The current username, password or host was not accepted when the connection to the database was attempted to be established!
Nevermind .. everything is fine. Sorry for making false alarm :)
- Status changed from Needs Feedback to Closed
Also available in: Atom
PDF