#19714 [Com]: Using default user in OCI8 functions

ID: 19714 Comment by: leopoldo dot antonetti at globalvue dot it Reported By: jomar at hafro dot is Status: Assigned Bug Type: OCI8 related Operating System: SunOS PHP Version: 4.2.2 Assigned To: maxim New Comment: Good morning, we are starting to use PHP 4.1.1 on an HP ALPHA system with OPENVMS, ORALCE8i and APACHE. I see that the OCILogon /@<connect-string> doesn't works. What is the correct syntax? is it a bug? is there any workaround? must I upgrade the version of PHP to a new one that works? Many thanks Leopoldo Antonetti Global Value Services S.p.A Midrange Technologies VMS System Technologies Tel. +39 01100.53258 MailTo:leopoldo.antonetti@globalvalue.it Previous Comments: ------------------------------------------------------------------------ [2002-11-11 13:08:10] maxim@php.net Oracle does not seem to read user/pass if it is passed to it as the username via OCILogon. When second parameter is an empty strng OCISessionBegin() complains about the "NULL password Given" while if username contains '/' it is 1) unparsed by API, 2) will still leave OCISessionBegin() without a password. I will take a look at it. ------------------------------------------------------------------------ [2002-10-02 08:15:44] sniper@php.net nevermind..should have read your report 2 times instead of one time. ------------------------------------------------------------------------ [2002-10-02 08:14:41] sniper@php.net You should be setting those environment variables in the SHELL not in apache httpd.. See http://www.php.net/manual/en/ref.oci8.php for more information. ------------------------------------------------------------------------ [2002-10-02 08:04:17] jomar at hafro dot is I´m using Apache enviroment : SetEnv ORACLE_HOME /usr/oracle SetEnv ORA_NLS33 /usr/oracle/ocommon/nls/admin/data SetEnv NLS_LANG icelandic_america I also set the tns_names and more env within root enviroment before I execute apachectl start running php as a module. I also compiled Php with Oci8. I´m having trouble with ocilogon function when I use the ocilogon("/","") (default user/nopass,server) If I logon using a valid username and password then it is ok, but when I use this method it returns an ora error : ORA-01005: null password given; logon denied I also have the ora libs and if I use ora_logon("/","") that seems to work. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19714&edit=1