ID: 19609
Updated by: georg@php.net
Reported By: gijs@spill.nl
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: Redhat 7.X
PHP Version: 4.2.2
New Comment:
Hmm it works fine here...
Do you use php as module?
Which (mysql)server parameters are specfied for timeouts?
Georg
Previous Comments:
------------------------------------------------------------------------
[2002-09-26 08:10:12] gijs@spill.nl
No, let met scetch the situation:
=== action 1 ====
mysql_pconnect(host1,user1,pass1);
than after changing the script
=== action 2 ====
mysql_pconnect(host2,user2,pass2);
PHP then should check if the host,user and pass are the same, these are
not. But it still uses the old link.
If it would work PHP should see there is a difference en start a new
link, wouldn't it?
------------------------------------------------------------------------
[2002-09-26 06:25:44] mfischer@php.net
Are you sure you are not reusing the old link and changing the databse?
This of course changes all other scripts database which happen to use
the same persistent resource link in their scripts.
------------------------------------------------------------------------
[2002-09-26 05:37:31] gijs@spill.nl
I have replicated this error op different servers.
mysql_pconnect does not look at the host,user or password but just
assumes the (persistent) link is okee and uses it.
This way once there is a perssistant link and I want to change to a
other DB server with a new script mysql_pconnect just takes the old
link en does not check if the host,user or password are the same.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=19609&edit=1