Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCWp3-006AQX-0M for pgsql-general@arkaria.postgresql.org; Thu, 30 May 2024 03:51:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sCWp2-000sDP-WB for pgsql-general@arkaria.postgresql.org; Thu, 30 May 2024 03:51:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCWp2-000sDE-CW for pgsql-general@lists.postgresql.org; Thu, 30 May 2024 03:51:24 +0000 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sCWoy-002c2G-LN for pgsql-general@lists.postgresql.org; Thu, 30 May 2024 03:51:23 +0000 Received: by mail-wr1-x436.google.com with SMTP id ffacd0b85a97d-354be94c874so309237f8f.3 for ; Wed, 29 May 2024 20:51:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717041079; x=1717645879; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=LiOXdAE3Kbela+YiBMUjCzimQs8csfFY8gDgGRotT04=; b=HCBTdjT4W/B2psDRM/fj0GjXqvd9aiGfasnsyx4ZB+Nu3ntTwBQmGgucibLwvGvHRR /sEhRXRwtcfZTX9/1K78hNxt6vXr/PHV9pQFCq9YZq6iSAXvyBYzOHbgF2Ap+FFbRlXP O2qWBMAgc2rvg17re9efZWJ7ww2xScqvZG54cMyxedLGtxKy7TODz7ca2YOgLJ8lPpol zWYuu97K4LBiZ5+6b3tmfb5GOfKdu7F7hcs87R7TihWy7gI+FHMq15WA2M93y8JfHGzP 7VW0ZlpqPBreig7binfAZ9KTRh1W2ZV6tDKB6Uty94nWs7rCdJi88pEub3kqhA+pdF2X j4rA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717041079; x=1717645879; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=LiOXdAE3Kbela+YiBMUjCzimQs8csfFY8gDgGRotT04=; b=CpnMXPk+t4X3LTq/eBINXoxMgqTxqtjCqTZTA+egLhnI1xP6bqkfaOVo4Uf6C4MJ4C Wk+Ri0+9KZvR0S+uve78+zy5k7zBJUwaxcY6Wdu4n0Fz1Rlp0r0cJobpClDFbRAJ4zJD v90Wqvtc+xTPbwiJobe4WC8md/keUwvk3Po+IvUZcDR4JiULcMkgjX7GKpGhNnl7OKrk hwX0J1eBCeyOSoiMbt8vlvRH+bBClmlOBqB/Z9QyvUGU6WVk2kpiCTTe0zBxeUzp9UtQ F+yjqbTrmxumLf+dDsCI7HDdM00c3EfLOZA8oIq02zfWjKaeQey+ID+Cato3uaUeffLk RaxA== X-Forwarded-Encrypted: i=1; AJvYcCVKPs2Oo+ZfzNwv+cJXphef/vSvQLC2aCiXvPZ2eqIEXULPebA5zME+y/W5EhFcJcjcbPNmAA9KAiCUIFQlEFgmDRBQaK6PKEyg39nVRZNChgbn X-Gm-Message-State: AOJu0YxiNvQozgTy/ayEYlqeyi+1HR8dzI7ZPn5hJtFEtkSzBny7iXhi 2Iap1EROSOqKD+aCwsvVX9Ofokf5mn3KUZPudJP6mZlXcqvyZbISGaizFaJ5w9DrHyNZTIqCFYk 0+Rx8R8I29VJsZyEzymy3JYZD7oT9wilp X-Google-Smtp-Source: AGHT+IFGAz7ywX4O9hhmwHPlEwdk3BlI8NHTwL1RgOJ8wSvCnL7lL6mCNSaNUzD+4SOnpTqaw6wPB2rsFQD1nz9T4/Y= X-Received: by 2002:adf:b1d1:0:b0:354:fc89:5432 with SMTP id ffacd0b85a97d-35dc0087fecmr1088753f8f.5.1717041078930; Wed, 29 May 2024 20:51:18 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Thu, 30 May 2024 08:51:03 +0500 Message-ID: Subject: Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database To: Sumit Kochar Cc: Muhammad Imtiaz , Ian Lawrence Barwick , "pgsql-general@lists.postgresql.org" , Kannan Rajesh , Haragopal Avvaru Content-Type: multipart/alternative; boundary="0000000000009315db0619a3c7d3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009315db0619a3c7d3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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-n= ewer-in-centos7 Regards Kashif Zeeshan Bitnine Global On Thu, May 30, 2024 at 8:50=E2=80=AFAM Kashif Zeeshan wrote: > 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=E2=80=AFPM Sumit Kochar > 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 >> *Sent:* Tuesday, May 28, 2024 11:43 PM >> *To:* Ian Lawrence Barwick >> *Cc:* Sumit Kochar ; >> 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 inst= all >> 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 >> wrote: >> >> 2024=E5=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 6:10 Sumit Kochar : >> > >> > 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 availabl= e. >> (...) >> >> > [root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 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=3Dhidden -I. -I./ -I/usr/edb/as13/include/ser= ver >> -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ >> -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -flto=3Dthin -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 >> >> CONFIDENTIALITY NOTICE This e-mail message and any attachments are only >> for the use of the intended recipient and may contain information that i= s >> privileged, confidential or exempt from disclosure under applicable law.= If >> you are not the intended recipient, any disclosure, distribution or othe= r >> 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 send= er >> immediately. Thank you. >> > --0000000000009315db0619a3c7d3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Please refer to the following links for help
On Thu, May 30, 2024 at 8:50=E2=80=AFAM Kashif Zeeshan= <kashi.zeeshan@gmail.com= > wrote:
Hi=C2=A0Sumit

Please make=C2=A0sure=C2=A0De= veloper Toolset Repo is enable, the package is not getting installed as its= not being found due to the missing Repo.

Regards<= /div>
Kashif Zeeshan
Bitnine Global

On Wed, May 29, 2024= at 10:10=E2=80=AFPM Sumit Kochar <Sumit.Kochar@mastercard.com> wrote:
<= /div>

Hi Muhammad,

=C2=A0

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

=C2=A0

Log reference below:

=C2=A0

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

This system is not registered with Spacewalk serv= er.

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 t= han once in the configuration

Repository mc-ol7_tsm-8.1.13_x86_64 is listed mor= e 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 llv= m-toolset-7

Loaded plugins: rhnplugin

This system is not registered with Spacewalk serv= er.

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 t= han once in the configuration

Repository mc-ol7_tsm-8.1.13_x86_64 is listed mor= e 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]#

=C2=A0

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.pos= tgresql.org
Subject: {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrappe= r on EDB Postgres to connect to SQL server database

=C2=A0

Hi , You n= eed to install the LLVM toolset. 1)Check that if it is installed or not : y= um list installed | grep llvm-toolset 2)If it is not installed, you can ins= tall it using the following command. sudo yum install llvm-toolset-7 Regards,Mu= hammad

=

Hi ,
You need to install the=C2=A0 LLVM toolset.

1)Check that if it is installed or not :

yum list installed =
| grep llvm-toolset
=C2=A0
2)If it is not installed, you can i=
nstall it using the following command.
sudo yum install ll=
vm-toolset-7
=C2=A0
Regards,=

Muhammad Imtiaz
=C2=A0
=C2=A0
=C2=A0

=C2=A0

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

2024=E5=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 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 availabl= e.
(...)

> [root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 install
>
> /opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno= -strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2=C2=A0 -I./in= clude/ -fvisibility=3Dhidden=C2=A0 -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=C2=A0 -I/usr/include -flto=3Dthin -em= it-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<= br> 7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.o= rg/centos/7/sclo/ .

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 priv= ileged, 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 attach= ments is prohibited. If you have received this e-mail message in error, ple= ase delete and notify the sender immediately. Thank you.
--0000000000009315db0619a3c7d3--