EspoCRM migrated to other server. User or password is incorrect

[sazicem]

One more hint: When you install the fresh instance, create an administrator account with a user name that is DIFFERENT than the admin user name that tou have in your database, so when you import the data to the new instance there will be no conflict becasue you are importing a user with the same name.

After you have substituted the settings-internal.php with your orignal version, the new administrator account will not be accesible becasue its password wash hashed with a different key.

Thanks a lot.

[telecastg]

One more hint: When you install the fresh instance, create an administrator account with a user name that is DIFFERENT than the admin user name that tou have in your database, so when you import the data to the new instance there will be no conflict becasue you are importing a user with the same name.

After you have substituted the settings-internal.php with your orignal version, the new administrator account will not be accesible becasue its password wash hashed with a different key.

[telecastg]

You're welcome, under Espo 7 the database parameters are stored in config-internal.php

[sazicem]

My preferred solution when something is not fixable within a reasonable period of time is simply to dump everything and start from scratch.

Check this post for instructions: https://forum.espocrm.com/forum/inst...1187#post61187

Please consider the following before opting for this option:

I am not sure if it is still possible to download a fresh installation of Espo 6.1.10 but if not, you will need to upgrade.

If you have code customizations (aside from anything done through the Admin GUI) you might have to iron out some issues caused by the extensive re-factorization to the codebase from Espo 6 to Espo 7.

It is possible to replicate everything as long as you have the following:

sql database export script (to load the database)

copy of the data/upload folder (to recover attachments and images)

copy of the config.php script (to recover setting preferences, like menu structure, etc)

copy of the config-internal.php script (to recover hashes and secret keys for passwords)

copy of folder custom/Espo/Custom and folder client/custom (to recover customizations made through the GUI)

Best of luck !

Thank you for help.
I have already installed a new version espo 7.4.3. Now I'm mentally preparing to manually make all the changes in espo 6.1.10. according with yours steps. I hope it will work.

I notice that config.php from version 7.4 differs from config.php from 6.10. In config.php version 7.4.3 installed on a xamp windows, I cannot find the name of the database, the user, the user password. Where can I change the connection data to another database in v7.4.3?

[esforim]

I hope that fake key!

[telecastg]

My preferred solution when something is not fixable within a reasonable period of time is simply to dump everything and start from scratch.

Check this post for instructions: https://forum.espocrm.com/forum/inst...1187#post61187

Please consider the following before opting for this option:

I am not sure if it is still possible to download a fresh installation of Espo 6.1.10 but if not, you will need to upgrade.

If you have code customizations (aside from anything done through the Admin GUI) you might have to iron out some issues caused by the extensive re-factorization to the codebase from Espo 6 to Espo 7.

It is possible to replicate everything as long as you have the following:

sql database export script (to load the database)

copy of the data/upload folder (to recover attachments and images)

copy of the config.php script (to recover setting preferences, like menu structure, etc)

copy of the config-internal.php script (to recover hashes and secret keys for passwords)

copy of folder custom/Espo/Custom and folder client/custom (to recover customizations made through the GUI)

Best of luck !

[sazicem]

sazicem ,

Maybe the following thread will be helpful:

https://docs.espocrm.com/administration/iis-server-configuration/

Thanks Vadym,

There is 2 instances I've tried to migrate.
1st - VM Ubuntu
2nd - VM Windows 11 ( for issue replay)

Same problem on both of them.. I lose all day on this issue.. bad for me.

No solution yet

[Vadym]

sazicem ,

Maybe the following thread will be helpful:

https://docs.espocrm.com/administration/iis-server-configuration/

[sazicem]

Hi sazicem,

Perhaps you don't copied 'passwordSalt', 'cryptKey', and 'hashSecretKey' (if it exists) values from backup config.php to a newly installed instance.
After replacing, rebuild via CLI and set new password for admin:

https://docs.espocrm.com/administration/commands/#rebuild

https://docs.espocrm.com/administration/commands/#setting-user-password

I find that lines in the config-internal. Same as source instance config.php

'hashSecretKey' => '857e4aed1274e0202c343f809afd7dbb',
'passwordSalt' => 'ecda6d0e25411446',
'cryptKey' => 'e112e4323a69d03a05962225d751a728',

I've rebuilded via CLI
I cannot add admin user or set user password. docs ar for ESPOCRM version 7. This commands works for ESPO v6?

PS If I install old instance to new instance on same server.. everythig ok. If I change server.. did not !

[sazicem]

Hi @sazicem,

in the config-internal you can find the following lines:
'passwordSalt' => '89131c4fb2831b2a',
'cryptKey' => '26ce13f3a19107a9a0d73bbbce1dd5d3',
'hashSecretKey' => '0d0be064886e6ea18be65c6899abf0b3',

Copy them fro your current working instance into your new instance if not done already.

Hope that helps.

I find that lines in the config-internal. Same as source instance config.php

'hashSecretKey' => '857e4aed1274e0202c343f809afd7dbb',
'passwordSalt' => 'ecda6d0e25411446',
'cryptKey' => 'e112e4323a69d03a05962225d751a728',

Still didn't work

[sazicem]

Hi sazicem,

Try specifying Permissions again: https://docs.espocrm.com/administrat...n/#permissions.

The new CRMESPO instance is on Windows OS. Full permissions already.

[STARFLEET]

@Vadym: :-) 1 minute faster than me :-)

[STARFLEET]

Hi @sazicem,

in the config-internal you can find the following lines:
'passwordSalt' => '89131c4fb2831b2a',
'cryptKey' => '26ce13f3a19107a9a0d73bbbce1dd5d3',
'hashSecretKey' => '0d0be064886e6ea18be65c6899abf0b3',

Copy them fro your current working instance into your new instance if not done already.

Hope that helps.

[Vadym]

Hi sazicem,

Perhaps you don't copied 'passwordSalt', 'cryptKey', and 'hashSecretKey' (if it exists) values from backup config.php to a newly installed instance.
After replacing, rebuild via CLI and set new password for admin:

https://docs.espocrm.com/administration/commands/#rebuild

https://docs.espocrm.com/administration/commands/#setting-user-password

[victor]

Hi sazicem,

Try specifying Permissions again: https://docs.espocrm.com/administrat...n/#permissions.