PHP 4.0 Bug #4223: PHP calls MySQL with apache user instead of connected user

From: 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.

« previous php.dev (#18142) next »