I guess it's really hard to make PHP work with Oracle huh?

Serialmouse

Why is that so?

No one seems to be able to help me on my posts about it.

Moonglobe

Huh?😕

rpanning

I'm not sure that too many people use Oracle with PHP. It's mostly mySQL and PHP.

LordShryku

I use Oracle with PHP :p
But I also use MySQL and PostgreSQL

Serialmouse

Maybe you can help me.....

Details on my problem are on DATABASE discussions...

Serialmouse

Update: Some Dirty Hack solution, to help some other guys like me out there
We (our technical team, Sys Ads, and Sys Devs) were able to make PHP connect to oracle dbase server by:

1) copying all profiles of .bashrc for user ORACLE and placed them in user ROOT too.
2) some recoding also was done, I realized some errors on my code too, but connection was the main problem, and dirty hack done in number 1.
3) I also changed our TNSNAMES.ORA to only have in CONNECT_DATA value: SERVICE_NAME: DEVT

4) APACHE process is now running under user ORACLE, not a secure option, but was a dirty hack anyway that worked

Side Effects: NOBODY is no longer running APACHE, Apache sometimes experiences SEGMAENTATION FAULT now.

Any other Ideas Fellas???

LordShryku

If Apache's getting Seg Faults now, this isn't really a viable solution, I would think. You could just put the enviroment variables in /etc/profile, and that would make them global. Then nobody would pick them up also. Also, make sure your oracle install directory has been chmodded(755), so that it can be used by someone outside of the oracle user/group. Or just add user nobody to the oracle group.

Serialmouse

Hello Pips,

This is to help others like me out there.

We already tried making user NOBODY a member of OINSTALL group and DBA group, groups defined by user ORACLE, this didn't totally work, I experienced TNS: No Listener all the time. (which was a step closer because before was no TNS resolved, I also declared PUTENV() in script to emulate ORACLE environment variables at that moment)

And the Segmentation Fault is gone, we just upgraded to PHP 4.3.4, because a bug report on PHP 4.3.2 was found, it's got something to do with OCILOGON that causes it to SEGMENTATION FAULT, so people out there, this is SERIALMOUSE posting this solution for others to use and build upon on, because I really couldn't find solutions posted out there in dozens of sites I have found, including ORACLE sites. So here it is, no one else must go through what our tech team did.

I would like to thank our team for relentlessly finding solutions regarding Oracle PHP connections just to finish within a day before the deadline for presentation. The Sys Ads: Ewoks, Degz The Sys Devs SerialMouse, JohnnyDu (he found the Seg Fault reason, through almighty GOOGLE), and Godie, and the one that perfectly implemented our idea (Godie and me thought of the environment variables for Oracle user was needed, but user NOBODY was executing Apache, so we thought of making user ORACLE execute APACHE, even used PUTENV() to emulate to NOBODY the env vars of ORACLE but that was not enough cause not all environment variables were copied hehehehehe, even made NOBODY a member of ORACLE's groups at first) our IT Consultant who copied all Oracle .bashrc variables to user ROOT based on the previous theories we had.

We will still clean up this solution, along the way. I may post the updates on that some time later.

Peace Out!!

Serialmouse
Systems Developer
for
Wireless Applications Systems in the Philippines