#19714 [Opn->Asn]: Using default user in OCI8 functions

ID: 19714 Updated by: maxim@php.net Reported By: jomar@hafro.is -Status: Open +Status: Assigned Bug Type: OCI8 related Operating System: SunOS PHP Version: 4.2.2 -Assigned To: +Assigned To: maxim New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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@hafro.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