Options

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