Why is Vertica Management Console reporting my TZ is not set

BobBryan

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 the 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"

Further information:

• The system is Ubuntu 14.04, the version that supports the (free) Community Edition.
• Each virtual machine has 4 gig of ram and 30 G of disk space (2.8 G swap)
• The machines all started out life as Vertica Community Edition Virtual Machine, Version 9.1, worked over to support clusters.
• The virtual machines are running under VirtualBox with the "VirtualBox Host-Only Ethernet Adapter" mode. I have assigned static IP addresses since that's what Vertica seems to want.
• 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 understand and experiment with the Vertica clustering.

Does anybody have any good suggestions where to look?

Arumugaguru_M

Can you please try if the environment variables are available during the SSH? In the validate hosting step, Vertica will try to run some commands via the SSH and if the environment variables are not available during SSH this issue may come up
https://stackoverflow.com/questions/1887365/ssh-remote-command-execution-and-ulimit