FreeTDS Development Group

[Igor Korot <ikorot01 AT gmail.com>]

Hi,

On Tue, Nov 24, 2020, 10:47 AM Merle Reinhart via FreeTDS <
freetds AT lists.ibiblio.org> wrote:

> Igor,
>
> I have not had any issues building either libiodbc or freetds on Mac OS X


Problem is - I didn't build iODBC - I installed it by grabbing it from
download section of iodbc site and ran the installer.

Thank you.

.
>
> libiodbc:
> sh autogen.sh
> ./configure --prefix=/usr/local/iodbc --with-iodbc-inidir=/Library/ODBC
> --disable-gui --disable-libodbc CFLAGS="-arch x86-64" CC="gcc-9"
> make
> sudo make install
>
> I stick it in a separate directory in /usr/local/ to make it easier for me
> to maintain, but that is just me.
> --with-iodbc-inidir=/Library/ODBC to make it more compatible with the way
> other apps tend to expect the ODBC configuration files
> --disable-gui to not bother with the gui and likely the frameworks which
> just complicates things, ie, I just treat it as a normal unix build
> --disable-libodbc since for my uses libiodbc had to coexist beside the
> unixodbc library
> CFLAGS and -arch x86-64 is just a holdover from years ago where I had to
> build both 32 and 64 bit libraries
> CC="gcc-9" I found years ago that the actual gnu c compiler worked better
> than Apple gcc compatibility wrapper around clang
>
> Last time I built it was this past August on macOS Mojave (Xcode 10.3)
> with iODBC 3.52.13.
>
>
> freetds then builds for me with out issues.
>
> ./configure --with-iodbc=/usr/local/iodbc --prefix=/usr/local/freetds
> --with-libiconv-prefix=/opt/sw -disable-debug --disable-server
> --disable-pool --enable-krb5 --enable-sspi CC=clang CFLAGS="-arch x86_64"
> LDFLAGS="-arch x86_64"
>
> --with-libiconv-prefix=/opt/sw I use the libiconv from the Fink software
> manager as I've had fewer issues with the more recent version it provides
> --disable-debug, -server, -pool I don't need these, so I explicitly
> disable them
> --enable-krb5 we use Kerberos database authentication
> --enable-sspi doesn't really matter on macOS
> CC=clang direct clang and not the Apple gcc compatibility wrapper seems to
> work a little bit better for me
> -arch x86_64 again is just a holdover from years ago when I had to build
> both 32 and 64 bit libraries
>
> Last time I built it was this past August on macOS Mojave (Xcode 10.3)
> with Freetds 1.0.48 and 1.1.24.
>
>
> Hopefully, this helps.
>
> Merle
>
>
>
>
> > On Nov 22, 2020, at 12:31 PM, Frediano Ziglio <freddy77 AT gmail.com>
> wrote:
> >
> > Il giorno sab 21 nov 2020 alle ore 06:46 Igor Korot <ikorot01 AT gmail.com>
> ha
> > scritto:
> >
> >> Sorry, I accidentally hit "Send"...
> >>
> >> Frediano,
> >> Sorry for the top-posting.
> >> Here are my observations:
> >>
> >> The configure script requires the directory where isql.h is
> >>
> >> On my system is in:
> >>
> >> [code]
> >> Igors-MacBook-Air:/ igorkorot$ find . -name isql.h
> >> find: ./usr/sbin/authserver: Permission denied
> >> ./usr/local/iODBC/include/isql.h
> >> find: ./.Spotlight-V100: Permission denied
> >> find: ./Library/Application Support/Apple/ParentalControls/Users:
> >> Permission denied
> >> find: ./Library/Application Support/Apple/AssetCache/Data: Permission
> >> denied
> >> find: ./Library/Application Support/ApplePushService: Permission denied
> >> ./Library/Frameworks/iODBC.framework/Versions/3.52/Headers/isql.h
> >> [/code]
> >>
> >> And so running:
> >>
> >> [code]
> >> Igors-MacBook-Air:freetds igorkorot$ ./configure --enable-odbc
> >> --enable-debug --enable-odbc-wide --with-iodbc=/usr/local/iODBC/
> >> [/code]
> >>
> >> succeeded.
> >>
> >> However, running "make" after that, results in:
> >>
> >> [code]
> >> Making all in odbc
> >> /Applications/Xcode.app/Contents/Developer/usr/bin/make  all-recursive
> >> Making all in .
> >>  CC       odbc.lo
> >> In file included from odbc.c:38:
> >> In file included from ../../include/freetds/odbc.h:36:
> >> /usr/local/iODBC//include/isql.h:84:10: fatal error: 'iODBC/sql.h'
> >> file not found
> >> #include <iODBC/sql.h>
> >>         ^~~~~~~~~~~~~
> >> 1 error generated.
> >> make[4]: *** [odbc.lo] Error 1
> >> make[3]: *** [all-recursive] Error 1
> >> make[2]: *** [all] Error 2
> >> make[1]: *** [all-recursive] Error 1
> >> make: *** [all-recursive] Error 1
> >> [/code]
> >>
> >> So, any help fixing this/properly running configure & make?
> >>
> >> Thank you.
> >>
> >>
> > Hi,
> >  it looks like MacOS is pretty weird. Also the installation of iODBC is
> > not that coherent.
> > There's a iodbc-config I tried to use but is pretty useless as it uses
> > "normal" Unix arguments (-L, -I, etc) while
> > iODBC is installed using MacOS frameworks. I "solved" using these
> commands:
> >
> > $ IODBC_CFLAGS='-I/usr/local/iODBC/include -F/Library/Frameworks
> -framework
> > iODBC -framework iODBCinst'
> > $ export IODBC_CFLAGS
> > $ IODBC_LIBS='-I/usr/local/iODBC/include -F/Library/Frameworks -framework
> > iODBC -framework iODBCinst'
> > $ export IODBC_LIBS
> > $ ./configure --with-iodbc
> >
> > (yes, the 2 environments are duplicated)
> >
> > it compiles (not currently tested) although otool -L is reporting that 2
> > iodbc libraries are imported (it should
> > import only one).
> >
> > I found on the internet a discussion where somebody wrote that a patch
> was
> > in progress (in May) but I installed
> > last iODBC and it still has the issue.
> >
> > I don't have much MacOS knowledge to suggest the final method, not sure
> if
> > this is the best way to
> > solve the issue.
> >
> > Frediano
> >
> >
> >>
> >>> On Fri, Nov 20, 2020 at 3:28 AM Igor Korot <ikorot01 AT gmail.com> wrote:
> >>>>
> >>>> Hi, Frediano,
> >>>>
> >>>> On Fri, Nov 20, 2020 at 2:41 AM Frediano Ziglio <freddy77 AT gmail.com>
> >> wrote:
> >>>>>
> >>>>> Il giorno ven 20 nov 2020 alle ore 07:37 Igor Korot <
> >> ikorot01 AT gmail.com> ha
> >>>>> scritto:
> >>>>>
> >>>>>> Hi, (Frediano),
> >>>>>> I am trying to build freeTDS latest release on OSX 10.13 with the
> >> ODBC
> >>>>>> driver.
> >>>>>>
> >>>>>> I installed latest iODBC DM and then tried building.
> >>>>>>
> >>>>>> The log is below:
> >>>>>>
> >>>>>> [code]
> >>>>>> Igors-MacBook-Air:freetds igorkorot$ ./configure --enable-odbc
> >>>>>> --enable-debug --enable-odbc-wide --with-iodbc && make
> >>>>>> checking for a BSD-compatible install... /usr/bin/install -c
> >>>>>> checking whether build environment is sane... yes
> >>>>>> checking for a thread-safe mkdir -p... ./install-sh -c -d
> >>>>>> checking for gawk... no
> >>>>>> checking for mawk... no
> >>>>>> checking for nawk... no
> >>>>>> checking for awk... awk
> >>>>>> checking whether make sets $(MAKE)... yes
> >>>>>> checking whether make supports nested variables... yes
> >>>>>> checking whether make supports nested variables... (cached) yes
> >>>>>> checking for gawk... (cached) awk
> >>>>>> checking for grep that handles long lines and -e... /usr/bin/grep
> >>>>>> checking whether ln -s works... yes
> >>>>>> checking for a sed that does not truncate output... /usr/bin/sed
> >>>>>> checking for pkg-config... no
> >>>>>>
> >>>>>
> >>>>> That's not expected. Weird on a new system, but maybe is just that I
> >> have
> >>>>> Brew installed.
> >>>>
> >>>> Probably.
> >>>> I rather prefer to install official packages and not from HB.
> >>>>
> >>>> Just grabbed it from iodbc.org...
> >>>>
> >>>>>
> >>>>>
> >>>>>> checking build system type... x86_64-apple-darwin17.7.0
> >>>>>> checking host system type... x86_64-apple-darwin17.7.0
> >>>>>> checking whether make supports the include directive... yes (GNU
> >> style)
> >>>>>> checking for gcc... gcc
> >>>>>>
> >>>>>
> >>>>> ... omissis ...
> >>>>>
> >>>>> checking compile-time options
> >>>>>> checking for IODBC... no
> >>>>>> configure: error: in `/Users/igorkorot/freetds':
> >>>>>> configure: error: The pkg-config script could not be found or is
> >> too
> >>>>>> old.  Make sure it
> >>>>>> is in your PATH or set the PKG_CONFIG environment variable to the
> >> full
> >>>>>> path to pkg-config.
> >>>>>>
> >>>>>
> >>>>> That is the result of not founding pkg-config previously
> >>>>
> >>>> Correct.
> >>>>
> >>>>>
> >>>>>
> >>>>>> Alternatively, you may set the environment variables IODBC_CFLAGS
> >>>>>> and IODBC_LIBS to avoid the need to call pkg-config.
> >>>>>>
> >>>>>
> >>>>> That's a workaround. Or you could try using --with-idobc=<directory>
> >>>>> instead.
> >>>>
> >>>> I don't know what flags that library was built with...
> >>>>
> >>>>>
> >>>>> In configure.ac:
> >>>>>
> >>>>>        # The user asked for iodbc support, but didn't tell us
> >>>>>        # where to look. So, we'll try to get the info from
> >>>>>        # pkg-config. If we can't, we'll display an error.
> >>>>>        PKG_CHECK_MODULES(IODBC, libiodbc)
> >>>>>
> >>>>> so the configure it's behaving as expected (although it could try a
> >> bit
> >>>>> harder).
> >>>>
> >>>> ... so I should use the path to libiodbc, right?
> >>>>
> >>>>>
> >>>>>
> >>>>>> See the pkg-config man page for more details.
> >>>>>>
> >>>>>> To get pkg-config, see <http://pkg-config.freedesktop.org/>.
> >>>>>> See `config.log' for more details
> >>>>>> Igors-MacBook-Air:freetds igorkorot$
> >>>>>> [/code]
> >>>>>>
> >>>>>> I can successfully run the iODBC GUI.
> >>>>>>
> >>>>>> So what is going on?
> >>>>>>
> >>>>>> Thank you.
> >>>>>>
> >>>>>
> >>>>> I'll check my MacOS to see where pkg-config is and where the include
> >> files
> >>>>> are.
> >>>>
> >>>> Maybe the install is different if its downloaded from iodbc.org?
> >>>>
> >>>> Thank you.
> >>>>
> >>>>>
> >>>>> Frediano
> >>>>> _______________________________________________
> >>>>> FreeTDS mailing list
> >>>>> FreeTDS AT lists.ibiblio.org
> >>>>> https://lists.ibiblio.org/mailman/listinfo/freetds
> >> _______________________________________________
> >> FreeTDS mailing list
> >> FreeTDS AT lists.ibiblio.org
> >> https://lists.ibiblio.org/mailman/listinfo/freetds
> >>
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > https://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
>