Comments

• Jim_Knicely - Select Field - Administrator

  November 2018

  To switch to the dbadmin user, run:

  su - dbadmin

  To create a DB, use admintools or MC...

  See:

  https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/AdminTools/CreatingADatabase.htm

  https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ManagementConsole/ManagingDatabaseClusters/CreateADatabaseUsingMC.htm

  0
• jmchu92

  November 2018

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

  0
• jmchu92

  November 2018

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

  0
• Jim_Knicely - Select Field - Administrator

  November 2018

  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

  0
• jmchu92

  November 2018

  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.

  0
• jmchu92

  November 2018

  /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.

  0
• jmchu92

  November 2018

  https://docs.microfocus.com/OBR/10.30/OBR_Interactive_Installation/OBR_Interactive_Installation/OBR_Interactive_Installation.htm

  I used this link to install Vertica on a separate box than OBR.

  0
• Jim_Knicely - Select Field - Administrator

  November 2018

  What user name did you specify when you installed Vertica?

  https://community.softwaregrp.com/t5/Operations-Bridge-Reporter-User/OBR-support-tip-Default-User-for-Operations-Bridge-Reporter/td-p/808449

  0
• jmchu92

  November 2018

  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.

  0
• Jim_Knicely - Select Field - Administrator

  December 2018

  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
  

  0
• jmchu92

  December 2018

  [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

  0
• jmchu92

  December 2018 edited December 2018

  $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?

  0
• Jim_Knicely - Select Field - Administrator

  December 2018 edited December 2018

  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?

  0
• jmchu92

  December 2018

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

  0
• jmchu92

  December 2018

  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?

  0
• jmchu92

  December 2018

  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.

  0
• Jim_Knicely - Select Field - Administrator

  December 2018

  I edited out the IP.

  0
• jmchu92

  December 2018

  Thank you

  0