[PHP-DEV] Bug #11341 Updated: OCI8 returns null password on logon at ora7 From: w.steenhof <email protected>
Date: 06/25/01

ID: 11341
User Update by: w.steenhof <email protected>
Status: Open
Bug Type: OCI8 related
Operating system: AIX
PHP Version: 4.0.4pl1
Description: OCI8 returns null password on logon at ora7

Updated to php 4.0.5, same problem.
Note: my email is w.steenhoff <email protected> (ff@)

Previous Comments:
---------------------------------------------------------------------------

[2001-06-07 17:08:12] w.steenhof <email protected>
When connecting to an Oracle 7 database using OCI8 I get
ORA-01005: null password given; logon denied
(This happens both using OCILogon() and OCIPLogon())

Note that oracle 8 and 8i databases work allright while
none of my 7 databases work.

If the password in incorrect, OCI tells me so, and if the password is correct I get this error.

I user php as a module in apache, and OCI uses the oracle 8 client.

phpinfo():
System AIX esther 3 4 00920517A000
Build Date Feb 9 2001
Configure Command './configure.ok' '--with-config-file-path=/etc/php' '--with-apxs' '--disable-pic' '--disable-rpath' '--disable-c9x-inline' '--disable-inline-optimization' '--with-gettext=shared' '--with-mysql=shared,/usr/local' '--with-pgsql=shared' '--with-dbm' '--with-db3' '--with-gdbm' '--with-mm=shared,/usr/local' '--with-readline=shared' '--with-gd=shared' '--with-jpeg-dir' '--with-xpm-dir' '--with-png-dir' '--with-zlib=shared' '--with-ldap=shared,/usr/ldap' '--enable-shared' '--enable-dbase' '--enable-filepro' '--with-oci8=shared,/oracle' '--with-imap-ssl=shared' '--with-imap=shared' '--with-java=/usr/jdk_base'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php
ZEND_DEBUG disabled
Thread Safety disabled

 This program makes use of the Zend scripting language engine:
Zend Engine v1.0.4, Copyright (c) 1998-2000 Zend Technologies

 

--------------------------------------------------------------------------------

PHP 4.0 Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference
 On On
allow_url_fopen
 1 1
arg_separator
 & &
asp_tags
 Off Off
auto_append_file
 no value no value
auto_prepend_file
 no value no value
browscap
 no value no value
default_charset
 no value no value
default_mimetype
 text/html text/html
define_syslog_variables
 Off Off
disable_functions
 no value no value
display_errors
 Off Off
display_startup_errors
 Off Off
doc_root
 no value no value
enable_dl
 On On
error_append_string
 Off Off
error_log
 no value no value
error_prepend_string
 Off Off
error_reporting
 2039 2039
expose_php
 On On
extension_dir
 /usr/local/lib/php/extensions/no-debug-non-zts-20001222/ /usr/local/lib/php/extensions/no-debug-non-zts-20001222/
file_uploads
 1 1
gpc_order
 GPC GPC
highlight.bg
 #FFFFFF #FFFFFF
highlight.comment
 #FF8000 #FF8000
highlight.default
 #0000BB #0000BB
highlight.html
 #000000 #000000
highlight.keyword
 #007700 #007700
highlight.string
 #DD0000 #DD0000
html_errors
 On On
ignore_user_abort
 Off Off
implicit_flush
 Off Off
include_path
 /usr/local/lib /usr/local/lib
log_errors
 Off Off
magic_quotes_gpc
 On On
magic_quotes_runtime
 Off Off
magic_quotes_sybase
 Off Off
max_execution_time
 300 300
open_basedir
 no value no value
output_buffering
 Off Off
output_handler
 no value no value
post_max_size
 8M 8M
precision
 14 14
register_argc_argv
 On On
register_globals
 On On
safe_mode
 Off Off
safe_mode_exec_dir
 no value no value
sendmail_from
 me <email protected> me <email protected>
sendmail_path
 /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
short_open_tag
 On On
SMTP
 localhost localhost
sql.safe_mode
 Off Off
track_errors
 On On
upload_max_filesize
 2M 2M
upload_tmp_dir
 no value no value
user_dir
 no value no value
variables_order
 EGPCS EGPCS
y2k_compliance
 Off Off

gd
GD Support enabled
GD Version 1.6.2 or higher
FreeType Support enabled
FreeType Linkage with TTF library
JPG Support enabled
PNG Support enabled
WBMP Support enabled

oci8
OCI8 Support enabled
Revision $Revision: 1.104.2.1 $
Oracle Version 8.0
Compile-time ORACLE_HOME /oracle
Libraries Used -R/oracle/lib -L/oracle/lib -lclntsh -lpsa -lcore4 -lnlsrtl3

zlib
ZLib Support enabled
Compiled Version 1.1.3
Linked Version 1.1.3

xml
XML Support active

standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active
 1 1
assert.bail
 0 0
assert.callback
 no value no value
assert.quiet_eval
 0 0
assert.warning
 1 1
safe_mode_allowed_env_vars
 PHP_ PHP_
safe_mode_protected_env_vars
 LD_LIBRARY_PATH LD_LIBRARY_PATH
session.use_trans_sid
 1 1

session
Session Support enabled

Directive Local Value Master Value
session.auto_start
 Off Off
session.cache_expire
 180 180
session.cache_limiter
 nocache nocache
session.cookie_domain
 no value no value
session.cookie_lifetime
 0 0
session.cookie_path
 / /
session.cookie_secure
 Off Off
session.entropy_file
 no value no value
session.entropy_length
 0 0
session.gc_maxlifetime
 1440 1440
session.gc_probability
 1 1
session.name
 PHPSESSID PHPSESSID
session.referer_check
 no value no value
session.save_handler
 files files
session.save_path
 /tmp /tmp
session.serialize_handler
 php php
session.use_cookies
 On On

posix
Revision $Revision: 1.27 $

pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 3.1 09-Feb-2000

ftp
FTP support enabled

dba
DBA support enabled
Supported handlers gdbm dbm db3

apache
APACHE_INCLUDE
APACHE_TARGET
Apache Version Apache/1.3.17
Apache Release 10317100
Apache API Version 19990320
Hostname:Port aftaxt01:80
User/Group nobody(-2)/-2
Max Requests Per Child: 0
Keep Alive: on
Max Per Connection: 100
Timeouts Connection: 300
Keep-Alive: 15
Server Root /usr/local
Loaded Modules mod_php4, mod_setenvif, mod_so, mod_unique_id, mod_usertrack, mod_headers, mod_expires, mod_cern_meta, mod_proxy, mod_digest, mod_auth_dbm, mod_auth_anon, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_speling, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_mime_magic, mod_log_config, mod_env, mod_vhost_alias, http_core

Apache Environment
Variable Value
DOCUMENT_ROOT /usr/local/share/apache/htdocs
HTTP_ACCEPT */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE nl
HTTP_CONNECTION Keep-Alive
HTTP_HOST aftaxt01
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
PATH /usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:.:/home/oper:/usr/local/bin:/aftaxt01_01/app/oracle/product/734/bin:/uni/em/bin
REDIRECT_STATUS 200
REDIRECT_UNIQUE_ID Ox <email protected>
REDIRECT_URL /
REMOTE_ADDR 150.99.14.87
REMOTE_PORT 3340
SCRIPT_FILENAME /usr/local/share/apache/htdocs/index.php
SERVER_ADDR 10.1.2.39
SERVER_ADMIN dba <email protected>
SERVER_NAME aftaxt01
SERVER_PORT 80
SERVER_SIGNATURE Apache/1.3.19 Server at aftaxt01 Port 80
SERVER_SOFTWARE Apache/1.3.19 (Unix) PHP/4.0.4pl1
UNIQUE_ID Ox <email protected>
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /
SCRIPT_NAME /index.php

HTTP Headers Information
HTTP Request Headers
HTTP Request GET / HTTP/1.1
Accept */*
Accept-Encoding gzip, deflate
Accept-Language nl
Connection Keep-Alive
Host aftaxt01
User-Agent Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
HTTP Response Headers
X-Powered-By PHP/4.0.4pl1
Keep-Alive timeout=15, max=100
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html

Additional Modules
filepro
dbase
Session MM

Environment
Variable Value
_ /usr/local/bin/httpd
LANG C
LOGIN root
NLSPATH /usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LINK_CNTRL L_PTHREADS_D7
PATH /usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:.:/home/oper:/usr/local/bin:/aftaxt01_01/app/oracle/product/734/bin:/uni/em/bin
LC__FASTMSG true
EDITOR /usr/bin/vi
LOGNAME root
MAIL /usr/spool/mail/root
LOCPATH /usr/lib/nls/loc
USER root
AUTHSTATE compat
SHELL /bin/ksh
ORACLE_TERM vt100
ODMDIR /etc/objrepos
ORATAB /etc/oratab
HOME /
PTHOME /tmp/iefit
LD_LIBRARY_PATH /usr/local/lib:/usr/lib
TERM vt220
MAILMSG [YOU HAVE NEW MAIL]
ORACLE_HOME /aftaxt01_01/app/oracle/product/734
PTOPT yes
PWD /var/apache/log
TZ NFT-1DFT,M3.5.0/02:00,M10.5.0/03:00
A__z ! LOGNAME

PHP Variables
Variable Value
PHP_SELF /index.php
HTTP_SERVER_VARS["DOCUMENT_ROOT"] /usr/local/share/apache/htdocs
HTTP_SERVER_VARS["HTTP_ACCEPT"] */*
HTTP_SERVER_VARS["HTTP_ACCEPT_ENCODING"] gzip, deflate
HTTP_SERVER_VARS["HTTP_ACCEPT_LANGUAGE"] nl
HTTP_SERVER_VARS["HTTP_CONNECTION"] Keep-Alive
HTTP_SERVER_VARS["HTTP_HOST"] aftaxt01
HTTP_SERVER_VARS["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
HTTP_SERVER_VARS["PATH"] /usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:.:/home/oper:/usr/local/bin:/aftaxt01_01/app/oracle/product/734/bin:/uni/em/bin
HTTP_SERVER_VARS["REDIRECT_STATUS"] 200
HTTP_SERVER_VARS["REDIRECT_UNIQUE_ID"] Ox <email protected>
HTTP_SERVER_VARS["REDIRECT_URL"] /
HTTP_SERVER_VARS["REMOTE_ADDR"] 150.99.14.87
HTTP_SERVER_VARS["REMOTE_PORT"] 3340
HTTP_SERVER_VARS["SCRIPT_FILENAME"] /usr/local/share/apache/htdocs/index.php
HTTP_SERVER_VARS["SERVER_ADDR"] 10.1.2.39
HTTP_SERVER_VARS["SERVER_ADMIN"] dba <email protected>
HTTP_SERVER_VARS["SERVER_NAME"] aftaxt01
HTTP_SERVER_VARS["SERVER_PORT"] 80
HTTP_SERVER_VARS["SERVER_SIGNATURE"] Apache/1.3.19 Server at aftaxt01 Port 80
HTTP_SERVER_VARS["SERVER_SOFTWARE"] Apache/1.3.19 (Unix) PHP/4.0.4pl1
HTTP_SERVER_VARS["UNIQUE_ID"] Ox <email protected>
HTTP_SERVER_VARS["GATEWAY_INTERFACE"] CGI/1.1
HTTP_SERVER_VARS["SERVER_PROTOCOL"] HTTP/1.1
HTTP_SERVER_VARS["REQUEST_METHOD"] GET
HTTP_SERVER_VARS["QUERY_STRING"]
HTTP_SERVER_VARS["REQUEST_URI"] /
HTTP_SERVER_VARS["SCRIPT_NAME"] /index.php
HTTP_SERVER_VARS["PATH_TRANSLATED"] /usr/local/share/apache/htdocs/index.php
HTTP_SERVER_VARS["PHP_SELF"] /index.php
HTTP_SERVER_VARS["argv"] Array
(
)

 
HTTP_SERVER_VARS["argc"] 0
HTTP_ENV_VARS["_"] /usr/local/bin/httpd
HTTP_ENV_VARS["LANG"] C
HTTP_ENV_VARS["LOGIN"] root
HTTP_ENV_VARS["NLSPATH"] /usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
HTTP_ENV_VARS["LINK_CNTRL"] L_PTHREADS_D7
HTTP_ENV_VARS["PATH"] /usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:.:/home/oper:/usr/local/bin:/aftaxt01_01/app/oracle/product/734/bin:/uni/em/bin
HTTP_ENV_VARS["LC__FASTMSG"] true
HTTP_ENV_VARS["EDITOR"] /usr/bin/vi
HTTP_ENV_VARS["LOGNAME"] root
HTTP_ENV_VARS["MAIL"] /usr/spool/mail/root
HTTP_ENV_VARS["LOCPATH"] /usr/lib/nls/loc
HTTP_ENV_VARS["USER"] root
HTTP_ENV_VARS["AUTHSTATE"] compat
HTTP_ENV_VARS["SHELL"] /bin/ksh
HTTP_ENV_VARS["ORACLE_TERM"] vt100
HTTP_ENV_VARS["ODMDIR"] /etc/objrepos
HTTP_ENV_VARS["ORATAB"] /etc/oratab
HTTP_ENV_VARS["HOME"] /
HTTP_ENV_VARS["PTHOME"] /tmp/iefit
HTTP_ENV_VARS["LD_LIBRARY_PATH"] /usr/local/lib:/usr/lib
HTTP_ENV_VARS["TERM"] vt220
HTTP_ENV_VARS["MAILMSG"] [YOU HAVE NEW MAIL]
HTTP_ENV_VARS["ORACLE_HOME"] /aftaxt01_01/app/oracle/product/734
HTTP_ENV_VARS["PTOPT"] yes
HTTP_ENV_VARS["PWD"] /var/apache/log
HTTP_ENV_VARS["TZ"] NFT-1DFT,M3.5.0/02:00,M10.5.0/03:00
HTTP_ENV_VARS["A__z"] ! LOGNAME

---------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online.

Full Bug description available at: http://bugs.php.net/?id=11341 

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