Thread: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

Brought to you by: mused

sqlrelay-discussion

[Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: Petros M. <ern...@ya...> - 2013-01-14 19:54:12

Hello,

On debian wheezy, the configure script cannot find some (optional)
dependencies such as freetds and odbc libraries. Of course, the relevant
'-dev' packages are already installed. Maybe this is irrelevant, but I
notice that both freetds and odbc libraries are packaged on Debian under
/usr, not under their own directory (e.g freetds headers are in
'/usr/include', not in '/usr/include/freetds'). I have also tried the
'--with-LIBRARY_NAME-prefix' option, but without any luck. I' m trying
with the latest sources (version 0.49).

Has anyone built sqlrelay successfully on Debian Wheezy?

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: David M. <dav...@fi...> - 2013-01-15 14:37:07

Interesting.  The freetds and odbc libs are under /usr on fedora and 
ubuntu too, and it finds them.  Something else must be going on.  Could 
you post the output of the configure script and attach the config.log 
file that gets generated?

Thanks.

Dave
dav...@fi...

On 01/14/2013 02:40 PM, Petros Moisiadis wrote:
> Hello,
>
> On debian wheezy, the configure script cannot find some (optional)
> dependencies such as freetds and odbc libraries. Of course, the relevant
> '-dev' packages are already installed. Maybe this is irrelevant, but I
> notice that both freetds and odbc libraries are packaged on Debian under
> /usr, not under their own directory (e.g freetds headers are in
> '/usr/include', not in '/usr/include/freetds'). I have also tried the
> '--with-LIBRARY_NAME-prefix' option, but without any luck. I' m trying
> with the latest sources (version 0.49).
>
> Has anyone built sqlrelay successfully on Debian Wheezy?
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. SALE $99.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122412
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: Petros M. <ern...@ya...> - 2013-01-15 19:02:12

Attachments: config.log.tar.gz

On 15/01/2013 04:36 Î¼Î¼, David Muse wrote:
> Interesting.  The freetds and odbc libs are under /usr on fedora and 
> ubuntu too, and it finds them.  Something else must be going on.  Could 
> you post the output of the configure script and attach the config.log 
> file that gets generated?
>
> Thanks.
>
> Dave
> dav...@fi...

Well, I also noticed other strange check results in the logs (eg.
'checking for ANSI C header files... no'). I' m attaching the logs.

Thanks.

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: Petros M. <ern...@ya...> - 2013-01-15 20:00:55

On 15/01/2013 09:02 μμ, Petros Moisiadis wrote:
>
> Well, I also noticed other strange check results in the logs (eg.
> 'checking for ANSI C header files... no'). I' m attaching the logs.
>
> Thanks.
>

Well, maybe that 'checking for ANSI C header files... no' is not that
strange...
However, I tried, on Debian, the configure script of another software
that needs odbc too, and the library was detected normally.
I also tried sqlrelay's configure script on a system with Archlinux and
the installed libraries were detected normally too.
So, I suppose the problem has to do only sqlrelay on Debian (Wheezy).

Thanks.

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: David M. <dav...@fi...> - 2013-01-15 20:48:05

Hmm...

If you can, try installing libtool, automake and autoconf, then run 
./autogen.sh inside of the sqlrelay distro and then ./configure again. 
It's possible that some things have changed on Wheezy that make the 
included configure script fail in odd ways, but that when the configure 
script is regenerated on Wheezy, it works.

I ran into issues like that with Ubuntu way back.  Ubuntu uses dash 
instead of bash for /bin/sh and autoconf from Fedora 13 (or so) created 
a configure script that wasn't compatible with dash, but if I used 
autoconf on Ubuntu, it worked.

This could be something similar.

Dave

On 01/15/2013 03:00 PM, Petros Moisiadis wrote:
> On 15/01/2013 09:02 μμ, Petros Moisiadis wrote:
>>
>> Well, I also noticed other strange check results in the logs (eg.
>> 'checking for ANSI C header files... no'). I' m attaching the logs.
>>
>> Thanks.
>>
>
> Well, maybe that 'checking for ANSI C header files... no' is not that
> strange...
> However, I tried, on Debian, the configure script of another software
> that needs odbc too, and the library was detected normally.
> I also tried sqlrelay's configure script on a system with Archlinux and
> the installed libraries were detected normally too.
> So, I suppose the problem has to do only sqlrelay on Debian (Wheezy).
>
> Thanks.
>
> ------------------------------------------------------------------------------
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> Ryb�+^t8��6�i:ڞ�ެ���̒@�虨��-�x!���0v�^j̜om==
>

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: Petros M. <ern...@ya...> - 2013-01-16 14:03:00

On 15/01/2013 10:47 μμ, David Muse wrote:
> Hmm...
>
> If you can, try installing libtool, automake and autoconf, then run 
> ./autogen.sh inside of the sqlrelay distro and then ./configure again. 
> It's possible that some things have changed on Wheezy that make the 
> included configure script fail in odd ways, but that when the configure 
> script is regenerated on Wheezy, it works.
>
> I ran into issues like that with Ubuntu way back.  Ubuntu uses dash 
> instead of bash for /bin/sh and autoconf from Fedora 13 (or so) created 
> a configure script that wasn't compatible with dash, but if I used 
> autoconf on Ubuntu, it worked.
>
> This could be something similar.
>
> Dave
>
I have already done that, without any luck though.

The output of ./autogen.sh:
libtoolize: putting auxiliary files in `.'.
libtoolize: copying file `./ltmain.sh'
libtoolize: Consider adding `AC_CONFIG_MACRO_DIR([m4])' to configure.in and
libtoolize: rerunning libtoolize, to keep the correct libtool macros
in-tree.
libtoolize: Consider adding `-I m4' to ACLOCAL_AMFLAGS in Makefile.am.

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: David M. <dav...@fi...> - 2013-01-16 19:36:57

Weird.  I don't see anything unusual in the configure output or 
config.log except for the lack of ANSI C header files, and in that case, 
the configure script failed to write out a test program for some reason.

Could you post the list of files in the freetds and freetds-dev 
packages?  Maybe that will shed some light on the issue.

Dave

On 01/16/2013 09:02 AM, Petros Moisiadis wrote:
> On 15/01/2013 10:47 μμ, David Muse wrote:
>> Hmm...
>>
>> If you can, try installing libtool, automake and autoconf, then run
>> ./autogen.sh inside of the sqlrelay distro and then ./configure again.
>> It's possible that some things have changed on Wheezy that make the
>> included configure script fail in odd ways, but that when the configure
>> script is regenerated on Wheezy, it works.
>>
>> I ran into issues like that with Ubuntu way back.  Ubuntu uses dash
>> instead of bash for /bin/sh and autoconf from Fedora 13 (or so) created
>> a configure script that wasn't compatible with dash, but if I used
>> autoconf on Ubuntu, it worked.
>>
>> This could be something similar.
>>
>> Dave
>>
> I have already done that, without any luck though.
>
> The output of ./autogen.sh:
> libtoolize: putting auxiliary files in `.'.
> libtoolize: copying file `./ltmain.sh'
> libtoolize: Consider adding `AC_CONFIG_MACRO_DIR([m4])' to configure.in and
> libtoolize: rerunning libtoolize, to keep the correct libtool macros
> in-tree.
> libtoolize: Consider adding `-I m4' to ACLOCAL_AMFLAGS in Makefile.am.
>
> ------------------------------------------------------------------------------
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> Ryb�+^t8��6�i:ڞ�ެ���̒@�虨��-�x!���0v�^j̜om==
>

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: Petros M. <ern...@ya...> - 2013-01-17 11:32:44

On 16/01/2013 09:36 μμ, David Muse wrote:
> Weird.  I don't see anything unusual in the configure output or 
> config.log except for the lack of ANSI C header files, and in that case, 
> the configure script failed to write out a test program for some reason.
>
> Could you post the list of files in the freetds and freetds-dev 
> packages?  Maybe that will shed some light on the issue.
>
> Dave
Good suggestion. I think that I found an explanation to the problem...
The debian packages put library files under
|"/usr/lib/x86_64-linux-gnu|" path, which is not checked by the
configure script.

For example, here are lists of files in 'freetds-*' packages:

|$ dpkg -L freetds-common||
||/.||
||/usr||
||/usr/share||
||/usr/share/doc||
||/usr/share/doc/freetds-common||
||/usr/share/doc/freetds-common/README||
||/usr/share/doc/freetds-common/NEWS.gz||
||/usr/share/doc/freetds-common/README.Debian||
||/usr/share/doc/freetds-common/changelog.Debian.gz||
||/usr/share/doc/freetds-common/copyright||
||/usr/share/doc/freetds-common/TODO.gz||
||/usr/share/doc/freetds-common/examples||
||/usr/share/doc/freetds-common/examples/locales.conf||
||/usr/share/doc/freetds-common/examples/freetds.conf.pl||
||/usr/share/doc/freetds-common/TODO.Debian||
||/usr/share/doc/freetds-common/changelog.gz||
||/usr/share/freetds||
||/usr/share/freetds/freetds.conf||
||/usr/share/man||
||/usr/share/man/man5||
||/usr/share/man/man5/freetds.conf.5.gz||
||/usr/lib||
||/usr/lib/odbc||
||/usr/include||
||/etc||
||/etc/freetds||
||/usr/share/doc/freetds-common/examples/freetds.conf||
||
||$ dpkg -L freetds-dev||
||/.||
||/usr||
||/usr/share||
||/usr/share/doc||
||/usr/share/doc/freetds-dev||
||/usr/share/doc/freetds-dev/changelog.Debian.gz||
||/usr/share/doc/freetds-dev/copyright||
||/usr/share/doc/freetds-dev/changelog.gz||
||/usr/lib||
||/usr/lib/x86_64-linux-gnu||
||/usr/lib/x86_64-linux-gnu/libct.a||
||/usr/lib/x86_64-linux-gnu/libsybdb.a||
||/usr/include||
||/usr/include/cspublic.h||
||/usr/include/ctpublic.h||
||/usr/include/sybdb.h||
||/usr/include/sqldb.h||
||/usr/include/odbcss.h||
||/usr/include/syberror.h||
||/usr/include/cstypes.h||
||/usr/include/tds_sysdep_public.h||
||/usr/include/bkpublic.h||
||/usr/include/sqlfront.h||
||/usr/include/sybfront.h||
||/usr/lib/x86_64-linux-gnu/libsybdb.so||
||/usr/lib/x86_64-linux-gnu/libct.so

||$ dpkg -L freetds-bin||
||/.||
||/usr||
||/usr/bin||
||/usr/bin/freebcp||
||/usr/bin/defncopy||
||/usr/bin/osql||
||/usr/bin/tsql||
||/usr/bin/bsqldb||
||/usr/bin/datacopy||
||/usr/bin/fisql||
||/usr/bin/tdspool||
||/usr/bin/bsqlodbc||
||/usr/share||
||/usr/share/doc||
||/usr/share/doc/freetds-bin||
||/usr/share/doc/freetds-bin/changelog.Debian.gz||
||/usr/share/doc/freetds-bin/copyright||
||/usr/share/doc/freetds-bin/changelog.gz||
||/usr/share/man||
||/usr/share/man/man1||
||/usr/share/man/man1/defncopy.1.gz||
||/usr/share/man/man1/tsql.1.gz||
||/usr/share/man/man1/osql.1.gz||
||/usr/share/man/man1/datacopy.1.gz||
||/usr/share/man/man1/bsqldb.1.gz||
||/usr/share/man/man1/freebcp.1.gz||
||/usr/share/man/man1/fisql.1.gz||
||/usr/share/man/man1/bsqlodbc.1.gz||
|

So, I guess that a solution would have to do with somehow making
sqlrelay's autoconf configuration/bootstrap files aware of the
'/usr/lib/x86_64-linux-gnu' path.||

Thanks.

Re: [Sqlrelay-discussion] configure script cannot find some dependencies on debian wheezy

From: Petros M. <ern...@ya...> - 2013-01-17 18:28:49

Attachments: multiarch_debian_configure.patch

On 17/01/2013 01:32 ??, Petros Moisiadis wrote:
> Good suggestion. I think that I found an explanation to the problem...
> The debian packages put library files under
> |"/usr/lib/x86_64-linux-gnu|" path, which is not checked by the
> configure script.
>
> For example, here are lists of files in 'freetds-*' packages:
>
> |$ dpkg -L freetds-common||
> ||/.||
> ||/usr||
> ||/usr/share||
> ||/usr/share/doc||
> ||/usr/share/doc/freetds-common||
> ||/usr/share/doc/freetds-common/README||
> ||/usr/share/doc/freetds-common/NEWS.gz||
> ||/usr/share/doc/freetds-common/README.Debian||
> ||/usr/share/doc/freetds-common/changelog.Debian.gz||
> ||/usr/share/doc/freetds-common/copyright||
> ||/usr/share/doc/freetds-common/TODO.gz||
> ||/usr/share/doc/freetds-common/examples||
> ||/usr/share/doc/freetds-common/examples/locales.conf||
> ||/usr/share/doc/freetds-common/examples/freetds.conf.pl||
> ||/usr/share/doc/freetds-common/TODO.Debian||
> ||/usr/share/doc/freetds-common/changelog.gz||
> ||/usr/share/freetds||
> ||/usr/share/freetds/freetds.conf||
> ||/usr/share/man||
> ||/usr/share/man/man5||
> ||/usr/share/man/man5/freetds.conf.5.gz||
> ||/usr/lib||
> ||/usr/lib/odbc||
> ||/usr/include||
> ||/etc||
> ||/etc/freetds||
> ||/usr/share/doc/freetds-common/examples/freetds.conf||
> ||
> ||$ dpkg -L freetds-dev||
> ||/.||
> ||/usr||
> ||/usr/share||
> ||/usr/share/doc||
> ||/usr/share/doc/freetds-dev||
> ||/usr/share/doc/freetds-dev/changelog.Debian.gz||
> ||/usr/share/doc/freetds-dev/copyright||
> ||/usr/share/doc/freetds-dev/changelog.gz||
> ||/usr/lib||
> ||/usr/lib/x86_64-linux-gnu||
> ||/usr/lib/x86_64-linux-gnu/libct.a||
> ||/usr/lib/x86_64-linux-gnu/libsybdb.a||
> ||/usr/include||
> ||/usr/include/cspublic.h||
> ||/usr/include/ctpublic.h||
> ||/usr/include/sybdb.h||
> ||/usr/include/sqldb.h||
> ||/usr/include/odbcss.h||
> ||/usr/include/syberror.h||
> ||/usr/include/cstypes.h||
> ||/usr/include/tds_sysdep_public.h||
> ||/usr/include/bkpublic.h||
> ||/usr/include/sqlfront.h||
> ||/usr/include/sybfront.h||
> ||/usr/lib/x86_64-linux-gnu/libsybdb.so||
> ||/usr/lib/x86_64-linux-gnu/libct.so
>
> ||$ dpkg -L freetds-bin||
> ||/.||
> ||/usr||
> ||/usr/bin||
> ||/usr/bin/freebcp||
> ||/usr/bin/defncopy||
> ||/usr/bin/osql||
> ||/usr/bin/tsql||
> ||/usr/bin/bsqldb||
> ||/usr/bin/datacopy||
> ||/usr/bin/fisql||
> ||/usr/bin/tdspool||
> ||/usr/bin/bsqlodbc||
> ||/usr/share||
> ||/usr/share/doc||
> ||/usr/share/doc/freetds-bin||
> ||/usr/share/doc/freetds-bin/changelog.Debian.gz||
> ||/usr/share/doc/freetds-bin/copyright||
> ||/usr/share/doc/freetds-bin/changelog.gz||
> ||/usr/share/man||
> ||/usr/share/man/man1||
> ||/usr/share/man/man1/defncopy.1.gz||
> ||/usr/share/man/man1/tsql.1.gz||
> ||/usr/share/man/man1/osql.1.gz||
> ||/usr/share/man/man1/datacopy.1.gz||
> ||/usr/share/man/man1/bsqldb.1.gz||
> ||/usr/share/man/man1/freebcp.1.gz||
> ||/usr/share/man/man1/fisql.1.gz||
> ||/usr/share/man/man1/bsqlodbc.1.gz||
> |
>
> So, I guess that a solution would have to do with somehow making
> sqlrelay's autoconf configuration/bootstrap files aware of the
> '/usr/lib/x86_64-linux-gnu' path.||
>
> Thanks. 

Finally, I patched acsite.m4 to also search in the
/usr/lib/[i386|x86_64]-linux-gnu paths used in multiarch debian systems,
ran again the autogen.sh script and now configure script finds all the libs.
I'm attaching the patch file.

Thanks for helping me find out what was going wrong.