After Vertica Has Been Installed....

I have just installed Vertica on my Linux server and I am wondering how to create a database or how to change to a super user so I can create a database or manage the admintools.... Any assistance is appreciated..

Comments

  • I am receiving an error - su: user dbadmin does not exist

  • How can I get to my install log? I believe I installed it successfully...

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Did you install Vertica or just the RPM?

    That is, did you run the /opt/vertica/sbin/install_vertica command?

    See:https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/InstallationGuide/InstallingVertica/InstallVerticaScript.htm

  • This is what I received.. I installed Vertica from the Operations Bridge Reporter tar file.

    Vertica Analytic Database 9.0.1-0 Installation Tool

    usage:
    # install or update:
    install_vertica --hosts host1,host2,host3 --rpm vertica.rpm
    install_vertica --hosts 192.168.1.101,192.168.1.101,192.168.1.102 \
    --rpm vertica.rpm

    # add or remove nodes
    install_vertica --add-hosts host4 --rpm vertica.rpm
    install_vertica --remove-hosts host4

    # get the full detailed help
    install_vertica --help
    install_vertica: error: unrecognized arguments: command
    Installation FAILED with errors.

    Installation stopped before any changes were made.

  • /opt/vertica/sbin/install_vertica

    Vertica Analytic Database 9.0.1-0 Installation Tool

    Validating options...

    Error: No machines will be included in the cluster!
    Hint: provide --hosts.
    Installation FAILED with errors.

    Installation stopped before any changes were made.

  • Within the instructions for the Vertica installation in OBR in the link previously provided, it didn't say to specify the username, I just ran the ./HP-SHR_10.30_setup.bin -i console and followed the steps.

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Sorry, I am not too familiar with OBR. Maybe someone else on the forum can help?

    But, are you sure that you are on the server where Vertica is installed?

    For example, you should be able to check of there are any Vertica processes running on the server. Like this:

    [dbadmin@s18384357 vertica]$ ps -ef | grep -i [v]ertica
    dbadmin  280201      1  0 Nov27 ?        00:00:00 /bin/bash /opt/vertica/agent/agent.sh /opt/vertica/config/users/dbadmin/agent.conf
    dbadmin  280209 280201  1 Nov27 ?        01:06:56 /opt/vertica/oss/python/bin/python ./simply_fast.py
    dbadmin  284911      1  0 Nov27 ?        00:54:19 /opt/vconsole/vendor/OpenJDK/Zulu/java/1.7u191/jre//bin/java -Djava.net.preferIPv4Stack=true -Djava.net.preferIPv4Addresses=true -Duser.language=en -Dvertica.home=/opt/vertica -Dvconsole.home=/opt/vconsole -Djava.library.path=/opt/vconsole/lib -Dderby.system.home=/opt/vconsole/mcdb/derby -Xmx2g -Xms1g -XX:MaxPermSize=256m -jar /opt/vconsole/lib/webui.war
    dbadmin  292832      1  0 Nov27 ?        00:00:54 /opt/vertica/spread/sbin/spread -c /home/dbadmin/test_db/v_test_db_node0001_catalog/spread.conf -D /opt/vertica/spread/tmp
    dbadmin  292870      1  1 Nov27 ?        01:44:14 /opt/vertica/bin/vertica -D /home/dbadmin/test_db/v_test_db_node0001_catalog -C test_db -n v_test_db_node0001 -h 74.208.100.58 -p 5433 -P 4803 -Y ipv4 -c
    dbadmin  292876 292870  0 Nov27 ?        00:00:55 /opt/vertica/bin/vertica-udx-zygote 11 3 292870 debug-log-off /home/dbadmin/test_db/v_test_db_node0001_catalog/UDxLogs 60 12 0
    dbadmin  308856      1  0 Nov09 ?        00:00:00 /opt/vertica/bin/rsync --daemon --config=/tmp/vbr_rsyncd/vbr_rsyncd.conf --port=50000
    
  • [root@---- ~]# ps -ef | grep -i [v]ertica
    root 23116 1 0 Nov14 ? 00:11:36 /opt/OV//nonOV/perl/a/bin/perl /opt/HP/BSM//PMDB/lib/perl/sec/2.7.6/sec -conf=/opt/HP/BSM//PMDB/config/Vertica_IA.rule -input=/opt/HP/BSM//PMDB/log/IAEvent.log -input= -intevents -log /opt/HP/BSM//PMDB/log/IAEngine.log

    This is what I got when I typed grep -I [v]ertica

  • edited 2018 04

    $PMDB_HOME /bin/CreateVerticaDatabase.sh verticadba password /opt/data /opt/catalog verticausr password pmdb tlson

    Prerequisites not fully met during local (OS) configuration for
    verify-xxx.xxx.xxx.xxx.xml:
    HINT (S0305): https://my.vertica.com/docs/9.0.x/HTML/index.htm#cshid=S0305
    TZ is unset for verticadba. Consider updating .profile or .bashrc
    WARN (N0010): https://my.vertica.com/docs/9.0.x/HTML/index.htm#cshid=N0010
    Linux iptables (firewall) has some non-trivial rules in tables: filter
    FAIL (S0020): https://my.vertica.com/docs/9.0.x/HTML/index.htm#cshid=S0020
    Readahead size of (/dev/mapper/vg1_quanvsvt1-opt) is too low for
    typical systems: 256 < 2048

    Also I ran the command above and got the following error. When I try to search for the link, I don't see anything pop up, do you know how to meet the 3 requirements?

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited 2018 03

    Hi,

    Those links are working for me. Prior to installing Vertica there are several prerequisites that you must complete:

    See:
    https://www.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/InstallationGuide/BeforeYouInstall/BeforeYouInstallVertica.htm

    However, being that you are installing a software product that OEMs Vertica, I wonder why those prerequisites aren't handled for you?

  • I am not sure either... the Readahead size was set to 2048 so I'm not sure what it is referring to.

  • I ran these commands to adjust readahead size.

    /sbin/blockdev --setra 2048 /dev/sda
    echo '/sbin/blockdev --setra 2048 /dev/sda' >> /etc/rc.local

    I am still receiving the same error.

    FAIL (S0020): https://my.vertica.com/docs/9.0.x/HTML/index.htm#cshid=S0020
    Readahead size of (/dev/mapper/vg1_quanvsvt1-opt) is too low for
    typical systems: 256 < 2048

    Any suggestions on how to fix this?

  • Jim, would you know how to delete this discussion post? I just realized an IP is indicated in the copy and paste and I would need it removed.

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    I edited out the IP.
  • Thank you

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file