Jump to content

Database connect 1und1 dbxxx.db.1and1.com failed


hheyne
 Share

Recommended Posts

Hello, I want to install pw 2.5.29dev on a 1and1 server. The installations goes into 

Database connection information did not work.

and also 

SQLSTATE[HY000] [1045] Access denied for user 'dboxxxx'@'xxx.xxx.xxx.xxx' (using password: YES)

I tried the parameters with adminer.php and everything works fine. Is there something to tweak in the install.php?

Thanks

Henning

P.S. I have databasename, username, password and servername. No unix-socket-connection.

Link to comment
Share on other sites

Hi cstevensjr, I used the hostname. In the error message the hostname is translated to the IP. I tried it with the port behind the IP and also with the port behind the hostname. Both fails. If I try it with the IP it goes into „connection refused”.

Link to comment
Share on other sites

It's a mass hoster. There are no specific rights for databases :-( I solved it now temporary with a database connection via Hetzner. So the site is now online and I have time to solve the problem.

Link to comment
Share on other sites

Hi Henning,

I had similar problems with 1&1 and fixed them by installing PW locally, then moving everything to the server (db via phpmyadmin), changing the config.php with the 1&1 db-credentials and finally adding the following line in the config:

$config->dbSocket = '/tmp/mysql5.sock';

Not sure where I found it, but worked for me :-)

  • Like 6
Link to comment
Share on other sites

Hi Robert,

thank you for your post. This is/was my plan b :-) I'll try it and wether if it works or not I will report the result so that others won't have such trouble.

Link to comment
Share on other sites

  • 3 weeks later...

I had the same problem with iPage.

"Database connection information did not work."

and also 

"SQLSTATE[HY000] ..."

The fix was getting the correct hostname. What seems to work for iPage is this host (replace username with your iPage username):

username.ipagemysql.com

The port is 3306.

I asked my hosting service and they gave it to me right away.

Link to comment
Share on other sites

Today I found the time to move the database to 1und1. I found that the given password has two interesting characters: " and '

This was the problem. I simply escaped one of them in the config file. Never use passwords with " or '.

Now I have another problem. I will post it in a seperate thread.

Link to comment
Share on other sites

  • 4 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...