Home » RDBMS Server » Security » Wallets
Wallets [message #592195] Mon, 05 August 2013 10:30 Go to next message
leeweb
Messages: 6
Registered: March 2007
Location: Cardiff, UK
Junior Member
Hi guys,

Firstly, please accept my apologies if this is in the wrong forum.

I'm trying to invoke a web service using PL/SQL. I have imported the trusted certificate, from our service partner, into the Wallet Manager. I have no certificate requests here, just trusted certificates.

I am then running the following query, just to test it:

select utl_http.request('https://www.callcreditsecure.co.uk/services/bsb/bsb7.asmx'
                        ,NULL
                        ,'file:C:\Documents and Settings\TLASupport\ORACLE\WALLETS'
                        ,'Link0292')
from dual;


This generates the following error:

select utl_http.request('https://www.callcreditsecure.co.uk/services/bsb/bsb7.asmx'
       *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-28862: SSL connection failed
ORA-06512: at line 1


Our database is installed on a Windows Server 2003 operating system, and I am running the query from this server.

Do I need to restart the database? Or is there something else wrong? Also, apologies if I haven't provided enough information. If you need more, please ask,

Many thanks,

Lee
Re: Wallets [message #592199 is a reply to message #592195] Mon, 05 August 2013 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 58849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The connection is with the database server, so the wallet must be on it.
Are you sure "file:C:\Documents and Settings\TLASupport\ORACLE\WALLETS" is something on the database server?

Regards
Michel
Re: Wallets [message #592224 is a reply to message #592199] Mon, 05 August 2013 13:04 Go to previous messageGo to next message
leeweb
Messages: 6
Registered: March 2007
Location: Cardiff, UK
Junior Member
Hi Michel, thank you for the reply. I'll try and explain a little more whilst answering your question.

Our development database is hosted on a Windows server. On this server, I created the wallet using OWM, logged in as our development administrator TLASupport. I saved the wallet to the default file location. Now this is where I made the assumption that, as a folder called "wallet" appeared at the location I specified, I assumed this was the right file location. I've then run the query mentioned earlier in a SQL plus session on the same windows server.

Could it be that the windows service for the database is running as a different user to the user that created the wallet? I really am stuck.

Thanks for your time,

Lee
Re: Wallets [message #592226 is a reply to message #592224] Mon, 05 August 2013 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I didn't use UTL_HTTP and SSL but the following links will show how they did:
UTL_HTTP and SSL (HTTPS) using Oracle Wallets
Using SSL client certificates for authentication in UTL_HTTP (it uses the previous article)
Access to HTTPS via utl_http using the orapki wallet command

Regards
Michel
Re: Wallets [message #592294 is a reply to message #592226] Tue, 06 August 2013 06:48 Go to previous messageGo to next message
leeweb
Messages: 6
Registered: March 2007
Location: Cardiff, UK
Junior Member
Hi Michel,

Thanks again for your time. I've finally worked it out. The issue was not my code, it was the firewall on the Windows server hosting the database. I added the IP address of the web service to the firewall, and hey presto, I got a response from the web service being invoked Embarassed

Once again, thanks for your time, it was very much appreciated,

Lee
Re: Wallets [message #592302 is a reply to message #592294] Tue, 06 August 2013 06:59 Go to previous message
Michel Cadot
Messages: 58849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know the origin of the problem, it might help someone in the future.

Regards
Michel
Previous Topic: VPD Policy Function Issue.
Next Topic: ORA-06512: at "DVSYS.DBMS_MACADM" line 1740
Goto Forum:
  


Current Time: Thu Aug 21 01:35:13 CDT 2014

Total time taken to generate the page: 0.13816 seconds