Comments on: PHP5 with Oracle client on FreeBSD tutorial

By: Fauzan

Fauzan — Mon, 26 Apr 2010 02:48:50 +0000

Is this article still applicable now? Because I found ‘Segmentation fault (core dumped)’ error in PHP after follow your instruction.
In the other hand, I tried to re-configure PHP with ./configure –with-oci8=/usr/local/oracle8-client but gave this error:
/usr/local/oracle8-client/lib/libclntsh.a(sltst.o)(.text+0×196): In function `sltstcr’:
: undefined reference to `pthread_create’
. . . . .
/usr/local/oracle8-client/lib/libclntsh.a(sepco.o)(.text+0x7d): In function `sepcoget_login’:
: undefined reference to `cuserid’
*** Error code 1
1 error
Stop in /usr/ports/lang/php5.
*** Error code 1

Do you have an idea to fix this issue?
FYI I’m using these OS and application:
FreeBSD 7.2
PHP-5.2.11

Thanks for your help,
#Fauzan

By: Westin Shafer

Westin Shafer — Wed, 09 Jul 2008 19:13:31 +0000

“Has anybody is submited this one to PHP or FREEBSD mailinglist/bug report?”

I did and they only came back with “This is a problem with the pspell extension.”

While this did cleare up the segfault I was getting in httpd-error.log file it did not clear up the CLI.

I also installed the PDO_OCI driver as well, and it appears that the segfault happends with it too.

By: noisex

noisex — Tue, 13 May 2008 17:12:20 +0000

Hallo!
I have the same problem as many of you described:

FreeBSD 7.0, PHP 5.2.6, PHP5-OCI8 1.2.5, Oracle 8 client 0.2.0_1. (All up2date). So every time when PHP-CLI or PHP-CGI script exits from comandline PHP die with seg.fault 11 (core dumped). I tried to recompile with this one patch http://canonical.wordpress.com/2007/09/12/freebsd-php-oci8-segfault-fix/ but on PHP5.2.6 this didn’t work for me. I hate this entries in /var/log/messages that my php died every time when script exits (i have a lot of scripts which run from CLI in crontab).

GDB debugger also nothing more than error didn’t tell me:

Program terminated with signal 11, Segmentation fault.
#0 0x88f18acc in ?? ()

So now many scripts i rewrite in perl which using p5-bdb-oracle with no problems or crashes.

Has anybody is submited this one to PHP or FREEBSD mailinglist/bug report?

By: Josh

Josh — Fri, 09 May 2008 02:40:38 +0000

If you do a phpinfo() after getting the OCI module built you’ll see that there was no compile-time ORACLE_HOME value set. The module still works fine for me as long as I have ORACLE_HOME set in httpd.conf and in my PHP scripts before I use any OCI functions.

By: Josh

Josh — Fri, 09 May 2008 02:38:00 +0000

Actually…Does setting ORACLE_HOME on the command line have any effect? I believe that building a port wipes out the environment vars so you can’t “pollute” the port build.

By: Josh

Josh — Wed, 23 Apr 2008 19:23:05 +0000

Thanks for the write-up. I have Oracle support apparently working in PHP5 according to phpinfo(), but I have yet to actually do anything with it.

By: Snaut

Snaut — Thu, 06 Mar 2008 09:46:29 +0000

Hi! With Apache 2.2.8+PHP5.2.5+oracle-client 1.2.0
i have:
[Thu Mar 06 12:34:52 2008] [notice] child pid 1587 exit signal Bus error (10)
[Thu Mar 06 12:43:07 2008] [notice] child pid 2205 exit signal Bus error (10)

On the php5.2.3+oracle-client 1.1.1 works fine… any ideas?

By: Justinas Balčiūnas

Justinas Balčiūnas — Fri, 29 Feb 2008 11:30:41 +0000

Thanks for the feedback Tom Weber!

By: Tom Weber

Tom Weber — Thu, 28 Feb 2008 16:21:14 +0000

Today I tried to upgrade my 6.2-STABLE to 7.0-RELEASE. I’ve used Oracle together with Perl and DBD::Oracle, wich worked thanks to this tutorial.

After upgrading the libs were broken. SQLPlus was working as expected, but in Perl I got several errors.

I had to rebuild Perl with all modules wich have something to do with Oracle, as well as all Oracle packages. Now it works perfectly again.

So Oracle client under FreeBSD 7.0-RELEASE is reported as success!

By: Westin Shafer

Westin Shafer — Wed, 23 Jan 2008 19:28:10 +0000

Thanks for the how-to. Oracle is up and running.

However, we are also experiencing the segfault on freebsd 6.2_RELEASE. This happens only on exit. This is also not related to other extensions, as I was able to test OCI8 first before installing the other modules.

Other problems include oci_pconnect will leave connections open indefinitely and oci_close has no effect on these connections.

The fix posted earlier seems to clear up the problem with the segfault, but I wonder how good the fix truly is. Anyone have any issues once the patch is installed, things like having to restart apache, server, ect?

As a side question,
Has anyone been able to compile the pecl oci8 client instead?