#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:[EMAIL PROTECTED] Previous Comments: [2002-11-11 13:08:10] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] nevermind..should have read your report 2 times instead of one time. [2002-10-02 08:14:41] [EMAIL PROTECTED] 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=19714edit=1
#19714 [Com]: Using default user in OCI8 functions
ID: 19714 Comment by: leopoldo dot antonetti at globalvalue 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:[EMAIL PROTECTED] Previous Comments: [2003-02-23 05:55:57] leopoldo dot antonetti at globalvue dot it 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:[EMAIL PROTECTED] [2002-11-11 13:08:10] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] nevermind..should have read your report 2 times instead of one time. [2002-10-02 08:14:41] [EMAIL PROTECTED] 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=19714edit=1
#19714 [Com]: Using default user in OCI8 functions
ID: 19714 Comment by: michael dot mauch at gmx dot de 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: The bug database is not a user support forum. Have a look at http://www.php.net/support.php to find the newsgroups and mailing lists where you can ask questions. Also see the user notes on the manual page http://www.php.net/manual/en/function.ocilogon.php, there are many examples. Previous Comments: [2003-02-23 05:57:54] leopoldo dot antonetti at globalvalue dot it 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:[EMAIL PROTECTED] [2003-02-23 05:55:57] leopoldo dot antonetti at globalvue dot it 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:[EMAIL PROTECTED] [2002-11-11 13:08:10] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] nevermind..should have read your report 2 times instead of one time. [2002-10-02 08:14:41] [EMAIL PROTECTED] 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. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19714 -- Edit this bug report at http://bugs.php.net/?id=19714edit=1
