ID: 11341 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: OCI8 related Operating System: AIX PHP Version: 4.0.4pl1 New Comment:
Solution as described in bug id 13525 works. Set NLS_LANG before starting apache: export NLS_LANG=English_America.WE8ISO8859P1 Previous Comments: ------------------------------------------------------------------------ [2001-06-25 09:43:19] [EMAIL PROTECTED] Updated to php 4.0.5, same problem. Note: my email is [EMAIL PROTECTED] (ff@) ------------------------------------------------------------------------ [2001-06-07 17:08:12] [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 [EMAIL PROTECTED] [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@ZQpZjAQkAAXp6gl4 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 [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@ZQpZjAQkAAXp6gl4 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@ZQpZjAQkAAXp6gl4 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"] [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@ZQpZjAQkAAXp6gl4 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 ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=11341&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
