PHP 4.0 Bug #4223: PHP calls MySQL with apache user instead of connected user
| From: | louis at sitebysite dot nl | Date: | Mon, 24 Apr 2000 07:04:48 +0000 |
| Subject: | PHP 4.0 Bug #4223: PHP calls MySQL with apache user instead of connected user | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-18142@lists.php.net to get a copy of this message | ||
From: louis@sitebysite.nl
Operating system: RedHat 6.1
PHP version: 4.0 Release Candidate 1
PHP Bug Type: MySQL related
Bug description: PHP calls MySQL with apache user instead of connected user
This is hard to reproduce, but every once in a while PHP tries to use the
user running apache instead of the user specified in mysql_pconnect() to
query MySQL. So after a pconnect with user X, you get a "access denied
for user www" from the query. Our config is a dual-processor webserver
and dual-processor MySQL machine. With low traffic, it does not occur.
It also appears to occur only when using write locks on tables, but I
can't positively verify that - only that I haven't seen it happen on sites
not using table locks, yet.
PHP configured with:
./configure --with-apxs=/usr/local/apache/bin/apxs --with-mysql=/usr --enable-track-vars
--with-gd=../gd1.4 --with-ttf --without-pcre-regex --with-mm=../mm-1.0.12
--enable-inline-optimization --disable-debug --with-recode --with-t1lib --with-dbase
Also running the Zend optimizer for RC1.