Fw: Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php
problem solved...don't know how!
(1) successfully installed oci8 1.3.5 (thanks)
I wiah oci8 were updated by yum
(2) had to renew my 11g1 Oracle password since it would expire in 4 days.
I had to : alter user (and had it backward the first time)
(3) bingo!!! it started working with the new password
Whew!
--- On Sun, 5/31/09, Fred Silsbee wrote:
> From: Fred Silsbee
> Subject: Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser
> based php
> To: "danaketh"
> Date: Sunday, May 31, 2009, 11:41 PM
> Thanks! I thought of that...give the
> #$% thing what it wants!
>
> However not sure that causes the problem!
>
> There is no dll (of course anywhere in my Fedora 9).
>
> Currently trying to isolate the problem by stripping out
> everything but the connect.
>
> I did this way back when I got it working late last year!
> whew!
>
>
>
> --- On Sun, 5/31/09, danaketh
> wrote:
>
> > From: danaketh
> > Subject: Re: [PHP-DB] oci8 1.3.4 working for months on
> my simple browser based php
> > To: "Fred Silsbee"
> > Date: Sunday, May 31, 2009, 11:07 PM
> >
> >
> >
> >
> >
> >
> > You have link to .dll somewhere.
> > I however
> > don't know where Fedora keeps php.ini and extension
> > configs (on Debian
> > I have this configured just by copying files
> module.ini and
> > module.so
> > to the /usr/lib/php/extensions/).
> >
> >
> >
> > But if you can't find where the problem is, you may
> try
> > a little dirty
> > technique - copy/rename php_oci8.so and php_oracle.so
> to
> > .dll and put
> > them in /usr/lib/php/modules - to see what it will do.
> Also
> > look in
> > that place for .ini files..
> >
> >
> >
> > Fred Silsbee napsal(a):
> >
> > Thanks!Did the phpize command and all
> that worked
> > great...I have a new oci8.so in the right place
> >
> > Makes no sense, there is nothing about windows
> in my
> > php.ini file
> >
> > /etc/httpd/logs/error_message:
> >
> > [Sun May 32 16:58:46 2009] [notice] suEXEC mechanism
> > enabled (wrapper: /usr/sbin/suexec)
> > [Sun May 31 16:58:46 2009] [notice] Digest:
> generating
> > secret for digest authentication ...
> > [Sun May 31 16:58:46 2009] [notice] Digest: done
> > PHP Warning: PHP Startup: Unable to load dynamic
> library
> > '/usr/lib/php/modules/php_oci8.dll' -
> > /usr/lib/php/modules/php_oci8.dll: cannot open shared
> object
> > file: No such file or directory in Unknown on line 0
> > PHP Warning: PHP Startup: Unable to load dynamic
> library
> > '/usr/lib/php/modules/php_oracle.dll' -
> > /usr/lib/php/modules/php_oracle.dll: cannot open
> shared
> > object file: No such file or directory in Unknown on
> line 0
> > [Sun May 31 16:58:55 2009] [notice] mod_python:
> Creating 4
> > session mutexes based on 256 max processes and 0 max
> > threads.
> > [Sun May 31 16:58:55 2009] [notice] mod_python: using
> > mutex_directory /tmp
> > [Sun May 31 16:58:57 2009] [notice] Apache/2.2.9
> (Unix)
> > DAV/2 mod_mono/1.2.6 PHP/5.2.9 mod_python/3.3.1
> Python/2.5.1
> > mod_ssl/2.2.9 OpenSSL/0.9.8g mod_perl/2.0.4
> Perl/v5.10.0
> > configured -- resuming normal operations
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP Notice: Undefined
> index: in
> > /var/www/html/handle_log_book11g1.php on line 88
> > [Sun May 31 17:01:22 2009] [error] [client
> 207..254.232.245]
> > PHP Stack trace:
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP 1. {main}()
> /var/www/html/handle_log_book11g1.php:0
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP Notice: Undefined
> index: in
> > /var/www/html/handle_log_book11g1.php on line 89
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP Stack trace:
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP 1. {main}()
> /var/www/html/handle_log_book11g1.php:0
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP Notice: Undefined
> index: in
> > /var/www/html/handle_log_book_MySQL.php on line 73
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP Stack trace:
> > [Sun May 31 17:01:22 2009] [error] [client
> 207.254.232.245]
> > PHP 1. {main}()
> /var/www/html/handle_log_book_MySQL.php
Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php
Look what extensions are you loading. You should find that in php.ini file. Maybe something nasty happened and you php.ini has extension=php_oracle.dll instead of extension=php_oracle.so. Also, if you are about to compile a module for PHP, first you have to run phpize, than ./configure and make ;) Fred Silsbee napsal(a): For months I've had a Oracle 11g1 browser based table access site/program working. I do regular Fedora 9 yum updates and have seen some pecl/pear stuff whizzing by. Just tried the Oracle 11g1 browser based table access site/program and NOTHING shows on the Firefox 3.0.10 screen. Not even an error. /etc/httpd/logs/error_log says something about "cannot open php_oracle.dll or php_oci8.dll" That is good...there isn't any dll on Linux. Proble: downloaded oci8-1.3.5 and the README file says to run ./configure but there are 2 files config.m4 and config.w32 nothing in this README file works...is it up to date? -- S pozdravem Daniel Tlach Freelance webdeveloper Email: m...@danaketh.com ICQ: 160914875 MSN: danak...@hotmail.com Jabber: danak...@jabbim.cz
Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php
If I had to guess the config.w32 is the window 32 bit config file. So I would try the other Bastien Sent from my iPod On May 31, 2009, at 15:28, Fred Silsbee wrote: For months I've had a Oracle 11g1 browser based table access site/ program working. I do regular Fedora 9 yum updates and have seen some pecl/pear stuff whizzing by. Just tried the Oracle 11g1 browser based table access site/program and NOTHING shows on the Firefox 3.0.10 screen. Not even an error. /etc/httpd/logs/error_log says something about "cannot open php_oracle.dll or php_oci8.dll" That is good...there isn't any dll on Linux. Proble: downloaded oci8-1.3.5 and the README file says to run ./ configure but there are 2 files config.m4 and config.w32 nothing in this README file works...is it up to date? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] oci8 1.3.4 working for months on my simple browser based php
For months I've had a Oracle 11g1 browser based table access site/program working. I do regular Fedora 9 yum updates and have seen some pecl/pear stuff whizzing by. Just tried the Oracle 11g1 browser based table access site/program and NOTHING shows on the Firefox 3.0.10 screen. Not even an error. /etc/httpd/logs/error_log says something about "cannot open php_oracle.dll or php_oci8.dll" That is good...there isn't any dll on Linux. Proble: downloaded oci8-1.3.5 and the README file says to run ./configure but there are 2 files config.m4 and config.w32 nothing in this README file works...is it up to date? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] oci8
oci8 OCI8 Supportenabled Version 1.3.4 Revision$Revision: 1.269.2.16.2.38.2.20 $ Active Persistent Connections 0 Active Connections 0 Compile-time ORACLE_HOMEno value Libraries Used no value Temporary Lob support enabled Collections support enabled Directive Local Value Master Value oci8.connection_class no valueno value oci8.default_prefetch 100 100 oci8.events Off Off oci8.max_persistent -1 -1 oci8.old_oci_close_semanticsOff Off oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20 even with: Global: in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv ORACLE_SID lmkiiiGDNSID SetEnv ORACLE_TERM xterm SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/11.1.0/db_1/lib:/lib:/usr/lib -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCI8 , PHP and APACHE issue
It's usually easy as that. Good to hear you got it to work. On Mon, Sep 1, 2008 at 2:59 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > Funny you should mention that. > > Could not load the extension. > > I tried putting c:\php\ext as extension_dir but that resulted in apache > being unable to start at all. > > Than I remembered that on this particular machine we were running as a > different user and not local system. When I changed that it worked ok > > I really need to understand more about windows I guess > > Jack > > -Original Message- > From: Evert Lammerts [mailto:[EMAIL PROTECTED] > Sent: Monday, September 01, 2008 10:32 PM > To: Jack van Zanen > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] OCI8 , PHP and APACHE issue > > No interesting entries in the logs? > > On Mon, Sep 1, 2008 at 2:27 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: >> I have the phpinidir directive set in apache so it loads the exact same >> php.ini as the cli >> >> Jack >> >> 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> >>> >>> I see that in both cases c:\PHP\php.ini is loaded. Are you sure that >>> after trying the command line you didn't cut - paste the file to >>> c:\windows? What do apache's and PHP's logs say? >>> >>> On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: >>> > Attached is phpinfo() both from the command line and from apache on the >>> > same >>> > machine >>> > >>> > >>> > I have done the exact same setup on my laptop and it works fine from >>> > apache >>> > and cli. >>> > I even copied over the httpd.conf and the php.ini file from my laptop as >>> > all >>> > paths and versions were identical. >>> > >>> > Oracle 10.2.0.4 client >>> > apache 2.2 >>> > php 5.2.6 >>> > >>> > Thanks >>> > >>> > >>> > On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: >>> >> >>> >> Can you send your and the output of phpinfo when run from the command >>> >> line and when run from the browser? >>> >> >>> >> On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> >>> >> wrote: >>> >> > Hi List, >>> >> > >>> >> > >>> >> > I have installed Oracle, PHP and apache on my windows machine and >>> >> > have >>> >> > the >>> >> > following issue >>> >> > >>> >> > If I run phpinfo() from the command line it shows OCI8 as enabled and >>> >> > I >>> >> > can >>> >> > connect to oracle databases. >>> >> > >>> >> > When I copy my php.ini to my windows directory (from my php >>> >> > directory) >>> >> > and >>> >> > start apache and than run phpinfo() from a php page in my browser it >>> >> > does >>> >> > not show me that OCI8 is enabled and also does not allow me to >>> >> > connect >>> >> > to >>> >> > databases. It does show it is using the right php.ini from my windows >>> >> > directory >>> >> > >>> >> > I'm sure this must be an environment setting somewhere but I can't >>> >> > work >>> >> > this out. >>> >> > >>> >> > Anybody with some more experience in configuring this combo can shed >>> >> > some >>> >> > light on this?? >>> >> > >>> >> > >>> >> > >>> >> > Brgds >>> >> > >>> >> > >>> >> > Jack >>> >> > >>> > >>> > >>> > >>> > -- >>> > J.A. van Zanen >> >> >> >> -- >> J.A. van Zanen >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OCI8 , PHP and APACHE issue
Funny you should mention that. Could not load the extension. I tried putting c:\php\ext as extension_dir but that resulted in apache being unable to start at all. Than I remembered that on this particular machine we were running as a different user and not local system. When I changed that it worked ok I really need to understand more about windows I guess Jack -Original Message- From: Evert Lammerts [mailto:[EMAIL PROTECTED] Sent: Monday, September 01, 2008 10:32 PM To: Jack van Zanen Cc: php-db@lists.php.net Subject: Re: [PHP-DB] OCI8 , PHP and APACHE issue No interesting entries in the logs? On Mon, Sep 1, 2008 at 2:27 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > I have the phpinidir directive set in apache so it loads the exact same > php.ini as the cli > > Jack > > 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> >> >> I see that in both cases c:\PHP\php.ini is loaded. Are you sure that >> after trying the command line you didn't cut - paste the file to >> c:\windows? What do apache's and PHP's logs say? >> >> On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: >> > Attached is phpinfo() both from the command line and from apache on the >> > same >> > machine >> > >> > >> > I have done the exact same setup on my laptop and it works fine from >> > apache >> > and cli. >> > I even copied over the httpd.conf and the php.ini file from my laptop as >> > all >> > paths and versions were identical. >> > >> > Oracle 10.2.0.4 client >> > apache 2.2 >> > php 5.2.6 >> > >> > Thanks >> > >> > >> > On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: >> >> >> >> Can you send your and the output of phpinfo when run from the command >> >> line and when run from the browser? >> >> >> >> On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> >> >> wrote: >> >> > Hi List, >> >> > >> >> > >> >> > I have installed Oracle, PHP and apache on my windows machine and >> >> > have >> >> > the >> >> > following issue >> >> > >> >> > If I run phpinfo() from the command line it shows OCI8 as enabled and >> >> > I >> >> > can >> >> > connect to oracle databases. >> >> > >> >> > When I copy my php.ini to my windows directory (from my php >> >> > directory) >> >> > and >> >> > start apache and than run phpinfo() from a php page in my browser it >> >> > does >> >> > not show me that OCI8 is enabled and also does not allow me to >> >> > connect >> >> > to >> >> > databases. It does show it is using the right php.ini from my windows >> >> > directory >> >> > >> >> > I'm sure this must be an environment setting somewhere but I can't >> >> > work >> >> > this out. >> >> > >> >> > Anybody with some more experience in configuring this combo can shed >> >> > some >> >> > light on this?? >> >> > >> >> > >> >> > >> >> > Brgds >> >> > >> >> > >> >> > Jack >> >> > >> > >> > >> > >> > -- >> > J.A. van Zanen > > > > -- > J.A. van Zanen > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCI8 , PHP and APACHE issue
No interesting entries in the logs? On Mon, Sep 1, 2008 at 2:27 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > I have the phpinidir directive set in apache so it loads the exact same > php.ini as the cli > > Jack > > 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> >> >> I see that in both cases c:\PHP\php.ini is loaded. Are you sure that >> after trying the command line you didn't cut - paste the file to >> c:\windows? What do apache's and PHP's logs say? >> >> On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: >> > Attached is phpinfo() both from the command line and from apache on the >> > same >> > machine >> > >> > >> > I have done the exact same setup on my laptop and it works fine from >> > apache >> > and cli. >> > I even copied over the httpd.conf and the php.ini file from my laptop as >> > all >> > paths and versions were identical. >> > >> > Oracle 10.2.0.4 client >> > apache 2.2 >> > php 5.2.6 >> > >> > Thanks >> > >> > >> > On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: >> >> >> >> Can you send your and the output of phpinfo when run from the command >> >> line and when run from the browser? >> >> >> >> On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> >> >> wrote: >> >> > Hi List, >> >> > >> >> > >> >> > I have installed Oracle, PHP and apache on my windows machine and >> >> > have >> >> > the >> >> > following issue >> >> > >> >> > If I run phpinfo() from the command line it shows OCI8 as enabled and >> >> > I >> >> > can >> >> > connect to oracle databases. >> >> > >> >> > When I copy my php.ini to my windows directory (from my php >> >> > directory) >> >> > and >> >> > start apache and than run phpinfo() from a php page in my browser it >> >> > does >> >> > not show me that OCI8 is enabled and also does not allow me to >> >> > connect >> >> > to >> >> > databases. It does show it is using the right php.ini from my windows >> >> > directory >> >> > >> >> > I'm sure this must be an environment setting somewhere but I can't >> >> > work >> >> > this out. >> >> > >> >> > Anybody with some more experience in configuring this combo can shed >> >> > some >> >> > light on this?? >> >> > >> >> > >> >> > >> >> > Brgds >> >> > >> >> > >> >> > Jack >> >> > >> > >> > >> > >> > -- >> > J.A. van Zanen > > > > -- > J.A. van Zanen > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCI8 , PHP and APACHE issue
I have the phpinidir directive set in apache so it loads the exact same php.ini as the cli Jack 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> > I see that in both cases c:\PHP\php.ini is loaded. Are you sure that > after trying the command line you didn't cut - paste the file to > c:\windows? What do apache's and PHP's logs say? > > On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > > Attached is phpinfo() both from the command line and from apache on the > same > > machine > > > > > > I have done the exact same setup on my laptop and it works fine from > apache > > and cli. > > I even copied over the httpd.conf and the php.ini file from my laptop as > all > > paths and versions were identical. > > > > Oracle 10.2.0.4 client > > apache 2.2 > > php 5.2.6 > > > > Thanks > > > > > > On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: > >> > >> Can you send your and the output of phpinfo when run from the command > >> line and when run from the browser? > >> > >> On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> > wrote: > >> > Hi List, > >> > > >> > > >> > I have installed Oracle, PHP and apache on my windows machine and have > >> > the > >> > following issue > >> > > >> > If I run phpinfo() from the command line it shows OCI8 as enabled and > I > >> > can > >> > connect to oracle databases. > >> > > >> > When I copy my php.ini to my windows directory (from my php directory) > >> > and > >> > start apache and than run phpinfo() from a php page in my browser it > >> > does > >> > not show me that OCI8 is enabled and also does not allow me to connect > >> > to > >> > databases. It does show it is using the right php.ini from my windows > >> > directory > >> > > >> > I'm sure this must be an environment setting somewhere but I can't > work > >> > this out. > >> > > >> > Anybody with some more experience in configuring this combo can shed > >> > some > >> > light on this?? > >> > > >> > > >> > > >> > Brgds > >> > > >> > > >> > Jack > >> > > > > > > > > > -- > > J.A. van Zanen > -- J.A. van Zanen
Re: [PHP-DB] OCI8 , PHP and APACHE issue
I see that in both cases c:\PHP\php.ini is loaded. Are you sure that after trying the command line you didn't cut - paste the file to c:\windows? What do apache's and PHP's logs say? On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > Attached is phpinfo() both from the command line and from apache on the same > machine > > > I have done the exact same setup on my laptop and it works fine from apache > and cli. > I even copied over the httpd.conf and the php.ini file from my laptop as all > paths and versions were identical. > > Oracle 10.2.0.4 client > apache 2.2 > php 5.2.6 > > Thanks > > > On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: >> >> Can you send your and the output of phpinfo when run from the command >> line and when run from the browser? >> >> On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote: >> > Hi List, >> > >> > >> > I have installed Oracle, PHP and apache on my windows machine and have >> > the >> > following issue >> > >> > If I run phpinfo() from the command line it shows OCI8 as enabled and I >> > can >> > connect to oracle databases. >> > >> > When I copy my php.ini to my windows directory (from my php directory) >> > and >> > start apache and than run phpinfo() from a php page in my browser it >> > does >> > not show me that OCI8 is enabled and also does not allow me to connect >> > to >> > databases. It does show it is using the right php.ini from my windows >> > directory >> > >> > I'm sure this must be an environment setting somewhere but I can't work >> > this out. >> > >> > Anybody with some more experience in configuring this combo can shed >> > some >> > light on this?? >> > >> > >> > >> > Brgds >> > >> > >> > Jack >> > > > > > -- > J.A. van Zanen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCI8 , PHP and APACHE issue
Attached is phpinfo() both from the command line and from apache on the same machine I have done the exact same setup on my laptop and it works fine from apache and cli. I even copied over the httpd.conf and the php.ini file from my laptop as all paths and versions were identical. Oracle 10.2.0.4 client apache 2.2 php 5.2.6 Thanks On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: > > Can you send your and the output of phpinfo when run from the command > line and when run from the browser? > > On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > > Hi List, > > > > > > I have installed Oracle, PHP and apache on my windows machine and have > the > > following issue > > > > If I run phpinfo() from the command line it shows OCI8 as enabled and I > can > > connect to oracle databases. > > > > When I copy my php.ini to my windows directory (from my php directory) > and > > start apache and than run phpinfo() from a php page in my browser it does > > not show me that OCI8 is enabled and also does not allow me to connect to > > databases. It does show it is using the right php.ini from my windows > > directory > > > > I'm sure this must be an environment setting somewhere but I can't work > > this out. > > > > Anybody with some more experience in configuring this combo can shed some > > light on this?? > > > > > > > > Brgds > > > > > > Jack > > > -- J.A. van Zanen phpinfo() PHP Version => 5.2.6 System => Windows NT D1LTYW1S 5.1 build 2600 Build Date => May 2 2008 18:01:20 Configure Command => cscript /nologo configure.js "--enable-snapshot-build" "--with-gd=shared" "--with-extra-includes=C:\Program Files (x86)\Microsoft SDK\Include;C:\PROGRA~2\MICROS~2\VC98\ATL\INCLUDE;C:\PROGRA~2\MICROS~2\VC98\INCLUDE;C:\PROGRA~2\MICROS~2\VC98\MFC\INCLUDE" "--with-extra-libs=C:\Program Files (x86)\Microsoft SDK\Lib;C:\PROGRA~2\MICROS~2\VC98\LIB;C:\PROGRA~2\MICROS~2\VC98\MFC\LIB" Server API => Command Line Interface Virtual Directory Support => enabled Configuration File (php.ini) Path => C:\WINDOWS Loaded Configuration File => C:\PHP\php.ini PHP API => 20041225 PHP Extension => 20060613 Zend Extension => 220060519 Debug Build => no Thread Safety => enabled Zend Memory Manager => enabled IPv6 Support => enabled Registered PHP Streams => php, file, data, http, ftp, compress.zlib Registered Stream Socket Transports => tcp, udp Registered Stream Filters => convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.* This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies ___ Configuration PHP Core Directive => Local Value => Master Value allow_call_time_pass_reference => Off => Off allow_url_fopen => On => On allow_url_include => Off => Off always_populate_raw_post_data => Off => Off arg_separator.input => & => & arg_separator.output => & => & asp_tags => Off => Off auto_append_file => no value => no value auto_globals_jit => On => On auto_prepend_file => no value => no value browscap => no value => no value default_charset => no value => no value default_mimetype => text/html => text/html define_syslog_variables => Off => Off disable_classes => no value => no value disable_functions => no value => no value display_errors => STDOUT => STDOUT display_startup_errors => Off => Off doc_root => no value => no value docref_ext => no value => no value docref_root => no value => no value enable_dl => On => On error_append_string => no value => no value error_log => no value => no value error_prepend_string => no value => no value error_reporting => 0 => 0 expose_php => On => On extension_dir => ./ext/ => ./ext/ file_uploads => On => On highlight.bg => #FF => #FF highlight.comment => #FF8000 => #FF8000 highlight.default => #BB => #BB highlight.html => #00 => #00 highlight.keyword => #007700 => #007700 highlight.string => #DD => #DD html_errors => Off => Off ignore_repeated_errors => Off => Off ignore_repeated_source => Off => Off ignore_user_abort => Off => Off implicit_flush => On => On include_path => .;C:\php5\pear => .;C:\php5\pear log_errors => On => On log_errors_max_len => 1024 => 1024 magic_quotes_gpc => Off => Off magic_quotes_runtime => Off => Off magic_quotes_sybase => Off => Off mail.force_extra_parameters => no value => no value max_execution_time => 0 => 0 max_input_nesting_level => 64 => 64 max_input_time => -1 => -1 memory_limit => 128M => 128M open_basedir => no value => no value output_buffering => 0 => 0 output_handler => no value => no value post_max_size => 8M => 8M precision => 14 => 14 realpath_cache_size => 16K => 16K realpath_cache_ttl => 120 => 120 register_argc_argv => On => On register_globals => Off => Off register_long_arrays => Off => Off report_memleaks => On => On report_zend_debug => Off => Off safe_mode => Off => Off safe_mode_exec_dir
Re: [PHP-DB] OCI8 , PHP and APACHE issue
at home now, will log on maybe later and get these Thanks so far 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> > Can you send your and the output of phpinfo when run from the command > line and when run from the browser? > > On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > > Hi List, > > > > > > I have installed Oracle, PHP and apache on my windows machine and have > the > > following issue > > > > If I run phpinfo() from the command line it shows OCI8 as enabled and I > can > > connect to oracle databases. > > > > When I copy my php.ini to my windows directory (from my php directory) > and > > start apache and than run phpinfo() from a php page in my browser it does > > not show me that OCI8 is enabled and also does not allow me to connect to > > databases. It does show it is using the right php.ini from my windows > > directory > > > > I'm sure this must be an environment setting somewhere but I can't work > > this out. > > > > Anybody with some more experience in configuring this combo can shed some > > light on this?? > > > > > > > > Brgds > > > > > > Jack > > > -- J.A. van Zanen
Re: [PHP-DB] OCI8 , PHP and APACHE issue
Can you send your and the output of phpinfo when run from the command line and when run from the browser? On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > Hi List, > > > I have installed Oracle, PHP and apache on my windows machine and have the > following issue > > If I run phpinfo() from the command line it shows OCI8 as enabled and I can > connect to oracle databases. > > When I copy my php.ini to my windows directory (from my php directory) and > start apache and than run phpinfo() from a php page in my browser it does > not show me that OCI8 is enabled and also does not allow me to connect to > databases. It does show it is using the right php.ini from my windows > directory > > I'm sure this must be an environment setting somewhere but I can't work > this out. > > Anybody with some more experience in configuring this combo can shed some > light on this?? > > > > Brgds > > > Jack > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OCI8 , PHP and APACHE issue
Hi List, I have installed Oracle, PHP and apache on my windows machine and have the following issue If I run phpinfo() from the command line it shows OCI8 as enabled and I can connect to oracle databases. When I copy my php.ini to my windows directory (from my php directory) and start apache and than run phpinfo() from a php page in my browser it does not show me that OCI8 is enabled and also does not allow me to connect to databases. It does show it is using the right php.ini from my windows directory I'm sure this must be an environment setting somewhere but I can't work this out. Anybody with some more experience in configuring this combo can shed some light on this?? Brgds Jack
RE: [PHP-DB] oci8
Send output of your phpinfo() function . Have you added vendor specific library(extention) in php.ini. --Manoj Kr. Sheoran <[EMAIL PROTECTED]> -Original Message- From: Joe [mailto:[EMAIL PROTECTED] Sent: Sunday, November 21, 2004 3:38 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] oci8 I am facing problem in connecting to Oracle from php. I followed the instructions listed in www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.h tml. However, when I run phpinfo(), it show that oci8 is not loaded and eventually the ocilogon() is not working. I'd really appreciate your feedback -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] oci8
I am facing problem in connecting to Oracle from php. I followed the instructions listed in www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.h tml. However, when I run phpinfo(), it show that oci8 is not loaded and eventually the ocilogon() is not working. I'd really appreciate your feedback -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] oci8 cannot connect after restarting DB
Every evening, for whatever reason, our Oracle db (9.2.0) is restated. After it is restarted, I am unable to build a connection with Oracle from PHP untill Apache is restarted. Whenever I do an ociplogon() or ocilogon() following an Oracle DB restart, it fails but I am unable to get a description of the error. Restarting Apache "fixes" the problem. Has anyone else experianced the same issue? It appears to me that this is a php oci8 bug. (shouldn't a new connection be built if a persistant connection fails, and if not using persistant connections, shouldn't this be a non issue?) Thanks, Michael
RE: [PHP-DB] OCI8
Thanks for your help, but i tried with OCIPLogon, and get same result.
-Message d'origine-
De : Ford, Mike [LSS] [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 13 août 2004 16:03
À : 'yannick'; [EMAIL PROTECTED]
Objet : RE: [PHP-DB] OCI8
On 13 August 2004 13:29, yannick wrote:
> I have some trouble with Oracle Database and php...
>
> see this code:
> while (1) {
> $conn=OCILogon($username,$password,$database);
Try OCIPLogon() rather than OCILogon().
> $stmt=OCIParse($conn,"select 50 as toto from dual");
> OCIDefineByName($stmt,"TOTO",&$total);
Not related to your problem, but you don't need that & -- in fact, it's
deprecated and may, one day, cause a parse error.
> OCIExecute($stmt);
> OCIFetch($stmt);
> echo ":::$total:::\n";
> OCILogoff($conn);
> $err=OCIError($conn);
> OCILogoff($conn);
> sleep(10);
> }
> >
>
> when i execute it, the number of fd on ocius.msg is growing. but
> there is only 1 connection at database.
>
> Can someone help me ?
Cheers!
Mike
-
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OCI8
On 13 August 2004 13:29, yannick wrote:
> I have some trouble with Oracle Database and php...
>
> see this code:
> while (1) {
> $conn=OCILogon($username,$password,$database);
Try OCIPLogon() rather than OCILogon().
> $stmt=OCIParse($conn,"select 50 as toto from dual");
> OCIDefineByName($stmt,"TOTO",&$total);
Not related to your problem, but you don't need that & -- in fact, it's deprecated and
may, one day, cause a parse error.
> OCIExecute($stmt);
> OCIFetch($stmt);
> echo ":::$total:::\n";
> OCILogoff($conn);
> $err=OCIError($conn);
> OCILogoff($conn);
> sleep(10);
> }
> >
>
> when i execute it, the number of fd on ocius.msg is growing. but
> there is only 1 connection at database.
>
> Can someone help me ?
Cheers!
Mike
-
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Headingley Campus, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OCI8
i don t really need to keep reconnecting.
i made this script to reproduce problem with apache.
ie:apache's child keep a lot of Fd to ocius.msg .
-Message d'origine-
De : Christopher Jones [mailto:[EMAIL PROTECTED]
Envoye : vendredi 13 aout 2004 15:12
A : yannick
Cc : [EMAIL PROTECTED]
Objet : Re: [PHP-DB] OCI8
It might be a feature of PHP's connection caching. Why don't
you log a bug in the PHP bug DB so the problem can be tracked?
Do you really need to keep reconnecting?
See
http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq
.html#conmgt
Chris
yannick wrote:
> I have some trouble with Oracle Database and php...
>
> see this code:
> while (1) {
> $conn=OCILogon($username,$password,$database);
> $stmt=OCIParse($conn,"select 50 as toto from dual");
> OCIDefineByName($stmt,"TOTO",&$total);
> OCIExecute($stmt);
> OCIFetch($stmt);
> echo ":::$total:::\n";
> OCILogoff($conn);
> $err=OCIError($conn);
> OCILogoff($conn);
> sleep(10);
> }
> ?>
>
> when i execute it, the number of fd on ocius.msg is growing. but there is
> only 1 connection at database.
>
> Can someone help me ?
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCI8
It might be a feature of PHP's connection caching. Why don't you log a bug in the PHP bug DB so the problem can be tracked? Do you really need to keep reconnecting? See http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt Chris yannick wrote: I have some trouble with Oracle Database and php... see this code: when i execute it, the number of fd on ocius.msg is growing. but there is only 1 connection at database. Can someone help me ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OCI8
I have some trouble with Oracle Database and php... see this code: when i execute it, the number of fd on ocius.msg is growing. but there is only 1 connection at database. Can someone help me ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OCI8 Memory Leak?
Thanks a lot for the response, Greg. I poked around quite a bit in the PEAR::DB source, and everything at first glance looks OK. Connections are closed properly, etc. After doing a little more digging on the Web, I noticed a mention to remove any reference to "SERVER=DEDICATED" from Oracle's tnsnames.ora file. I did, and it seems to have helped... though I'm not convinced. Thanks! Shawn -Original Message- From: Greg Skouby [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 3:28 PM To: Shawn Coomey Subject: RE: [PHP-DB] OCI8 Memory Leak? Hi Shawn, We are using almost the exact same setup that you describe without the PEAR abstraction. We host a moderate sized application on this box and it has performed flawlessly. My first indication, though I don't know why it would be happening, is that there is a problem in the PEAR abstraction level. --Greg -Original Message- From: Shawn Coomey [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 11:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] OCI8 Memory Leak? Hi folks- I am building an application which uses OCI8 functions (abstracted with PEAR::DB) to perform queries against an Oracle 9i database. Here's my platform info: Solaris 8 (SunOS 5.2) on a Sun Ultra II workstation Oracle 9i PHP 4.3.5RC2-dev Apache 1.3.29 Here's my problem: Everything works well, but over time the Apache httpd processes start to take huge amounts of memory: for instance: I checked this morning and each of the apache processes running were using over 125MB per instance, and the server had slowed to a standstill. The processes upon restart use between 15-20MB per instance. Is there something in the Oracle client configuration or in php/pear that can lead to this sort of memory problem? Any help is greatly appreciated. Shawn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OCI8 Memory Leak?
Hi folks- I am building an application which uses OCI8 functions (abstracted with PEAR::DB) to perform queries against an Oracle 9i database. Here's my platform info: Solaris 8 (SunOS 5.2) on a Sun Ultra II workstation Oracle 9i PHP 4.3.5RC2-dev Apache 1.3.29 Here's my problem: Everything works well, but over time the Apache httpd processes start to take huge amounts of memory: for instance: I checked this morning and each of the apache processes running were using over 125MB per instance, and the server had slowed to a standstill. The processes upon restart use between 15-20MB per instance. Is there something in the Oracle client configuration or in php/pear that can lead to this sort of memory problem? Any help is greatly appreciated. Shawn
[PHP-DB] OCI8 issue (and some apc too): configure bugs?
Hello all,
I've read several messages and articles about php/oci8 combination, but I
still have some issues not resolved.
On this system:
Debian (stable), PHP 4.0.6, Oracle 8.1.7, Apache 1.3.9-14,
I compile php like this:
#Begin
ORACLE_HOME=/oracle/product/8.1.7
./configure \
--prefix=/usr \
--with-apxs \
--with-config-file-path=/etc/php4/apache \
--with-gd=shared \
--with-jpeg-dir=/usr \
--with-png-dir=/usr \
--with-zlib-dir=/usr \
--enable-gd-native-ttf \
--enable-apc \
--enable-inline-optimization \
--with-oci8=${ORACLE_HOME} |
tee /tmp/phpbuild.log
make | tee -a /tmp/phpbuild.log
make install | tee -a /tmp/phpbuild.log
#End
I ran phpize on ext/oci8 and also ran autoconf on top level of the source
tree, before that.
The problem is that it doesn't build the oci8.so and php_apc.so in the
modules directory!
Anybody knows why that?
What I have already tried:
On the ext source tree I find the oci8.lo and php_apc.lo files. Then, first
I tried to rename them to .so.
And put the following on apache initialization:
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/product/8.1.7
PATH=$PATH:$ORACLE_HOME/bin
ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1"
NLS_LANG33=$ORACLE_HOME/ocommon/nls/admin/data
LD_PRELOAD=$ORACLE_HOME/lib/libclntsh.so.8.0
LD_LIBRARY_PATH=/lib:/usr/lib:$ORACLE_HOME/lib
unset LANG
export (...all of them)
Result: APC works fine, and so OCI8, BUT...
on apache error.log it tells me oci8 could not be loaded. ("ELF file's
phentsize not the expected size in Unknown on line 0")
Things are working probably just because of the LD_PRELOAD line above.
I've tried then to generate the .so in the right way:
cc -shared -o oci8.so oci8.lo (is it the right way?)
Now apache tells me that oci8.so is a "invalid library (maybe not a PHP
library) on Unknown line 0"
I just want to understand, can somebody help me understand it?
Thank you in advance,
Diego Morales.
--
Diego Francisco de Gastal Morales
Técnico em Informática
Equipe de Redes - DI
Tribunal de Justiça do RS
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] OCI8
On Thu, Jan 17, 2002 at 01:20:47PM -0700, Randall Barber wrote: > I've been using the OCI8 extension and have a question about the Persistent >Connections. > > While debugging the site, I will run into the following error (paraphrased): > > BeginSession: too many processes running > > etc... > > I have my scripts setup in the following way: > > > OCIPLogon(...); > > stuff > > ?> > > > I never do call OCILogOff(...) explicitly. I may misunderstand, but I thought when >a call to a persistent connection is made, it will first look for an open session and >use it. > Otherwise, it creates a new one. This correct? yes. > > What causes this "overload" of sorts? Is it PHP or Apache? when using persustent connections you will at one point have as many db-connections as you have httpd processes. so to limit the no. of connections to your DB you have to set MaxClients in httpd.conf. i'mn ot to sure about the windows stuff here - does it work when using OCILogin instead of OCIPlogon? tc > > Win2k > Apache 1.3.20 > PHP 4.1.0 > > Thanks in advance for your help > RDB > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] OCI8
I've been using the OCI8 extension and have a question about the Persistent Connections. While debugging the site, I will run into the following error (paraphrased): BeginSession: too many processes running etc... I have my scripts setup in the following way: I never do call OCILogOff(...) explicitly. I may misunderstand, but I thought when a call to a persistent connection is made, it will first look for an open session and use it. Otherwise, it creates a new one. This correct? What causes this "overload" of sorts? Is it PHP or Apache? Win2k Apache 1.3.20 PHP 4.1.0 Thanks in advance for your help RDB
[PHP-DB] OCI8 Function Clarification
I have a simple SELECT statement that returns more than one row.
When I do something like this:
do
{
.
} while (OCIFetch($qryResult) != false);
I get an "Out of sequence" error on OCIFetch. So then I tried this:
$numRows = OCIRowCount($qryResult);
for($i = 0; $i < $numRows; $i++)
{
OCIFetch($qryResult);
..
}
Now I get 0, for the row count. If I call OCIFetch once, before the OCIRowCount, I
get a value of 1 (which makes sense I guess, since it will only fetch one row at a
time).
*** How do I step through a SELECT result set?
Thanks
RDB
[PHP-DB] OCI8
Anyone can help with php and OCI8, to get the connection with Oracle? I am running Oracle 9.0 and the error message is ORA-12705 (invalid or unknown NLS parameter in /usr/local/apache/htdocs/xyz.php on line 5). I am running PHP 4.0.6, Apache 1.3.22 on Suse linux 7.1 Thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8.max_links missing from php.ini
Hello, I checked the windows php.ini and i did not see any reference to oci8.allow_persistent=On ; allow or prevent persistent links oci8.check_persistent=On ; check that a connection is still validbefore reuse oci8.max_persistent=-1 ; maximum number of persistent links. -1 means no limit oci8.max_links=-1 ; maximum number of links (persistent+non persistent). -1 means no limit Are they actually supported? Thanks, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] oci8 and arrays as parameter
On Mon, Sep 10, 2001 at 03:50:08PM +0200, Ez-Berlin, E2boxb wrote: > hi list, read my paper from conf.php.net/oci - it should explain all that! tc > > I'm using PHP 4.0.6 and i want to give an array as parameter > from a php script to an oracle pl/sql - procedure... > > We had an older asp - site, witch used the same stored procedure, so > that it's clear, the procedure works... > In asp it calls "AddTable" to bind the parameter as array > > call without typ: > OCIbindbyname($stmt, ":P13", &$arr,-1); > -> Warning: > Array to string conversion in x on line y > > call with OCI_B_CURSOR: > OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); > -> Warning: > Supplied argument is not a valid OCI8-Statement resource in x on line y > > call with OCI_B_TABLE: > OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); > -> Warning: > Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y > > I got the same message with parameters: OCI_B_ARRAY, > OCI_B_VARRAY and any other typs > > Is this not possible with the current version? > > regards > Olaf Taesch > mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8 and arrays as parameter
I am using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without typ: OCIbindbyname($stmt, ":P13", &$arr,-1); -> Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); -> Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); -> Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8 and arrays as parameter
hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without typ: OCIbindbyname($stmt, ":P13", &$arr,-1); -> Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); -> Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); -> Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oci8 and arrays as parameter
hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without typ: OCIbindbyname($stmt, ":P13", &$arr,-1); -> Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_CURSOR); -> Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, ":P13", &$arr,1,OCI_B_TABLE); -> Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] OCI8: searching for testcase that causes "failed to rollback outstanding transactions" or SEGFAULTs
resend cause of type in adress - Forwarded message from "Thies C. Arntzen" <[EMAIL PROTECTED]> - Date: Sun, 18 Feb 2001 17:26:25 +0100 From: "Thies C. Arntzen" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: OCI8: searching for testcase that causes "failed to rollback outstanding transactions" or SEGFAULTs User-Agent: Mutt/1.3.15i hi, (sorry for cross-posting) i'm currently investigating some reported problems with the PHP 4 OCI8 interface. some people have reported SEGFAULTs and "failed to rollback outstanding transactions" messages in their apache error_log. sadly i cannot reproduce any of those problems on my machine. i would be very happy to hear of anybody who managed to crash PHP4+OCI8 and who could send me a _SHORT_ testscript that allows me to reproduce (and fix) this problem! regards, tc - End forwarded message - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] OCI8 error problems
On Thu, Feb 15, 2001 at 10:07:23AM -0500, Brian Lalor wrote: > On Thu, 15 Feb 2001, Thies C. Arntzen wrote: > > > how should it? > > > > you would have to pass in the correct statement|connection > > handle - elsewise it simply won't work! > > Ok, that was a cobbled-up code snippet; replace $this->conn with $conn, > and $statement with $s. > > It still doesn't work... works for me. tc -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] OCI8 error problems
On Thu, 15 Feb 2001, Thies C. Arntzen wrote: > how should it? > > you would have to pass in the correct statement|connection > handle - elsewise it simply won't work! Ok, that was a cobbled-up code snippet; replace $this->conn with $conn, and $statement with $s. It still doesn't work... _ B r i a n L a l o r [EMAIL PROTECTED] http://hcirisc.cs.binghamton.edu/~blalor Spam me not. To get my pgp key, put "get pgp key" in the subject of your message I will finish what I start -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: AW: [PHP-DB] OCI8 error problems
On Thu, 15 Feb 2001, Matthias Kopolt wrote: > > Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900) > violated ORA-06512: at > >"CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1 in db.php on > line 344 > > this has nothing to do with PHP, this is your personal DB-Problem ;-) I *know* that. the problem is that I can't trap and then programmatically display the error! _ B r i a n L a l o r [EMAIL PROTECTED] http://hcirisc.cs.binghamton.edu/~blalor Spam me not. To get my pgp key, put "get pgp key" in the subject of your message Woody: What's going on, Mr. Peterson? Norm: Let's talk about what's going *in* Mr. Peterson. A beer, Woody. -- Cheers, Paint Your Office -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] OCI8 error problems
On Wed, Feb 14, 2001 at 05:40:02PM -0500, Brian Lalor wrote:
> Good afternoon, all. Sorry if this has been covered before, but a search
> of the archives doesn't turn up any relevant answers.
>
> I'm having a problem with the OCI8 commands. I'm using PHP 4.0.4pl1 with
> Oracle 8.0.5 (yes, I know that's old, but somebody seems to have lost the
> CD for 8.1...). Consider the following code where OCIExecute returns
> false and PHP spits out the wrning message
> Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900)
>violated ORA-06512: at "CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1
>in db.php on line 344
>
> $s = OCIParse($conn, $query)
> $rc = OCIExecute($s, OCI_COMMIT_ON_SUCCESS);
> if(!$rc) {
> $err = OCIError($statement);
^^?
>
> if(!$err) {
> $err = OCIError($this->conn);
^^^?
>
> if(!$err) {
> $err = OCIError();
>
> if(!$err) {
> print("OCIExecute() returned false, but can't find an error\n");
how should it?
you would have to pass in the correct statement|connection
handle - elsewise it simply won't work!
zc
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
AW: [PHP-DB] OCI8 error problems
> Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900) violated ORA-06512: at >"CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1 in db.php on line 344 this has nothing to do with PHP, this is your personal DB-Problem ;-) A "constraint" is a DB-Rule that keeps you from producing invalid or senseless records. You normaly set them explicitly or be declaruing columns as unique or by disallowing null values. In this case you violated a "unique constraint" maybe you're inserting twice the same record, or there is already a record with the same id or ... you can investigate your Table defintions or search the DB with tool for the constraintsname CUSTOM.SYS_C007900 if you dont have a clue what you are violating. I'd guess your MULT_SHIP_ADDRESS_PKG is already used ... mk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] OCI8 error problems
Good afternoon, all. Sorry if this has been covered before, but a search
of the archives doesn't turn up any relevant answers.
I'm having a problem with the OCI8 commands. I'm using PHP 4.0.4pl1 with
Oracle 8.0.5 (yes, I know that's old, but somebody seems to have lost the
CD for 8.1...). Consider the following code where OCIExecute returns
false and PHP spits out the wrning message
Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900)
violated ORA-06512: at "CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1
in db.php on line 344
$s = OCIParse($conn, $query)
$rc = OCIExecute($s, OCI_COMMIT_ON_SUCCESS);
if(!$rc) {
$err = OCIError($statement);
if(!$err) {
$err = OCIError($this->conn);
if(!$err) {
$err = OCIError();
if(!$err) {
print("OCIExecute() returned false, but can't find an error\n");
} else {
print("error elsewhere\n");
print_r($err);
}
} else {
print("error in connection\n");
print_r($err);
}
} else {
print("error in statement\n");
print_r($err);
}
}
I always end up with "OCIExecute() returned false, but can't find an
error". I can, of course, suppress the PHP error by preceding OCIExecute
with an @, but that doesn't fix the problem: I can't programmatically
retrieve the error.
Am I missing something, or is the OCI8 support just badly broken?
Thanks,
B
_
B r i a n L a l o r [EMAIL PROTECTED]
http://hcirisc.cs.binghamton.edu/~blalor Spam me not.
To get my pgp key, put "get pgp key" in the subject of your message
Asking a pilot what he thinks about the FAA is like asking a fireplug what
it thinks about a dog.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] OCI8 and Listener
Hi. Stefan the returned error is TNS-12162 TNS:service name is incorrectly specified Cause: The connect descriptor corresponding to the service name in TNSNAMES.ORA is incorrectly specified. Action: Make sure there are no syntax errors in the connect descriptor. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the SQL*Net V2 Administrator's Guide. This allways seems to be an error with PHP4 they identify an TNS error as ORA error. Check oracle a76999.pdf for all errors. Try tnsping to see if your TNSNAMES.ora is set correct. You do NOT need to start a listener on the machine where the application runs, only on the server. > Stefan Fokuhl schrieb: > Hi, > > i've compiled my php modul with oci8.But I can't connect to my db. It > tells me the error ORA-12162. In the documentation there is no such > error mentioned. > > Do I need to start to Oracle listner? > Is tere somebody who had solved this problem in the past? > > Thanks > > Stefan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] OCI8 and Listener
The server (that is running the actual Oracle Database) has to have the listener running. If you can connect with SQL*Plus (the Oracle provided SQL interpreter) then you should be able to connect with PHP. Not sure what the error you are receiving is though as I don't have a reference here. Try searching google for that error... Sean -Original Message- From: Stefan Fokuhl [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 7:06 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] OCI8 and Listener Hi, i've compiled my php modul with oci8.But I can't connect to my db. It tells me the error ORA-12162. In the documentation there is no such error mentioned. Do I need to start to Oracle listner? Is tere somebody who had solved this problem in the past? Thanks Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] OCI8 and Listener
Stefan, can you connect with oracles SQL*Plus tool? Steve Farmer At 8:05 AM +0100 15/1/01, Stefan Fokuhl wrote: >Hi, > >i've compiled my php modul with oci8.But I can't connect to my db. It >tells me the error ORA-12162. In the documentation there is no such >error mentioned. > >Do I need to start to Oracle listner? >Is tere somebody who had solved this problem in the past? > >Thanks > >Stefan > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- --- "I disagree completely with what you are saying, but I will defend to the death your right to say it" - Voltaire Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] OCI8 and Listener
Hi, i've compiled my php modul with oci8.But I can't connect to my db. It tells me the error ORA-12162. In the documentation there is no such error mentioned. Do I need to start to Oracle listner? Is tere somebody who had solved this problem in the past? Thanks Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
