Đã Hủy

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

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 ****

Kĩ năng: Django, MySQL, Python, Kiến trúc phần mềm, SQL

Xem nhiều hơn: ajax django mysql, connecting gridview sql, mysql api vba help, google cloud sql connection refused, cloud sql proxy, how to connect to cloud database using java, gcloud sql connect, connect to google cloud sql with php, google cloud sql tutorial, connecting to cloud sql from external applications, google cloud sql connection string, error connecting primavera sql, flex django mysql, oracle sql help, asp connecting string sql 2005, connecting flash sql database, error 502 php sql server, codeigniter sql help, connecting excel sql database, connecting ms sql flex frame work

Về Bên Thuê:
( 21 nhận xét ) Santiago, Chile

ID dự án: #18821084

10 freelancer đang chào giá trung bình $166 cho công việc này

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 trong 3 ngày
(13 Nhận xét)
6.9
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 trong 3 ngày
(17 Nhận xét)
4.6
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 Thêm

$222 USD trong 3 ngày
(6 Nhận xét)
3.6
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 trong 7 ngày
(4 Nhận xét)
3.1
abnsela

{"error": "invalid_grant","error_description": "Bad Request"} Hello, After reading your project details I believe I'm suitable for this project. As we have specialists in PHP scripts . We specialize and have 5 yea Thêm

$250 USD trong 3 ngày
(24 Nhận xét)
2.6
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 Thêm

$222 USD trong 3 ngày
(3 Nhận xét)
1.9
panopengl916

Hi. I read your text carefully and understood correctly. I am a fullstack web developer and have rich experience of DJANGO. My PREVIOUS PROJECT is the [login to view URL] GITHUB URL is the [login to view URL] Thêm

$155 USD trong 3 ngày
(3 Nhận xét)
1.5
tabishadnan

Dear Sir I have seen your job posting and i have to ask some [login to view URL] come over the chat so we can discuss things. All the skills/experience will be discussed/revealed over the chat. I need to know the technic Thêm

$172 USD trong 5 ngày
(0 Nhận xét)
0.0
ZhorzhAlexandr

[at]PROJECT_NAME = @PROJECT_NAME Made something similar with postgres, should work the same for MySQL You should setup access rights and keys, to connect to your database # create cloud sql database gcloud sql da Thêm

$111 USD trong 1 ngày
(0 Nhận xét)
1.2
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 trong 3 ngày
(0 Nhận xét)
0.0