DIYMacServer » PHP

8 posts

MySQL error when configuring PHP

started at 23 May 2008
started by clify
last reply from richard
  • clify
    23 May 2008
    #

    Hi,

    Having no joy compiling PHP on Leopard. Previous manage to install both Apache and MySQL. The configure script exits with the following:

    checking for MySQL support... yes
    checking for specified location of the MySQL UNIX socket... no
    checking for MySQL UNIX socket location... no
    checking for mysql_close in -lmysqlclient... no
    checking for mysql_error in -lmysqlclient... no
    configure: error: mysql configure failed. Please check config.log for more information.

    I ran config with the following settings:


    /configure --prefix=/usr/local/php5 \
    > --mandir=/usr/share/man \
    > --infodir=/usr/share/info \
    > --sysconfdir=/etc \
    > --with-zlib \
    > --with-zlib-dir=/usr \
    > --with-openssl \
    > --enable-exif \
    > --enable-ftp \
    > --enable-mbstring \
    > --enable-mbregex \
    > --enable-sockets \
    > --with-mysql=/usr/local/mysql \
    > --with-mysqli=/usr/local/mysql/bin/mysql_config \
    > --with-apxs2=/usr/local/apache2/bin/apxs

    Does anyone have idea what my maybe wrong with my MySQL setup that cause PHP to fail to compile?

    TIA,

    clify

  • richard
    31 May 2008
    #

    Could you post the output of the mysql_config command ?

  • wafox
    13 Dec 2008
    #

    not to hijack this (but I will as the last post on this thread was in May) I have the same issue. I'm running MySQL 5.0.51b

    I was trying to upgrade my php install to 5.2.8 (from 5.2.6) and got the exact same error as the OP. Here is my output of mysql_config:

    Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
    Options:
    --cflags [-I/usr/local/mysql/include/mysql]
    --include [-I/usr/local/mysql/include/mysql]
    --libs [-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm]
    --libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r -lz -lm]
    --socket [/tmp/mysql.sock]
    --port [3306]
    --version [5.0.51b]
    --libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld -lz -lm]

  • richard
    14 Dec 2008
    #

    Could you mail me the config.log file from the 5.2.8 php source directory just to see where and perhaps why it went wrong ?

  • wafox
    16 Dec 2008
    #

    richard,

    I sent this as requested. Thanks for your help.

  • richard
    19 Dec 2008
    #

    The MySQL installation was 64 bits while trying to compile PHP as 32 bits application.

  • gshockoman
    19 Feb 2009
    #

    what is the solution to this ?
    can php be compiled in 64bit as well ?

    thanx

  • richard
    21 Feb 2009
    #

    Yes, that is possible: rad http://diymacserver.com/2008/10/04/update-on-64-bits-compilation/ for more info.

Reply

You must log in to post.