[PHP-DEV] PHP 4.0 Bug #3417: OCIPlogOn() open connection but don't close id From: adelcros <email protected>
Date: 02/06/00

From: adelcros <email protected>
Operating system: solaris 2.6
PHP version: 4.0 Beta 3
PHP Bug Type: Oracle related
Bug description: OCIPlogOn() open connection but don't close id

<?
$db = NEGO;
$conn = OCIPLogon("webadm","ma2web",$db);
$stmtz = OCIParse($conn,"select IMGPO from $table where prodid = $pid");
OCIExecute($stmtz,OCI_DEFAULT);
$i=0;
while (OCIFetchInto($stmtz, &$result, OCI_RETURN_LOBS)) {
    echo $result[$i];
    $i++;
}
OCIFreeStatement($stmtz);
?>

--------------------------
Apache 1.3.9 compiled with PHP4beta3 with session (cookies)
with enable-tracks-var and with oci. on sun solaris 2.6
UltraSparc 450, Oracle 8.1.5.0.0
----------------------------
[PHP]
engine = On ; Enable the PHP scripting language engin
e under Apache
short_open_tag = On ; allow the <? tag. otherwise, only <?php and <s
cript> tags are recognized.
asp_tags = Off ; allow ASP-style <% %> tags
precision = 14 ; number of significant digits displayed
in floating point numbers
y2k_compliance = Off ; whether to be year 2000 compliant (will cause p
roblems with non y2k compliant browsers)
output_buffering = Off ; Output buffering allows you to send header line
s (including cookies)
                                                        ; even after you send bod
y content, in the price of slowing PHP's
                                                        ; output layer a bit.
                                                        ; You can enable output b
uffering by in runtime by calling the output
                                                        ; buffering functions, or
 enable output buffering for all files
                                                        ; by setting this directi
ve to On.
; Safe Mode
safe_mode = Off
safe_mode_exec_dir =

; Colors for Syntax Highlighting mode. Anything that's acceptable in <font color
=???> would work.
highlight.string = #DD0000
highlight.comment = #FF8000
highlight.keyword = #007700
highlight.bg = #FFFFFF
highlight.default = #0000BB
highlight.html = #000000

; Misc
expose_php = On ; Decides whether PHP may expose the fact
 that it is installed on the
                                                ; server (e.g., by adding its sig
nature to the Web server header).
                                                ; It is no security threat in any
 way, but it makes it possible
                                                ; to determine whether you use PH
P on your server or not.

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 30 ; Maximum execution time of each script, in seconds (
UNIX only)
memory_limit = 8388608 ; Maximum amount of memory a script may consume (
8MB)

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; error_reporting is a bit-field. Add each number up to get desired error report
ing level
; 1 = Normal errors
; 2 = Normal warnings
; 4 = Parser errors
; 8 = Notices - warnings you can ignore, but sometimes imply a bug (e.g., using
an uninitialized variable)
error_reporting = 7
display_errors = On ; Print out errors (as a part of the HTML script)
log_errors = Off ; Log errors into a log file (server-spec
ific log, stderr, or error_log (below))
track_errors = Off ; Store the last error/warning message in $php_er
rormsg (boolean)
;error_prepend_string = "<font color=ff0000>" ; string to output before an erro
r message
;error_append_string = "</font>" ; string to output after an error
 message
;error_log = filename ; log errors to specified file
;error_log = syslog ; log errors to syslog (Event Log on NT,
not valid in Windows 95)
warn_plus_overloading = Off ; warn if the + operator is used
with strings

;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
gpc_order = "GPC" ; Order of evaluation of GET/POST
/Cookie data. Later values override
                                                                ; earlier values
(e.g., by default, POST variables override GET variables,
                                                                ; and Cookie vari
ables override both POST and GET variables).
gpc_globals = On ; Whether or not to defin
e GET/POST/Cookie variables in the global
                                                                ; scope. You may
 want to turn this off if you don't want
                                                                ; to clutter your
 scripts' global scope with user data. This makes
                                                                ; most sense when
 coupled with track_vars - in which case you can
                                                                ; access all of t
he GPC variables through the $HTTP_GET_VARS[],
                                                                ; $HTTP_POST_VARS
[] and $HTTP_COOKIE_VARS[] variables.
track_vars = On ; enable $HTTP_GET_VARS[]
, $HTTP_POST_VARS[] and $HTTP_COOKIE_VARS[] arrays

; Magic quotes
magic_quotes_gpc = On ; magic quotes for incoming GET/P
OST/Cookie data
magic_quotes_runtime= Off ; magic quotes for runtime-generated data
, e.g. data from SQL, from exec(), etc.
magic_quotes_sybase = Off ; Use Sybase-style magic quotes (
escape ' with '' instead of \')

; automatically add files before or after any PHP document
auto_prepend_file =
auto_append_file =

;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
include_path = ; UNIX: "/path1:/path2" Windows: "\path1;\pa
th2"
doc_root = ; the root of the
 php pages, used only if nonempty
user_dir = ; the directory u
nder which php opens the script using /~username, used only if nonempty
;upload_tmp_dir = ; temporary directory for HTTP uploaded f
iles (will use system default if not specified)
upload_max_filesize = 2097152 ; 2 Meg default limit on file uploads
extension_dir = ./ ; directory in which the
loadable extensions (modules) reside
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[Syslog]
define_syslog_variables = Off ; Whether or not to define the various syslog var
iables,
                                                                ; e.g. $LOG_PID,
$LOG_CRON, etc. Turning it off is a
                                                                ; good idea perfo
rmance-wise. In runtime, you can define
                                                                ; these variables
 by calling define_syslog_variables()

[mail function]
SMTP = localhost ;for win32 only
sendmail_from = me <email protected> ;for win32 only
sendmail_path = ;for unix only, m
ay supply arguments as well (default is sendmail -t)

[Debugger]
debugger.host = localhost
debugger.port = 7869
debugger.enabled = False

[SQL]
sql.safe_mode = Off

uodbc.allow_persistent = On ; allow or prevent persistent links
uodbc.max_persistent = -1 ; maximum number of persistent links. -1
means no limit
uodbc.max_links = -1 ; maximum number of links (persis
tent+non persistent). -1 means no limit
uodbc.defaultlrl = 4096 ; Handling of LONG fields. Returns number
 of bytes to variables, 0 means passthru
uodbc.defaultbinmode = 1 ; Handling of binary data. 0 means passth
ru, 1 return as is, 2 convert to char
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation o
f uodbc.defaultlrl
; and uodbc.defaultbinmode
[MySQL]
mysql.allow_persistent = On ; allow or prevent persistent link
mysql.max_persistent = -1 ; maximum number of persistent links. -1
means no limit
mysql.max_links = -1 ; maximum number of links (persis
tent+non persistent). -1 means no limit
mysql.default_port = ; default port number for mysql_c
onnect(). If unset,
                                                                ; mysql_connect()
 will use the $MYSQL_TCP_PORT, or the mysql-tcp
                                                                ; entry in /etc/s
ervices, or the compile-time defined MYSQL_PORT
                                                                ; (in that order)
. Win32 will only look at MYSQL_PORT.
mysql.default_host = ; default host for mysql_connect(
) (doesn't apply in safe mode)
mysql.default_user = ; default user for mysql_connect(
) (doesn't apply in safe mode)
mysql.default_password = ; default password for mysql_connect() (d
oesn't apply in safe mode)
                                                                ; Note that this
is generally a *bad* idea to store passwords
                                                                ; in this file.
*Any* user with PHP access can run
                                                                ; 'echo cfg_get_v
ar("mysql.default_password")' and reveal that
                                                                ; password! And
of course, any users with read access to this
                                                                ; file will be ab
le to reveal the password as well.

[mSQL]
msql.allow_persistent = On ; allow or prevent persistent link
msql.max_persistent = -1 ; maximum number of persistent li
nks. -1 means no limit
msql.max_links = -1 ; maximum number of links (persis
tent+non persistent). -1 means no limit

[PostgresSQL]
pgsql.allow_persistent = On ; allow or prevent persistent link
pgsql.max_persistent = -1 ; maximum number of persistent links. -1
means no limit
pgsql.max_links = -1 ; maximum number of links (persis
tent+non persistent). -1 means no limit

[Sybase]
sybase.allow_persistent = On ; allow or prevent persistent link
sybase.max_persistent = -1 ; maximum number of persistent links. -1
means no limit
sybase.max_links = -1 ; maximum number of links (persis
tent+non persistent). -1 means no limit
;sybase.interface_file = "/usr/sybase/interfaces"
sybase.min_error_severity = 10 ; minimum error severity to displ
ay
sybase.min_message_severity = 10 ; minimum message severity to dis
play
sybase.compatability_mode = Off ; compatability mode with old versions of
 PHP 3.0.
                                                                        ; If on,
this will cause PHP to automatically assign types to results
                                                                        ; accordi
ng to their Sybase type, instead of treating them all as
                                                                        ; strings
. This compatability mode will probably not stay around
                                                                        ; forever
, so try applying whatever necessary changes to your code,
                                                                        ; and tur
n it off.

[Sybase-CT]
sybct.allow_persistent = On ; allow or prevent persistent lin
k
sybct.max_persistent = -1 ; maximum number of persistent li
nks. -1 means no limit
sybct.max_links = -1 ; maximum number of links
 (persistent+non persistent). -1 means no limit
sybct.min_server_severity = 10 ; minimum server message severity
 to display
sybct.min_client_severity = 10 ; minimum client message severity
 to display

[bcmath]

bcmath.scale = 0 ; number of decimal digits for all bcmath functions
[browscap]
;browscap = extra/browscap.ini

[Informix]
ifx.default_host = ; default host for ifx_connect()
(doesn't apply in safe mode)
ifx.default_user = ; default user for ifx_connect()
(doesn't apply in safe mode)
ifx.default_password = ; default password for ifx_connec
t() (doesn't apply in safe mode)
ifx.allow_persistent = On ; allow or prevent persistent lin
k
ifx.max_persistent = -1 ; maximum number of persistent li
nks. -1 means no limit
ifx.max_links = -1 ; maximum number of links (persis
tent+non persistent). -1 means no limit
ifx.textasvarchar = 0 ; if set on, select statements re
turn the contents of a text blob instead of it's id
ifx.byteasvarchar = 0 ; if set on, select statements re
turn the contents of a byte blob instead of it's id
ifx.charasvarchar = 0 ; trailing blanks are stripped fr
om fixed-length char columns. May help the life
                                                ; of Informix SE users.
ifx.blobinfile = 0 ; if set on, the contents of text
&byte blobs are dumped to a file instead of
                                                ; keeping them in memory

ifx.nullformat = 0 ; NULL's are returned as empty st
rings, unless this is set to 1. In that case,
                                                ; NULL's are returned as string '
NULL'.

[Session]
session.save_handler = files ; handler used to store/retrieve data
session.save_path = /tmp ; argument passed to save_handler
                                    ; in the case of files, this is the
                                    ; path where data files are stored
session.use_cookies = 1 ; whether to use cookies
session.name = PHPSESSID ; name of the session
                                    ; is used as cookie name
session.auto_start = 0 ; initialize session on request startup
session.cookie_lifetime = 0 ; lifetime in seconds of cookie
                                    ; or if 0, until browser is restarted
session.cookie_path = / ; the path the cookie is valid for
session.cookie_domain = ; the domain the cookie is valid for
session.serialize_handler = php ; handler used to serialize data
                                    ; php is the standard serializer of PHP
session.gc_probability = 1 ; procentual probability that the
                                    ; 'garbage collection' process is started
                                    ; on every session initialization
session.gc_maxlifetime = 1440 ; after this number of seconds, stored
                                    ; data will be seen as 'garbage' and
                                    ; cleaned up by the gc process
session.extern_referer_check = ;
session.entropy_file = ;
session.entropy_length = 0 ;

[MSSQL]
;extension=php_mssql.dll
mssql.allow_persistent = On ; allow or prevent persistent lin
k
mssql.max_persistent = -1 ; maximum number of persistent li
nks. -1 means no limit
mssql.max_links = -1 ; maximum number of links
 (persistent+non persistent). -1 means no limit
mssql.min_error_severity = 10 ; minimum error severity to displ
ay
mssql.min_message_severity = 10 ; minimum message severity to dis
play
mssql.compatability_mode = Off ; compatability mode with old versions of
 PHP 3.0. 

-- 
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>