Skip to content

the url is invalid #2694

@ivostoykov

Description

@ivostoykov

I'm submitting a potential issue

  • bug report
  • feature request

Describe the issue
Trying to connect the free db hosting located on db.bit.io using a SQL IDE client. I've got a connection string error.

Driver Version? 42.5.1

Java Version? 11.0.11+9-Ubuntu-0ubuntu2.18.04

OS Version? Linux Ubuntu 22.04 LTS

PostgreSQL Version? 14

To Reproduce
Using a connection string URL like postgresql://aaa:complex_password_with_special_symbols@db.bit.io/aaa/bbb
aaa/bbb is the name of the database. At the same time aaa is the username as well

Expected behaviour
to connect aaa/bbb databse
But got an error "According to the driver "PostgreSQL", the URL "postgresql://aaa:complex_password_with_special_symbols@db.bit.io/aaa/bbb" is invalid."

This text of the error is reported by the Squirrel SQL client I'm using to connect
Tried to set the driver properties individually, bypassing the query string parsing. But the connection still fails.
No problem to connect using pg library in NodeJs with the same credentials.

Logs
no PostgreSQL logs are available

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions