tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Started by Sumit Kocharalmost 2 years ago6 messagesgeneral

Jump to latest

Sumit Kochar

Sumit.Kochar@mastercard.com

almost 2 years ago

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357

Please advise if this has been encountered or a workaround is available.

OS:

NAME="Oracle Linux Server"
VERSION="7.9"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Oracle Linux Server 7.9"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:9:server"
HOME_URL=https://linux.oracle.com/
BUG_REPORT_URL=https://github.com/oracle/oracle-linux

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.9
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.9

Version of tds_fdw:

postgres=# \dx

List of installed extensions

Name | Version | Schema | Description

------------------+---------+------------+------------------------------------------------------

edb_dblink_libpq | 1.0 | pg_catalog | EnterpriseDB Foreign Data Wrapper for PostgreSQL

edb_dblink_oci | 1.0 | pg_catalog | EnterpriseDB Foreign Data Wrapper for Oracle

edbspl | 1.0 | pg_catalog | EDB-SPL procedural language

pldbgapi | 1.1 | pg_catalog | server-side support for debugging PL/pgSQL functions

plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language

(5 rows)

PostgreSQL Version:

postgres=# SELECT version();

version

--------------------------------------------------------------------------------------------------------------------------------------------------

PostgreSQL 13.13 (EnterpriseDB Advanced Server 13.13.19) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

(1 row)

Issue Details:

tds_fdw install steps performed:

yum install install edb-as13-server edb-as13-server-libs edb-as13-server-devel

yum install -y gcc make wget epel-release freetds freetds-devel

dnf install redhat-rpm-config

subscription-manager repos --enable rhel-7-server-optional-rpms \

--enable rhel-server-rhscl-7-rpms \

--enable rhel-7-server-devtools-rpms

yum install llvm-toolset-7-clang-analyzer llvm-toolset-7-clang-tools-extra llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-clang-libs llvm-toolset-7-llvm-libs

export TDS_FDW_VERSION="2.0.3"

wget https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.tar.gz

tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz

cd tds_fdw-${TDS_FDW_VERSION}

PATH=/usr/edb/as13/bin:$PATH

make USE_PGXS=1

PATH=/usr/edb/as13/bin:$PATH

make USE_PGXS=1 install

Logs:

[root@hostip ~]# yum install install edb-as13-server edb-as13-server-libs edb-as13-server-devel\

Loaded plugins: rhnplugin\

This system is not registered with Spacewalk server.\

You can use rhn_register to register.\

Spacewalk support will be disabled.\

Repository mc-ol7-base-x86_64 is listed more than once in the configuration\

Repository mc-ol7-layered-x86_64 is listed more than once in the configuration\

Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\

Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\

No package install available.\

Package edb-as13-server-13.13.19-1.el7.x86_64 already installed and latest version\

Package edb-as13-server-libs-13.13.19-1.el7.x86_64 already installed and latest version\

Package edb-as13-server-devel-13.13.19-1.el7.x86_64 already installed and latest version\

Nothing to do\

[root@hostip ~]#\

[root@hostip ~]# yum install -y gcc make wget epel-release freetds freetds-devel\

Loaded plugins: rhnplugin\

This system is not registered with Spacewalk server.\

You can use rhn_register to register.\

Spacewalk support will be disabled.\

Repository mc-ol7-base-x86_64 is listed more than once in the configuration\

Repository mc-ol7-layered-x86_64 is listed more than once in the configuration\

Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\

Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\

Package gcc-4.8.5-44.0.3.el7.x86_64 already installed and latest version\

Package 1:make-3.82-24.el7.x86_64 already installed and latest version\

Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version\

Package epel-release-7-14.noarch already installed and latest version\

Package freetds-1.3.3-1.el7.x86_64 already installed and latest version\

Package freetds-devel-1.3.3-1.el7.x86_64 already installed and latest version\

Nothing to do\

[root@hostip ~]#\

[root@hostip ~]# dnf install redhat-rpm-config\

-bash: dnf: command not found\

[root@hostip ~]#\

[root@hostip ~]# subscription-manager repos --enable rhel-7-server-optional-rpms \ --enable rhel-server-rhscl-7-rpms \ --enable rhel-7-server-devtools-rpms\

-bash: subscription-manager: command not found\

[root@hostip ~]#\

[root@hostip ~]# yum install llvm-toolset-7-clang-analyzer llvm-toolset-7-clang-tools-extra llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-clang-libs llvm-toolset-7-llvm-libs\

Loaded plugins: rhnplugin\

This system is not registered with Spacewalk server.\

You can use rhn_register to register.\

Spacewalk support will be disabled.\

Repository mc-ol7-base-x86_64 is listed more than once in the configuration\

Repository mc-ol7-layered-x86_64 is listed more than once in the configuration\

Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\

Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\

**No package llvm-toolset-7-clang-analyzer available.\

No package llvm-toolset-7-clang-tools-extra available.\

No package llvm-toolset-7 available.\

No package llvm-toolset-7-clang available.\

No package llvm-toolset-7-clang-libs available.\

No package llvm-toolset-7-llvm-libs available.\**

Error: Nothing to do\

[root@hostip ~]#\

[root@hostip ~]#

[root@hostip ~]# export TDS_FDW_VERSION="2.0.3"

[root@hostip ~]# wget https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.tar.gz

--2024-05-28 15:44:39-- https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz

Resolving github.com (github.com)... 140.82.112.4

Connecting to github.com (github.com)|140.82.112.4|:443... connected.

HTTP request sent, awaiting response... 302 Found

Location: https://codeload.github.com/tds-fdw/tds_fdw/tar.gz/refs/tags/v2.0.3 [following]

--2024-05-28 15:44:39-- https://codeload.github.com/tds-fdw/tds_fdw/tar.gz/refs/tags/v2.0.3

Resolving codeload.github.com (codeload.github.com)... 140.82.113.10

Connecting to codeload.github.com (codeload.github.com)|140.82.113.10|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: unspecified [application/x-gzip]

Saving to: 'tds_fdw-2.0.3.tar.gz'

[ <=> ] 72,527 --.-K/s in 0.05s

2024-05-28 15:44:39 (1.50 MB/s) - 'tds_fdw-2.0.3.tar.gz' saved [72527]

[root@hostip ~]#

[root@hostip ~]# tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz

tds_fdw-2.0.3/

tds_fdw-2.0.3/.gitattributes

tds_fdw-2.0.3/.github/

tds_fdw-2.0.3/.github/ISSUE_TEMPLATE.md

tds_fdw-2.0.3/.gitignore

tds_fdw-2.0.3/ForeignSchemaImporting.md

tds_fdw-2.0.3/ForeignServerCreation.md

tds_fdw-2.0.3/ForeignTableCreation.md

tds_fdw-2.0.3/InstallAlpine.md

tds_fdw-2.0.3/InstallDebian.md

tds_fdw-2.0.3/InstallOSX.md

tds_fdw-2.0.3/InstallRHELandClones.md

tds_fdw-2.0.3/InstallUbuntu.md

tds_fdw-2.0.3/InstallopenSUSE.md

tds_fdw-2.0.3/LICENSE

tds_fdw-2.0.3/META.json

tds_fdw-2.0.3/Makefile

tds_fdw-2.0.3/README.md

tds_fdw-2.0.3/UserMappingCreation.md

tds_fdw-2.0.3/Variables.md

tds_fdw-2.0.3/include/

tds_fdw-2.0.3/include/deparse.h

tds_fdw-2.0.3/include/options.h

tds_fdw-2.0.3/include/tds_fdw.h

tds_fdw-2.0.3/include/visibility.h

tds_fdw-2.0.3/logo/

tds_fdw-2.0.3/logo/tds_fdw.svg

tds_fdw-2.0.3/sql/

tds_fdw-2.0.3/sql/tds_fdw.sql

tds_fdw-2.0.3/src/

tds_fdw-2.0.3/src/deparse.c

tds_fdw-2.0.3/src/options.c

tds_fdw-2.0.3/src/tds_fdw.c

tds_fdw-2.0.3/tds_fdw.control

tds_fdw-2.0.3/tests/

tds_fdw-2.0.3/tests/.gitignore

tds_fdw-2.0.3/tests/README.md

tds_fdw-2.0.3/tests/lib/

tds_fdw-2.0.3/tests/lib/__init__.py

tds_fdw-2.0.3/tests/lib/messages.py

tds_fdw-2.0.3/tests/lib/tests.py

tds_fdw-2.0.3/tests/mssql-tests.py

tds_fdw-2.0.3/tests/postgresql-tests.py

tds_fdw-2.0.3/tests/tests/

tds_fdw-2.0.3/tests/tests/mssql/

tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.json

tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.sql

tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_table.json

tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_table.sql

tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_table.json

tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_table.sql

tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_table.json

tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_table.sql

tds_fdw-2.0.3/tests/tests/mssql/012_create_date_table.json

tds_fdw-2.0.3/tests/tests/mssql/012_create_date_table.sql

tds_fdw-2.0.3/tests/tests/mssql/013_create_time_table.json

tds_fdw-2.0.3/tests/tests/mssql/013_create_time_table.sql

tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_table.json

tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_table.sql

tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2_table.json

tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2_table.sql

tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeoffset_table.json

tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeoffset_table.sql

tds_fdw-2.0.3/tests/tests/mssql/017_create_char_table.json

tds_fdw-2.0.3/tests/tests/mssql/017_create_char_table.sql

tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_table.json

tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_table.sql

tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharmax_table.json

tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharmax_table.sql

tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_table.json

tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_table.sql

tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary4_table.json

tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary4_table.sql

tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinarymax_table.json

tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinarymax_table.sql

tds_fdw-2.0.3/tests/tests/mssql/023_create_null_datetime_table.json

tds_fdw-2.0.3/tests/tests/mssql/023_create_null_datetime_table.sql

tds_fdw-2.0.3/tests/tests/mssql/024_create_null_datetime2_table.json

tds_fdw-2.0.3/tests/tests/mssql/024_create_null_datetime2_table.sql

tds_fdw-2.0.3/tests/tests/mssql/025_create_match_column_table.json

tds_fdw-2.0.3/tests/tests/mssql/025_create_match_column_table.sql

tds_fdw-2.0.3/tests/tests/mssql/026_create_column_name_table.json

tds_fdw-2.0.3/tests/tests/mssql/026_create_column_name_table.sql

tds_fdw-2.0.3/tests/tests/mssql/027_create_query_option_table.json

tds_fdw-2.0.3/tests/tests/mssql/027_create_query_option_table.sql

tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simple_prerequisites.json

tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simple_prerequisites.sql

tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simple.json

tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simple.sql

tds_fdw-2.0.3/tests/tests/postgresql/

tds_fdw-2.0.3/tests/tests/postgresql/000_create_schema.json

tds_fdw-2.0.3/tests/tests/postgresql/000_create_schema.sql

tds_fdw-2.0.3/tests/tests/postgresql/001_create_server.json

tds_fdw-2.0.3/tests/tests/postgresql/001_create_server.sql

tds_fdw-2.0.3/tests/tests/postgresql/002_create_user_mapping.json

tds_fdw-2.0.3/tests/tests/postgresql/002_create_user_mapping.sql

tds_fdw-2.0.3/tests/tests/postgresql/003_import_schema.json

tds_fdw-2.0.3/tests/tests/postgresql/003_import_schema.sql

tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.json

tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.json

tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin.json

tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax.json

tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.json

tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.json

tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.json

tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.json

tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.json

tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.sql

tds_fdw-2.0.3/tests/tests/postgresql/013_float4.json

tds_fdw-2.0.3/tests/tests/postgresql/013_float4.sql

tds_fdw-2.0.3/tests/tests/postgresql/014_float8.json

tds_fdw-2.0.3/tests/tests/postgresql/014_float8.sql

tds_fdw-2.0.3/tests/tests/postgresql/015_date.json

tds_fdw-2.0.3/tests/tests/postgresql/015_date.sql

tds_fdw-2.0.3/tests/tests/postgresql/016_time.json

tds_fdw-2.0.3/tests/tests/postgresql/016_time.sql

tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.json

tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.sql

tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.json

tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.sql

tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoffset.json

tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoffset.sql

tds_fdw-2.0.3/tests/tests/postgresql/020_char.json

tds_fdw-2.0.3/tests/tests/postgresql/020_char.sql

tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.json

tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.sql

tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.json

tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.json

tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.sql

tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.json

tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.sql

tds_fdw-2.0.3/tests/tests/postgresql/025_varbinarymax.json

tds_fdw-2.0.3/tests/tests/postgresql/025_varbinarymax.sql

tds_fdw-2.0.3/tests/tests/postgresql/026_null_datetime.json

tds_fdw-2.0.3/tests/tests/postgresql/026_null_datetime.sql

tds_fdw-2.0.3/tests/tests/postgresql/027_null_datetime2.json

tds_fdw-2.0.3/tests/tests/postgresql/027_null_datetime2.sql

tds_fdw-2.0.3/tests/tests/postgresql/028_column_match_enabled.json

tds_fdw-2.0.3/tests/tests/postgresql/028_column_match_enabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/029_column_match_disabled.json

tds_fdw-2.0.3/tests/tests/postgresql/029_column_match_disabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/030_column_name.json

tds_fdw-2.0.3/tests/tests/postgresql/030_column_name.sql

tds_fdw-2.0.3/tests/tests/postgresql/031_query_option_column_match_enabled.json

tds_fdw-2.0.3/tests/tests/postgresql/031_query_option_column_match_enabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/032_query_option_column_match_disabled.json

tds_fdw-2.0.3/tests/tests/postgresql/032_query_option_column_match_disabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple.json

tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple.sql

tds_fdw-2.0.3/tests/tests/postgresql/034_explain.json

tds_fdw-2.0.3/tests/tests/postgresql/034_explain.sql

tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.json

tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.sql

tds_fdw-2.0.3/tests/validate-test-json

[root@hostip ~]#

[root@hostip ~]# cd tds_fdw-${TDS_FDW_VERSION}

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]# PATH=/usr/edb/as13/bin:$PATH

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o src/tds_fdw.o src/tds_fdw.c

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fPIC -shared -o tds_fdw.so src/tds_fdw.o src/options.o src/deparse.o -L/usr/edb/as13/lib -L/usr/libexec/edb-icu66/lib/ -L/usr/lib64/llvm5.0/lib -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/usr/edb/as13/lib',--enable-new-dtags -lsybdb

cp sql/tds_fdw.sql sql/tds_fdw--2.0.3.sql

cp README.md README.tds_fdw.md

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2 -I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=thin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

make: *** [src/tds_fdw.bc] Error 127

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]# PATH=/usr/edb/as13/bin:$PATH

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

make: *** [src/tds_fdw.bc] Error 127

[root@hostip tds_fdw-2.0.3]#

CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you.

Ian Lawrence Barwick

barwick@gmail.com

almost 2 years ago

In reply to: Sumit Kochar (#1)

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

2024年5月29日(水) 6:10 Sumit Kochar <Sumit.Kochar@mastercard.com>:

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357

Please advise if this has been encountered or a workaround is available.

(...)

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2 -I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=thin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/ .

Regards

Ian Barwick

Muhammad Imtiaz

imtiaz.m@bitnine.net

almost 2 years ago

In reply to: Ian Lawrence Barwick (#2)

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Hi ,

You need to install the LLVM toolset.

1)Check that if it is installed or not :

yum list installed | grep llvm-toolset

2)If it is not installed, you can install it using the following command.
sudo yum install llvm-toolset-7

Regards,
Muhammad Imtiaz

On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick <barwick@gmail.com>
wrote:

Show quoted text

2024年5月29日(水) 6:10 Sumit Kochar <Sumit.Kochar@mastercard.com>:

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL

server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357

Please advise if this has been encountered or a workaround is available.

(...)

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes

-fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2
-I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server
-I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/
-D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=thin -emit-llvm
-c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/ .

Regards

Ian Barwick

Sumit Kochar

Sumit.Kochar@mastercard.com

almost 2 years ago

In reply to: Muhammad Imtiaz (#3)

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Hi Muhammad,

Tried to install as per step2 mentioned, but got message - No package llvm-toolset-7 available.

Log reference below:

[root@hostip tds_fdw-2.0.3]# yum list installed | grep llvm-toolset
This system is not registered with Spacewalk server.
You can use rhn_register to register.
Spacewalk support will be disabled.
Repository mc-ol7-base-x86_64 is listed more than once in the configuration
Repository mc-ol7-layered-x86_64 is listed more than once in the configuration
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration
Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]# sudo yum install llvm-toolset-7
Loaded plugins: rhnplugin
This system is not registered with Spacewalk server.
You can use rhn_register to register.
Spacewalk support will be disabled.
Repository mc-ol7-base-x86_64 is listed more than once in the configuration
Repository mc-ol7-layered-x86_64 is listed more than once in the configuration
Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration
Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration
No package llvm-toolset-7 available.
Error: Nothing to do
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]#

From: Muhammad Imtiaz <imtiaz.m@bitnine.net>
Sent: Tuesday, May 28, 2024 11:43 PM
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Sumit Kochar <Sumit.Kochar@mastercard.com>; pgsql-general@lists.postgresql.org
Subject: {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Hi , You need to install the LLVM toolset. 1)Check that if it is installed or not : yum list installed | grep llvm-toolset 2)If it is not installed, you can install it using the following command. sudo yum install llvm-toolset-7 Regards,Muhammad

Hi ,

You need to install the LLVM toolset.

1)Check that if it is installed or not :

yum list installed | grep llvm-toolset

2)If it is not installed, you can install it using the following command.

sudo yum install llvm-toolset-7

Regards,

Muhammad Imtiaz

On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick <barwick@gmail.com<mailto:barwick@gmail.com>> wrote:
2024年5月29日(水) 6:10 Sumit Kochar <Sumit.Kochar@mastercard.com<mailto:Sumit.Kochar@mastercard.com>>:

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357<https://urldefense.com/v3/__https:/github.com/tds-fdw/tds_fdw/issues/357__;!!NDdRaFrjhKsg!t-kF9UHinbmu8b-lP0a7cxXvk9iocWrHWabJZytaRmbcLq4qaDB1zumrFBtMXnXur-vljJoQxz1eqIb5YfTO6y4$>

Please advise if this has been encountered or a workaround is available.

(...)

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2 -I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=thin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/<https://urldefense.com/v3/__http:/mirror.centos.org/centos/7/sclo/__;!!NDdRaFrjhKsg!t-kF9UHinbmu8b-lP0a7cxXvk9iocWrHWabJZytaRmbcLq4qaDB1zumrFBtMXnXur-vljJoQxz1eqIb5wnHkTo8$> .

Regards

Ian Barwick

Kashif Zeeshan

kashi.zeeshan@gmail.com

almost 2 years ago

In reply to: Sumit Kochar (#4)

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Hi Sumit

Please make sure Developer Toolset Repo is enable, the package is not
getting installed as its not being found due to the missing Repo.

Regards
Kashif Zeeshan
Bitnine Global

On Wed, May 29, 2024 at 10:10 PM Sumit Kochar <Sumit.Kochar@mastercard.com>
wrote:

Show quoted text

Hi Muhammad,

Tried to install as per step2 mentioned, but got message - * No package
llvm-toolset-7 available.*

*Log reference below:*

*[root@hostip tds_fdw-2.0.3]# yum list installed | grep llvm-toolset*

*This system is not registered with Spacewalk server.*

*You can use rhn_register to register.*

*Spacewalk support will be disabled.*

*Repository mc-ol7-base-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-layered-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the
configuration*

*[root@hostip tds_fdw-2.0.3]#*

*[root@hostip tds_fdw-2.0.3]#*

*[root@hostip tds_fdw-2.0.3]# sudo yum install llvm-toolset-7*

*Loaded plugins: rhnplugin*

*This system is not registered with Spacewalk server.*

*You can use rhn_register to register.*

*Spacewalk support will be disabled.*

*Repository mc-ol7-base-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-layered-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the
configuration*

*No package llvm-toolset-7 available.*

*Error: Nothing to do*

*[root@hostip tds_fdw-2.0.3]#*

*[root@hostip tds_fdw-2.0.3]#*

*From:* Muhammad Imtiaz <imtiaz.m@bitnine.net>
*Sent:* Tuesday, May 28, 2024 11:43 PM
*To:* Ian Lawrence Barwick <barwick@gmail.com>
*Cc:* Sumit Kochar <Sumit.Kochar@mastercard.com>;
pgsql-general@lists.postgresql.org
*Subject:* {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrapper on EDB
Postgres to connect to SQL server database

Hi , You need to install the LLVM toolset. 1)Check that if it is installed
or not : yum list installed | grep llvm-toolset 2)If it is not installed,
you can install it using the following command. sudo yum install
llvm-toolset-7 Regards,Muhammad

Hi ,

You need to install the LLVM toolset.

1)Check that if it is installed or not :

yum list installed | grep llvm-toolset

2)If it is not installed, you can install it using the following command.

sudo yum install llvm-toolset-7

Regards,

Muhammad Imtiaz

On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick <barwick@gmail.com>
wrote:

2024年5月29日(水) 6:10 Sumit Kochar <Sumit.Kochar@mastercard.com>:

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL

server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357

<https://urldefense.com/v3/__https:/github.com/tds-fdw/tds_fdw/issues/357__;!!NDdRaFrjhKsg!t-kF9UHinbmu8b-lP0a7cxXvk9iocWrHWabJZytaRmbcLq4qaDB1zumrFBtMXnXur-vljJoQxz1eqIb5YfTO6y4$>

Please advise if this has been encountered or a workaround is available.

(...)

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes

-fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2
-I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server
-I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/
-D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=thin -emit-llvm
-c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/
<https://urldefense.com/v3/__http:/mirror.centos.org/centos/7/sclo/__;!!NDdRaFrjhKsg!t-kF9UHinbmu8b-lP0a7cxXvk9iocWrHWabJZytaRmbcLq4qaDB1zumrFBtMXnXur-vljJoQxz1eqIb5wnHkTo8$>
.

Regards

Ian Barwick

CONFIDENTIALITY NOTICE This e-mail message and any attachments are only
for the use of the intended recipient and may contain information that is
privileged, confidential or exempt from disclosure under applicable law. If
you are not the intended recipient, any disclosure, distribution or other
use of this e-mail message or attachments is prohibited. If you have
received this e-mail message in error, please delete and notify the sender
immediately. Thank you.

Kashif Zeeshan

kashi.zeeshan@gmail.com

almost 2 years ago

In reply to: Kashif Zeeshan (#5)

Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

Please refer to the following links for help

https://access.redhat.com/solutions/3500401
https://stackoverflow.com/questions/72778135/install-llvm-toolset-10-0-or-newer-in-centos7

Regards
Kashif Zeeshan
Bitnine Global

On Thu, May 30, 2024 at 8:50 AM Kashif Zeeshan <kashi.zeeshan@gmail.com>
wrote:

Show quoted text

Hi Sumit

Please make sure Developer Toolset Repo is enable, the package is not
getting installed as its not being found due to the missing Repo.

Regards
Kashif Zeeshan
Bitnine Global

On Wed, May 29, 2024 at 10:10 PM Sumit Kochar <Sumit.Kochar@mastercard.com>
wrote:

Hi Muhammad,

Tried to install as per step2 mentioned, but got message - * No package
llvm-toolset-7 available.*

*Log reference below:*

*[root@hostip tds_fdw-2.0.3]# yum list installed | grep llvm-toolset*

*This system is not registered with Spacewalk server.*

*You can use rhn_register to register.*

*Spacewalk support will be disabled.*

*Repository mc-ol7-base-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-layered-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the
configuration*

*[root@hostip tds_fdw-2.0.3]#*

*[root@hostip tds_fdw-2.0.3]#*

*[root@hostip tds_fdw-2.0.3]# sudo yum install llvm-toolset-7*

*Loaded plugins: rhnplugin*

*This system is not registered with Spacewalk server.*

*You can use rhn_register to register.*

*Spacewalk support will be disabled.*

*Repository mc-ol7-base-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-layered-x86_64 is listed more than once in the
configuration*

*Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the
configuration*

*Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the
configuration*

*No package llvm-toolset-7 available.*

*Error: Nothing to do*

*[root@hostip tds_fdw-2.0.3]#*

*[root@hostip tds_fdw-2.0.3]#*

*From:* Muhammad Imtiaz <imtiaz.m@bitnine.net>
*Sent:* Tuesday, May 28, 2024 11:43 PM
*To:* Ian Lawrence Barwick <barwick@gmail.com>
*Cc:* Sumit Kochar <Sumit.Kochar@mastercard.com>;
pgsql-general@lists.postgresql.org
*Subject:* {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrapper on EDB
Postgres to connect to SQL server database

Hi , You need to install the LLVM toolset. 1)Check that if it is
installed or not : yum list installed | grep llvm-toolset 2)If it is not
installed, you can install it using the following command. sudo yum install
llvm-toolset-7 Regards,Muhammad

Hi ,

You need to install the LLVM toolset.

1)Check that if it is installed or not :

yum list installed | grep llvm-toolset

2)If it is not installed, you can install it using the following command.

sudo yum install llvm-toolset-7

Regards,

Muhammad Imtiaz

On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick <barwick@gmail.com>
wrote:

2024年5月29日(水) 6:10 Sumit Kochar <Sumit.Kochar@mastercard.com>:

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL

server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357

<https://urldefense.com/v3/__https:/github.com/tds-fdw/tds_fdw/issues/357__;!!NDdRaFrjhKsg!t-kF9UHinbmu8b-lP0a7cxXvk9iocWrHWabJZytaRmbcLq4qaDB1zumrFBtMXnXur-vljJoQxz1eqIb5YfTO6y4$>

Please advise if this has been encountered or a workaround is available.

(...)

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes

-fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2
-I./include/ -fvisibility=hidden -I. -I./ -I/usr/edb/as13/include/server
-I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/
-D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=thin -emit-llvm
-c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/
<https://urldefense.com/v3/__http:/mirror.centos.org/centos/7/sclo/__;!!NDdRaFrjhKsg!t-kF9UHinbmu8b-lP0a7cxXvk9iocWrHWabJZytaRmbcLq4qaDB1zumrFBtMXnXur-vljJoQxz1eqIb5wnHkTo8$>
.

Regards

Ian Barwick

CONFIDENTIALITY NOTICE This e-mail message and any attachments are only
for the use of the intended recipient and may contain information that is
privileged, confidential or exempt from disclosure under applicable law. If
you are not the intended recipient, any disclosure, distribution or other
use of this e-mail message or attachments is prohibited. If you have
received this e-mail message in error, please delete and notify the sender
immediately. Thank you.