Why is Vertica Management Console reporting my TZ is not set
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"
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 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?
configuration installation vertica
add a comment |
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"
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 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?
configuration installation vertica
add a comment |
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"
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 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?
configuration installation vertica
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"
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 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?
configuration installation vertica
configuration installation vertica
asked 8 mins ago
user1683793user1683793
1032
1032
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230918%2fwhy-is-vertica-management-console-reporting-my-tz-is-not-set%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230918%2fwhy-is-vertica-management-console-reporting-my-tz-is-not-set%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown