Building on MacOS Sierra (10.12.6) Fails

[qakapil]

Hi,

While trying to build sqlsmith on MacOS Sierra, the make command fails with this error -

GNU Make 3.81
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
This program built for i386-apple-darwin11.3.0

Any suggestions please ?

Thanks,
Kapil.

[anse1]

Kapil Sharma writes:

While trying to build sqlsmith on MacOS Sierra, the make command fails with this error -

[...]

Any suggestions please ?

I don't have access to a similar system to test, so a couple of questions to narrow the problem down: Is this the only "error message" you see? It looks like the common output of the command "make --version". Did you build from the master branch or the release tarball? What exact invocation of make fails? Does it fail during configure (it tests aspects about make) or during actual building? Did you follow the recipe in the README? Maybe post a log of all commands you invoked and their output. regards, Andreas

[qakapil]

Sorry, I pasted wrong error message above.

I tried building from both master and v1.0 branches.
I followed the README and all the previous steps passed

brew install libpqxx automake libtool autoconf autoconf-archive pkg-config # Passed
cd sqlsmith
autoreconf -i #Passed
./configure #Passed
make . #Failed

#make
/Library/Developer/CommandLineTools/usr/bin/make all-am
g++ -std=c++11 -g -O2 -Wl,--as-needed -L/lib64 -o sqlsmith relmodel.o schema.o random.o expr.o grammar.o log.o dump.o sqlsmith.o -L/usr/local/Cellar/libpqxx/6.1.1/lib -L/usr/local/lib -lpqxx
ld: warning: directory not found for option '-L/lib64'
ld: unknown option: --as-needed
clang: error: linker command failed with exit code 1 (use -v to see invocation)
make[1]: *** [sqlsmith] Error 1
make: *** [all] Error 2

[anse1]

Kapil Sharma writes:

g++ -std=c++11 -g -O2 -Wl,--as-needed -L/lib64 -o sqlsmith relmodel.o

[...]

ld: unknown option: --as-needed clang: error: linker command failed with exit code 1 (use -v to see invocation)

Hrm, looks like your clang++ expects a different version of ld. Things I'd try: - Try updating binutils and clang - maybe one of them is outdated - Try building with gcc instead of clang in the hope that this pairing works. To do that, invoke configure like this: ./configure CXX=/path/to/GNU-g++ - Try invoking the failed linker command manually without the option -Wl,--as-needed. This should yield a running sqlsmith binary. regards, Andreas

[qakapil]

Now even configure is failing. Both with and without CXX=/path/to/GNU-g++

checking for the PostgreSQL libraries LIBS... -lpq
checking for the PostgreSQL version... 10.3
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking for the PostgreSQL library linking is working... no
configure: error: Library requirements (PostgreSQL) not met.

I probably shouldn't have played with MacOs's default clang provided by apple.

[anse1]

Kapil Sharma writes:

checking for libpq-fe.h... yes checking for the PostgreSQL library linking is working... no configure: error: Library requirements (PostgreSQL) not met.

Could you provide the linker error message? IIRC it should be near the end of config.log.

[qakapil]

configure:5135: checking for libpq-fe.h
configure:5135: result: yes
configure:5146: checking for the PostgreSQL library linking is working
configure:5172: g++ -std=c++11 -o conftest -g -O2 -I/usr/local/Cellar/postgresql/10.3/include -L/usr/local/lib conftest.cpp -lpq >&5
conftest.cpp:30:12: error: cannot initialize a variable of type 'char' with an lvalue of type 'const char [18]'
char conninfo="dbname = postgres";
^ ~~~~~~~~~~~~~~~~~~~
1 error generated.
configure:5172: $? = 1
configure: failed program was:
| /* confdefs.h */
| #define PACKAGE_NAME "SQLsmith"
| #define PACKAGE_TARNAME "sqlsmith"
| #define PACKAGE_VERSION "1.1"

[anse1]

Kapil Sharma writes:

configure:5146: checking for the PostgreSQL library linking is working configure:5172: g++ -std=c++11 -o conftest -g -O2 -I/usr/local/Cellar/postgresql/10.3/include -L/usr/local/lib conftest.cpp -lpq >&5 conftest.cpp:30:12: error: cannot initialize a variable of type 'char' with an lvalue of type 'const char [18]' char conninfo="dbname = postgres"; ^ ~~~~~~~~~~~~~~~~~~~

Looks like a broken autoconf check to me. It doesn't seem to come from a macro sqlsmith, autoconf nor autoconf-archive ever shipped though. Do you have any idea where it could come from on your system? Maybe look for the broken code or the check name in the generated aclocal.m4. The macros there usually have a comment on where they originated from.

[anse1]

Andreas Seltenreich writes:

Kapil Sharma writes: > configure:5146: checking for the PostgreSQL library linking is working > configure:5172: g++ -std=c++11 -o conftest -g -O2 -I/usr/local/Cellar/postgresql/10.3/include -L/usr/local/lib conftest.cpp -lpq >&5 > conftest.cpp:30:12: error: cannot initialize a variable of type 'char' with an lvalue of type 'const char [18]' > char conninfo="dbname = postgres"; > ^ ~~~~~~~~~~~~~~~~~~~ Looks like a broken autoconf check to me. It doesn't seem to come from a macro sqlsmith, autoconf nor autoconf-archive ever shipped though.

Ah, I retract that: There is a very recent commit to autoconf-archive that introduced the broken check: ,----[ git://git.sv.gnu.org/autoconf-archive.git ] | commit 19caa0caffa7f12ff77bd9727dbd844e28376895 | Author: Bastien Roucariès <bastien.roucaries+debian@gmail.com> | Date: Mon Mar 12 14:23:51 2018 +0100 | | Modernize ax_lib_postgresql | | Avoid a compilation failure on debian `----

[anse1]

There's still no upstream-fix in autoconf-archive, but there is a new release tarball for sqlsmith available now.
Building from the tarball avoids the autoconf issues you are running into.
Make sure to invoke the configure from the tarball right-away without running autoconf or autoreconf,
as this would reintroduce the broken autoconf-archive code.

[anse1]

This as been fixed in autoconf-archive ↝ closing this issue