This walkthrough will show an example of using WFR's INI File Encryption features as described in section 5.14 of the 11.1.1.8 installation guide.
The Install guide has a good walkthrough of the steps, but it's not 100% specific to the AP Solution. It does require a few decisions not included in the document.
1. You should have your own XML-formate RSA key pair. Brainware states to receive this keypair directly from Brainware support, but Oracle's doc does not include that statement. I've found that the easiest way to generate the key is to use a simple java app to format it as needed. I'll attach a link to the java app at the bottom. Note that this is using java.security, but BouncyCastle should be usable as well, if desired. You can also use the sample keypair provided in the doc, but this should not be used for production as it it not secure (the private key is published in the doc!)
2. Take your ini file and remove the password from the SQL_VL_##_ConnectionString . The way the encryption works is to decrypt the password, then it will append it back to the ConnectionString before the script actually attempts to create a db connection with it
3. Create a matching SQL_VL_##_ConnectionPassword=<my encrypted password> entry in the ini file. we'll cover how to create the encrypted password a few steps down
4. Open your sdp in Designer. Show Scripts. Go to Sheet #2.
5. Enable the CdrCrypt Reference (figure 5-3 in the install doc)
6. Take the supplied sample script and update to your Private key (be sure to remove any line feeds!), or use the supplied if POC/DEV
7. Paste the script into the fnSetDBConnection (or create your own function and call the function from this location); place it as follows:
On Error GoTo lbl_error
<ADD SCRIPT HERE>
fnSetDBConnection =1
blFoundEmptyConnection = False
8. In a command prompt, cd to <wfr_home>/bin/bin
9. Run the following command to get the encrypted string used in step #3:
DstCrypt.exe /text "MyClearTextPassword" /key "<myPUBLICkey>" >> my_enc_password.txt
10. find your encrypted string at the end of the output:
Text <cleartextpassword> encoded to XBj9I3tuiu+f/XZBH1qIENWGFdoNkmFdtvc3L8LMdBH[...]
11. Paste your enc password into the ini file as stated in #3
12. Save and verify your sdp changes
13. Test!
Troubleshooting tips:
** You can use the script to place file outputs to verify each step of the way.
** If you notice nothing is happening, comment out the "On Error GoTo lbl_error" line; this will allow the errors to output to the RTS console
** If you're getting object errors on the .decrypt function call; make sure you have patched your WFR 11g instance with the two Web Verifier patches; the name of the patch states "Web Verifier", but Patch #2 contains patches for the core products. Also, be sure to deploy both patches since they are not cumulative. Even if you're not using Web Verifier, go ahead and apply these patches.
Oracle may be providing a script sample for this in the future. I'll be sure to update to reflect the supported method. But, as of 2015/04/12, nothing has been published.
Hope that helps!
-ryan
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThank you for the tutorial! It's very useful!
ReplyDeletejson formatter
Nerds support provides high quality IT Services and cloud computing services in Miami and South Florida. Find award-winning VoIP service and its experts in Miami today!
ReplyDeleteFaridabad call girls
ReplyDeleteFaridabad call girl
Faridabad escorts
Faridabad escort
Escort services in Faridabad
Escort services in Faridabad
Call girls in Faridabad
Call girl in Faridabad
Faridabad escort services
Faridabad escort service
Escorts in Faridabad
Escorts in Faridabad
Escorts in Faridabad
Escorts in Faridabad
Escort in Faridabad
Escort in Faridabad
Escort in Faridabad
Escort in Faridabad
Escort services in Faridabad
Escort services in Faridabad
Escort services in Faridabad
Escort services in Faridabad
Escort service in Faridabad
Escort service in Faridabad
Escort service in Faridabad
Escort service in Faridabad
This is so much amazing .so,you can also visite my links.
ReplyDeletecall girls in kolkata
russian escorts in kolkata
kolkata call girls
call girls kolkata
escorts in kolkata
kolkata escort
housewife escorts in kolkata
college call girls in kolkata
call girls in park street
escorts in park street
call girls in gurgaon
call girl in gurgaon
gurgaon call girls
escorts in gurgaon
gurgaon escorts
gurgaon escort
Escort services in Gurgaon
Escort service in Gurgaon
russian escorts in gurgaon
housewife escorts in gurgaon
college call girls in gurgaon
Call girls in Noida
Call girl in Noida
Escorts in Noida
Escort services in Noida
Escort service in Noida
Noida Escorts
Noida Escort
Noida Call girls
Noida Call girl
Call Girl in Faridabad
ReplyDeleteCall Girl in Faridabad
Call Girl in Faridabad
Call Girl in Faridabad
Faridabad Call girls
Faridabad Call girls
Faridabad Call girls
Faridabad Call girls
Faridabad Call girl
Faridabad Call girl
Faridabad Call girl
Faridabad Call girl
Faridabad Escorts
Faridabad Escorts
Faridabad Escorts
Faridabad Escorts
Faridabad Escort
Faridabad Escort
Faridabad Escort
Faridabad Escort
Very nice post I really enjoyed it...You can also visit my website for
ReplyDeleteEscort Service in Jaipur
Call Girl in Jaipur
Jaipur Call Girls
Jaipur Escorts
Escort Services in Jaipur
Escorts in Jaipur
Call Girls in Jaipur
Celebrity Escorts in Jaipur
Air Hostess Escorts in Jaipur
Call Girls in Jaipur
Call Girl in Jaipur
Escorts in Jaipur
Escort in Jaipur
Jaipur Escort Service
Jaipur Escort Servives
Jaipur Escorts Service
Jaipur Escorts Servives
Jaipur Call Girls
Jaipur Call Girl
Escort Service in Jaipur
Escorts Service in Jaipur
Escort Services in Jaipur
Jaipur Escort
Jaipur Escorts
Very nice post I really enjoyed it...You can also visit my website for
ReplyDeleteCall Girls in Jaipur
Jaipur Call Girls
Escorts in Jaipur
Jaipur Escorts
Escort Service in Jaipur
Independent Escorts in Jaipur
Escort Services in Jaipur
College Call Girls in Jaipur
Call Girls in Jaipur
Call Girl in Jaipur
Escorts in Jaipur
Escort in Jaipur
Jaipur Escort Service
Jaipur Escort Servives
Jaipur Escorts Service
Jaipur Escorts Servives
Jaipur Call Girls
Jaipur Call Girl
Escort Service in Jaipur
Escorts Service in Jaipur
Escort Services in Jaipur
Jaipur Escort
Jaipur Escorts
Call girls in Gurgaon
ReplyDeleteCall girls in Lucknow
Call girls in Guwahati
Call girl in Gurgaon
Call girl in Lucknow
Call girl in Guwahati
Gurgaon call girls
Lucknow call girls
Guwahati call girls
Bangalore call girls
Gurgaon call girl
Lucknow call girl
Guwahati call girl
Bangalore call girl
Escorts in Gurgaon
Escorts in Lucknow
Escorts in Guwahati
Escorts in Bangalore
Escort services in Gurgaon
Escort services in Lucknow
Escort services in Guwahati
Escort services in Bangalore
Escort service in Gurgaon
Escort service in Lucknow
Escort service in Guwahati
Escort service in Bangalore
Gurgaon escorts
Lucknow escorts
Guwahati escorts
Bangalore escorts
Gurgaon escort
Lucknow escort
Guwahati escort
Bangalore escort
Hello guys!! I know you want to put your lips on my boobs. If you want to get masturbated by my soft hand then you can hire me easily. simple visit our websites
ReplyDeleteCall Girls in Bangalore
Call Girls in Lucknow
Call Girls in Gurgaon
Call Girls in Guwahati
Call Girls in Faridabad
==========================
Bangalore Call Girl
Escorts in Lucknow
Escorts in Gurgaon
Escorts in Guwahati
Escorts in Faridabad
==========================
Escort service in Bangalore
Escort service in Lucknow
Escort services in Gurgaon
Escort service in Guwahati
Escort service in Faridabad
============================
Escorts in Bangalore
Lucknow Call Girls
Escort service in Gurgaon
Guwahati Call Girls
Faridabad Call Girls
=============================
Lucknow Call Girl
Gurgaon Call Girls
Guwahati Call Girl
Faridabad Call Girl
Gurgaon Call Girl
=================================
Escorts in Kolkata | Escorts in Gurgaon | Escorts in Noida | Escorts in Puri | Escort services in Kolkata | Escort services in Gurgaon | Escort services in Noida | Escort services in Puri | Escorts in bhubaneswar | Escorts in cuttack | Escort services in bhubaneswar | Escort services in cuttack
ReplyDeletekolkata call girls | call girls kolkata | call girl in gurgaon | gurgaon call girls | Call girl in Noida | call girls in puri | puri call girls | call girls in bhubaneswar | bhubaneswar call girls | call girls in cuttack | cuttack call girls | Call girls in Noida | Call girl in Noida | Noida Call girls | Noida Call girl | call girls in kolkata call girls in puri | puri call girls | puri call girl | call girls in bhubaneswar | bhubaneswar call girls | bhubaneswar call girl | call girls in cuttack | cuttack call girls | cuttack call girl
ReplyDeleteIf you are in Jaipur and need beautiful Jaipur Call Girl or white skin Jaipur Call Girls then you can simply book call girls in Jaipur from one of the best escort agency named Jaipur Call Girls. It is No.1 premier escort agency and provide both incall or outcall facility to clients.Please click on the following link to check the official websites Jaipur Call Girl
ReplyDeleteEscorts in Faridabad
ReplyDeleteEscort services in Faridabad
Escort services in Faridabad
Escorts in Faridabad
Call Girls in Faridabad
insect control company door.
ReplyDeleteInsects, which are a major source of inconvenience to individuals and they also pose a great danger to them where they are found and spread in various places and institutions and often difficult to control and it becomes Egypt anxiety and large pollution شركة مكافحة حشرات
شركة مكافحه النمل الابيض بالمجمعة
شركة مكافحه حشرات بالمجمعة
thanks for sharing such a wonderful information from this post
ReplyDeletedigital marketing
I love programming, but sometimes it is very tiring. After work, I relax playing online games. I can always choose an interesting game on Nightrush and enjoy.
ReplyDeleteI admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much.
ReplyDeletemobile phone repair in Louisville
mobile phone repair in Beachwood
mobile phone repair in Bensalem
mobile phone repair in Dubuque
mobile phone repair in Winston-Salem
Thank you very much for publishing this kind of article. I like your article very much.
ReplyDeleteI want to share my website details with you please give me some information to increase
performance like as your website.
gta liberty city apk
ReplyDeleteputlocker
ReplyDeleteAmazing Article
ReplyDeleteinternship in chennai
internship in chennai for cse
internship for mba in chennai
internship in chennai for hr
internship in chennai for mba
companies for internship in chennai
internship in chennai for ece
paid internship in chennai
internship in chennai for biotechnology
internship in chennai for b.com students
Why is it so important to buy instagram followers cheap? Well, it's because Instagram doesn't really care about the law. The rules on selling products on the internet don't apply, because no one is actually breaking them. Therefore, you should do everything you can to avoid getting arrested.
ReplyDeleteChoose One of the best viral buy tiktok followers uk programs. Whether you are someone who wants to get their name out there, your talent to be admired, and your social profile to be viewed, you've come to the right place!
ReplyDeleteThe last thing you should remember is to take time to network, practice online marketing and try different strategies. This will make sure that you always have something that will work for your business. and keep on buy instagram followers australia
ReplyDeleteEncrypting the SQL connection string passwords in WebCenter Forms Recognition is not an easy job for novice man, thanks for creating such nice tutorial. Students may need programming help to solve this without this tutorial.
ReplyDeleteThanks for sharing such a nice piece of information to us. This is very knowledgeable for me. I am an assignment expert and I am offering Assignment Help to students of Australia and all over the world. Edit my paper
ReplyDeleteI would like to be your pen friend...You can write me email on guwahaticallgirl@gmail.com for
ReplyDeleteGuwahati Escort
Guwahati Escort
Guwahati Escort
Guwahati Escort
I was very happy to find this site. I really enjoyed reading this article today and think it might be one of the best articles I have read so far. I wanted to thank you for this excellent reading !! I really enjoy every part and have bookmarked you to see the new things you post. Well done for this excellent article. Please keep this work of the same quality.
ReplyDeleteData Science Course in Bangalore
Very informative blog, and beautifully elaborating the complete information about the topic. We are from the same domain emerging as the top mobile app development company for versatile app creation services. You can email us at sales@appsquadz.com or Phone Number: +91-9717270746
ReplyDelete