After Vertica Has Been Installed....

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

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

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.

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.

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

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.

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

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.

Thank you