Why is Vertica Management Console reporting my TZ is not setWhy bulk loading a Vertica database table does...

Why avoid shared user accounts?

Why do neural networks need so many training examples to perform?

Citing paywalled articles accessed via illegal web sharing

Mathematics and the art of linearizing the circle

Why zero tolerance on nudity in space?

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

A curious equality of integrals involving the prime counting function?

What does it mean for a caliber to be flat shooting?

Is there any risk in sharing info about technologies and products we use with a supplier?

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

using 'echo' & 'printf' in bash function calls

Do authors have to be politically correct in article-writing?

What is the most fuel efficient way out of the Solar System?

Why is it that Bernie Sanders is always called a "socialist"?

Dilemma of explaining to interviewer that he is the reason for declining second interview

Is there a Linux system call to create a “view” of a range of a file?

Early credit roll before the end of the film

Why exactly do action photographers need high fps burst cameras?

Do theoretical physics suggest that gravity is the exchange of gravitons or deformation/bending of spacetime?

Why did Democrats in the Senate oppose the Born-Alive Abortion Survivors Protection Act (2019 S.130)?

How old is the day of 24 equal hours?

Is using an 'empty' metaphor considered bad style?

What sets the resolution of an analog resistive sensor?

Why was Lupin comfortable with saying Voldemort's name?



Why is Vertica Management Console reporting my TZ is not set


Why bulk loading a Vertica database table does not load all lines?When should I NOT set the Maximum Server Memory option in SQL Server?Why does SQL Server Management Studio crash?Why would Vertica let me start a transaction if I can't roll it back?Why is Postgres not respecting my log file name convention dictated by “log_filename”?SQL Server Installation Error: Object reference not set to an instance of an object













0















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?









share



























    0















    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?









    share

























      0












      0








      0








      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?









      share














      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





      share












      share










      share



      share










      asked 8 mins ago









      user1683793user1683793

      1032




      1032






















          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
          });


          }
          });














          draft saved

          draft discarded


















          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
















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          ORA-01691 (unable to extend lob segment) even though my tablespace has AUTOEXTEND onORA-01692: unable to...

          Always On Availability groups resolving state after failover - Remote harden of transaction...

          Circunscripción electoral de Guipúzcoa Referencias Menú de navegaciónLas claves del sistema electoral en...