#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 Updated by: [EMAIL PROTECTED] Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: >It not PHP problem. It problem OCI8 extension. Your misconfiguration is noway OCI8 problem. OCI8 extension does not care of any env variables, they are used by the Oracle client library. The error you get means the Oracle client library failed to initialize and OCI8 extension has nothing to do about it. >What can I make or look for the decision of this problem? I've told you everything. Check the ORACLE_HOME var and make sure the dir is readable by Apache user (www, nobody, apache, httpd or whatever you set it to). Other env variables also might affect it. If you still unable to make it work - please find a support forum and ask your questions there, since this is NOT a support forum. Thank you. Previous Comments: [2007-04-25 10:14:22] sasha at it-energy dot ru It not PHP problem. It problem OCI8 extension. This extension not work in this combination. It realy combination. Configure and make runs successfuly. What can I make or look for the decision of this problem? [2007-04-25 09:59:48] [EMAIL PROTECTED] Please ask your questions on a support forum. This is not PHP problem. [2007-04-25 09:47:35] sasha at it-energy dot ru May be problem in this, what directory structure not the same in 9.2 client and 10.2 client In 9.2 client nlb file found in $ORACLE_HOME/ocommon/nls/ADMIN/DATA. In 10.2 client nlb file found in $ORACLE_HOME/nls/data. It may produce error ? The directory in both case is standard. Not manualy moved and renamed. [2007-04-25 09:39:46] sasha at it-energy dot ru Available. I run as root: . oraenv ! Set all needed enviroment sqlplus . for test cconnections /opt/apache2/bin/apachectl start For test I set chmod -R +r $ORACLE_HOME Error the same ! [2007-04-25 09:11:16] [EMAIL PROTECTED] >I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect >succsessfuly" ORACLE_HOME should be available for _Apache_ process during the start up process. Oracle directory also has to be readable by Apache user. 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/41184 -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1
#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 User updated by: sasha at it-energy dot ru Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: It not PHP problem. It problem OCI8 extension. This extension not work in this combination. It realy combination. Configure and make runs successfuly. What can I make or look for the decision of this problem? Previous Comments: [2007-04-25 09:59:48] [EMAIL PROTECTED] Please ask your questions on a support forum. This is not PHP problem. [2007-04-25 09:47:35] sasha at it-energy dot ru May be problem in this, what directory structure not the same in 9.2 client and 10.2 client In 9.2 client nlb file found in $ORACLE_HOME/ocommon/nls/ADMIN/DATA. In 10.2 client nlb file found in $ORACLE_HOME/nls/data. It may produce error ? The directory in both case is standard. Not manualy moved and renamed. [2007-04-25 09:39:46] sasha at it-energy dot ru Available. I run as root: . oraenv ! Set all needed enviroment sqlplus . for test cconnections /opt/apache2/bin/apachectl start For test I set chmod -R +r $ORACLE_HOME Error the same ! [2007-04-25 09:11:16] [EMAIL PROTECTED] >I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect >succsessfuly" ORACLE_HOME should be available for _Apache_ process during the start up process. Oracle directory also has to be readable by Apache user. [2007-04-25 09:02:08] sasha at it-energy dot ru Yes ! I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect succsessfuly" If ORACLE_HOME not correct call sqlplus not correct start. Realy, I do . oraenv and set valid SID 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/41184 -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1
#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 Updated by: [EMAIL PROTECTED] Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: Please ask your questions on a support forum. This is not PHP problem. Previous Comments: [2007-04-25 09:47:35] sasha at it-energy dot ru May be problem in this, what directory structure not the same in 9.2 client and 10.2 client In 9.2 client nlb file found in $ORACLE_HOME/ocommon/nls/ADMIN/DATA. In 10.2 client nlb file found in $ORACLE_HOME/nls/data. It may produce error ? The directory in both case is standard. Not manualy moved and renamed. [2007-04-25 09:39:46] sasha at it-energy dot ru Available. I run as root: . oraenv ! Set all needed enviroment sqlplus . for test cconnections /opt/apache2/bin/apachectl start For test I set chmod -R +r $ORACLE_HOME Error the same ! [2007-04-25 09:11:16] [EMAIL PROTECTED] >I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect >succsessfuly" ORACLE_HOME should be available for _Apache_ process during the start up process. Oracle directory also has to be readable by Apache user. [2007-04-25 09:02:08] sasha at it-energy dot ru Yes ! I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect succsessfuly" If ORACLE_HOME not correct call sqlplus not correct start. Realy, I do . oraenv and set valid SID [2007-04-25 08:29:52] [EMAIL PROTECTED] >There is something wrong with your system - please check that >ORACLE_HOME isset and points to the right directory Do I really need to add something? 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/41184 -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1
#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 User updated by: sasha at it-energy dot ru Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: May be problem in this, what directory structure not the same in 9.2 client and 10.2 client In 9.2 client nlb file found in $ORACLE_HOME/ocommon/nls/ADMIN/DATA. In 10.2 client nlb file found in $ORACLE_HOME/nls/data. It may produce error ? The directory in both case is standard. Not manualy moved and renamed. Previous Comments: [2007-04-25 09:39:46] sasha at it-energy dot ru Available. I run as root: . oraenv ! Set all needed enviroment sqlplus . for test cconnections /opt/apache2/bin/apachectl start For test I set chmod -R +r $ORACLE_HOME Error the same ! [2007-04-25 09:11:16] [EMAIL PROTECTED] >I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect >succsessfuly" ORACLE_HOME should be available for _Apache_ process during the start up process. Oracle directory also has to be readable by Apache user. [2007-04-25 09:02:08] sasha at it-energy dot ru Yes ! I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect succsessfuly" If ORACLE_HOME not correct call sqlplus not correct start. Realy, I do . oraenv and set valid SID [2007-04-25 08:29:52] [EMAIL PROTECTED] >There is something wrong with your system - please check that >ORACLE_HOME isset and points to the right directory Do I really need to add something? [2007-04-25 08:26:57] sasha at it-energy dot ru Installed full ORACLE client 10.2.0 php configure from root as: ./configure --with-apxs2=/opt/apache2/bin/apxs --with-openssl --enable-shmop --enable-sysvsem --enable-sysvshm --with-zlib --with-oci8=$ORACLE_HOME --enable-sigchild --with-iconv Before configure test sqlplus user/[EMAIL PROTECTED] coneect succsessfuly. 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/41184 -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1
#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 User updated by: sasha at it-energy dot ru Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: Available. I run as root: . oraenv ! Set all needed enviroment sqlplus . for test cconnections /opt/apache2/bin/apachectl start For test I set chmod -R +r $ORACLE_HOME Error the same ! Previous Comments: [2007-04-25 09:11:16] [EMAIL PROTECTED] >I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect >succsessfuly" ORACLE_HOME should be available for _Apache_ process during the start up process. Oracle directory also has to be readable by Apache user. [2007-04-25 09:02:08] sasha at it-energy dot ru Yes ! I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect succsessfuly" If ORACLE_HOME not correct call sqlplus not correct start. Realy, I do . oraenv and set valid SID [2007-04-25 08:29:52] [EMAIL PROTECTED] >There is something wrong with your system - please check that >ORACLE_HOME isset and points to the right directory Do I really need to add something? [2007-04-25 08:26:57] sasha at it-energy dot ru Installed full ORACLE client 10.2.0 php configure from root as: ./configure --with-apxs2=/opt/apache2/bin/apxs --with-openssl --enable-shmop --enable-sysvsem --enable-sysvshm --with-zlib --with-oci8=$ORACLE_HOME --enable-sigchild --with-iconv Before configure test sqlplus user/[EMAIL PROTECTED] coneect succsessfuly. [2007-04-25 08:20:53] sasha at it-energy dot ru Description: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/apache2/htdocs/dbtest01.php on line 24 Reproduce code: --- $ORACLE_HOME = getenv("ORACLE_HOME"); echo "ORACLE_HOME=$ORACLE_HOME\n"; $NLS_LANG = getenv("NLS_LANG"); echo "NLS_LANG=$NLS_LANG\n"; $LD_LIBRARY_PATH = getenv("LD_LIBRARY_PATH"); echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH\n"; $ORA_NLS33 = getenv("ORA_NLS33"); echo "ORA_NLS33=$ORA_NLS33\n"; $username = "***"; $paswd= "**"; $dbstring = "**"; $db_conn = ocilogon($username, $paswd, $dbstring ); if (!$db_conn){ echo "...FAILED"; } Expected result: Connect to database. Actual result: -- ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/client_1 NLS_LANG=american_america.CL8MSWIN1251 LD_LIBRARY_PATH=/opt/oracle/oracle/product/10.2.0/client_1/lib:/opt/apache2/lib:/opt/oracle/oracle/product/10.2.0/client_1/lib ORA_NLS33=/opt/oracle/oracle/product/10.2.0/client_1/nls/data Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/apache2/htdocs/dbtest01.php on line 24 ...FAILED -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1
#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 Updated by: [EMAIL PROTECTED] Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: >I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect >succsessfuly" ORACLE_HOME should be available for _Apache_ process during the start up process. Oracle directory also has to be readable by Apache user. Previous Comments: [2007-04-25 09:02:08] sasha at it-energy dot ru Yes ! I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect succsessfuly" If ORACLE_HOME not correct call sqlplus not correct start. Realy, I do . oraenv and set valid SID [2007-04-25 08:29:52] [EMAIL PROTECTED] >There is something wrong with your system - please check that >ORACLE_HOME isset and points to the right directory Do I really need to add something? [2007-04-25 08:26:57] sasha at it-energy dot ru Installed full ORACLE client 10.2.0 php configure from root as: ./configure --with-apxs2=/opt/apache2/bin/apxs --with-openssl --enable-shmop --enable-sysvsem --enable-sysvshm --with-zlib --with-oci8=$ORACLE_HOME --enable-sigchild --with-iconv Before configure test sqlplus user/[EMAIL PROTECTED] coneect succsessfuly. [2007-04-25 08:20:53] sasha at it-energy dot ru Description: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/apache2/htdocs/dbtest01.php on line 24 Reproduce code: --- $ORACLE_HOME = getenv("ORACLE_HOME"); echo "ORACLE_HOME=$ORACLE_HOME\n"; $NLS_LANG = getenv("NLS_LANG"); echo "NLS_LANG=$NLS_LANG\n"; $LD_LIBRARY_PATH = getenv("LD_LIBRARY_PATH"); echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH\n"; $ORA_NLS33 = getenv("ORA_NLS33"); echo "ORA_NLS33=$ORA_NLS33\n"; $username = "***"; $paswd= "**"; $dbstring = "**"; $db_conn = ocilogon($username, $paswd, $dbstring ); if (!$db_conn){ echo "...FAILED"; } Expected result: Connect to database. Actual result: -- ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/client_1 NLS_LANG=american_america.CL8MSWIN1251 LD_LIBRARY_PATH=/opt/oracle/oracle/product/10.2.0/client_1/lib:/opt/apache2/lib:/opt/oracle/oracle/product/10.2.0/client_1/lib ORA_NLS33=/opt/oracle/oracle/product/10.2.0/client_1/nls/data Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/apache2/htdocs/dbtest01.php on line 24 ...FAILED -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1
#41184 [Bgs]: NOT CONNECT to DATABASE
ID: 41184 User updated by: sasha at it-energy dot ru Reported By: sasha at it-energy dot ru Status: Bogus Bug Type: OCI8 related Operating System: SUSE 10 PHP Version: 5.2.1 New Comment: Yes ! I write "Before configure test sqlplus user/[EMAIL PROTECTED] conect succsessfuly" If ORACLE_HOME not correct call sqlplus not correct start. Realy, I do . oraenv and set valid SID Previous Comments: [2007-04-25 08:29:52] [EMAIL PROTECTED] >There is something wrong with your system - please check that >ORACLE_HOME isset and points to the right directory Do I really need to add something? [2007-04-25 08:26:57] sasha at it-energy dot ru Installed full ORACLE client 10.2.0 php configure from root as: ./configure --with-apxs2=/opt/apache2/bin/apxs --with-openssl --enable-shmop --enable-sysvsem --enable-sysvshm --with-zlib --with-oci8=$ORACLE_HOME --enable-sigchild --with-iconv Before configure test sqlplus user/[EMAIL PROTECTED] coneect succsessfuly. [2007-04-25 08:20:53] sasha at it-energy dot ru Description: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/apache2/htdocs/dbtest01.php on line 24 Reproduce code: --- $ORACLE_HOME = getenv("ORACLE_HOME"); echo "ORACLE_HOME=$ORACLE_HOME\n"; $NLS_LANG = getenv("NLS_LANG"); echo "NLS_LANG=$NLS_LANG\n"; $LD_LIBRARY_PATH = getenv("LD_LIBRARY_PATH"); echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH\n"; $ORA_NLS33 = getenv("ORA_NLS33"); echo "ORA_NLS33=$ORA_NLS33\n"; $username = "***"; $paswd= "**"; $dbstring = "**"; $db_conn = ocilogon($username, $paswd, $dbstring ); if (!$db_conn){ echo "...FAILED"; } Expected result: Connect to database. Actual result: -- ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/client_1 NLS_LANG=american_america.CL8MSWIN1251 LD_LIBRARY_PATH=/opt/oracle/oracle/product/10.2.0/client_1/lib:/opt/apache2/lib:/opt/oracle/oracle/product/10.2.0/client_1/lib ORA_NLS33=/opt/oracle/oracle/product/10.2.0/client_1/nls/data Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /opt/apache2/htdocs/dbtest01.php on line 24 ...FAILED -- Edit this bug report at http://bugs.php.net/?id=41184&edit=1