php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #3524 ora_logon function does not work propertly
Submitted: 2000-02-17 19:59 UTC Modified: 2000-03-07 08:58 UTC
From: aambults at exchange dot telekom dot lv Assigned:
Status: Closed Package: Oracle related
PHP Version: 3.0.14 OS: linux RH6.1
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: aambults at exchange dot telekom dot lv
New email:
PHP Version: OS:

 

 [2000-02-17 19:59 UTC] aambults at exchange dot telekom dot lv
Ora_Logon() function does not work propertly when I use them to connect to remote database via Sqlnet .

With the same configuration ora_logon in php3.0.4 works quite well.

Error msg: Warning: Unable to connect to ORACLE (ORA-01005: null password given; logon denied) in /home/httpd/html/118/118.php3 on line 157

============================================
this is php3 script fragment:

putenv("ORACLE_HOME=/usr/oracle/ora8050");
157: $or=ora_logon("userid@W118.TELEKOM.LV","888888");
$a=ora_open($or);
 where userid - real oracle userid; "W118.TELEKOM.LV" -   
real TNS name of oracle database; "888888" user userid password.
============================================
 From the same host I can do so:
sqlplus userid/888888@W118.telekom.lv and it works.

There are info prom phpinfo() :

PHP Version 3.0.14
by Rasmus Lerdorf, Andi Gutmans, Zeev Suraski, Stig Bakken, Shane Caraveo, Jim Winstead, and countless others.


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

System: Linux www118-2 2.2.12-20 #1 Mon Sep 27 10:40:35 EDT 1999 i686 unknown
Build Date: Feb 17 2000

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

Extensions
Extensions Additional Information 
PHP core CFLAGS=
HSREGEX= 
PostgreSQL Allow persistent links: Yes 
Persistent links: 0/Unlimited 
Total links: 0/Unlimited 
Compilation definitions: PGSQL_INCLUDE=
PGSQL_LFLAGS=
PGSQL_LIBS=
 
 
Imap 4R1 Imap Support enabled
Imap c-client Version: Imap 4.1 
 
Basic Functions No additional information. 
PHP_DL Dynamic Library support enabled.  
PHP_dir No additional information. 
PHP_filestat No additional information. 
PHP_file No additional information. 
PHP_head No additional information. 
Sendmail Path to sendmail: /usr/sbin/sendmail -t 
Syslog No additional information. 
Socket functions No additional information. 
Regular Expressions System regex library enabled  
gd Version 1.3 with GIF support 
OCI8 Oracle version: 
Compile-time ORACLE_HOME: 
Libraries used:  
Oracle Oracle version: 
Compile-time ORACLE_HOME: 
Libraries used:  
Apache APACHE_INCLUDE=
APACHE_TARGET=
Apache Version: Apache/1.3.9
Apache Release: 10309100
Apache API Version: 19990320
Hostname/port: localhost.localdomain:80
User/Group: nobody(99)/99
Max Requests: per child: 100    keep alive: on    max per connection: 100
Timeouts: connection: 300    keep-alive: 15
Server Root: /etc/httpd
Loaded modules: mod_perl, mod_php3, mod_setenvif, mod_so, mod_usertrack, mod_headers, mod_expires, mod_proxy, mod_digest, mod_auth_db, mod_auth_anon, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent, mod_log_config, mod_env, mod_vhost_alias, http_core
 
Crypt No additional information. 
DBM This is GDBM version 1.8.0, as of May 19, 1999. 
bcmath No additional information. 
browscap No additional information. 
PHP_pack No additional information. 
zlib Zlib support active (compiled with 1.1.3, linked with 1.1.3). 
PCRE Perl Compatible Regular ExpressionsPCRE library version: 2.05 21-Apr-1999 
 
Posix $Revision: 1.18 $  
LCG No additional information. 

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

Configuration
Configure command: ./configure '--prefix=/usr' '--with-apxs' '--with-config-file-path=/etc/httpd' '--enable-safe-mode' '--with-exec-dir=/usr/bin' '--with-system-regex' '--disable-debug' '--with-zlib' '--with-gd' '--with-freetype' '--with-oracle=/usr/oracle/ora8050' '--disable-debug' '--enable-magic-quotes' '--enable-track-vars'
php3.ini file path is set to: /etc/httpd
Directive Master Value Local Value 
arg_separator  &  & 
asp_tags 1 1 
auto_prepend_file  /etc/httpd/conf/append.php3  /etc/httpd/conf/append.php3 
auto_append_file     
browscap  none  none 
cgi_ext  none  none 
debugger.host  none  none 
debugger.port 0 0 
define_syslog_variables 0 0 
display_errors 1 1 
doc_root     
enable_dl 1 1 
engine 1 1 
error_log  none  none 
error_append_string  none  none 
error_prepend_string  none  none 
error_reporting 7 7 
extension_dir  /usr/lib/apache/  /usr/lib/apache/ 
gpc_order  GPC  GPC 
ignore_user_abort 0 0 
include_path     
isapi_ext  none  none 
last_modified 0 0 
log_errors 1 1 
max execution time 30 30 
magic_quotes_gpc 1 1 
magic_quotes_runtime 0 0 
magic_quotes_sybase 0 0 
memory limit 8388608 8388608 
nsapi_ext  none  none 
open_basedir  none  none 
precision 14 14 
safe_mode 0 0 
safe_mode_exec_dir     
sendmail_from  me@localhost.com  me@localhost.com 
sendmail_path  /usr/sbin/sendmail -t  /usr/sbin/sendmail -t 
short_open_tag 1 1 
smtp  localhost  localhost 
sql_safe_mode 0 0 
track_errors 0 0 
track_vars 1 1 
upload_max_filesize 2097152 2097152 
upload_tmp_dir  none  none 
user_dir     
warn_plus_overloading 0 0 
xbithack 0 0 
browscap  none  none 
y2k_compliance 1 1 
highlight_comment  #FF8000  #FF8000 
highlight_default  #0000BB  #0000BB 
highlight_html  #000000  #000000 
highlight_string  #DD0000  #DD0000 
highlight_bg  #FFFFFF  #FFFFFF 
highlight_keyword  #007700  #007700 

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

Environment
Variable Value 
USERNAME root 
ENV /root/.bashrc 
HISTSIZE 1000 
HOSTNAME ******* (My comment) 
LOGNAME root 
HISTFILESIZE 1000 
MAIL /var/spool/mail/root 
TERM vt100 
HOSTTYPE i386 
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin 
HOME /root 
INPUTRC /etc/inputrc 
SHELL /bin/bash 
USER root 
LC_ALL en_US 
LANG en_US 
OSTYPE Linux 
LINGUAS en_US 
SHLVL 2 
_ /bin/nice 
NLS_LANG Latvian_Latvia.BLT8CP921 
ORA_NLS /usr/oracle/ora8050/ocommon/nls/admin/data 
ORA_NLS32 /usr/oracle/ora8050/ocommon/nls/admin/data 
ORA_NLS33 /usr/oracle/ora8050/ocommon/nls/admin/data 
ORACLE_HOME /usr/oracle/ora8050 
ORACLE_SID w118 

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

PHP Variables
Variable Value 
PHP_SELF /118/118.php3 

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

Apache Environment
Variable Value 
DOCUMENT_ROOT /home/httpd/html  
HTTP_ACCEPT */*  
HTTP_ACCEPT_ENCODING gzip, deflate  
HTTP_ACCEPT_LANGUAGE lv  
HTTP_CONNECTION Keep-Alive  
HTTP_HOST *********** (My comment) 
HTTP_PRAGMA no-cache  
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)  
HTTP_VIA 1.0 ERATO:880  
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin  
REMOTE_ADDR ********* (My comment)
REMOTE_PORT 2817  
SCRIPT_FILENAME /home/httpd/html/118/118.php3  
SERVER_ADDR 194.8.18.12  
SERVER_ADMIN root@localhost  
SERVER_NAME localhost.localdomain  
SERVER_PORT 80  
SERVER_SIGNATURE Apache/1.3.9 Server at localhost.localdomain Port 80
  
SERVER_SOFTWARE Apache/1.3.9 (Unix) (Red Hat/Linux) mod_perl/1.21 PHP/3.0.14  
GATEWAY_INTERFACE CGI/1.1  
SERVER_PROTOCOL HTTP/1.0  
REQUEST_METHOD GET  
QUERY_STRING   
REQUEST_URI /118/118.php3  
SCRIPT_NAME /118/118.php3  

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

HTTP Headers Information
HTTP Request Headers 
HTTP Request GET /118/118.php3 HTTP/1.0  
Accept */*  
Accept-Encoding gzip, deflate  
Accept-Language lv  
Connection Keep-Alive  
Host ************* (My comment)  
Pragma no-cache  
User-Agent Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)  
Via 1.0 ERATO:880  
HTTP Response Headers 
X-Powered-By PHP/3.0.14  
Connection close  
Content-Type text/html  


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



Patches

Add a Patch

Pull Requests

Add a Pull Request

 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sat Jul 24 18:01:23 2021 UTC