make install fails on CentOs 6.5 64 bits - Postgresql 9.3 about tds_fdw HOT 10 CLOSED

Hi,
I was able to run make install editing this Makefile line: DATA = $(wildcard sql/--.sql) sql/$(EXTENSION)--$(EXTVERSION).sql to DATA = $(wildcard sql/--.sql).
After this, i got another error when creating pg extension:
ERROR: could not load library "/usr/pgsql-9.3/lib/tds_fdw.so": /usr/pgsql-9.3/lib/tds_fdw.so: undefined symbol: dbwillconvert

Regards

from tds_fdw.

Strange. I'll look into it. Someone else is getting a similar error. What is the output of ldd /usr/pgsql-9.3/lib/tds_fdw.so?

from tds_fdw.

At some point, I made a change to the Makefile that messed up linking. I am pretty sure I tested the new Makefile, but apparently I must not have tested correctly. When I tested just now, it obviously failed.

I committed some changes to the Makefile just now, and it builds just fine for me on CentOS 6 x86_64. Can you please give the new Makefile a try?

from tds_fdw.

Hi Geoff,
Thanks for your answer. I executed make install again but the same error occurred:

/bin/mkdir -p '/usr/pgsql-9.3/lib'
/bin/mkdir -p '/usr/pgsql-9.3/share/extension'
/bin/mkdir -p '/usr/pgsql-9.3/share/extension'
/bin/mkdir -p '/usr/share/doc/pgsql/extension'
/usr/bin/install -c -m 755  tds_fdw.so '/usr/pgsql-9.3/lib/tds_fdw.so'
/usr/bin/install -c -m 644 ./tds_fdw.control '/usr/pgsql-9.3/share/extension/'
/usr/bin/install -c -m 644 ./sql/tds_fdw--1.0.0.sql ./sql/tds_fdw--1.0.0.sql  '/usr/pgsql-9.3/share/extension/'
/usr/bin/install: will not overwrite just-created `/usr/pgsql-9.3/share/extension/tds_fdw--1.0.0.sql' with `./sql/tds_fdw--1.0.0.sql'
make: *** [install] Error 1

I needed to edit the makefile again to compile tds_fdw. After compiling, I tried tio create the extension and it seems to be ok:

postgres=# CREATE EXTENSION tds_fdw;
CREATE EXTENSION

Now, the output of ldd /usr/pgsql-9.3/lib/tds_fdw.so is:

 ldd /usr/pgsql-9.3/lib/tds_fdw.so
        linux-vdso.so.1 =>  (0x00007fff637ff000)
        libsybdb.so.5 => /usr/lib64/libsybdb.so.5 (0x00007f941b99c000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f941b608000)
        libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f941b3c3000)
        libgnutls.so.26 => /usr/lib64/libgnutls.so.26 (0x00007f941b120000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f941af18000)
        libgcrypt.so.11 => /lib64/libgcrypt.so.11 (0x00007f941aca2000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f941aa85000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f941be10000)
        libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f941a79f000)
        libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f941a572000)
        libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f941a36e000)
        libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f941a163000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f9419f5e000)
        libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f9419d5b000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f9419b41000)
        libtasn1.so.3 => /usr/lib64/libtasn1.so.3 (0x00007f9419930000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f941971a000)
        libgpg-error.so.0 => /lib64/libgpg-error.so.0 (0x00007f9419516000)
        libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f94192f6000)

Before it was:

ldd /usr/pgsql-9.3/lib/tds_fdw.so
        linux-vdso.so.1 =>  (0x00007fff5a399000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f8ba6051000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f8ba65f0000)

I will test to query my sql server database tomorrow when I get back to work (in some hours), and get back to you with the test results.

Regards,
Vitor

from tds_fdw.

Thanks for the quick reply. I just committed a Makefile with changes to fix the problem with DATA as well.

from tds_fdw.

Hi Geoff,
With this new commit I was able to run make install without errors. I created the extension with this new generate tds_fdw.so and it was ok. Now I can access my Sql Server tables!
Thanks for your help.

It is possible to write on sql server?

Regards,
Vitor

from tds_fdw.

I'm glad it works for you now!

Write support isn't available yet. Maybe I'll get around to adding it eventually. tds_fdw is kind of a hobby project for me right now. I don't really get a chance to work on it as part of my day job.

from tds_fdw.

Ok!

Regards

from tds_fdw.

i have the same problem on WINDOWS.
Do you have windows version? I just testet oracle_fdw and it wast copy&paste install....
Please answer,
Regards!

from tds_fdw.

Hi @binekkk,

I haven't tried compiling under Windows, but you will also need a DB-Library implementation there too. The FreeTDS documentation lists several ways to build FreeTDS on Windows.

from tds_fdw.