Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. WordPress (Developer)
  3. Cannot login to site after migrating a wordpress.com site to Cloudron

Cannot login to site after migrating a wordpress.com site to Cloudron

Scheduled Pinned Locked Moved Solved WordPress (Developer)
14 Posts 5 Posters 1.8k Views 5 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • jdaviescoatesJ Offline
      jdaviescoatesJ Offline
      jdaviescoates
      wrote on last edited by jdaviescoates
      #1

      Hi all,

      I just used https://wordpress.org/plugins/all-in-one-wp-migration/ to migrate https://gooplearn.wpcomstaging.com/ (a wordpress.com site to https://goop.development.coop/

      It's all worked great, aside from one rather big issue: I can no longer login to the website.

      I contacted servmask (the people who make the great migration plugin linked to above) and they quickly replied suggesting I use their reset password tool as described here:

      But that didn't work either:

      So, I'm guessing the issue must be something to do with the Cloudron environment.

      Help!

      (tagging @d19dotca as I know he's used this plugin quite a bit 🙂 )

      I use Cloudron with Gandi & Hetzner

      1 Reply Last reply
      0
      • jdaviescoatesJ Offline
        jdaviescoatesJ Offline
        jdaviescoates
        wrote on last edited by jdaviescoates
        #8

        WP CLI to the rescue!

        Solved it by opening the app web terminal and doing this:

        wp cache flush

        Then I could login again!

        Now to start again with a clean slate in case my tinkering has left a mess

        Edit: turns out it wasn't just flushing the cache that that fixed it! Seems I had to use the reset password tool first and then flush the cache and then login using that new login in a private browsing tab, and then I could login and then I was away.

        So, basically what resolved this was:

        1. using the resetpass.php tool to reset the admin user pw to servmask
        2. flushing the cache using wp cli i.e. type wp cache flush into the app web terminal
        3. login in an incognito/ private tab using the credentials from the resetpass.php tool
        4. editing/ updating the passwords of other users (even after getting access none of the old pw worked before anymore)
        5. delete the resetpass.php tool

        (but perhaps the suggestion by @micmc would've worked too. Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.)

        I use Cloudron with Gandi & Hetzner

        1 Reply Last reply
        0
        • jdaviescoatesJ Offline
          jdaviescoatesJ Offline
          jdaviescoates
          wrote on last edited by
          #2

          I figured I'd try to use these MySQL instructions to adding a new user directly into the database:

          https://wp-qa.com/wordpress-cannot-login-after-migrating-with-all-in-one-wp-migration

          But even though I can get into MySQL using the Terminal, I can't use those commands as I don't know the db name and password.

          I use Cloudron with Gandi & Hetzner

          1 Reply Last reply
          0
          • jdaviescoatesJ Offline
            jdaviescoatesJ Offline
            jdaviescoates
            wrote on last edited by jdaviescoates
            #3

            Using wp cli I can see all the users are there, but none of them can login

            /app/code# wp user list +-----------+---------------+---------------+----------------------------------+---------------------+---------------+ | ID | user_login | display_name | user_email | user_registered | roles | +-----------+---------------+---------------+----------------------------------+---------------------+---------------+ | 217402542 | gooplearn | gooplearn | xxx@xxx.xxx | 2022-02-18 22:11:09 | administrator | | 217402544 | jdaviescoates | jdaviescoates | josef@xxx.xxx | 2022-08-09 16:00:53 | administrator | | 217402543 | josef | josef | josef@xxx.xxx | 2022-08-09 15:59:24 | administrator | +-----------+---------------+---------------+----------------------------------+---------------------+---------------+

            But none of the credentials for those users work.

            What's going on?!? 😞

            I use Cloudron with Gandi & Hetzner

            girishG 1 Reply Last reply
            0
            • jdaviescoatesJ jdaviescoates

              Using wp cli I can see all the users are there, but none of them can login

              /app/code# wp user list +-----------+---------------+---------------+----------------------------------+---------------------+---------------+ | ID | user_login | display_name | user_email | user_registered | roles | +-----------+---------------+---------------+----------------------------------+---------------------+---------------+ | 217402542 | gooplearn | gooplearn | xxx@xxx.xxx | 2022-02-18 22:11:09 | administrator | | 217402544 | jdaviescoates | jdaviescoates | josef@xxx.xxx | 2022-08-09 16:00:53 | administrator | | 217402543 | josef | josef | josef@xxx.xxx | 2022-08-09 15:59:24 | administrator | +-----------+---------------+---------------+----------------------------------+---------------------+---------------+

              But none of the credentials for those users work.

              What's going on?!? 😞

              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #4

              @jdaviescoates Could it be because the app was installed with LDAP enabled?

              jdaviescoatesJ 1 Reply Last reply
              1
              • girishG girish

                @jdaviescoates Could it be because the app was installed with LDAP enabled?

                jdaviescoatesJ Offline
                jdaviescoatesJ Offline
                jdaviescoates
                wrote on last edited by
                #5

                @girish nope, not that. I thought the same but have already tried again leaving access to the app.

                I use Cloudron with Gandi & Hetzner

                1 Reply Last reply
                0
                • robiR Offline
                  robiR Offline
                  robi
                  wrote on last edited by
                  #6

                  I remember having a similar issue, and I ended up simply changing the admin pw via the db commands to nothing, then logging in and updating it.

                  Conscious tech

                  jdaviescoatesJ 1 Reply Last reply
                  0
                  • robiR robi

                    I remember having a similar issue, and I ended up simply changing the admin pw via the db commands to nothing, then logging in and updating it.

                    jdaviescoatesJ Offline
                    jdaviescoatesJ Offline
                    jdaviescoates
                    wrote on last edited by jdaviescoates
                    #7

                    @robi thing is, I've already used that pw reset tool to effectively do that. The problem is that for some reason correct credentials just don't work.

                    I use Cloudron with Gandi & Hetzner

                    micmcM 1 Reply Last reply
                    0
                    • jdaviescoatesJ Offline
                      jdaviescoatesJ Offline
                      jdaviescoates
                      wrote on last edited by jdaviescoates
                      #8

                      WP CLI to the rescue!

                      Solved it by opening the app web terminal and doing this:

                      wp cache flush

                      Then I could login again!

                      Now to start again with a clean slate in case my tinkering has left a mess

                      Edit: turns out it wasn't just flushing the cache that that fixed it! Seems I had to use the reset password tool first and then flush the cache and then login using that new login in a private browsing tab, and then I could login and then I was away.

                      So, basically what resolved this was:

                      1. using the resetpass.php tool to reset the admin user pw to servmask
                      2. flushing the cache using wp cli i.e. type wp cache flush into the app web terminal
                      3. login in an incognito/ private tab using the credentials from the resetpass.php tool
                      4. editing/ updating the passwords of other users (even after getting access none of the old pw worked before anymore)
                      5. delete the resetpass.php tool

                      (but perhaps the suggestion by @micmc would've worked too. Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.)

                      I use Cloudron with Gandi & Hetzner

                      1 Reply Last reply
                      0
                      • jdaviescoatesJ jdaviescoates marked this topic as a question on
                      • jdaviescoatesJ jdaviescoates has marked this topic as solved on
                      • jdaviescoatesJ jdaviescoates

                        @robi thing is, I've already used that pw reset tool to effectively do that. The problem is that for some reason correct credentials just don't work.

                        micmcM Offline
                        micmcM Offline
                        micmc
                        wrote on last edited by
                        #9

                        @jdaviescoates You might have overwritten the wp-config.php file created by cloudron install, with the wp-config.php file in your migration file.

                        There's nothing to prevent you from redoing the process since you already have the migration file on hand.

                        So, simply scrap this install. Reinstall WordPress with Cloudron and make a backup of the wp-config.php file before migrating. Then upload and overwrite the wp-config.php file with the one created with cloudron that you've just backed up.

                        All should work as normally now.

                        Ignorance is not an excuse anymore!
                        https://AutomateKit.com

                        jdaviescoatesJ 1 Reply Last reply
                        1
                        • micmcM micmc

                          @jdaviescoates You might have overwritten the wp-config.php file created by cloudron install, with the wp-config.php file in your migration file.

                          There's nothing to prevent you from redoing the process since you already have the migration file on hand.

                          So, simply scrap this install. Reinstall WordPress with Cloudron and make a backup of the wp-config.php file before migrating. Then upload and overwrite the wp-config.php file with the one created with cloudron that you've just backed up.

                          All should work as normally now.

                          jdaviescoatesJ Offline
                          jdaviescoatesJ Offline
                          jdaviescoates
                          wrote on last edited by jdaviescoates
                          #10

                          @micmc thanks, that might well have done it too, who knows?

                          Perhaps I'll give that a try at some point!

                          Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.

                          I use Cloudron with Gandi & Hetzner

                          micmcM 1 Reply Last reply
                          0
                          • jdaviescoatesJ jdaviescoates

                            @micmc thanks, that might well have done it too, who knows?

                            Perhaps I'll give that a try at some point!

                            Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.

                            micmcM Offline
                            micmcM Offline
                            micmc
                            wrote on last edited by micmc
                            #11

                            @jdaviescoates said in Cannot login to site after migrating a wordpress.com site to Cloudron:

                            @micmc thanks, that might well have done it too, who knows?

                            Perhaps I'll give that a try at some point!

                            Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.

                            Perhaps I'll give that a try at some point!

                            Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.

                            Huh? That's just impossible mate.
                            You see, wp-config files holds database credentials. So when you migrate form another server, the wp migration file will carry the wp-config file with db connect credentials from that server.

                            Now, you need to install a fresh WordPress before migrating the site, so how can the cloudron install provide the sames db connect credential as the other site had? Might have you mixed the wp-config files?

                            Ignorance is not an excuse anymore!
                            https://AutomateKit.com

                            jdaviescoatesJ 1 Reply Last reply
                            0
                            • micmcM micmc

                              @jdaviescoates said in Cannot login to site after migrating a wordpress.com site to Cloudron:

                              @micmc thanks, that might well have done it too, who knows?

                              Perhaps I'll give that a try at some point!

                              Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.

                              Perhaps I'll give that a try at some point!

                              Edit: nope, that wouldn't have helped - the wpconfig.php files before and after migration were identical.

                              Huh? That's just impossible mate.
                              You see, wp-config files holds database credentials. So when you migrate form another server, the wp migration file will carry the wp-config file with db connect credentials from that server.

                              Now, you need to install a fresh WordPress before migrating the site, so how can the cloudron install provide the sames db connect credential as the other site had? Might have you mixed the wp-config files?

                              jdaviescoatesJ Offline
                              jdaviescoatesJ Offline
                              jdaviescoates
                              wrote on last edited by jdaviescoates
                              #12

                              @micmc said in Cannot login to site after migrating a wordpress.com site to Cloudron:

                              That's just impossible mate.

                              Nah, it's simple really. Evidently the migration plugin doesn't overwrite the wpconfig.php file when it does the migration (which makes sense as like you say, that would mess with the db connection and break everything)

                              Anyways, I've sorted my issue by using the resetpass.php tool, using wp cli to flush the cache then logging in in a private/ incognito tab, then changing the passwords of the other users and changing the one that was changed by resetpass.php back to what it was before, then deleting the resetpass.php tool

                              Seems the issue is somehow the migration plugin borked all the passwords.

                              I use Cloudron with Gandi & Hetzner

                              micmcM 1 Reply Last reply
                              1
                              • jdaviescoatesJ jdaviescoates

                                @micmc said in Cannot login to site after migrating a wordpress.com site to Cloudron:

                                That's just impossible mate.

                                Nah, it's simple really. Evidently the migration plugin doesn't overwrite the wpconfig.php file when it does the migration (which makes sense as like you say, that would mess with the db connection and break everything)

                                Anyways, I've sorted my issue by using the resetpass.php tool, using wp cli to flush the cache then logging in in a private/ incognito tab, then changing the passwords of the other users and changing the one that was changed by resetpass.php back to what it was before, then deleting the resetpass.php tool

                                Seems the issue is somehow the migration plugin borked all the passwords.

                                micmcM Offline
                                micmcM Offline
                                micmc
                                wrote on last edited by
                                #13

                                @jdaviescoates 👍 😊

                                Ignorance is not an excuse anymore!
                                https://AutomateKit.com

                                1 Reply Last reply
                                0
                                • d19dotcaD Offline
                                  d19dotcaD Offline
                                  d19dotca
                                  wrote on last edited by
                                  #14

                                  I think I had that issue a long time ago and it was something to do with the Auth-LDAP plugin not saving the passwords in the database, and so if that plugin gets disabled then we can't login 'offline'. The WP CLI will be the best way to work around it I think, as it seems you did already also with the password reset tool too! 🙂

                                  --
                                  Dustin Dauncey
                                  www.d19.ca

                                  1 Reply Last reply
                                  2
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                    • Login

                                    • Don't have an account? Register

                                    • Login or register to search.
                                    • First post
                                      Last post
                                    0
                                    • Categories
                                    • Recent
                                    • Tags
                                    • Popular
                                    • Bookmarks
                                    • Search