How to configure and run mss_setup for remote posting to SQL Server target in Linux.
説明
How to configure and run mss_setup for remote posting to SQL Server target in Linux.
原因
From version 10.1.1, SharePlex only supports remote posting from Linux to SQL server databases.
対策
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' --
