FUDforum: comp.lang.php » Oracle Wallet and PHP issue.

Home » Imported messages » comp.lang.php » Oracle Wallet and PHP issue.

Show: Today's Messages :: Polls :: Message Navigator

Re: Oracle Wallet and PHP issue. [message #179428 is a reply to message #179426]

Sun, 28 October 2012 00:29

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 10/27/2012 12:34 PM, shashi(dot)divekar(at)gmail(dot)com wrote:
> I have been struggling on this PHP-ORACLE Wallet issue and may be you have answer !
>
> In nutshell - perl and sqlplus works for Oracle Wallet for reading from database and well as writing into database. php works for reading from database. BUT PHP DOES NOT WORK FOR WRITING INTO DATABASE !
>
>
> My php.ini file contains -
> # cat /usr/php-5.4.5/lib/php.ini
> extention = oci8.so
> extension_dir = "/opt/php/lib/php/extensions/
> no-debug-non-zts-20100525"
> date.timezone = "America/Los_Angeles"
> output_buffering = On
> oci8.privileged_connect = On
>
>
> We have two oracle accounts log_reader and log_writer. log_reader has read access for reading data. log_writer has write access writting data into database. The application is run from Apache and uses Perl and PHP. Passwords are hardcoded into php/perl scripts. Recently we are trying to migrate to Oracle Wallet to eliminate hard coded passwords. Oracle wallet is configured and following works - sqlplus and perl for both log_reader and log_writer accounts. php for log_reader account.
>
> php does not work for log-writer account. We get following error - insert err = 1031:ORA-01031: insufficient privileges
>
> PHP code -
> $conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT);
>
> In short with Oracle Wallet there is no problem for sqlplus and Perl. But for PHP we are facing issue when we try to write/insert data into database. Read for PHP works fine.
>
> I have tried following so far but no luck -
>
> $conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT);
>
> $conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT+OCI_SYSOPER);
>
> $conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT+OCI_SYSDBA);
>
> php does not work for log-writer account. We get following error - insert err = 1031:ORA-01031: insufficient privileges
>
> Any idea how to resolve this problem ?
>
> Thanks in advance.
> -Shashi DIvekar
>

Did you ask Oracle Wallet support? They know their code better than
anyone else.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		Oracle Wallet and PHP issue. By: shashi.divekar on Sat, 27 October 2012 16:34
		Re: Oracle Wallet and PHP issue. By: Jerry Stuckle on Sun, 28 October 2012 00:29
		Re: Oracle Wallet and PHP issue. By: Michael Vilain on Sun, 28 October 2012 06:06
		Re: Oracle Wallet and PHP issue. By: Denis McMahon on Sun, 28 October 2012 23:51
		Re: Oracle Wallet and PHP issue. By: btran007 on Thu, 12 June 2014 18:30
		Re: Oracle Wallet and PHP issue. By: Christoph Michael Bec on Thu, 12 June 2014 19:02
		Re: Oracle Wallet and PHP issue. By: Thomas 'PointedEars' on Fri, 13 June 2014 17:28
		Re: Oracle Wallet and PHP issue. By: btran007 on Fri, 13 June 2014 19:17
		Re: Oracle Wallet and PHP issue. By: btran007 on Fri, 13 June 2014 19:15
		Re: Oracle Wallet and PHP issue. By: Jerry Stuckle on Fri, 13 June 2014 19:23

Previous Topic:	Re: PHP and Sqlite Encryption extension
Next Topic:	function for preserving special characters?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 14:43:41 GMT 2024

Total time taken to generate the page: 0.04502 seconds