We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


connection timeout from remote computer — Vertica Forum

connection timeout from remote computer

I setup a one node instance using vertica community edition. I ran install like this:

 

/opt/vertica/sbin/install_vertica --hosts 127.0.0.1 --rpm /home/ec2-user/vertica-7.1.2-0.x86_64.RHEL5.rpm --dba-user dbadmin --data-dir /home/ec2-user/vertica1

 

install ran correctly...I created a db...loaded data...but did it all from the box. 

 

My problem is that I can't connect to it from a remote computer. I can telnet on the ip address of the box on port 5433 but I can't connect to vertica. I this error:

 

vsql: could not connect to server: Connection timed out (0x0000274C/10060)
Is the server running on host "10.205.118.122" and accepting
TCP/IP connections on port 5433?

 

My guess is that I shoudl have done an "--hosts boxipaddress" instead of "--hosts 127.0.0.1"?

 

netstat shows this:

 


tcp 0 3331573 127.0.0.1:5433 127.0.0.1:49915 FIN_WAIT1
tcp 0 1442177 127.0.0.1:5433 127.0.0.1:49760 FIN_WAIT1

 

but I feel like it should show my ip adress instead of 127.0.0.1

 

am i on the right path here...and how do I fix this issue?

 

also, iptables is disabled...

 

 

 

I also changed my admintools.conf to looks like this:

 

 

[Cluster]
hosts = 10.205.118.122,127.0.0.1

[Nodes]
node0001 = 10.205.118.122,/home/ec2-user/vertica1,/home/ec2-user/vertica1
v_mdetest_node0001 = 10.205.118.122,/home/ec2-user/vertica1,/home/ec2-user/vertica1
v_mdetest2_node0001 = 10.205.118.122,/home/ec2-user/vertica1,/home/ec2-user/vertica1

[Database:mdetest]
restartpolicy = ksafe
port = 5433
path = /home/ec2-user/vertica1/mdetest
nodes = v_mdetest_node0001

[Database:mdetest2]
restartpolicy = ksafe
port = 5433
path = /home/ec2-user/vertica1/mdetest2/v_mdetest2_node0001_catalog
nodes = v_mdetest2_node0001

 

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file