SharePlex 12.2 - Installation and Setup guide

Solve database connection problems for PostgreSQL

Did you verify the credentials?

If SharePlex cannot connect to a source or target database, you can view the login credentials that are being used for that database by using the connection command with the show option. For example:

sp_ctrl> connection r.mydb show

You can also view connection settings in the connections.yaml file, which is stored in the data sub-directory of the SharePlex variable-data directory. If there are no settings in this file, it means that the SharePlex database setup procedure was not performed on this database.

To view the correct database setup procedure for the database, see SharePlex Reference GuideSharePlex Utilities

You can use the connection command to update connection properties. For more information, see the SharePlex Reference Guide.

Did you assign a DBA role to the SharePlex PostgreSQL user?

The SharePlex PostgreSQL user requires a DBA role with unlimited privileges. The SharePlex user is created with the default PostgreSQL profile under the assumption that the profile has the unlimited resource privileges assigned by PostgreSQL as the default. If SharePlex is unable to interact with PostgreSQL, check to see if the default was changed. If so, assign SharePlex a DBA role with unlimited privileges for all definitions.

Installing SharePlex on a Docker container

You can install SharePlex on a Docker container manually or through a Dockerfile.

To install SharePlex on a Docker container through a Dockerfile, follow these steps:

1. Create a docker build file in the following format (This is a sample Docker file format created for the Linux platform):

2. Create a SharePlex install script file similar to the below sample file: (This is a sample SharePlex install script file format created for the Linux platform)

   #!/bin/bashset -e

   echo 'export SP_HOME=/u01/splex

   export SP_SYS_HOST_NAME=$(hostname)

   export SP_SYS_PRODDIR=${SP_HOME}/prod

   export SP_SYS_VARDIR=${SP_HOME}/var

   export SP_SYS_BINDIR=${SP_SYS_PRODDIR}/bin

   export SP_COP_TPORT=4545

   export SP_COP_UPORT=4545

   export PATH=${SP_SYS_BINDIR}:${PATH}

   alias spbin="cd ${SP_SYS_BINDIR}/"

   alias spvar="cd ${SP_SYS_VARDIR}/"

   alias splog="cd ${SP_SYS_VARDIR}/log"

   alias spc="${SP_SYS_BINDIR}/sp_ctrl"

   alias gocop="${SP_SYS_BINDIR}/sp_cop -u${SP_COP_TPORT} &"

   export ODBCINI=${SP_SYS_VARDIR}/odbc/odbc.ini

   export ODBCSYSINI=${SP_SYS_VARDIR}/odbc

   ' >> /home/splex/.bashrc

   /u01/splex/SharePlex.tpm -r /u01/splex/product.rsp

3. Create SharePlex silent install file (Examples: product.rsp) used for silent ora_setup. Not applicable for PostgreSQL. For additional information, see Run database setup for Oracle in silent mode section.

4. Install Docker (Example: Docker desktop).

5. Choose a base image.

6. Install necessary packages (Example: PostgreSQL ODBC driver / Oracle Instant Client).

7. Add custom files to the project directory (SharePlex files).

8. Specify the user that will run your container (Example: splex:spadmin).

9. Specify the exposed ports (Example: 2100).

10. Define the entry point (Example: bash).

11. Define a configuration method (Example: environment variables / scripts).

12. Externalize your data (define an external volume for persistent data).

Build and run SharePlex container

1. Create the following files and and copy them to the project directory (Example: splex_to_container) :

   • dockerfile (Docker build file)

   • installsplex.sh (SharePlex install script)

   • product.rsp (SharePlex silent install file)

   • SharePlex.tpm (SharePlex TPM installer)

2. From within this directory, run the following commands:

   1. docker build -t shareplex:11

      This command will build the SharePlex image with the name "shareplex" and tag "11".

   2. docker run -itd --privileged -d --memory-reservation=100m --expose 22 --ulimit nofile=2000:2000 -p 4545:4545 -p 80:22 --name shareplex -it shareplex:11.4

      This command will start the container from the image "shareplex:11" named "shareplex."

   3. docker exec -it shareplex bash

      This command will start an interactive terminal session into the running SharePlex container. You can now run a database setup utility.

Assign SharePlex users to security groups

Contents

Overview

The SharePlex security groups provide access control to the SharePlex command and control system. Without proper configuration of these groups, anyone with permissions on the system can use the commands that view, configure, and control data replication.

Overview of SharePlex security groups

About the SharePlex Security Groups

To monitor, control, or change SharePlex replication, a person must be assigned to one of the SharePlex security groups on the systems where he or she will be issuing commands. Each group corresponds to an authorization level, which determines which SharePlex commands a person can issue. To execute a command, a user must have that command’s authorization level or higher. Use the authlevel command to determine your authorization level for issuing SharePlex commands on a system.

Description of the SharePlex security groups

Refer to the following table to determine the group and authorization level that you want to grant each SharePlex user.

User Authorization Levels and Roles

Note: The default name for the SharePlex administrator group is spadmin, but you can designate any group or specify any name for that group during installation.