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
 [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: Sat Dec 21 14:01:32 2024 UTC