Login incorrect after migrating host (from hosted v6 to local v8 vm)

[p0ddie]

Hi,

I'm trying to move an old Espo 6.1.10 installation that is hosted externally onto a Linux Turnkey vm with Espo 8.0.6 already installed: https://www.turnkeylinux.org/espocrm

My problem is that after I follow the instructions to make a backup with the official backup script on the source host and then restore the backup on the target host, I can't log in with my admin user. Here's what I did:

- created a backup with the backup script from https://docs.espocrm.com/administrat...p-and-restore/
- installed turnkey vm on my host
- set and wrote down all passwords
- check if the original espo install on the target works (it does)
- backup data/config.php and config-internal.php from original install (from my source, I do not seem to have a config-internal.php, only config.php. This is a 10 year old Espo install that has been updated as far as possible on this hosted vm)
- scp'd my backup to the target turnkey host
- untared backup, restored files to /var/www/espocrm
- mysql --user=espocrm --password=MYPASSWORD espocrm < db.sql - I used credentials found in the original target config.php
- modified my freshly restored config.php to match the sql credentials, also copied the password salt

When I point my browser to the target Espo, I get the correct custom name of the Espo install, the login window looks the way it looks on the original, but when I try to log in with my admin account (account exists in Maria db) then I get "Username/Password wrong". The same user/pass works on the source.

What did I do wrong? Thanks!

[lazovic]

Hi p0ddie,

You can try to change admin password by using the following command in CLI: https://docs.espocrm.com/administrat...-user-password.

This case could happen for a variety of reasons.
You may have more serious problems if you have transferred the database and files from an instance with old EspoCRM version installed to a very new one (e.g., from v6.1.10 to v8.0.6). In such cases, you need to either first upgrade the EspoCRM version for the old instance on old server and only then transfer all files and the database to another server with clean EspoCRM installed, or transfer the files and database from an unupgraded version to the same old version on a new server and only then upgrade EspoCRM there.

[p0ddie]

Thanks, I'll try with an older version of Turnkey Linux with version 6.1. I hope it works this time

[yuri]

Not sure what is wrong. But you can set new password for users via CLI: https://docs.espocrm.com/administrat...-user-password

[p0ddie]

Setting the password via cli is what I tried first. It didn't work. What however worked was hunting down an older version of the Turnkey Linux Espo VM that was closer to what I have installed (6 vs 6.1 or something). I could scp the backup over directly into my new vm and restore everything. So for anyone reading this, just either update your source before you migrate or use the same/similar version when you restore the backup.