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

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

Answers

  • SruthiASruthiA Vertica Employee Administrator

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

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

  • SruthiASruthiA Vertica Employee Administrator

    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/

Leave a Comment

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