Hi,
I have problem to access to Vertica server from other hosts. It's the same problem when try to access locally by FQDN over vsql.
This working fine:
vsql -h localhost -p 5433 -U dbadmin -w dbadmin -d opsadb
Same host, just connection by FQDN:
vsql -h vmvertica.domain.loc -p 5433 -U dbadmin -w dbadmin -d opsadb
vsql: FATAL 2248: Authentication failed for username "dbadmin"
Other informations:
[dbadmin@vmvertica config]$ admintools -t list_allnodes
Node | Host | State | Version | DB
-------------------+-----------+-------+-------------------+--------
v_opsadb_node0001 | 127.0.0.1 | UP | vertica-7.1.1.000 | opsadb
[dbadmin@vmvertica config]$ admintools -t view_cluster
DB | Host | State
--------+------+-------
opsadb | ALL | UP
opsadb=> select * from vs_subnets;
oid | name | schema | subnet | address_family
-----+------+--------+--------+----------------
(0 rows)
opsadb=> select * from vs_network_interfaces;
oid | name | schema | node | address | address_family
-------------------+------+--------+-------------------+---------------+----------------
45035996273846194 | eth0 | 0 | 45035996273704980 | 192.168.12.12 | ipv4
opsadb=> select * from network_interfaces;
node_id | node_name | interface | ip_address_family | ip_address | subnet | mask | broadcast_address
-------------------+-------------------+-----------+-------------------+--------------------------+-------------+-----------------------------------------+-------------------
45035996273704980 | v_opsadb_node0001 | lo | ipv4 | 127.0.0.1 | 127.0.0.0 | 255.0.0.0 | 127.0.0.1
45035996273704980 | v_opsadb_node0001 | eth0 | ipv4 | 192.168.12.12 | 192.168.12.0 | 255.255.255.0 | 192.168.12.255
45035996273704980 | v_opsadb_node0001 | lo | ipv6 | ::1 | ::1 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff |
45035996273704980 | v_opsadb_node0001 | eth0 | ipv6 | dea0::60a:25ff:b854:1d22 | 1e80:: | ffff:ffff:ffff:ffff::
Firewall is down, port 5433 can be reached from other servers. Vertica database has single node.
[admintools.conf]
last_port = 5433
tmp_dir = /tmp
default_base = /home/dbadmin
format = 3
install_opts = -u dbadmin -g verticadba -p '***' -d /opt/vertica/opsa_data -L CE -s '192.168.12.12' -Y --failure-threshold NONE
spreadlog = False
controlsubnet = default
controlmode = broadcast
[Cluster]
hosts = 192.168.12.12
[Nodes]
node0001 = 192.168.12.12,/opt/vertica/opsa_data,/opt/vertica/opsa_data
v_opsadb_node0001 = 127.0.0.1,/opt/vertica/opsa_data,/opt/vertica/opsa_data
[Database:opsadb]
restartpolicy = ksafe
port = 5433
path = /opt/vertica/opsa_data/opsadb/v_opsadb_node0001_catalog
nodes = v_opsadb_node0001
Any idea how to enable remote access on Vertica server?
, maybe !