RE: [PHP-DEV] PHP 4.0 Bug #5980: Informix ifx_connect reuses closed connection resource id From: Andrej Falout (afalout <email protected>)
Date: 08/12/00

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> >And why is this a problem for you?
>
> I discovered this problem when I was creating a database and then
creating
> its tables in the same script. Creating a database has to be done
by a DBA
> user.

Nope. All privileges info in Informix engines is stored in sys*
tables. No database, not special users. Everyone who can access the
engine can create database and become the owner.

> The tables and other objects of the database can be created by any
> user.

Ooops, nope again. They can be create by DBA and RESOURCE privileged
users. I think not everything can be done by RESOURCE.

> When I used the same user for both things the connection was reused
> but since I was closing and reopening it

"it"? You are closing and reopening connection from PHP to Informix.

> I encountered the problem.

But you did not answer why is it a problem for you? I did not see this
as a problem situation, so far?
 
> This problem is still a bug in PHP that needs to be fixed but I am
avoiding
> it by not closing the connection when the server, database, user and
> password are the same. So this won't affect PHP Metabase driver
unless you
> use more than one Metabase database connection setups which is not
usual
> and it is not the way Metabase manager class works.

Still confused...

Yours, Andrej Falout, http://www.falout.com ICQ 7628616
#-----------------------------------------------------------------
globals "I_speak_for_myself.4gl"

"I didn't know what I was doing. A blood vessel in my brain must
have burst" - Chief of police in Hesse, Germany, after he was
caught shoplifting ant poison worth a few dollars.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.0.2i

iQA/AwUBOZUzzBZH34ibpTRkEQLErQCdGGUwpojHWnHu4N0XOq40oGtYMMgAnRO/
4uQ0m4kqKuIXNv+9hmojCub6
=EaGN
-----END PGP SIGNATURE----- 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>