mongodb-js / vscode

Connect to MongoDB and Atlas and directly from your VS Code environment, navigate your databases and collections, inspect your schema and use playgrounds to prototype queries and aggregations.
https://marketplace.visualstudio.com/items?itemName=mongodb.mongodb-vscode
Apache License 2.0
327 stars 58 forks source link

Connection error sql & mongodb #760

Closed Makksat closed 3 months ago

Makksat commented 3 months ago
Screenshot 2024-07-12 at 15 22 31

That's my first when I start to practice work with databases on mongodb and sql. 1 link is connection error in mongodb, 2 link is connection error with sql. I can't understand what wrong is

2 link: [1720788874311] INFO (ext): SQLTools is starting [1720788874313] INFO (ext): initializing language client... [1720788874313] INFO (ext): Registering client for languages [{"scheme":"sqltools"},{"language":"sql","scheme":"untitled"},{"language":"sql","scheme":"file"},{"language":"sql","scheme":"sqltools"}] ns: "lc" [1720788874315] INFO (ext): loading plugins... [1720788874315] INFO (ext): registering Formatter Plugin. plugin: { "name": "Formatter Plugin" } [1720788874316] INFO (ext): registering Connection Manager Plugin. plugin: { "name": "Connection Manager Plugin" } [1720788874316] INFO (ext): registering CodeLens Plugin. plugin: { "name": "CodeLens Plugin", "registeredLanguages": [] } [1720788874316] INFO (ext): registering Dependency Manager Plugin. plugin: { "name": "Dependency Manager Plugin", "installingDrivers": [] } [1720788874319] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1720788874319] INFO (ext): registering History Manager Plugin. plugin: { "name": "History Manager Plugin" } [1720788874319] INFO (ext): registering Bookmarks Manager Plugin. plugin: { "name": "Bookmarks Manager Plugin" } [1720788874320] INFO (ext): registering Authentication Provider Plugin. plugin: { "name": "Authentication Provider Plugin", "isRegistered": false } [1720788874321] INFO (ext): registering Object Drop-in Provider (plugin). plugin: { "type": "plugin", "name": "Object Drop-in Provider", "isRegistered": false } [1720788874321] INFO (ext): SQLTools activation completed. 9.91258 ms [1720788874321] INFO (ext): Formatter Plugin registered! [1720788874321] INFO (ext): CodeLens Plugin registered! [1720788874321] INFO (ext): Dependency Manager Plugin registered! [1720788874322] INFO (ext): Connection Manager Plugin registered! [1720788874322] INFO (ext): History Manager Plugin registered! [1720788874322] INFO (ext): Bookmarks Manager Plugin registered! [1720788874322] INFO (ext): Authentication Provider Plugin registered! [1720788874322] INFO (ext): Object Drop-in Provider (plugin) registered! [1720788874373] INFO (ext): registering MySQL/MariaDB/TiDB Plugin (driver). plugin: { "extensionId": "mtxr.sqltools-driver-mysql", "name": "MySQL/MariaDB/TiDB Plugin", "type": "driver" } [1720788874771] INFO (ls): SQLTools Server started!

Using node runtime?: no ExecPath: /Applications/Visual Studio Code.app/Contents/Frameworks/Code Helper (Plugin).app/Contents/MacOS/Code Helper (Plugin)

[1720788874782] INFO (ext): LanguageClient ready ns: "lc" [1720788874782] INFO (ls): Initialized with node version:v20.9.0 [1720788874785] INFO (ls): REQUEST RECEIVED => ls/RegisterPlugin [1720788874785] INFO (ls): request to register plugin: "/Users/maksatkaparov/.vscode/extensions/mtxr.sqltools-driver-mysql-0.6.3/out/ls/plugin.js" [1720788875057] INFO (ls): Driver mysql registered! place: "driver-map" ns: "ls-context" [1720788875058] INFO (ls): Driver mariadb registered! place: "driver-map" ns: "ls-context" [1720788875058] INFO (ls): Driver tidb registered! place: "driver-map" ns: "ls-context" [1720788875059] INFO (ext): MySQL/MariaDB/TiDB Plugin (driver) registered! [1720788876063] INFO (ext): EXECUTING COMMAND => sqltools.refreshTree [1720788876063] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1720788876320] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1720788881712] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1720788883875] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1720790600997] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1720790600999] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1720790602101] INFO (ext): EXECUTING COMMAND => sqltools.selectConnection [1720790602102] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1720790602103] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1720790602104] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1720790602104] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1720790602105] INFO (ls): REQUEST RECEIVED => connection/ConnectRequest [1720790602107] INFO (ls): Connection instance created for MySQL Local. ns: "conn-manager" [1720790602130] ERROR (ls): {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"xprotocol","enableSsl":"Disabled"}}},"name":"Error"} ns: "conn" [1720790602131] ERROR (ls): Connecting error: {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"xprotocol","enableSsl":"Disabled"}}},"name":"Error"} ns: "conn-manager" [1720790602131] ERROR (ls): Open connection error ns: "conn-manager" [1720790602132] ERROR (ext): ERROR: Error opening connection Error, {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"xprotocol","enableSsl":"Disabled"}}}} ns: "error-handler" [1720790606526] INFO (ext): EXECUTING COMMAND => sqltools.showOutputChannel

Makksat commented 3 months ago

if someone know how to connect them, please, help me

alenakhineika commented 3 months ago

Hi there, it seems you're attempting to connect to MySQL, but this extension is specifically designed for a MongoDB database. To use this extension, you'll need to have a MongoDB cluster running and connect using a MongoDB URI. You can learn more from the MongoDB for VS Code documentation. Hope this helps!

Makksat commented 3 months ago

Hi there, it seems you're attempting to connect to MySQL, but this extension is specifically designed for a MongoDB database. To use this extension, you'll need to have a MongoDB cluster running and connect using a MongoDB URI. You can learn more from the MongoDB for VS Code documentation. Hope this helps! Thanks for your help. I will try now