[PHP-DEV] Bug #11341 Updated: OCI8 returns null password on logon at ora7
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 #FF #FF highlight.comment #FF8000 #FF8000 highlight.default #BB #BB highlight.html #00 #00 highlight.keyword #007700 #007700 highlight.string #DD #DD 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
[PHP-DEV] Bug #11341 Updated: OCI8 returns null password on logon at ora7
ID: 11341 User Update by: [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 [EMAIL PROTECTED] (ff@) Previous Comments: --- [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 #FF #FF highlight.comment #FF8000 #FF8000 highlight.default #BB #BB highlight.html #00 #00 highlight.keyword #007700 #007700 highlight.string #DD #DD 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