[PHP-DEV] Bug #11341 Updated: OCI8 returns null password on logon at ora7

2001-12-28 Thread w . steenhoff

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

2001-06-25 Thread w . steenhof

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