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 #179430 is a reply to message #179426]

Sun, 28 October 2012 06:06

Michael Vilain
Messages: 88
Registered: September 2010

Karma:

Member

In article <ddbd4219-15dc-4abc-aa4e-7f197e7c3d89(at)googlegroups(dot)com>,
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

Contact your Oracle DBA. I suspect the account used to write to the
database doesn't have the privs or it's setup incorrectly.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

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 Jan 30 16:57:44 GMT 2025

Total time taken to generate the page: 0.03180 seconds