Installing Sandbox Environment

Installing 7.1 Sandbox Environment Using VirtualBox on Windows

19

This tutorial will cover the installation of a 3 node Vertica 7.1 sandbox environment on CentOS 6.5 using VirtualBox 4.3 with Windows. As this is a sandbox environment, the settings described in the tutorial are the minimum requirements for running Vertica on the described software stack. Refer to the installation documentation for a comprehensive guide on installing Vertica or the VM Configuration Guide for VM hardware recommendations.

Overview

Basic knowledge of Linux is highly recommended. There may be some missing configuration components, but for purposes of creating a sandbox environment, the procedure below suffices. The estimated set up time is around 30 minutes, and videos are provided where appropriate. For installation of a Vertica 7.2 sandbox environment, follow our newer tutorial.

  1. Required Tools & Software
  2. Initial VM Configuration
  3. CentOS Installation
  4. CentOS Configuration
  5. VM Cloning
  6. Configure Cloned Machines
  7. Install Vertica
  8. Post-install Steps & Example Database

Click here if you wish to read this tutorial on a single page.

About the author / 

Norbert Krupa

Norbert is the founder of vertica.tips and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

19 Comments

  1. abhishek August 25, 2014 at 12:16 PM -  Reply

    crystal clear explanation..nice

    • Norbert Krupa August 25, 2014 at 1:22 PM -  Reply

      Thanks Abhishek!

  2. VIKAS December 7, 2014 at 6:52 AM -  Reply

    Any ideas to ignore ‘Unsupported Hardware Detected’ message box in kickstart ?

    Regards,
    Vikas

    • Norbert Krupa December 7, 2014 at 8:10 AM -  Reply

      I’m guessing you’re using RHEL. You can try to set the --failure-threshold to NONE, but this is not used in production environments and your database may not start.

      • VIKAS December 7, 2014 at 9:02 AM -  Reply

        Hi there, I am using CentOS 6.3 in a VM on my Macbook. I am not sure where I should use ‘failure-threshold’ parameter suggested by you.

        • Norbert Krupa December 7, 2014 at 9:05 AM -  Reply

          Sorry. If you’re seeing the message in the OS, you can ignore it. If it’s through Vertica, then you would use that parameter when installing.

  3. Jeff February 10, 2015 at 4:15 AM -  Reply

    Hi, Would this still work if the Virtualbox guest machines were created as 32-bit systems?

    • Norbert Krupa February 10, 2015 at 8:50 AM -  Reply

      It should. CentOS might give you a message such as Unsupported Hardware Detected.

  4. Prasanta Mishra February 20, 2015 at 7:36 AM -  Reply

    Hi Norbert,

    Thanks for providing clear steps to perform the Vertica DB installation however I need one more assistance regarding the installation of Vertica MC. If can provide clear steps for installation of MC, will help me a lot like above.

    Thanks,Mishra.

    • Norbert Krupa February 20, 2015 at 8:38 AM -  Reply

      Follow the documentation on installing the MC. It’s a straight forward process.

  5. George V March 2, 2015 at 2:45 PM -  Reply

    Thanks for this very helpful website.

    I am facing an error while starting the VM, I am using CentOS 6.6, as the URL directs me to that link.

    Failed to open a session for the virtual machine Vertica_Node1.
    The virtual machine ‘Vertica_Node1’ has terminated unexpectedly during startup with exit code 1.
    Result Code: E_FAIL (0x80004005)
    Component: Machine
    Interface: IMachine {480cf695-2d8d-4256-9c7c-cce4184fa048}

    Appreciate your response.

    Thanks,
    George

    • Norbert Krupa March 2, 2015 at 3:43 PM -  Reply

      George, please try downloading CentOS-6.5-x86_64-minimal.iso from the vault. I’ve updated the link in the tutorial for that version.

    • Norbert Krupa May 14, 2016 at 8:26 AM -  Reply

      Their server may be down or you’re not connected to a WAN.

  6. sasanka ghosh December 27, 2016 at 12:01 AM -  Reply

    Hi Krupa , I have downloaded the 2.2 gb Ova file . the rpm is 4.1. Leaving that aside after i login with dbadmin and password after that i see only 2 icons computer and trash . What are the next steps ? i am using Vmware 6.0.4 build-2237854. with redhat 6.0 enterprise linux 64 bit.

    Regards
    sasanka

    • Norbert Krupa December 27, 2016 at 6:54 PM -  Reply

      I’m not entirely sure where you downloaded the .ova file from as this is a build-a-sandbox-from-scratch tutorial.

      • sasanka ghosh December 28, 2016 at 7:45 AM -  Reply

        Hi Krupa
        Thanks for the reply .

        I had downloaded the Ova file from my Vertica Only .
        The issue with the Ova file is that i tried all things like SSH test, adapter change etc. still i am not able get the injet address through which can transfer file from host windows to Guest OS using putty/winSCP etc.

        Regarding the Sandbox which u have suggested i have 2-3 issues .
        1. when configure network always ETH1 will fail . though CENT OS will be installed and after reboot i can login with root . I believe for cluster instillation both the networks are necessary . IU am able to transfer file from host to guest OS.
        2.The CENT OS minimal is displaying in very small window and as well as no facility of scrolling etc. I understand pressing some key additionally one can scroll etc. but will be very difficult to work .

        additional query

        I am now trying to download full version RHEL Linu RPM above 7.1 i.e. as i had downloaded rpm8.1 from my vertica will work or i have to download some specific version?

        • Norbert Krupa December 28, 2016 at 2:45 PM -  Reply

          This specific tutorial was written and tested for the 7.1 RPM.

  7. sasanka ghosh December 27, 2016 at 12:53 PM -  Reply

    Not seeing my earlier comment but u can remove it . hard to explain what i was expecting vuis a vis when i download a oracle packaged VM box. Doing r &d and will come back . Kind of pain in the a$$ unlike Oracle . Too much constraints and compatibility issues .. When someone is trying to explore it should be cakewalk otherwise the hidden sill set ups put off many people though the ultimate product is very high end and worth it .

Leave a Reply

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.

Notice

This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: