• Resolved Samkhe

    (@samkhe)


    Hello,

    I already used Duplicator many time without any problem.
    But today, I’m trying to migrate a website on a new dedicated server but I get the error:

    Database connection failed
    Access denied for user :’xxx@localhost’ (using password: YES)

    Do you have an idea what could be the problem?
    My sql server is using socket, could it be the problem?

    Thanks for your help.
    Sam

    http://wordpress.org/extend/plugins/duplicator/

Viewing 7 replies - 16 through 22 (of 22 total)
  • I want to install the package in an already existing WP site. So the mysql user is already been used for the installation of the existing site!
    I checked the via phpmyadmin, so i am sure the user/password combination is correct.

    But i do not really understand what you mean by the hosts table being correctly. Could you please elaborate some more about that?
    Do you mean the hosts file on the provider server? But i do not have access to that. Or do you mean the hosts file on my local pc, from which i made the package and installer?

    This morning (i live in gmt+1) i started all over again, installing your duplicator-dev version again in my local machine and making a new package from my local setup, but still no success.

    What strikes me is that the installer, once copied to remote site, does not work correctly on the port number (localhost:3351).
    I have to modify the installer.php to force it to use port 3351 in order to successfully pass the connection test.
    I commented out lines 524 and 1188, and added this in the next lines:
    $db_port = ‘3351’;
    Then the connection test is successful, but i get still the above mentioned error when i start Run Deployment.

    Btw, i have also a site with a difgferent provider, who does not use port numbers for the connection with mysql db. There it works perfectly! But this provider still sypports mysql v4, hence the use of the port nr for v5. 🙁
    Hope you have some other suggestion…

    Extra info,
    In order to check the database access, i also installed a clean WordPress 3.7.1 version on the online site. (acct.koor-marcantus.nl)
    And that works flawlessly! So I get the impression that the database credentials and the database user rights should be OK.

    Next attempt.
    I followed your Manual Extraction method from the FAQ, but i did the extraction a litle bit differently, cause i do not know whether there is a ZipArchive available at the host.
    – I extracted the package.zip locally and transferred all files to a empty directory on the host. Also created a database with database user/pw. Checked this with a install of WordPress, which went perfectly, so database access is OK.
    – Removed the WordPress install, so i have an empty dir for the Duplivate process.
    – With ftp, i copied all files inclusive dir structure to the host dir.
    – Modified the installer.php to force it to use port 3351 for the database connection.
    – Started installer.php as described in the FAC for Manual Extraction.
    – Test for database connection was OK.
    – Running Run Deployment, with the Manual package extraction selected, resulted in the Database connection Failed error with server
    code: 200
    status: OK
    – Opening installer-log.txt link shows 0 information.

    What to do now…

    Hey Deltabert,

    You may have to submit a support ticket for this as I’m not 100% sure what the issue might be…

    Thanks~

    Hi Cory,

    I did submitted a support ticket.
    There is a work around possible, but i think maybe more (potential) users could benefit a solution on this issue. So will wait the reaction on the support ticket.

    Hi guys, I face pretty much the same.

    I have used duplicator many times without issues. Now I’m trying to copy TO an openshift account and I managed to pass the tests by changing the db_port values in the script.
    I get 504 errors though.
    I’m trying with a 10Mb package so that can’t be the issue.

    Deltabert, did you find a solution?

    Hey Apoikos,

    I wasn’t able to do too much to help out @deltabert as the time to debug some of these issues can consume hours and on some servers even days… I’m working on the next version really soon and will try and do some more testing around this issue. If you find any solutions or work-arounds let me know as I would appreciate the help with testing…

    Thxs

Viewing 7 replies - 16 through 22 (of 22 total)

The topic ‘Database connection failed’ is closed to new replies.