• Hi,
    I’m moving my site from local to live, but i’ve had some issues with connecting to my new database. I’ve also tried a “clean” wp install and it still wont connect to database.
    I am 100% sure I’ve entered the right database name, address and password.

    I dont know if this is relevant, but I’ve cleaned the domain from ExpressionEngine and the database I’m going to use is the same that was once used with EE. (I have deleted all the tables from the database)

    server code: 200
    status: OK
    response:
    INSTALL ERROR!
    DATABASE CONNECTION FAILED!
    The server requested authentication method unknown to the client

    https://wordpress.org/plugins/duplicator/

Viewing 15 replies - 1 through 15 (of 15 total)
  • Mark

    (@mharris_wlaes)

    I’m having exactly the same problem.

    I’ve taken the dbname, host location, db username and password from the wp_config file on my new GoDaddy install so I know these are correct.

    Help!?!

    JohnnyP

    (@johnpottermedia)

    same thing has happened to me on ipower.com server.
    What happened to the plugin? It was awesome until today!

    Hey Guys,

    Nothing has changed with 0.5.6 for the last few months and the next version will also have no changes around this portion of the plugin, this is most likely related to how the connect is made to your host. I have test on 4 separate hosts without issues…

    I would double check with your host and see if they have changed anything. They will give you the exact credentials you need to connect. Every host is different and needs the exact settings or else it won’t work. The test connection call is a very generic PHP call so their really isn’t anything in the plugin that can be updated/fixed…

    Also be sure your host has not changed anything around how they use the mysqli lib.

    Hope this helps!

    I’d like to echo this problem.

    To help us hone in on a solution, a couple of questions to the others: Who is your host? Looking to duplicate a single site or an entire multisite network? which version of WordPress are you all working with?

    @cory: you first mention “exact credentials” and then mention “exact settings” – are you referring to something beyond the credentials when you say “settings” or were you using the terms interchangeably? Should our host/s have not changed anything around mysql lib, what would be your next guess.. seems interesting to have four separate parties all report suddenly experiencing the same problem for the first time within the last week.

    JohnnyP

    (@johnpottermedia)

    Just learned it was a problem at my hosting company. They updated the php from 5.3 to 5.5 and when they turned it back to 5.3 for me the plugin worked fine. Hope this helps.
    BTW. I love the Duplicator Plugin and willing to pay for pro version

    My hosting service is Hostgator and php is 5.4.32. I haven’t tested the recent version of Duplicator yet, but I’m wondering if anyone else has version 5.4.32 and has updated Duplicator without any problems. Thanks 🙂

    The code around the installers “Test Connection” is pretty basic and hasn’t changed in several versions, The call basically uses the mysqli_connect function.

    If its not working on a specific PHP version then it may be that when that PHP version was built it wasn’t compiled with mysqli lib support. You would need to double check with your host and you can also validate with a php_info call.

    If you have validated the credentials with you host and they say their good to go and the mysqli lib is installed, I can have a look at your system, but I’m not quite sure what I can do at this point…

    okay.. i was actually trying to move a multisite network. turned out that when I commented out the multisite lines in wp-config, I could connect (albeit, only to site-1). Still chasing down the issue which will likely have something to do with updating references to the base URL in the DB or a clash somewhere of site IDs between site and DB. i.e. nothing to do with this plugin and only echoes Corey’s previous claims that this plugin isn’t the best for multisite 😉 I knew the risk I was taking and gambled anyway.

    For future multisite folks that try to move using this otherwise awesome plugin, and that encounter this problem, all is not lost! I’d suggest also checking out the below two links:
    http://goo.gl/8FkqW9
    http://goo.gl/rSvK6L

    I’d otherwise had plans to test whether simple moves (i.e. single site backup & redeploy) were still working for me or not, but I haven’t had the chance – my assumption is it’ll work fine and it was only that I was trying to be too clever.

    hope you guys can get your moves sorted out!

    Thanks for posting the work-arounds @smelsworst!

    Cheers~

    I resolved mine by doing a manual move of my network, I haven’t retested with Duplicator but I have a suspicion the plugin works ‘fine’ for moving a multisite network, except that the user just has to go into their DB and update a number of links that Duplicator doesn’t get, namely:

    – wp_blogs
    – wp_site
    – wp_options
    _ wp_x_options (one for each blog in the network)

    Ben

    I think a better option for MU sites is NS Cloner. Duplicator isn’t really wired for MU setups at this point in time.

    NS Cloner is awesome for copies of blogs/sites within a network, but the use case I’m describing is about copying/backing-up/moving the network (incl. to a different server or directory). From what I can tell (and god knows I’ve tried!), NS Cloner isn’t up to that task.

    I think Duplicator can do the job, it’s just not plug-and-play like it is on single sites – so admins have to be happy to jump into the DB. after running installer.php

    Hey smelsworst,

    If you want to put together a list of things that you are having to do manually and just send me an email or put it in a ticket here:
    lifeinthegrid.com/support (refer to this thread)

    I’ll see if I can improve the migrations for MU…

    Cheers~

    It’s probably a little dependent upon which plugins are installed/etc.. but the main things are:

    DB Changes:
    wp_site: update values for domain and path
    wp_blogs: update values for domain and path for each sub-site/blog
    wp_x_options (one for each sub-site/blog, where x is the blog-id): update values for option_name like ‘siteurl’, option_name like ‘home’, option_name like ‘upload_url_path’ and there’ll be others if you’ve got things like woocommerce, etc. installed, but the user can also update these via the network admin>sites>SITE_NAME>edit>settings themselves..

    wp-config.php will need to be updated:
    define(‘DOMAIN_CURRENT_SITE’, ‘NEWVALUE’);
    define(‘PATH_CURRENT_SITE’, ‘NEWVALUE’);

    the rest of the multisite lines in wp-config.php should not need to be changed.

    AND, seems that many users (myself included) have issues with the .htaccess file, so that might also need to be updated, see here: http://codex.wordpress.org/Multisite_Network_Administration#.htaccess_and_Mod_Rewrite

    once you’ve done that it “should” work, but for me, it’s still not – likely something up with the rewrite rules in .htaccess. time for the ametur to step out of the way and pay for a professional!

    hope that helps.

    Thanks Ben! I’ll also look at the info from linked in…

    Cheers~

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘DATABASE CONNECTION FAILED!’ is closed to new replies.