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 1sCWoB-006AJr-MC for pgsql-general@arkaria.postgresql.org; Thu, 30 May 2024 03:50:33 +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 1sCWoB-000pAS-Ka for pgsql-general@arkaria.postgresql.org; Thu, 30 May 2024 03:50:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCWoB-000pAK-77 for pgsql-general@lists.postgresql.org; Thu, 30 May 2024 03:50:31 +0000 Received: from mail-vs1-xe30.google.com ([2607:f8b0:4864:20::e30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sCWo7-001Rs6-VC for pgsql-general@lists.postgresql.org; Thu, 30 May 2024 03:50:30 +0000 Received: by mail-vs1-xe30.google.com with SMTP id ada2fe7eead31-48a39b54e22so171816137.3 for ; Wed, 29 May 2024 20:50:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717041027; x=1717645827; 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=boU9+MpT6qVkeow8lkHr0MjXTOOjQVGrj6JFJUJOrGI=; b=ngo6m642BSKmCaDuexipQLYXzUHl12v8JjjwQUnwMXrtOqiejHtJSMNL2gB+twK8Jr MjEIA4ywTm11+RBeDwD4n76dlMaqkVoKK94oEBOZwAGi5QWF8DYElu3dFkV1nAcQ8b6U DUTmZ77kBGHHvm9vdBX1JDNLEt5aqLe0cMFFAX4kp573Xia/meI4KTp+qSbJOmAuSJwi 5jjoFtomaNYnphq8a5wnrTmQe7uSCY8Iq4kTtxbOZmhedSqeCDdpdRXnvfO66rynsSXC 3HWLPAC19J6LlHt/+8v2ijYxb40TKItx2zO3PuueofudfnwoAqrePoKGTlrzmt7RzSPN KpZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717041027; x=1717645827; 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=boU9+MpT6qVkeow8lkHr0MjXTOOjQVGrj6JFJUJOrGI=; b=Bpq1dx4v2lTGHlONs1+jVzu1fFwCSdNNzdki7x55vJ6uRPgYMQ9y8sTF7QC2dluqGG UnC6T3JL+b9zahAI+mWgA/1GK8SCB7dd/T0H/xU/bPdhHdDcWhWusOgIy9dCnMnRjmYt Q3nyxijIM8lpcIVU7iMNoDk8rjPWVQYfSwWmuXzd1GupaD16mHKaqVbfZP/+r5R9uzPZ SrW8QR2yvJ53nZyf0JU6clLnwRF6kwov8DEvJFHOnirVqNRE8b+b76gRtRHaE9bzez3X bVKN6YQfqRMyRHIM/cnc3Gcdx96M34nAOYpN6GiQL1vFYsJ9m9oXQTcoE+RSXQuwx9MW bfsQ== X-Forwarded-Encrypted: i=1; AJvYcCW7kKzCqI5BnT839hfWKbeOCYa9J7mcRkah4aST2zorWg5xMDEsE37XXif47k57Q4rLLGh23KtG3FH5zexd6W3sX6rgCo041cDllAhaLsHh8aT5 X-Gm-Message-State: AOJu0YxJgp5ZDMioQguKxCERq6Aqz7nh/r+i+ds18sebWCANa3zcjFAB HrcA3SXGqeZmmfaOdZOLZqDximn0PTFDWbSjdLwB3pDZfHywYipv9c10uCmqDhL4JMxgm/vszlN WLJK8vsvaWb8s6u1INay0ftOfgjY= X-Google-Smtp-Source: AGHT+IGKZwiP57jt1k9BVq2Wxk0CBqWMjtNe7HpWivixUTRIolYujY0kBG8yNtJZsBktQRCoSwBJGRvCvhM+DnleatU= X-Received: by 2002:a67:ad0f:0:b0:48b:ae5b:b356 with SMTP id ada2fe7eead31-48baea188bbmr1046052137.15.1717041026839; Wed, 29 May 2024 20:50:26 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Thu, 30 May 2024 08:50:14 +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="000000000000783cde0619a3c4eb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000783cde0619a3c4eb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 installe= d > 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 > 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 available= . > (...) > > > [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/serv= er > -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-l= lvm > -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 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 sende= r > immediately. Thank you. > --000000000000783cde0619a3c4eb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Sumit

Please make=C2=A0sure=C2= =A0Developer Toolset Repo is enable, the package is not getting installed a= s its not being found due to the missing Repo.

Reg= ards
Kashif Zeeshan
Bitnine Global

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

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.
--000000000000783cde0619a3c4eb--