Getting error trying to run script with SQLTools

Question

I tryed to use the SqlTools extansion for VSCorde and wanted to run the script with it and gives me this erros (I'm using github codespaces)

[1674681282366] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1674681282367] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1674681282368] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1674681282369] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1674681284190] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1674681284191] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1674681284191] INFO  (ls): REQUEST RECEIVED => connection/ConnectRequest
[1674681284192] INFO  (ls): Connection instance created for panel.
    ns: "conn-manager"
[1674681284193] ERROR (ls): {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default"}}},"name":"Error"}
    ns: "conn"
[1674681284193] ERROR (ls): Connecting error: {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default"}}},"name":"Error"}
    ns: "conn-manager"
[1674681284193] ERROR (ls): Open connection error
    ns: "conn-manager"
[1674681284194] ERROR (ext): ERROR: Error fetching records. connect ECONNREFUSED 127.0.0.1:3306, {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"default"}}}}
    ns: "error-handler"```

score 0 · Answer 1 · answered May 10 '23 at 08:10

Most probably, the error took place because the tool could not connect to the MySQL server. The ECONNREFUSED error message states that the server rejected the connection request.

Possibly, the reasons were incorrect server settings, incorrect login details, or configuration errors.

Please check the below options:

• Ensure that the MySQL server is active, and the IP address 127.0.0.1:3306 is available.
• Make sure that your login details for connection to the MySQL server are correct.
• Check the MySQL server settings and make sure that it allows external connections.
• Check the SqlTools extension configuration and make sure that you have specified the correct MySQL server address, provided the correct login details, and set other settings correctly.

If the issue persists, please provide us with more information via the form below:

https://www.devart.com/company/contactform.html

Describe the problem and the actions you have taken. Also, attach relevant screenshots to aid us in better understanding the issue. We’ll do our best to help you solve the problem.

Getting error trying to run script with SQLTools

1 Answers1