Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

EBS General Discussion


unable to configure IMAP server (ssl ) to workflow notification mailer.


Hi we are trying to configure imap server (ssl enabled 993port) to workflow notification mailer.but facing issues from front end. it works from concurrent manager node.  tried the following 1. on concurrent manager node ,copied the cert to $OA_JRE_TOP/jre/lib/security/ 2. keytool -genkey -keyalg "RSA" -keystore javamailer -keypass <pwd> -storepass <pwd> -validity 1200 3. keytool -import -alias imapcert -file server.crt -v -keystore javamailer  4. ran $FND_TOP/sql/afsvcpup.sql and updated the MAILER_SSL_TRUSTSTORE to $OA_JRE_TOP/jre/lib/security/javamailer 5. tried from CM node ,it worked connected to imap $AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap \ -Ddbcfile=$FND_SECURE/<dbcfile.dbc> \ -Dport=993 -Dssl=Y \ -Dtruststore=<location and name of your local trust store> \ -Dserver=<imap server> \ -Daccount=<imap account> \ -Dpassword=<imap account password> \ -Dconnect_timeout=120 -Ddebug=Y \ -Dlogfile=/tmp/testing.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer  6. tried configuring from frontend, it fails with validation error.  followed  IMAPSSL Workflow Mailer Setup Using Self Signed Certificate [ID 409026.1] Steps for Configuring Workflow Java Mailer and IMAP (Dovecot) with SSL on Linux [ID 1265949.1]  did i missed any steps or did wrong .unable to find the issue, can anyone help me ?  Regards, Narayana

Hi;  Is there any firewall issue  Regard Helios

iiam able to ping my client machine and also connect , if there is any firewall issue will it work ?

Hi;  Could be,is there any error message?  Regard Helios

only validation error,please check host,name,passwd

Please post the details of the application release, database version and OS.  only validation error,please check host,name,passwd  Please post the complete and exact errror message.  Please review these docs.  Workflow Mailer Configuration SSL Implementation [Video] [ID 1324799.1] Unable To Perform The Workflow Mailer Configuration As It Keeps Giving "Validation Error Occured" [ID 603954.1] Workflow Mailer IMAP SSL Setup Shows Invalid Username/Password Error In Split Environment [ID 1276166.1] Java Notification Mailer configuration fails on EMail Servers configuration page [ID 1239213.1] Diagnostic Test Catalog for 12.1.3 [ID 1083807.1] -- Workflow After Enabling SSL/TLS, Workflow Mailer does not Start due to "Unable to connect" error [ID 1456124.1] Steps for Configuring Workflow Java Mailer and IMAP (Dovecot) with SSL on Linux [ID 1265949.1] How to Set Mailer Parameter MAILER_SSL_TRUSTSTORE ? [ID 444946.1]  Thanks, Hussein

i followed those notes,same issue.

Hi,  Please see  Validation Error Occurred in Workflow Mailer Configuration [ID 869985.1]  If the above does not fix the issue, please post the "complete error message" you are getting.  If you just say validation error, we would not have any clue what it is validating until you post the complete error message.  Thanks

user3312007 wrote: i followed those notes,same issue.  What exactly did you follow in those docs?  If you have some difficulties in posting the complete error message, please rename the Workflow log file, reproduce the issue and upload the log file to any free hosting website and post the link here.  Thanks, Hussein

Hi, i copied  the cert to CM node, keytool -genkey -alias -keystore -storetype JKS keytool -import -alias my_cert -file ca1.cer -keystore .keystore -storepass erptg2 keytool -import -alias my_cert1 -file ca2.cer -keystore .keystore -storepass erptg2 bash-3.00$ keytool -list -keystore .keystore Enter keystore password: Keystore type: JKS Keystore provider: SUN Your keystore contains 2 entries my_cert, Nov 10, 2012, trustedCertEntry, Certificate fingerprint (MD5): 7B:F0:A7:C3:CB:45:36:4D:BF:D8:5E:96:35:B5:B0:FD my_cert1, Nov 10, 2012, trustedCertEntry, Certificate fingerprint (MD5): F6:18:36:BB:AB:4B:EE:77:E3:23:AE:0D:B5:9E:14:0E  from OAM, edit notification mailer, set inbound thread count to o , added imap server details, hostname,username,passwd, checked inbound ssl enabled and added smtp server details and finished.  ran @$FND_TOP/sql/afsvcpup.sql  and changed the inbound theread count to 1, SSL trust store to /export/home/aperptg2/nar  now, started mailer, status shows running now. but when i sent an test mail to user and click on click here to respond ,it is asking for my apps login instead of generating NID in email. any setup required ?  i am doing this on test env and override email address has been set to mine.  no errors in log file.

now, started mailer, status shows running now. but when i sent an test mail to user and click on click here to respond ,it is asking for my apps login instead of generating NID in email. any setup required ?  i am doing this on test env and override email address has been set to mine.  no errors in log file.  Enable debug as per (How To Enable Debug On The Workflow Functionality [ID 1324952.1]) and check the log file then.  Thanks, Hussein

hi Hussein,  i just enabled debug and tried again,dont know how but it started working  and i acknowledge test notifications in mail itself. checked the IMAP account PROCESS folder, it has mails which got processed   thank you, i will try to reproduce same on another test environment and update this thread.  Regards, Narayana

Hi,  i followed the following steps and able to configure now.  i copied the cert to CM node, keytool -genkey -alias -keystore -storetype JKS keytool -import -alias my_cert -file ca1.cer -keystore .keystore -storepass erptg2 keytool -import -alias my_cert1 -file ca2.cer -keystore .keystore -storepass erptg2 bash-3.00$ keytool -list -keystore .keystore Enter keystore password: Keystore type: JKS Keystore provider: SUN Your keystore contains 2 entries my_cert, Nov 10, 2012, trustedCertEntry, Certificate fingerprint (MD5): 7B:F0:A7:C3:CB:45:36:4D:BF:D8:5E:96:35:B5:B0:FD my_cert1, Nov 10, 2012, trustedCertEntry, Certificate fingerprint (MD5): F6:18:36:BB:AB:4B:EE:77:E3:23:AE:0D:B5:9E:14:0E  from OAM, edit notification mailer, set inbound thread count to o , added imap server details, hostname,username,passwd, checked inbound ssl enabled and added smtp server details and finished.  ran @$FND_TOP/sql/afsvcpup.sql and changed the inbound theread count to 1, SSL trust store to <keystore location>. Direct response parameter to Y.  and bounced concurrent manager node services. its working now.  thanks for your help in resolving this.  Regards, Narayana

Thanks for the update!  Regards, Hussein


Related Links

responsibility assignment
TNS-01190 the user is not authorized to execute listener command
Error while creating customer account sites
backend query to configure do not send mail
Correct Discoverer version for EBS 11.5.10
Upgrade of 12.1.3
How can we make/use our own Attribute in AME
What Globall rollout in Oracle application in r12
Oracle Apps Services
R12.1.3 - Unable to perform Traces
Passing the current RESP in a concurrent program
R12 form error : frm-92101 - HELP thanks
Does R12 cloning requires IBM AIX 5L cc utility?
How to map Hire Purchase Scenario in R12
R12 DB Upgrade to 11.2.0.1 - is the examples cd needed?
Migration of E Biz Suite 11i from HP PRISC to HP Itanium