登录gcpsql:如何确保PromptSession被导入或删除

2024-04-25 05:02:15 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试使用云Shell来更新一些用户权限。I am logging in using ^{}

gcloud sql connect my-instance
Whitelisting your IP for incoming connection for 5 minutes...done.
Connecting to database with SQL user [sqlserver].********************************************************************************
Python command will soon point to Python v3.7.3.
Python 2 will be sunsetting on January 1, 2020.
See http://https://www.python.org/doc/sunset-python-2/
Until then, you can continue using Python 2 at /usr/bin/python2, but soon
/usr/bin/python symlink will point to /usr/local/bin/python3.
To suppress this warning, create an empty ~/.cloudshell/no-python-warning file.
The command will automatically proceed in  seconds or on any key.
********************************************************************************
> Password:
Traceback (most recent call last):
  File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main
    "__main__", fname, loader, pkg_name)
  File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
    exec code in run_globals
  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/main.py", line 117, in <module>
    main()
  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/main.py", line 110, in main
    run_cli_with(mssqlcli_options)
  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/main.py", line 43, in run_cli_with
    from mssqlcli.mssql_cli import MssqlCli
  File "/usr/local/lib/python2.7/dist-packages/mssqlcli/mssql_cli.py", line 18, in <module>
    from prompt_toolkit.shortcuts import PromptSession, CompleteStyle
ImportError: cannot import name PromptSession

A)我已经使root用户的密码如此不安全和容易,我不可能打错它。你知道吗

B)现在是一月三号,所以我真的不知道这个Python版本的错误是关于什么的。我制作了这个文件,但仅供参考~/.cloudshell不存在,所以我必须先制作它。即便如此,它只是抑制了版本警告,当我尝试登录时,主要错误仍然存在。你知道吗

The documentation承认有几个其他的登录方法使用glcoud beta sql connect,但这又给我带来了另一个错误

2020/01/04 18:38:41 Rlimits for file descriptors set to {&{8500 1048576}}
2020/01/04 18:38:41 invalid json file "/tmp/tmp.s38C662KKr/legacy_credentials/me@gmail.com/adc.json": open /tmp/tmp.s38C662KKr/legacy_credentials/me@gmail.com/adc.json: no such file or directory
ERROR: (gcloud.beta.sql.connect) Failed to start the Cloud SQL Proxy.

alpha相同。你知道吗

这是我在cloudshell中输入的第一个东西,所以我无法想象什么会破坏PromptSession。你知道吗

如何解决此错误并使用Cloud Shell登录到SQL Server?


Tags: toruninpymainlibpackagesusr
1条回答
网友
1楼 · 发布于 2024-04-25 05:02:15

在尝试从Cloud Shell连接时很可能出现问题(我使用此命令从计算引擎实例连接);可能与Python run-time/environment变量有关。据报道here。工程部已经意识到并正在调查此事。你知道吗

相关问题 更多 >