Really strange issue with Digital Ocean

  • Here’s my environment;

    Digital Ocean Ubuntu 14.04LTS droplet VPS
    PHP Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
    with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies

    mySQL Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.3

    I was and have been happily building up a blog and came to it and was unable to login to wp-login via the same credentials I’ve always used. No matter what process I use to reset the password, it doesn’t ‘take’

    I’ve replaced the wp-login with a new one from a fresh WP install (modifying the appropriate section) but that didnt work

    I’ve used WP Cli to ammend the user, directly. That does not work

    I’ve gone into PHPMYADMIN and modified the user, re-hashing a fresh MD5 password – that doesnt work

    I’ve built a new user in mySQL directly, still cant get in.

    I’ve destroyed the existing user, and built a new one in myphpadmin but still cant access with any password I set.

    I’ve ran various ’emergency’ and ‘password reset’ scripts to no avail

    I’ve disabled all plugins

    I’ve modified the theme ini file to attempt to allow entry but that does not work

    in every instance, for every change, I’ve restarted mysql and apache and in all cases rebooted the VM

    Help!? Please!?

Viewing 15 replies - 1 through 15 (of 17 total)
  • Thread Starter Mario De’Cristofano

    (@mariodc1)

    in terms of troubleshooting, I’ve grepped the logs for my incoming IP to see where its failing at the login but there’s nothing relevant. In fact, there’s nothing there at all.

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    really desperate. Could any one offer some advice?

    Have you tried from a different browser, device, machine?

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    yes tried several new/different machines & devices, with cleared DNS caches & from different IPs. Really frustrated ??

    OK, I have to ask because I’ve done this myself a few times. Are you editing the right database?

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    thanks Dave, really appreciate just talking it through with someone. Yes, definitely the correct database as its a single VM with just this instance of WordPress on it. I’m editing the Wp_users dBase and can see the admin user there.

    In other instances where I’ve built a user from scratch via myPHPAdmin, I’ve of course, also touched wp_meta

    I’m pretty confident there is the only one database to touch, Wp_users right?

    How about using wp-cli to create a brand new user with admin rights?

    wp user create ...etc

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    I used wp cli to create a new user. I checked and that had populated the database. I couldn’t reverse the MD5 password so I put in a new one and selected MD5, (as I know PHPMyadmin automatically upgrades the plan text to the hash) but that didn’t work

    Just going to try restarting mysql

    Why are you immediately editing the password? Can’t you just use --user_pass=<password> when creating the user with wp-cli?

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    restarting MySQL and Apache didn’t work out for me either!

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    ok I’ll try that now Dave

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    I updated the user I created, restarted MySQL and apache – no joy whatsoever. Here’s my output

    wp –allow-root user create mariodc [email protected] –role=administrator

    wp –allow-root user update 5 –user_pass=mariopass

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    my fear is I don’t know what I’m doing, and I’m doing something stupid. Because I’ve done everything so many times, I don’t want to miss anything. But I’ve tried all these approaches after a fresh nights sleep and I just can’t work it out.

    Thread Starter Mario De’Cristofano

    (@mariodc1)

    Digital Ocean have been great, even they have tried to help but they are stumped. But through them, I’ve eliminated its probably not that the Wp installation hasn’t become unbound in any way from the database or there’s an inherent issue with the software stack.

    Very strange. How about setting up a new WordPress install on a sub-domain or in a sub-directory. Maybe even just renaming the current site directory and creating a new directory using the old name, then the hosting will be the same. Create a new DB and just carry out a conventional install.

    If all goes well, we know your LAMP stack is AOK and that it’s something to do with your current WordPress install.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Really strange issue with Digital Ocean’ is closed to new replies.