Re: Why Can't I Get PHP to Work with MySQL??
| From: | Brian Clark | Date: | Mon, 24 Dec 2001 00:35:22 +0000 |
| Subject: | Re: Why Can't I Get PHP to Work with MySQL?? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-78635@lists.php.net to get a copy of this message | ||
* Ben Ocean (lists@thewebsons.com) [Dec 23. 2001 16:45]:
> >>./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!
[...]
> 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
Didn't we just go over this yesterday? You needed to pass
--with-mysql=/usr/local instead of --with-mysql=/usr/local/mysql
In the configure you edited, it's going to be looking for [Whatever you
passed configure for --with-mysql] plus a) lib or b) lib/mysql plus
libmysqlclient.*
So when you pass configure --with-mysql=/usr/local/mysql and the path is
actually /usr/local/lib/mysql, you're making it look in a)
/usr/local/mysql/lib or b) /usr/local/mysql/lib/mysql
It doesn't find what it's looking for, so it tells you " Cannot find
mysqlclient library under /usr/local/mysql", which is the path you gave
it. The error is sort of misleading because it doesn't report *exactly*
where it looked, but it's correct nonetheless.
You need to pass it /usr/local because that is the correct *base* path.
Now, after that, if it doesn't configure correctly, that's another story.
--
Brian Clark | Avoiding the general public since 1805!
Fingerprint: 07CE FA37 8DF6 A109 8119 076B B5A2 E5FB E4D0 C7C8
Shin: A device for finding furniture in the dark.