compiling PHP can't find mysql header files???? finds the socket?

checking for mhash support... no
checking whether to include mime_magic support... no
checking for MING support... no
checking for mSQL support... no
checking for MSSQL support via FreeTDS... no
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock
configure: error: Cannot find MySQL header files under yes.
Note that the MySQL client library is not bundled anymore!
/usr/local/src/php-5.2.3 # dir /var/lib/mysql
total 21M
8.0K drwxr-xr-x  4 mysql mysql 4.0K Aug 27 15:42 .
8.0K drwxr-xr-x 31 root  root  4.0K Aug 24 02:52 ..
 11M -rw-rw----  1 mysql mysql  10M Aug 27 15:42 ibdata1
5.1M -rw-rw----  1 mysql mysql 5.0M Aug 27 15:42 ib_logfile0
5.1M -rw-rw----  1 mysql mysql 5.0M Aug 24 10:13 ib_logfile1
8.0K drwx------  2 mysql mysql 4.0K Aug 24 10:13 mysql
4.0K srwxrwxrwx  1 mysql mysql    0 Aug 27 15:42 mysql.sock
8.0K drwx------  2 mysql mysql 4.0K Aug 24 10:13 test

Our old system R.H.4 came with the mysql headers,etc.....Does this mean we have to get the Mysqld Enterprise software with license separate from the R.H. 5 system??????

 

/root/php-5.2.3 # dir /usr/include/mysql
total 584K
8.0K drwxr-xr-x    2 root root 4.0K Jul 26 23:31 .
 24K drwxr-xr-x  229 root root  20K Aug  3 12:11 ..
 12K -rw-r--r--    1 root root 4.5K Nov 23  2004 chardefs.h
8.0K -rw-r--r--    1 root root 3.3K Nov 23  2004 errmsg.h
 16K -rw-r--r--    1 root root 9.3K Nov 23  2004 history.h
 12K -rw-r--r--    1 root root 6.5K Nov 23  2004 keycache.h
8.0K -rw-r--r--    1 root root 3.5K Nov 23  2004 keymaps.h
 24K -rw-r--r--    1 root root  18K Nov 23  2004 m_ctype.h
 12K -rw-r--r--    1 root root 7.9K Nov 23  2004 m_string.h
8.0K -rw-r--r--    1 root root 1.9K Nov 23  2004 my_alloc.h
 32K -rw-r--r--    1 root root  27K Nov 23  2004 my_config.h
8.0K -rw-r--r--    1 root root 3.3K Nov 23  2004 my_dbug.h
8.0K -rw-r--r--    1 root root 3.5K Nov 23  2004 my_dir.h
8.0K -rw-r--r--    1 root root 3.0K Nov 23  2004 my_getopt.h
 44K -rw-r--r--    1 root root  38K Nov 23  2004 my_global.h
8.0K -rw-r--r--    1 root root 1.5K Nov 23  2004 my_list.h
8.0K -rw-r--r--    1 root root 3.6K Nov 23  2004 my_net.h
8.0K -rw-r--r--    1 root root 1.3K Nov 23  2004 my_no_pthread.h
 28K -rw-r--r--    1 root root  24K Nov 23  2004 my_pthread.h
8.0K -rw-r--r--    1 root root 1.8K Nov 23  2004 my_semaphore.h
 20K -rw-r--r--    1 root root  15K Nov 23  2004 mysql_com.h
 16K -rw-r--r--    1 root root  12K Nov 23  2004 mysqld_error.h
8.0K -rw-r--r--    1 root root 1.3K Nov 23  2004 mysql_embed.h
 32K -rw-r--r--    1 root root  27K Nov 23  2004 mysql.h
8.0K -rw-r--r--    1 root root 1.6K Nov 23  2004 mysql_time.h
8.0K -rw-r--r--    1 root root  790 Nov 23  2004 mysql_version.h
 36K -rw-r--r--    1 root root  31K Nov 23  2004 my_sys.h
8.0K -rw-r--r--    1 root root 2.0K Nov 23  2004 my_xml.h
 12K -rw-r--r--    1 root root 5.7K Nov 23  2004 raid.h
 36K -rw-r--r--    1 root root  32K Nov 23  2004 readline.h
8.0K -rw-r--r--    1 root root 3.7K Nov 23  2004 rlmbutil.h
 16K -rw-r--r--    1 root root 9.5K Nov 23  2004 rlprivate.h
8.0K -rw-r--r--    1 root root 1.4K Nov 23  2004 rlshell.h
8.0K -rw-r--r--    1 root root 2.8K Nov 23  2004 rltypedefs.h
8.0K -rw-r--r--    1 root root 1.8K Nov 23  2004 sql_common.h
 12K -rw-r--r--    1 root root 6.3K Nov 23  2004 sql_state.h
8.0K -rw-r--r--    1 root root 1.1K Nov 23  2004 sslopt-case.h
8.0K -rw-r--r--    1 root root 1.9K Nov 23  2004 sslopt-longopts.h
8.0K -rw-r--r--    1 root root  970 Nov 23  2004 sslopt-vars.h
8.0K -rw-r--r--    1 root root 3.0K Nov 23  2004 tilde.h
8.0K -rw-r--r--    1 root root 1.3K Nov 23  2004 typelib.h
8.0K -rw-r--r--    1 root root 1.5K Nov 23  2004 xmalloc.h

Try this solution:

 

create symb link for mysql_config

sudo ln -s /usr/local/mysql/bin/mysql_config /usr/bin/mysql_config

HTH

kurund

configure:55648: checking whether to include mime_magic support
configure:56005: checking for MING support
configure:57231: checking for mSQL support
configure:57742: checking for MSSQL support via FreeTDS
configure:58392: checking for MySQL support
configure:58438: checking for specified location of the MySQL UNIX socket
configure:58495: checking for MySQL UNIX socket location
configure:58685: checking for mysql_close in -lmysqlclient
configure:58704: gcc -o conftest -I/usr/include -g -O2  -Wl,-rpath,/usr/lib/mysql -L/usr/lib/mysql -L/usr/lib  conftest.c -lm
ysqlclient  -lz -lresolv -lm -ldl -lnsl  -lxml2 -lz -lm -lxml2 -lz -lm 1>&5
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
configure: failed program was:
#line 58693 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char mysql_close();

int main() {
mysql_close()
; return 0; }
configure:58925: checking for mysql_error in -lmysqlclient
configure:58944: gcc -o conftest -I/usr/include -g -O2  -Wl,-rpath,/usr/lib/mysql -L/usr/lib/mysql -L/usr/lib  -Wl,-rpath,/us
r -L/usr conftest.c -lmysqlclient  -lz -lz -lresolv -lm -ldl -lnsl  -lxml2 -lz -lm -lxml2 -lz -lm 1>&5
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
configure: failed program was:
#line 58933 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char mysql_error();

int main() {
mysql_error()
; return 0; }

checking for MSSQL support via FreeTDS... no
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock
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.