Moved to New Server Admin Log-In Fails

I install suteCRM8 on a production server and decided I would rather have it on my local server so I searched for how to do that and got the move made with help from the community Forum, Thank you, although I can not log-in as admin.
I reset the admin password using the SQL statement: update users set user_hash =md5(‘new_password’) where id =‘1’.;
and continue to get the error message: Login credentials incorrect, please try again.

I’ve made the edits to config but still can not log-in
I know I’m missing something but can not find the answer.
Ubuntu 20.04 production server and local server path is identical on both servers
PHP version 7.4.x
Mariadb 10.x
it seems to be working but still get log-in error
I don’t see anything in the .htaccess file that I should change
apache log:
127.0.0.1 - - [29/Dec/2021:21:06:47 -0600] "GET /phpmyadmin/db_structure.php?db=yourname_suit&ajax_request=true&ajax_page_request=true&_nocache=1640833607667973453&token=246745263323244a6c23625e4>
127.0.0.1 - - [29/Dec/2021:21:07:15 -0600] “POST /phpmyadmin/logout.php HTTP/1.1” 302 10725 “-” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:95.0) Gecko/20100101 Firefox/95.0”
127.0.0.1 - - [29/Dec/2021:21:07:15 -0600] “GET /phpmyadmin/index.php HTTP/1.1” 200 5167 “-” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:95.0) Gecko/20100101 Firefox/95.0”
127.0.0.1 - - [29/Dec/2021:21:07:16 -0600] “GET /phpmyadmin/favicon.ico HTTP/1.1” 200 22788 “-” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:95.0) Gecko/20100101 Firefox/95.0”
43.131.23.132 - - [29/Dec/2021:21:12:59 -0600] “GET / HTTP/1.1” 200 2930 “-” “-”
43.131.23.132 - - [29/Dec/2021:21:13:07 -0600] “GET /dist/themes/suite8/images/favicon.ico HTTP/1.1” 200 5656 “-” “Go-http-client/1.1”
205.185.122.46 - - [29/Dec/2021:21:13:42 -0600] “-” 408 0 “-” “-”

Hi @440music,

Welcome to the community :wave: and thanks for trying out SuiteCRM 8.

When moving to the new server did you change the db password in the following places?

  • public/legacy/config.php
  • .env.local
    • Please have in mind that the string in DATABASE_URL needs to be url encoded.
    • ex: ! should be %21, # should be %21

If the above is not the problem could you check the following please?

Check is the following logs:

  • logs on logs/prod/prod.log
  • logs in public/legacy/suitecrm.log
  • PHP error logs

If nothing on the above:

  • On the file .env change the APP_ENV=prod to APP_ENV=qa
  • open the browser devtools
  • try again
  • Check the network tab for a graphql with an error entry on the response
  • This error should have a stack trace.

Could you send this please?