Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #13814 > unrolled thread

Re: Oracle Wallet and PHP issue.

Back to article view | Back to comp.lang.php

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Oracle Wallet and PHP issue. btran007@gmail.com - 2014-06-12 11:30 -0700
    Re: Oracle Wallet and PHP issue. Christoph Michael Becker <cmbecker69@arcor.de> - 2014-06-12 21:02 +0200
      Re: Oracle Wallet and PHP issue. Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-13 19:28 +0200
        Re: Oracle Wallet and PHP issue. btran007@gmail.com - 2014-06-13 12:17 -0700
      Re: Oracle Wallet and PHP issue. btran007@gmail.com - 2014-06-13 12:15 -0700
        Re: Oracle Wallet and PHP issue. Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 15:23 -0400

#13814 — Re: Oracle Wallet and PHP issue.

On Saturday, October 27, 2012 12:34:40 PM UTC-4, Shashikant Divekar 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

Hello Shashi,

I am struggling to get perl to connect using Oracle wallet.  You say perl and sqlplus works for Oracle Wallet for reading from database and well as writing into database.  Would you mind sharing how you did that.  I have Oracle Wallet setup and I can connect running sqlplus from the command line.  However, I keep getting ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin). Here is my script:

use DBI;

my $db=DBI->connect("dbi:Oracle:tnsname");

It's very simple but it's not working.  Can you please help?

Thanks

[toc] | [next] | [standalone]

#13815

btran007@gmail.com wrote:

> I am struggling to get perl to connect using Oracle wallet.  You say
> perl and sqlplus works for Oracle Wallet for reading from database
> and well as writing into database.  Would you mind sharing how you
> did that.  I have Oracle Wallet setup and I can connect running
> sqlplus from the command line.  However, I keep getting ORA-01017:
> invalid username/password; logon denied (DBD ERROR: OCISessionBegin).

You are better off to ask Perl related questions in a Perl related
newsgroup or forum.  This is comp.lang.php, which obviously deals with
PHP related topics.

HTH

-- 
Christoph M. Becker

[toc] | [prev] | [next] | [standalone]

#13827

Christoph Michael Becker wrote:

> btran007@gmail.com wrote:
>> I am struggling to get perl to connect using Oracle wallet.  You say
>> perl and sqlplus works for Oracle Wallet for reading from database
>> and well as writing into database.  Would you mind sharing how you
>> did that.  I have Oracle Wallet setup and I can connect running
>> sqlplus from the command line.  However, I keep getting ORA-01017:
>> invalid username/password; logon denied (DBD ERROR: OCISessionBegin).
> 
> You are better off to ask Perl related questions in a Perl related
> newsgroup or forum.  This is comp.lang.php, which obviously deals with
> PHP related topics.

ACK.  But the line

>> On Saturday, October 27, 2012 12:34:40 PM UTC-4, Shashikant Divekar 
>> wrote:

in the previous poster’s *reply* speaks for itself, don’t you think? ;-)

<http://twovoyagers.com/improve-usenet.org/>


PointedEars
-- 
Use any version of Microsoft Frontpage to create your site.
(This won't prevent people from viewing your source, but no one
will want to steal it.)
  -- from <http://www.vortex-webdesign.com/help/hidesource.htm> (404-comp.)

[toc] | [prev] | [next] | [standalone]

#13832

On Friday, June 13, 2014 1:28:04 PM UTC-4, Thomas 'PointedEars' Lahn wrote:
> Christoph Michael Becker wrote:
> 
> 
> 
> > btran007@gmail.com wrote:
> 
> >> I am struggling to get perl to connect using Oracle wallet.  You say
> 
> >> perl and sqlplus works for Oracle Wallet for reading from database
> 
> >> and well as writing into database.  Would you mind sharing how you
> 
> >> did that.  I have Oracle Wallet setup and I can connect running
> 
> >> sqlplus from the command line.  However, I keep getting ORA-01017:
> 
> >> invalid username/password; logon denied (DBD ERROR: OCISessionBegin).
> 
> > 
> 
> > You are better off to ask Perl related questions in a Perl related
> 
> > newsgroup or forum.  This is comp.lang.php, which obviously deals with
> 
> > PHP related topics.
> 
> 
> 
> ACK.  But the line
> 
> 
> 
> >> On Saturday, October 27, 2012 12:34:40 PM UTC-4, Shashikant Divekar 
> 
> >> wrote:
> 
> 
> 
> in the previous poster's *reply* speaks for itself, don't you think? ;-)
> 
> 
> 
> <http://twovoyagers.com/improve-usenet.org/>
> 
> 
> 
> 
> 
> PointedEars
> 
> -- 
> 
> Use any version of Microsoft Frontpage to create your site.
> 
> (This won't prevent people from viewing your source, but no one
> 
> will want to steal it.)
> 
>   -- from <http://www.vortex-webdesign.com/help/hidesource.htm> (404-comp.)

I am sorry I don't follow.  There's nothing useful.  May be I missed something.

Thanks

[toc] | [prev] | [next] | [standalone]

#13831

On Thursday, June 12, 2014 3:02:33 PM UTC-4, Christoph Michael Becker wrote:
> btran007@gmail.com wrote:
> 
> 
> 
> > I am struggling to get perl to connect using Oracle wallet.  You say
> 
> > perl and sqlplus works for Oracle Wallet for reading from database
> 
> > and well as writing into database.  Would you mind sharing how you
> 
> > did that.  I have Oracle Wallet setup and I can connect running
> 
> > sqlplus from the command line.  However, I keep getting ORA-01017:
> 
> > invalid username/password; logon denied (DBD ERROR: OCISessionBegin).
> 
> 
> 
> You are better off to ask Perl related questions in a Perl related
> 
> newsgroup or forum.  This is comp.lang.php, which obviously deals with
> 
> PHP related topics.
> 
> 
> 
> HTH
> 
> 
> 
> -- 
> 
> Christoph M. Becker

I took your suggestion and tried to post on perl forum/group 3 times but they appear.  Do I not have privs?

Thanks

[toc] | [prev] | [next] | [standalone]

#13833

On 6/13/2014 3:15 PM, btran007@gmail.com wrote:
> On Thursday, June 12, 2014 3:02:33 PM UTC-4, Christoph Michael Becker wrote:
>> btran007@gmail.com wrote:
>>
>>
>>
>>> I am struggling to get perl to connect using Oracle wallet.  You say
>>
>>> perl and sqlplus works for Oracle Wallet for reading from database
>>
>>> and well as writing into database.  Would you mind sharing how you
>>
>>> did that.  I have Oracle Wallet setup and I can connect running
>>
>>> sqlplus from the command line.  However, I keep getting ORA-01017:
>>
>>> invalid username/password; logon denied (DBD ERROR: OCISessionBegin).
>>
>>
>>
>> You are better off to ask Perl related questions in a Perl related
>>
>> newsgroup or forum.  This is comp.lang.php, which obviously deals with
>>
>> PHP related topics.
>>
>>
>>
>> HTH
>>
>>
>>
>> -- 
>>
>> Christoph M. Becker
> 
> I took your suggestion and tried to post on perl forum/group 3 times but they appear.  Do I not have privs?
> 
> Thanks
> 

The people in a PHP newsgroup would have no idea what you need to post
to a perl forum/group.  Why not ask someone in that group?

Or, if it is a forum, ask the forum admin?

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex@attglobal.net
==================

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.php

csiph-web