(Django + MySQL + Google Cloud SQL): Help with error connecting through Google cloud_sql_proxy

Cancelled Posted 5 years ago Paid on delivery
Cancelled Paid on delivery

Error migrating a Python Django Project connected to MySQL Database in Google Cloud SQL by using the cloud_sql_proxy

##### This is the error migrating

(python3.7) main_folder/ (credentials✗) $ python [login to view URL] migrate [15:58:46]

Traceback (most recent call last):

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/django/db/backends/base/[login to view URL]", line 216, in ensure_connection

[login to view URL]()

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/django/db/backends/base/[login to view URL]", line 194, in connect

[login to view URL] = self.get_new_connection(conn_params)

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/django/db/backends/mysql/[login to view URL]", line 227, in get_new_connection

return [login to view URL](**conn_params)

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/pymysql/[login to view URL]", line 94, in Connect

return Connection(*args, **kwargs)

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/pymysql/[login to view URL]", line 327, in __init__

[login to view URL]()

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/pymysql/[login to view URL]", line 597, in connect

self._get_server_information()

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/pymysql/[login to view URL]", line 966, in _get_server_information

packet = self._read_packet()

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/pymysql/[login to view URL]", line 656, in _read_packet

packet_header = self._read_bytes(4)

File "/Users/coto/beecoss/_venv/python3.7/lib/python3.7/site-packages/pymysql/[login to view URL]", line 702, in _read_bytes

CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")

[login to view URL]: (2013, 'Lost connection to MySQL server during query')

##### THIS IS THE LOG FOR CLOUD_SQL_PROXY

main_folder/ (credentials✗) $ ../cloud_sql_proxy -instances="GOOGLE_PROJECT:us-central1:INSTANCE-DB"=tcp:3306

2019/02/26 15:52:11 Listening on [login to view URL] for GOOGLE_PROJECT:us-central1:INSTANCE-DB

2019/02/26 15:52:11 Ready for new connections

2019/02/26 15:52:19 New connection for "GOOGLE_PROJECT:us-central1:INSTANCE-DB"

2019/02/26 15:52:19 couldn't connect to "GOOGLE_PROJECT:us-central1:INSTANCE-DB": Post [login to view URL]: oauth2: cannot fetch token: 400 Bad Request

Response: {

"error": "invalid_grant",

"error_description": "Bad Request"

}

q2019/02/26 15:58:45 New connection for "GOOGLE_PROJECT:us-central1:INSTANCE-DB"

2019/02/26 15:58:45 couldn't connect to "GOOGLE_PROJECT:us-central1:INSTANCE-DB": Post [login to view URL]: oauth2: cannot fetch token: 400 Bad Request

Response: {

"error": "invalid_grant",

"error_description": "Bad Request"

}

^C

*** just indicate the solution, i'll give 5 stars and release the milestone agreed to whom is able to help us ***

*** I'll give screenshots to validate my current Google Cloud SQL configurations ****

Django MySQL Python Software Architecture SQL

Project ID: #18821084

About the project

8 proposals Remote project Active 5 years ago

8 freelancers are bidding on average $157 for this job

huangrong180405

Hello. I am very interested to your project. I have a wealthy experience of Django. I can satisfy all your requirements. Please contact me and let discuss in detail. Thanks.

$200 USD in 3 days
(19 Reviews)
7.0
SammyOpiyo

Hello, How are you authenticating the cloud sql proxy? Looks like you have an issue with that. I am a Python Backend Developer with 3 years experience who for the past 1 year has been getting his hands dirty with More

$222 USD in 3 days
(12 Reviews)
4.4
dpappu131

Hi,,,, please provide me the detials I can solve this and once it is done you can release the milestone.... Thanks ... Waiting for your response ... Regards ...

$155 USD in 3 days
(17 Reviews)
4.5
todo2095

hi there, i will be happy to help you as i'm a full stack developer. i'm available to start working now, contact me to discuss more. best regards, Kerols T.

$140 USD in 7 days
(5 Reviews)
3.5
amhazeem

Hi there, I believe the issue is that, your token is not valid, Can you confirm if your API key is valid and active. If not, I would like to discuss more with you to help troubleshoot and resolve this issue as soon More

$222 USD in 3 days
(3 Reviews)
1.9
MohamadHamad84

hello dear I have dealed with this problem in the past and I have exprince in solving it I have exprince in python and dango thanks

$35 USD in 3 days
(0 Reviews)
0.0