error dbinit: Failed to get user dbadmin. Did you create it?

apriyad2

Hello Community Experts,

I have installed Vertica but getting below error:

2023/12/14 14:35:50 init.go:25: error dbinit: Failed to get user dbadmin. Did you create it?
2023/12/14 14:35:50 main.go:135: fatal dbinit: dbinit failed: user: unknown user dbadmin

SruthiA

where are you seeing these error messages? can you share me the output of rpm -qa|grep vertica?

apriyad2

Dear Sruthi,

[root@SUL7GBLV2237 ~]# rpm -qa|grep vertica
vertica-console-23.4.0-0.x86_64
vertica-10.1.1-7.x86_64

I am getting this error while running dbinit.sh.

[root@SUL7GBLV2237 bin]# ./dbinit.sh
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_HOME=/opt/vertica
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_PORT=5433
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_DBA=dbadmin
2023/12/15 07:51:12 environmentLoader.go:37: info GetEnv: VERTICA_DBA_PASS=******
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_DB=itomdb
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_DBA_HOME=
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_RW_USER=vertica_rwuser
2023/12/15 07:51:12 environmentLoader.go:37: info GetEnv: VERTICA_RW_PASSWD=******
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_RO_USER=vertica_rouser
2023/12/15 07:51:12 environmentLoader.go:37: info GetEnv: VERTICA_RO_PASSWD=******
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: TENANT=provider
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: DEPLOYMENT=default
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: MEMORY_SIZE=10%
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: CONCURRENCY=4
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: QUEUE_TIMEOUT=0
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: EXPRESS_LOAD_CONF_PATH=/usr/local/itom-di-pulsarudx/conf
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: EXPRESS_LOAD_MEMORY_SIZE=5%
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: EXPRESS_LOAD_MAX_MEMORY_SIZE=20%
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: EXPRESS_LOAD_CONCURRENCY=16
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: EXPRESS_LOAD_EXECUTION_PARALLELISM=8
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: EXPRESS_LOAD_QUEUE_TIMEOUT=0
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: CLUSTER_K8S_PROVIDER=
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: CONFIG_STORE_SCHEMA=
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: DBINIT_CONF_FILE=
2023/12/15 07:51:12 environmentLoader.go:39: info GetEnv: VERTICA_VERSION_CONSTRAINT=>= 10.0, <= 12.0.3
2023/12/15 07:51:12 init.go:25: error dbinit: Failed to get user dbadmin. Did you create it?
2023/12/15 07:51:12 main.go:135: fatal dbinit: dbinit failed: user: unknown user dbadmin

Please suggest what needs to be done.

SruthiA

why are you using that script? you need to create database using admintools

https://docs.vertica.com/23.4.x/en/admin/using-admin-tools/admin-tools-reference/config-menu-options/creating-db/