Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

mysql_init build problem.

Help
Simba L
2011-01-08
2013-05-30
  • Simba L
    Simba L
    2011-01-08

    I am unable to build 0.12.1 from the FreeBSD ports on a 7.2-RELEASE machine. I presently have 0.11 running just fine, though my attempts at upgrading have been unsuccessful. I have also tried building from source, as well as the latest SVN with similar results. The issue seems to be a common theme with mysql though I have yet to uncover a solution.

    Configure:

    $ ./configure -with-search=/usr/local -disable-inotify -disable-sqlite3 -enable-mysql -with-mysql-cfg=/usr/local/bin/mysql_config -enable-libjs -with-js-h=/usr/local/include -with-js-libs=/usr/local/lib -enable-libexif -with-libexif-h=/usr/local/include -with-libexif-libs=/usr/local/lib -enable-external-transcoding -enable-ffmpegthumbnailer -with-ffmpegthumbnailer-h=/usr/local/include -with-ffmpegthumbnailer-libs=/usr/local/lib -enable-curl -with-curl-cfg=/usr/local/bin/curl-config -enable-ffmpeg -disable-libextractor -disable-id3lib -enable-taglib -with-taglib-cfg=/usr/local/bin/taglib-config -disable-tombdebug -prefix=/usr/local -mandir=/usr/local/man -infodir=/usr/local/info/ -build=i386-portbld-freebsd7.2

    Error:

    checking mysql.h usability… yes
    checking mysql.h presence… yes
    checking for mysql.h… yes
    checking for mysql_init… no
    configure: error: unable to configure mysql support

    MySQL is 5.0.26 

    Relevant config.log portion:

    configure:22663: checking for mysql.h
    configure:22672: result: yes
    configure:22699: checking for mysql_init
    configure:22755: c++ -o conftest -O2 -fno-strict-aliasing -pipe -I/usr/local/include/mysql -fno-strict-aliasing -pipe   -fno-omit-$
    /usr/bin/ld: warning: libcrypt.so.3, needed by /usr/local/lib/mysql/libmysqlclient_r.so, may conflict with libcrypt.so.4
    /usr/bin/ld: warning: libm.so.4, needed by /usr/local/lib/mysql/libmysqlclient_r.so, may conflict with libm.so.5
    /usr/bin/ld: warning: libz.so.3, needed by /usr/local/lib/mysql/libmysqlclient_r.so, may conflict with libz.so.4
    /usr/bin/ld: warning: libssl.so.4, needed by /usr/local/lib/mysql/libmysqlclient_r.so, may conflict with libssl.so.5
    /usr/bin/ld: warning: libcrypto.so.4, needed by /usr/local/lib/mysql/libmysqlclient_r.so, may conflict with libcrypto.so.5
    /usr/local/lib/mysql/libmysqlclient_r.so: undefined reference to `__h_error'
    configure:22762: $? = 1

     
  • Simba L
    Simba L
    2011-01-08

    Issue seems to be that it will not build against client 5.0.26. Upgraded to 5.1.54_1 and 0.21.0 builds.

     

  • Anonymous
    2013-02-18

    looks like issue is the same with me :

    mysql-5.5.29-1.fc16.x86_64
    mysql-libs-5.5.29-1.fc16.x86_64
    mysql-devel-5.5.29-1.fc16.x86_64

    under fedora 16

     

  • Anonymous
    2013-02-18

       4083 configure:22609: x86_64-thecus64v1-linux-gnu-g++ -E  -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector -param=ssp-buffer-size=4  -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOU        RCE -fno-strict-aliasing -fwrapv -fPIC  -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 conftest.cpp
       4084 configure:22616: $? = 0
       4085 configure:22630: result: yes
       4086 configure:22663: checking for mysql.h
       4087 configure:22672: result: yes
       4088 configure:22699: checking for mysql_init
       4089 configure:22755: x86_64-thecus64v1-linux-gnu-g++ -o conftest -g -O2 -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector -param=ssp-buffer-size=4  -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -        D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -fPIC  -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1  -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstac        k-protector -param=ssp-buffer-size=4  -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -fPIC  -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FAST        MUTEX=1   -lrt conftest.cpp -L/usr/lib64/mysql -lmysqlclient -lpthread -lz -lm -lrt -lssl -lcrypto -ldl  >&5
       4090 /data/Development/Home/Thecus/Toolchains/x-tools/x86_64-thecus64v1-linux-gnu/lib/gcc/x86_64-thecus64v1-linux-gnu/4.4.3/../../../../x86_64-thecus64v1-linux-gnu/bin/ld: cannot find -lz
       4091 collect2: ld returned 1 exit status
       4092 configure:22762: $? = 1

     

  • Anonymous
    2013-02-20

    it appears that this issue shows up when you compile it with sqlite3 and it cannot find the libs/headers, passing with-h& with-libs for slite3 resolved the issue