public inbox for [email protected]  
help / color / mirror / Atom feed
Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
3+ messages / 2 participants
[nested] [flat]

* Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
@ 2024-05-29 17:10 Sumit Kochar <[email protected]>
  2024-05-30 03:50 ` Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Kashif Zeeshan <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Sumit Kochar @ 2024-05-29 17:10 UTC (permalink / raw)
  To: Muhammad Imtiaz <[email protected]>; Ian Lawrence Barwick <[email protected]>; +Cc: [email protected] <[email protected]>; Kannan Rajesh <[email protected]>; Haragopal Avvaru <[email protected]>

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 <[email protected]>
Sent: Tuesday, May 28, 2024 11:43 PM
To: Ian Lawrence Barwick <[email protected]>
Cc: Sumit Kochar <[email protected]>; [email protected]
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 <[email protected]<mailto:[email protected]>> wrote:
2024年5月29日(水) 6:10 Sumit Kochar <[email protected]<mailto:[email protected]>>:
>
> 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-f...;
>
>
>
> 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/cento...; .

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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
  2024-05-29 17:10 Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Sumit Kochar <[email protected]>
@ 2024-05-30 03:50 ` Kashif Zeeshan <[email protected]>
  2024-05-30 03:51   ` Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Kashif Zeeshan <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Kashif Zeeshan @ 2024-05-30 03:50 UTC (permalink / raw)
  To: Sumit Kochar <[email protected]>; +Cc: Muhammad Imtiaz <[email protected]>; Ian Lawrence Barwick <[email protected]>; [email protected] <[email protected]>; Kannan Rajesh <[email protected]>; Haragopal Avvaru <[email protected]>

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 <[email protected]>
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 <[email protected]>
> *Sent:* Tuesday, May 28, 2024 11:43 PM
> *To:* Ian Lawrence Barwick <[email protected]>
> *Cc:* Sumit Kochar <[email protected]>;
> [email protected]
> *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 <[email protected]>
> wrote:
>
> 2024年5月29日(水) 6:10 Sumit Kochar <[email protected]>:
> >
> > 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-kF9UHinb...;
> >
> >
> >
> > 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-l...;
> .
>
> 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.
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
  2024-05-29 17:10 Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Sumit Kochar <[email protected]>
  2024-05-30 03:50 ` Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Kashif Zeeshan <[email protected]>
@ 2024-05-30 03:51   ` Kashif Zeeshan <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Kashif Zeeshan @ 2024-05-30 03:51 UTC (permalink / raw)
  To: Sumit Kochar <[email protected]>; +Cc: Muhammad Imtiaz <[email protected]>; Ian Lawrence Barwick <[email protected]>; [email protected] <[email protected]>; Kannan Rajesh <[email protected]>; Haragopal Avvaru <[email protected]>

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 <[email protected]>
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 PM Sumit Kochar <[email protected]>
> 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 <[email protected]>
>> *Sent:* Tuesday, May 28, 2024 11:43 PM
>> *To:* Ian Lawrence Barwick <[email protected]>
>> *Cc:* Sumit Kochar <[email protected]>;
>> [email protected]
>> *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 <[email protected]>
>> wrote:
>>
>> 2024年5月29日(水) 6:10 Sumit Kochar <[email protected]>:
>> >
>> > 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-kF9UHinb...;
>> >
>> >
>> >
>> > 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-l...;
>> .
>>
>> 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.
>>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2024-05-30 03:51 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-29 17:10 Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Sumit Kochar <[email protected]>
2024-05-30 03:50 ` Kashif Zeeshan <[email protected]>
2024-05-30 03:51   ` Kashif Zeeshan <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox