Return
-
Title
How to configure and run mss_setup for remote posting to SQL Server target in Linux. -
Description
How to configure and run mss_setup for remote posting to SQL Server target in Linux. -
Cause
From version 10.1.1, SharePlex only supports remote posting from Linux to SQL server databases. -
Resolution
Steps:
1.Install latest Sql Server ODBC drivers in Linux.
By default, drivers will be installed in below location
$ /opt/microsoft/msodbcsql18/lib64 ---->ODBC Driver 18
2.Modify odbcinst.ini and odbc.ini files located in SP_SYS_VARDIR/odbc directory as below.
$ cat odbcinst.ini
# Example driver definitions
[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.1.so.2.1
UsageCount=1
$ cat odbc.ini
[splex]
Driver=ODBC Driver 18 for SQL Server
Description = linux
Trace = No
Server= tcp:REMOTE-HOSTNAME
Database=shareplex
Port = 1433
TrustServerCertificate=Yes
3. Run mss_setup:
[user@server] $ mss_setup
Welcome to SharePlex for Microsoft SQL Server setup.
This process creates the SharePlex tables, login and user accounts needed to run SharePlex replication.
To create these items, we must connect to the database as an Administrator.
Enter the Microsoft SQL Server DSN name [] : splex
Enter the Microsoft SQL Server Administrator name : admin
Enter the password for the Administrator account :
Enter the database name : shareplex
Database name 'shareplex' does not exist.
Would you like to create it? [y] : y
Database 'shareplex' created.
Would you like to create a new SharePlex login? [y] : y
Enter the name of the new SharePlex login : shareplex
Enter the password for the new Shareplex login :
Re-enter the password for the new Shareplex login :
Will this database be used as a source? [n] : n
Completed SharePlex for Microsoft SQL Server database configuration
SharePlex User name: shareplex
Database name: shareplex
-- The datasource identifier in the SharePlex configuration is 'r.shareplex' --
Setup was successful!