DX NetOps

 View Only
  • 1.  Error in DR backup configuration

    Posted Aug 30, 2018 11:15 AM

    CA PM version is 3.6 on rhel 6.8 

    now we have follow the process for vertica backup configuration 

    1. Configure the Data Repository Backup we follow the all steps till 

    when i am executing below script 

    /opt/vertica/bin/vbr.py --task backup --config-file /home/dradmin/CSPDCL_Snapshot.ini

    but getting below error 

    [dradmin@xxxxxxx ~]$ /opt/vertica/bin/vbr.py --task backup --config-file /home/dradmin/xxxxx_Snapshot.ini

    Starting backup of database drdata.
    Participating nodes: v_drdata_node0001.
    Error: SQL command "select name,catalogpath from v_internal.vs_nodes;" failed: vsql: FATAL 3781: Invalid username or password
    Backup FAILED.

    *******************************Error in Details ******************************

    2018-08-30 18:56:14 localhost vbr VBR log initialized.
    2018-08-30 18:56:14 localhost vbr Command line: /opt/vertica/bin/vbr.py --task backup --config-file /home/dradmin/xxxx_Snapshot.ini
    2018-08-30 18:56:14 localhost vbr Getting cluster information.
    2018-08-30 18:56:16 localhost vbr Getting information for database: drdata.
    2018-08-30 18:56:20 localhost vbr Launching rsync daemon on "xxxxxxx".
    2018-08-30 18:56:20 localhost backup_python ['ssh', '-T', '-x', '-o', 'ServerAliveInterval=60', '-o', 'BatchMode=yes', '-o', 'ExitOnForwardFailure=yes', '-o', 'PasswordAuthentication=no', '-o', 'StrictHostKeyChecking=no', '-oNoHostAuthenticationForLocalhost=yes', 'xxxxxxx', '/opt/vertica/oss/python/bin/python -V || true']
    2018-08-30 18:56:20 localhost backup_python ['ssh', '-T', '-x', '-o', 'ServerAliveInterval=60', '-o', 'BatchMode=yes', '-o', 'ExitOnForwardFailure=yes', '-o', 'PasswordAuthentication=no', '-o', 'StrictHostKeyChecking=no', '-oNoHostAuthenticationForLocalhost=yes', 'xxxxxxx', '/opt/vertica/oss/python/bin/python']
    2018-08-30 18:56:20 localhost rsyncd_launcher Output from rsync launcher:
    2018-08-30 18:56:20 localhost rsyncd_launcher Transfer Server process entry: pid 215460.
    Acquiring remoteServer mutex.
    Acquired remoteServer mutex.
    ps aux | grep rsync | grep -v grep | grep daemon | grep port=50000
    dradmin 202101 0.0 0.0 101440 656 ? Ss 17:55 0:00 /opt/vertica/bin/rsync --daemon --config=/tmp/vbr_rsyncd/vbr_rsyncd.conf --port=50000
    Rsync daemon is already running.
    Released mutex.

    2018-08-30 18:56:20 localhost vbr Checking node connectivity.
    2018-08-30 18:56:22 localhost vbr All nodes reachable.
    2018-08-30 18:56:22 localhost vbr Making temp directories.
    2018-08-30 18:56:22 localhost vbr Locking nodes.
    2018-08-30 18:56:22 localhost vbr Locked nodes.
    2018-08-30 18:56:23 localhost backup_python ['ssh', '-T', '-x', '-o', 'ServerAliveInterval=60', '-o', 'BatchMode=yes', '-o', 'ExitOnForwardFailure=yes', '-o', 'PasswordAuthentication=no', '-o', 'StrictHostKeyChecking=no', '-oNoHostAuthenticationForLocalhost=yes', 'xxxxxxx', '/opt/vertica/oss/python/bin/python -V || true']
    2018-08-30 18:56:23 localhost backup_python ['ssh', '-T', '-x', '-o', 'ServerAliveInterval=60', '-o', 'BatchMode=yes', '-o', 'ExitOnForwardFailure=yes', '-o', 'PasswordAuthentication=no', '-o', 'StrictHostKeyChecking=no', '-oNoHostAuthenticationForLocalhost=yes', 'xxxxxxx', '/opt/vertica/oss/python/bin/python']
    2018-08-30 18:56:23 localhost location_locker Locked backup location: MappingBackupLocation(backup_host='xxxxxxx', backup_dir='/home/dradmin/bkup').
    2018-08-30 18:56:24 localhost vbr Starting backup of database drdata.
    2018-08-30 18:56:24 localhost vbr Participating nodes: v_drdata_node0001.
    2018-08-30 18:56:24 localhost vsql /opt/vertica/bin/vsql -q -t -X -ddrdata -p5433 -Udradmin -h172.24.18.23
    2018-08-30 18:56:24 localhost vsql Error reading from vsql: vsql: FATAL 3781: Invalid username or password
    2018-08-30 18:56:24 localhost vbr Error: SQL command "select name,catalogpath from v_internal.vs_nodes;" failed: vsql: FATAL 3781: Invalid username or password
    Backup FAILED.

    **************************************************************************88

     

    Please suggest me how to resolve this 

    Thanks 



  • 2.  Re: Error in DR backup configuration

    Posted Aug 30, 2018 11:48 AM

    FATAL 3781: Invalid username or password

     

    Does your CSPDCL_Snapshot.ini file include this section and is the information correct?

     


    [Database]
    dbName = *********
    dbUser = *********
    dbPassword = xxxxxxxxxxxxxxxxxxxx



  • 3.  Re: Error in DR backup configuration
    Best Answer

    Broadcom Employee
    Posted Aug 30, 2018 04:33 PM

    Or do you use a password file under [Misc] in the CSPDCL_Snapshot.ini file?

     

    [Misc]
    snapshotName = backup_snapshot
    restorePointLimit = 7
    objectRestoreMode = createOrReplace

    passwordFile = /home/dradmin/passwd

     

     

    In either instance, validate the information you have set.