Bug #3524: ora_logon function does not work propertly

From: aambults@exchange.telekom.lv Operating system: linux RH6.1 PHP version: 3.0.14 PHP Bug Type: Oracle related Bug description: ora_logon function does not work propertly 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 --------------------------------------------------------------------------------