:"connect: connection refused" on Azure Cluster-in-a-Box

Help
1

I had a Cluster-in-a-Box installed and processing Pipeline data on an Azure GOV Cloud VM. I shut it down for a few weeks and restarted it today. However, I can no longer navigate beyond the “Connect to a cluster” page.

http://XXX.XX.0.X:8080/connect/new

Here is an error list from the web site.

2022/04/29 15:52:27 proxy.go:111 dial tcp XXX.XX.X.X:3306: connect: connection refused
Proxy error
platform/studio/server.ProxyHandler.func2
/go/src/platform/studio/server/proxy.go:111
net/http.HandlerFunc.ServeHTTP
/usr/local/go/src/net/http/server.go:2042
platform/vendor/github.com/gorilla/mux.(*Router).ServeHTTP
/go/src/platform/vendor/github.com/gorilla/mux/mux.go:210
platform/vendor/github.com/rs/cors.(*Cors).Handler.func1
/go/src/platform/vendor/github.com/rs/cors/cors.go:200
net/http.HandlerFunc.ServeHTTP
/usr/local/go/src/net/http/server.go:2042
platform/vendor/github.com/gorilla/handlers.loggingHandler.ServeHTTP
/go/src/platform/vendor/github.com/gorilla/handlers/handlers.go:69
net/http.serverHandler.ServeHTTP
/usr/local/go/src/net/http/server.go:2843
net/http.(*conn).serve
/usr/local/go/src/net/http/server.go:1925
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1374
172.21.1.130 - - [29/Apr/2022:15:52:27 +0000] “GET /proxy?hostname=XXX.XX.X.X&port=3306 HTTP/1.1” 502 16

I have all the ports that need to be opened configured on the firewall. I tested all the inbound ports and they all were able to connect. I do get a warning label on Azure Network Settings that port 3306 and port 22 are open to the internet. Though that should not be the issue.

Is there any logging that could point me as to the cause of this navigation issue? It looks like Port 3306 is not accessible but my Azure tests tell me it is accessible.

2

I have been trying to the clusters singlestore studio up and running. I found the 2 memsql.log files on the Linux machine. I am using a CentOS VM running on Azure. I do not have RDP installed on it and I do not have a GUI or desktop installed. I am using SSH to connect.

The 2 memsql.log files have the last log entries from 18 days ago when I last successfully setup the Pipeline and loaded some data.

I would have assumed that navigating to the following URL would have caused some new entries to the memsql.log file, but nothing new is there, http://xxx.xx.x.x:8080/connect/new .

Maybe I need to look elsewhere for this trace of log info.

I checked out the CONNECTION TEST on Azure for the VM at port 3306 and that works. When I tried the same IP and port using Telnet my connection is refused. Just like when I try to navigation into the Studio.

3

On the CentOS VM itself the firewall is not running.

firewall-cmd --state

4

SOLVED - One of the nodes was not started. I mistakenly assumed that if the web site is running then the SingleStore cluster is running

2 Likes
5

@manoj I’m glad you found a solution! Thanks for posting it.

1 Like
6

Happy Friday Manoj! :sun_with_face:

Thanks so much for using the forums to document your process openly. We’re so glad you were able to find a solution and appreciate you keeping us updated.

Because we know how impactful sharing content like this is for other community members to learn from, we gave you and this post a shoutout during our May Community Call!

:cinema: ICYMI – Check out our May Community Call replay on youtube. :cinema: