php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #3417 OCIPlogOn() open connection but don't close id
Submitted: 2000-02-06 10:16 UTC Modified: 2006-07-17 08:07 UTC
From: adelcros at cybercable dot fr Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0 Beta 3 OS: solaris 2.6
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: adelcros at cybercable dot fr
New email:
PHP Version: OS:

 

 [2000-02-06 10:16 UTC] adelcros at cybercable dot fr
<?
$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@localhost.com        ;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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-02-06 10:21 UTC] thies at cvs dot php dot net
ociplogon is not supposed to close the connection. (read the manual)

what is your problem?
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 12 04:01:27 2024 UTC