invalid connection option "dsn"

[Karmenzind]

Description

pgcli 'user=@something password=xxxxx host=x.x.x.x port=32765 dbname=@something' user and dbname start with @

I use this command to connect the database, then it raised invalid connection option "dsn".

This command worked fine several days ago (before updating my system packages), I don't remember which version pgcli was.

Your environment

OS:

Linux version 5.19.13-arch1-1 (linux@archlinux) (gcc (GCC) 12.2.0, GNU ld (GNU Binutils) 2.39.0) #1 SMP PREEMPT_DYNAMIC Tue, 04 Oct 2022 14:36:58 +0000

CLI:

Version: 3.5.0

pip freeze:

aiohttp==3.8.1
aiosignal==1.2.0
appdirs==1.4.4
arandr==0.1.10
asciinema==2.2.0
asgiref==3.5.2
async-timeout==4.0.2
attrs==22.1.0
autocommand==2.2.1
autopep8==1.7.0
backports.csv==1.0.7
blessed==1.19.1
blessings==1.7
bpython==0.23
btrfsutil==5.19.1
CacheControl==0.12.11
cachy==0.3.0
certifi==2022.9.24
cffi==1.15.1
chardet==5.0.0
charset-normalizer==2.1.1
cleo==1.0.0a5
cli-helpers==2.2.1
click==8.1.3
colorama==0.4.5
commonmark==0.9.1
configobj==5.1.0.dev0
crashtest==0.4.0
cryptography==38.0.1
curtsies==0.4.0
cwcwidth==0.1.6
Cython==0.29.32
defusedxml==0.7.1
Deprecated==1.2.13
distlib==0.3.6
distro==1.7.0
Django==3.2.16
django-cors-headers==3.13.0
django-debug-toolbar==3.7.0
django-filter==22.1
django-stubs==1.12.0
django-stubs-ext==0.5.0
docopt==0.6.2
docutils==0.19
dulwich==0.20.46
entrypoints==0.4
filelock==3.8.0
flake8==5.0.4
frozenlist==1.3.1
future==0.18.2
greenlet==1.1.3
gunicorn==20.1.0
html2text==2020.1.16
html5lib==1.1
httpie==3.2.1
idna==3.4
importlib-metadata==4.9.0
importlib-resources==5.9.0
inflect==6.0.0
iniconfig==1.1.1
iotop==0.6
iredis==1.12.0
isort==5.10.1
jaraco.classes==3.2.3
jaraco.context==4.1.2
jaraco.functools==3.5.2
jaraco.text==3.9.1
jeepney==0.8.0
jsonschema==4.16.0
keyring==23.9.3
keyutils==0.6
lark==1.1.2
lockfile==0.12.2
Markdown==3.3.6
markdown-live-preview==0.2.20
mccabe==0.7.0
mistune==2.0.4
more-itertools==8.13.0
msgpack==1.0.4
multidict==6.0.2
mycli==1.25.0
mypy==0.961
mypy-extensions==0.4.3
nspektr==0.4.0
OpenCC==1.1.4
ordered-set==4.1.0
packaging==21.3
pendulum==2.1.2
pep517==0.13.0
pexpect==4.8.0
pgcli==3.5.0
pgspecial==2.0.1
pika==1.3.0
pipenv==2022.10.4
pkginfo==1.8.3
platformdirs==2.5.2
pluggy==1.0.0
ply==3.11
poetry==1.2.1
poetry-core==1.2.0
poetry-plugin-export==1.0.7
prompt-toolkit==3.0.31
psycopg==3.1.3
psycopg-c==3.1.3
psycopg2==2.9.3
psycopg2-binary==2.9.4
ptyprocess==0.7.0
py==1.11.0
pyaes==1.6.1
pycairo==1.21.0
pycodestyle==2.9.1
pycparser==2.21
pydantic==1.10.2
pyflakes==2.5.0
Pygments==2.11.2
PyGObject==3.42.2
pylev==1.4.0
pylibmc==1.6.3
pymemcache==3.5.2
pymongo==4.2.0
PyMySQL==1.0.2
pynvim==0.4.3
pyOpenSSL==22.1.0
pyparsing==3.0.9
pyperclip==1.8.2
pyrsistent==0.19.0
PySocks==1.7.1
pytest==7.1.3
pytest-django==4.5.2
python-dateutil==2.8.2
pytz==2022.4
pytzdata==2020.1
pyxdg==0.28
PyYAML==6.0
ranger-fm==1.9.3
redis==4.3.4
requests==2.28.1
requests-toolbelt==0.9.1
resolvelib==0.8.1
rich @ file:///build/python-rich/src/rich-12.6.0/dist/rich-12.6.0-py3-none-any.whl
SecretStorage==3.3.3
setproctitle==1.3.1
shellingham==1.5.0
six==1.16.0
sqlparse==0.4.2
tabulate==0.9.0
tenacity==8.1.0
terminaltables==3.1.0
toml==0.10.2
tomli==2.0.1
tomlkit==0.11.4
trove-classifiers==2022.9.26
types-pytz==2022.4.0.0
types-PyYAML==6.0.12
typing_extensions==4.3.0
udiskie==2.4.2
urllib3==1.26.12
validate==5.1.0.dev0
validate-pyproject==0.10.1
virtualenv==20.16.0
virtualenv-clone==0.5.7
watchdog==2.1.6
wcwidth==0.2.5
webencodings==0.5.1
wrapt==1.14.1
yarl==1.8.1
zipp==3.8.1
zope.event==4.5.0
zope.interface==5.5.0

[JasonDorn]

Also experiencing this

[dan-dr]

same

[Elkasitu]

I'm also experiencing this issue

[Karmenzind]

As a workaround I removed the system package pgcli and linked the command to the version 3.3.0 installed in a vitualenv. The old version is quite enough for my daily work.

[bbr-kymono]

To solve this problem I had to change my connection way...

This format works fine for me:

pgcli postgres://<user>:<password>@<host>:<port>/<db name>

[j-bennet]

Fixed in https://github.com/dbcli/pgcli/pull/1390.