I am experimenting with setting up a Vertica Community Edition (9.2.0-0) cluster using three virtual machines. In the Vertica Management Console, when I enter my IP addresses and ask to "Validate Host" it chugs through and decides that I don't have a TZ variable set.
The error message (complete with their spelling):
Warning:Test: checking environmental variable TZ : WARN 17: enviornment variable TZ is not set
Except I DO have it set, both for the system and for the dbadmin user.
If I log in as dbadmin, I get:
dbadmin@Ubuntu-14A:~$ echo $TZ America/New_York
If I log in as root, I get:
root@Ubuntu-14A:~# echo $TZ America/New_York
Checking for TZ in all the places it would be expected:
dbadmin@Ubuntu-14A:~$ grep TZ /etc/profile export TZ="America/New_York" dbadmin@Ubuntu-14A:~$ grep TZ /etc/bashrc export TZ="America/New_York" dbadmin@Ubuntu-14A:~$ sudo grep TZ /root/.bashrc export TZ="America/New_York" dbadmin@Ubuntu-14A:~$ grep TZ ~dbadmin/.bashrc export TZ="America/New_York" dbadmin@Ubuntu-14A:~$ grep TZ ~dbadmin/.profile export TZ="America/New_York"
- The system is Ubuntu 14.04, the version that supports the (free) Community Edition.
- Each virtual machine has 4 gig of ram and 32gig of disk space.
- The virtual machines are running under VirtualBox with the network in NAT Network mode. I have assigned static IP addresses since Vertica seems to want that.
- I am aware I won't get the performance I would get if I had dedicated servers but my objective at this time is to experiment with the Vertica clustering.
Does anybody have any good suggestions where to look?