After Vertica Has Been Installed....

jmchu92

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

Jim_Knicely

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

jmchu92

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

jmchu92

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

Jim_Knicely

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

jmchu92

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.

jmchu92

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

jmchu92

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.

Jim_Knicely

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

jmchu92

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_Knicely

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

jmchu92

[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

jmchu92

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

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?

jmchu92

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

jmchu92

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?

jmchu92

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_Knicely

I edited out the IP.

jmchu92

Thank you