Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199901

[PHP3] Persisant Connection problem: MySQL-PHP3-Apache From: gmkelly <email protected>
Date: 01/30/99

Hi All,

I have MySQL-2.05, PHP-3.0.6, Apache-1.3.4 on a RedHat 5.2 Linux
system running kernel release 2.2.0 on a dual PPro SMP System (128Mb).

In writing my php web pages I have noticed that the mysql_pconnect
will at times disappear, and then a "automatic" retry makes a pconnect but
defaults to my login name @ localhost. Now, I have set up a number of
MySQL user access accounts, and of course while I can tolerate the
pconnect invoking my username <email protected> and not the MySQL username
I originally login as, this will create big problems once I move out of the
"development" phase, onto real live testing on the net.

I have tried, and do pass all variables across my exclusively php pages,
(ie: $user, $password, $host, ..... etc.) but this doesn't help in making the
pconnect call re-pconnect with the original Host,Username,Password
request.

eg: I login in with mysql_pconnect($host,$user,$password) were
$host = "bushrock"; (/etc/hosts develops the FQDN from this alias)
$user = "gmkelly"; and $password = "helpme"; pconnection is made
OK, and I can do correct MySQL transfers. After about three php3
invoked screens later, I lose the pconnection, and it makes another
successfully but defaults with my login-name <email protected>

So is there a way to set the default $host, $user, $password in a
re-connecting pconnect ?

I realise that this is probably either a "setup problem" or a "bug" in
MySQL or maybe in PHP3, so please excuse the cross posting.

I have looked thru old mailing list etc, but haven't noticed any reports.
Has anyone experienced this, and more hopefully, anyone got a fix or
any comments on likely things I have missed ?

Thanks, Grahame.

PS:

The following mysqlbug report output may help with more details.
I have NOT submitted this or any report yet as I want to check that
I haven't missed anything, and checked all doco, mailing lists etc.
first before "adding" more support work onto the MySQL/PHP teams.
(I worked for 14 years in support - so I best do as I preach ~(:>o)

Also, local domain is a "10.10.10.0" network via a firewall, so disregard.

>MySQL support: [none]
>Synopsis: mysql_pconnect defaults to login-name <email protected>, not original
mysql login.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: support
>Release: mysql-3.22.14b-gamma (Source distribution)

>Environment:

System: Linux bushrock.zipzip.com.au 2.2.0-final #1 SMP Fri Jan 22 15:33:17
EST 1999 i686 unknown
Architecture: i686 - Dual PPro System

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-tcp-port=3306
Perl: This is perl, version 5.004_04 built for i386-linux 

-- 

------------------------------------------------------
Sydney Linux User Group - Coordinator &  Member (SLUG) 
see http://www.slug.org.au for details on activities
------------------------------------------------------

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>