(Django + MySQL + Google Cloud SQL): Help with error connecting through Google cloud_sql_proxy
$30-250 USD
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 ****
Project ID: #18821084
About the project
8 freelancers are bidding on average $157 for this job
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.
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
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 ...
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.
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