Moving the dataabase

[dafnie]

Hi

I have imported a database with testdata in my testinstallation of Espo and changed the SQL setting in config.php, but the login system response dialog says that the user password is now wrong. Is there any way to correct this?
I found the incrypted user-password in the database but I can't figure how to decrypt them?

[yuri]

Hi,

You should carry over passwordSalt and cryptKey from config.php

[dafnie]

Great. it worked perfectly.
I just carried over passwordSalt I couldn't find cryptKey. Anyway it worked..

Thanks..

[ziondevil]

can you explain how to carry over?

[tarasm]

All passwords are encrypted with passwordSalt from data/config.php

[tarasm]

ziondevil, did you move files and database dump?

can you explain how to carry over?

[ziondevil]

yes move all files and dump the entire database

[tarasm]

It should work fine. Please check if "siteUrl" from data/config.php is correct.

[ziondevil]

also correct

[tarasm]

Something wrong with your files or database dump. All you need for moving:
1. Archive EspoCRM directory,
2. Dump MySQL database.
3. Copy them on a new hosting/server,
4. Unarchive files,
5. Import the database dump
6. Correct siteUrl" in the data/config.php if a domain name was changed.

Note: if you see an install process after moving to a new server, something wrong with your file archive (check if "data" directory exists).

Did you do as described above?

[ziondevil]

all the above is correct
:/


I have all files with the correct permissions, espo can read the database...


also i'm trying to reset the password

[2016-07-12 11:51:09] Espo.ERROR: Display Error: Connection refused, Code: 500 URL: /api/v1/User/passwordChangeRequest [] []

[tarasm]

Are you sure that MySQL user is correct and has all privileges?

[ziondevil]

I have repetead all the steps and mysql user with all privileges.

Also if i try to reset the password 500 conecction refused.

Worng username and password

[dafnie]

Have you checked the databasesetting in config file

[iscon]

I can confirm that it works correctly with 415, did it a couple of times within one server and between different servers.
Check data/logs for any clues, then check the apache error log. Most likely you'll find a verbose explanation there. My guess is that your permissions on the espo directory are wrong - chown recursively to the Apache user (if on your own machine) or to your ftp user on webspache. Set permissions to 755 for all files and dirs.