google-marketing-solutions/crmint

CRMint deploy errors at Applying database migrations

nnajdova-git opened this issue · 0 comments

Hi,

I got owner permissions to the GCP project and managed to get further in the installation process.

The deployment reached the following "Applying database migrations" phase without errors and then it got the following errors:
Command: . env/bin/activate && python -m flask db upgrade
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'crmintapp'@'cloudsqlproxy34.76.231.109' (using password: YES)") (Background on this error at: http://sqlalche.me/e/e3q8)
Command: . env/bin/activate && python -m flask db-seeds
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'crmintapp'@'cloudsqlproxy
34.76.231.109' (using password: YES)") (Background on this error at: http://sqlalche.me/e/e3q8)
I checked the UI, and this is what I see:
image
image

This is the solution & reasoning:
Most likely the Cloud SQL password in the ~/crmint/cli/stages/kt-bb-predicted-profit-pilot.py file in your Cloud Shell doesn't match the actual Cloud SQL password — usually it happens when you deploy CRMint from another Cloud Shell instance, and the file is generated from scratch with a new random password.

Also, please double check the rest of the CLoud SQL settings in the file, e.g. region, instance name, etc.
How to:
image