Delphix Products

 View Only
  • 1.  About creation of Dsource and getting the error

    Posted 02-08-2024 11:18:00 PM

    Hello All,

    We've established a mount point for PostgreSQL, and during the creation of the dSource, we've encountered a situation where the permissions of PostgreSQL are being altered to root.

    And this is the error we are getting in the Delphix Engine

    Thanks,



    ------------------------------
    Harsha KJ
    Associate Engineer
    Unisys Corporation
    ------------------------------


  • 2.  RE: About creation of Dsource and getting the error

    Posted 02-08-2024 11:31:00 PM

    Hi Harsha,

    Could you share the output of sudo -l -S for user postgres? I'd recommend opening a support case with Delphix Support for further log reviews. 

    Cheers!

    VJ



    ------------------------------
    Vijayendra Salvi
    Principal Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: About creation of Dsource and getting the error

    Posted 02-09-2024 02:13:00 AM

    Hello Vijayendra,

    This is the Output for the sudo -l -S
    Thanks,



    ------------------------------
    Harsha KJ
    Associate Engineer
    Unisys Corporation
    ------------------------------



  • 4.  RE: About creation of Dsource and getting the error

    Posted 02-09-2024 04:22:00 AM

    Hi Harsha,

    Can you please check your /etc/sudoers file and confirm that you have a similar configuration for the postgres user?

    Defaults:postgres !requiretty
    postgres ALL=NOPASSWD:  /bin/mount,/bin/umount,/bin/mkdir,/bin/rmdir

    The output above seems to imply that is not configured as we expect it: Postgres Sudo Requirements

    You could also try to run sudo /bin/mount, sudo /bin/umount while logged as postgres to see if you get a prompt for the password.

    If you would like to raise a support case and attach a support bundle, we may be able to investigate this further for you.



    ------------------------------
    Sandro Latini
    Senior Principal Support Engineer
    Delphix
    ------------------------------



  • 5.  RE: About creation of Dsource and getting the error

    Posted 02-09-2024 09:23:00 AM

    Hello,

    The mount point (/mnt/provision) must be owned by the Delphix operating system user. It looks like our PostgreSQL documentation is missing that point so I will file a documentation bug.

    Other datasets note this requirement ( target host requirements ):

    There must be a directory (e.g. "/mnt/provision/" or "/mnt/staging/") that will be used as a container for the NFS mount points that are created when provisioning a VDB or linking a staging push dSource.

    The delphix_os user and primary OS group (i.e. oinstall or dba) must own the directory.

    The directory must have at least permissions -rwxrwx--- (0770).

    There must be no symbolic links in the path of this directory, because NFS can mount into a directory with symlinks in its path, but cannot unmount.

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------