Re: Why Can't I Get PHP to Work with MySQL??

At 02:32 PM 12/23/01 -0600, you wrote:

At 12:16 PM 12/23/2001 -0800, Ben Ocean wrote:

Hi; I get this error when I try to restart Apache: Syntax error on line 236 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/libexec/libphp4.so into server: /etc/httpd/libexec/libphp4.so The above file does, of course, exist. I'm running RH71 i386 with MySQL and PHP installed from source files. Here's my config script: ./configure --with-apxs=/etc/httpd/bin/apxs --with-mysql=/usr/local/mysql --with-kerberos=/usr/kerberos --with-ldap=/usr/local/openldap So, what gives? I've googled this one and it appears there's a lot of folks with this question unanswered!

From the PHP INSTALL file: <quote> Note 3! If you are on Linux and have installed shared libraries, make sure the location of these shared libraries are listed in your /etc/ld.so.conf file. For example, if you have: /usr/local/lib/mysql/libmysqlclient.so Make sure /etc/ld.so.conf contains: /usr/local/lib/mysql Then run ldconfig. </quote> Do the above and this should take care of it.

Well, I'm afraid I've done all of that and the problem remains :( I recalled I also had to hard-code something in the configure script that wasn't working properly: # BENO'S CHANGE: LAST LINE BELOW COMMENT AS WELL... # for i in lib lib/mysql; do # str="$MYSQL_DIR/$i/libmysqlclient.*" # for j in echo $str; do

#    if test -r $j; then
#      MYSQL_LIB_DIR=$MYSQL_DIR/$i
#      break 2
#    fi

# done # # done MYSQL_LIB_DIR=/usr/local/lib (starts at around line 3350). I was getting this error: configure: error: Cannot find mysqlclient library under /usr/local/mysql whereas the library is actually found under /usr/local/lib/mysql. At any rate, made the edit and the error message disappeared, so I assume I did something right, but the fact that I had to make an edit makes me suspicious. Any more ideas? TIA, BenO