Skip to main content
 首页 » 编程设计

python之连接到 Cloud SQL 时的 Cloud Functions "Connection Refused"

2024年12月31日8zdz8207

我正在尝试跟随 example provided by Google使用 Python 和 MySQL 实例将 Cloud Functions 脚本连接到 Cloud SQL。

我在项目中创建了一个 Cloud SQL 实例,然后创建了一个 Cloud Function,我在其中将整个脚本从链接粘贴到内联编辑器中。我将环境变量设置为连接到 Cloud SQL 所需的值,但出现错误。

为了完成这项工作,我是否缺少一些明显的东西?

Error: function crashed. Details: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)")

Traceback (most recent call last): File "/env/local/lib/python3.7/site-packages/pymysql/connections.py", line 582, in connect **kwargs) File "/opt/python3.7/lib/python3.7/socket.py", line 727, in create_connection raise err File "/opt/python3.7/lib/python3.7/socket.py", line 716, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/user_code/main.py", line 49, in mysql_demo mysql_conn = pymysql.connect(**mysql_config) File "/env/local/lib/python3.7/site-packages/pymysql/init.py", line 94, in Connect return Connection(*args, **kwargs) File "/env/local/lib/python3.7/site-packages/pymysql/connections.py", line 327, in init self.connect() File "/env/local/lib/python3.7/site-packages/pymysql/connections.py", line 629, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/env/local/lib/python3.7/site-packages/pymysql/connections.py", line 570, in connect sock.connect(self.unix_socket) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/env/local/lib/python3.7/site-packages/google/cloud/functions_v1beta2/worker.py", line 297, in run_http_function result = _function_handler.invoke_user_function(flask.request) File "/env/local/lib/python3.7/site-packages/google/cloud/functions_v1beta2/worker.py", line 199, in invoke_user_function return call_user_function(request_or_event) File "/env/local/lib/python3.7/site-packages/google/cloud/functions_v1beta2/worker.py", line 192, in call_user_function return self._user_function(request_or_event) File "/user_code/main.py", line 53, in mysql_demo mysql_conn = pymysql.connect(**mysql_config) File "/env/local/lib/python3.7/site-packages/pymysql/init.py", line 94, in Connect return Connection(*args, **kwargs) File "/env/local/lib/python3.7/site-packages/pymysql/connections.py", line 327, in init self.connect() File "/env/local/lib/python3.7/site-packages/pymysql/connections.py", line 629, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)")

请您参考如下方法:

非常重要的信息:

在开始之前,您需要前往 GCP IAM 将云 SQL 管理员角色添加到云函数服务帐户。服务账号信息可以在云功能的通用选项卡中找到。完成此操作后,您应该可以开始了。如果没有,请尝试向您的云功能服务帐户添加更多角色,例如项目编辑器。

代码引用,(只修改部分)

# TODO(developer): specify SQL connection details   
CONNECTION_NAME = getenv( 
'INSTANCE_CONNECTION_NAME', 
'proj-chatbot-og:us-central1:your connection name') 
# Please don't change the name on the left like MYSQL_USER 
DB_USER = getenv('MYSQL_USER', 'your user name') 
DB_PASSWORD = getenv('MYSQL_PASSWORD', 'your password') 
DB_NAME = getenv('MYSQL_DATABASE', 'your sql database') 
 
 
mysql_config = { 
'user': DB_USER, 
'password': DB_PASSWORD, 
'db': DB_NAME, 
'charset': 'utf8mb4', 
'cursorclass': pymysql.cursors.DictCursor, 
'autocommit': True 
} 

完整的文档可以在这里找到 https://cloud.google.com/functions/docs/sql

如果您发现解决方案解决了您的问题,请为解决方案投票。