Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error opening connection getaddrinfo ENOTFOUND db[XXXXXXXXXX].hosting-data.io #1195

Closed
4 tasks
FrankCoder opened this issue Jul 28, 2023 · 1 comment
Closed
4 tasks

Comments

@FrankCoder
Copy link

SQLTOOLS fails to connect to my ionos hosted mysql 8 db using the same server, port, database, user, name and password I use for my app to connect, which connects flawlessly.

The error returned is "Error opening connection getaddrinfo ENOTFOUND db[XXXXXXXXXX].hosting-data.io"

To Reproduce
{
"mysqlOptions": {
"authProtocol": "xprotocol",
"enableSsl": "Disabled"
},
"previewLimit": 500,
"server": "dbXXXXXXXXXX.hosting-data.io",
"port": 33060,
"driver": "MySQL",
"name": "mgmt-db",
"group": "Production",
"database": "dbsXXXXXXX",
"username": "dbuXXXXXXX",
"password": "***********************",
"connectionTimeout": 15
}

Not going to provide credentials at this moment, can setup separated DB for reproduction if necessary.
I did triple check the values.
My password is 24 characters long, do you have a limit?

Desktop (please complete the following information):

  • SQLTools Version v0.28.0
  • VS Code Version: 1.80.2 (Universal)
    Commit: 2ccd690cbff1569e4a83d7c43d45101f817401dc
    Date: 2023-07-27T21:05:41.366Z (4 hrs ago)
    Electron: 22.3.14
    ElectronBuildId: 22695494
    Chromium: 108.0.5359.215
    Node.js: 16.17.1
    V8: 10.8.168.25-electron.0
    OS: Darwin arm64 22.5.0
  • Driver:
    • PostgreSQL/Redshift
    • [ X] MySQL/MariaDB
    • MSSQL/Azure
    • SQLite
    • Other? Which...
  • Database version: MySQL v8
@FrankCoder
Copy link
Author

This is a limitation with IONOS. Db is not accessible outside their network.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants