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

Pull Requests

 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed Feb 05 12:01:32 2025 UTC