This discussion is archived
14 Replies Latest reply: Nov 22, 2012 12:20 PM by gCubed RSS

Email-statusing -service error

User190110 - Oracle Newbie
Currently Being Moderated
Hi All,

After configuring Email-statusing-service properties in config.properties file and running run.sh file throws the below error .Please sahre your ideas on this


... 12 more
2012-11-20 18:15:00,013 [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-5] ERROR com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl - Error while trying to archive messages: Error while trying to load messages: Connection refused
com.oracle.pgbu.teammember.messaging.dao.MessageDaoException: Error while trying to load messages: Connection refused
at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages(ImapMessageDao.java:89)
at com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl.processUpdatedTasks(TaskMessageServiceImpl.java:40)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused by: javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:665)
at javax.mail.Service.connect(Service.java:295)
at javax.mail.Service.connect(Service.java:176)
at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages(ImapMessageDao.java:58)
... 9 more

Regards,
naga
  • 1. Re: Email-statusing -service error
    Sachin Gupta Pro
    Currently Being Moderated
    Check the settings in config.properties. it may not be correct. From the server where this is setup can you telnet to SMTP and IMAP ports?
  • 2. Re: Email-statusing -service error
    User190110 - Oracle Newbie
    Currently Being Moderated
    Hi,

    After starting the IMAP service ,when i ran run.sh ,now i see error Authentication Failed .

    ERROR com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao - Error while trying to load messages: AUTHENTICATE failed.
    javax.mail.AuthenticationFailedException: AUTHENTICATE failed.
    at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:660)
    at javax.mail.Service.connect(Service.java:295)
    at javax.mail.Service.connect(Service.java:176)
    at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages(ImapMessageDao.java:58)
    at com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl.processUpdatedTasks(TaskMessageServiceImpl.java:40)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546).

    As per the MOS ID 1504660.1 ,

    Below are steps needto be performesd

    Update the Email Statusing Service config.properties file to:
    - Use a valid UPN for the imap.username field,
    - Confirm the correct password for the imap.password field.

    To complete these steps:
    1. Browse to the Email Statusing Service home directory
    2. Open the config.properties file
    3. Update the 'imap.username' field with the userPrincipleName (UPN) of the configured user (and not the email address of the user).
    4. Update the 'imap.password' field with the valid password for the user, if required.
    5. Restart the Email Statusing Servic

    **But my question here is What is UPN,where can see this .**

    Regards,
    Naga
  • 3. Re: Email-statusing -service error
    958146 Newbie
    Currently Being Moderated
    Hi,

    Check your IMAP SSL is enabled or not. IMAP default port is 143.
  • 4. Re: Email-statusing -service error
    User190110 - Oracle Newbie
    Currently Being Moderated
    Is IMAP SSL is mandatory ,as SSL parameter is set to false in config.properties
  • 5. Re: Email-statusing -service error
    Sachin Gupta Pro
    Currently Being Moderated
    yes, set it to yes and try again.
  • 6. Re: Email-statusing -service error
    User190110 - Oracle Newbie
    Currently Being Moderated
    #DO NOT CHANGE THIS LINE
    config.version = 0.3
    # ================================================================

    # ================================================================
    #
    # P6 Team Member E-Mail Statusing
    #
    # This file controls the settings used by the P6 E-Mail Statusing
    # service. Administrators should set up the e-mail account that
    # is to be used by the service as well as which messages to look
    # for to update assigned tasks.
    # ================================================================
    # ------------------------
    # P6 Configuration
    # ------------------------
    # Specify a P6 user that is assigned to at least one module access and has resource access.
    p6.admin.user = admin

    # Folder containing the P6 Bootstrap file.
    p6.bootstrap = ************************

    # Frequency for checking mail folder for new messages to process. This value
    # must be cron style formatted string
    mail.read.schedule=0 0/1 * * * ?

    # -----------------------------
    # Outgoing mail (SMTP Settings)
    # -----------------------------
    # The SMTP server that will be used to send the e-mails. Hostname or ip address.
    send.host = 127.0.0.1

    # The port number to use when connecting to the SMTP server.
    send.port = 25

    # Specifies whether the connection should use SSL. Valid values are true, false
    send.ssl = false

    # The e-mail address that will be used to send the e-mail.
    send.email = your.email@example.com

    # Password for the above username. If you do not specify the password in this file,
    # you will be prompted to enter it when the application is started. You also have
    # the option of specifying the password on the command line in the following
    # manner: -Dsend.password=thePassword
    # send.password = thePassword

    # -----------------------------
    # Incoming Mail (IMAP Settings)
    # -----------------------------
    # Settings for reading e-mails with the IMAP protocol
    # Settings for reading e-mails with the IMAP protocol

    imap.host = 127.0.0.1

    # IMAP port number
    imap.port = 143

    # Use SSL. Valid values are true and false
    imap.ssl = true

    # IMAP username
    imap.username = testuser ( user created in primavera application)

    # Password for the above username. If you do not specify the password in this file,
    # you will be prompted to enter it when the application is started. You also have
    # the option of specifying the password on the command line in the following
    # manner: -Dimap.password=thePassword
    # imap.password = Test123

    # IMAP search folder. This is the folder that will be searched for
    # incoming e-mails to process for updates.
    imap.search.folder = inbox

    # --------------------------
    # IMAP Folder configuration
    # --------------------------

    # The folder where messages that have been processed successfully will be
    # placed. It will be created if it does not exist.
    imap.success.folder = P6Success

    # The folder where messages which have resulted in an error during processing
    # will be placed. It will be created if it does not exist.
    imap.failure.folder = P6Fail

    # The folder where messages which are currently being processed will be placed.
    # It will be created if it does not exist
    imap.temp.folder = P6Temp

    # -----------------------
    # Message Format options
    # -----------------------

    # The text that will be searched for in the subject line of incoming messages.
    # Messages matching this term will be for updates and applied to P6
    update.task.search.term = Your requested P6 tasks


    Can you please confirm the above setting s as.when SSL = true i am receivng the below error .

    Error while trying to load messages: Unrecogni zed SSL message, plaintext connection?
    javax.mail.MessagingException: Unrecognized SSL message, plaintext connection?;
    nested exception is:
    javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connecti on?
    at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:665)
    at javax.mail.Service.connect(Service.java:295)
    at javax.mail.Service.connect(Service.java:176)
    at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages( ImapMessageDao.java:58)
    at com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl.processUp datedTasks(TaskMessageServiceImpl.java:40)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryB ean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:26 0)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJob Bean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j ava:546)
    Caused by: javax.net.ssl.SSLException: Unrecognized SSL message, plaintext conne ction?
    at sun.security.ssl.InputRecord.handleUnknownRecord(InputRecord.java:541 )
    at sun.security.ssl.InputRecord.read(InputRecord.java:374)
    at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927)
    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl. java:1328)
    at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1355 )
    at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1339 )
    at com.sun.mail.util.SocketFetcher.configureSSLSocket(SocketFetcher.java :507)
  • 7. Re: Email-statusing -service error
    Sachin Gupta Pro
    Currently Being Moderated
    Is this the file you are using? You need to do more settings like put the host name and username etc to make this work.
  • 8. Re: Email-statusing -service error
    User190110 - Oracle Newbie
    Currently Being Moderated
    1) ya i am using this...in the place of hostname i am using 127.0.0.1,confirmed by IT team,but i am not exactly sure ,which user/password i should provide ?

    2) Now after enabling SSL to true i see different error ,error below .

    ERROR --> Error while trying to archive messages: Error while trying to load messages: Unrecognized SSL message, plaintext connection?
    com.oracle.pgbu.teammember.messaging.dao.MessageDaoException: Error while trying to load messages: Unrecognized SSL message, plaintext connection?
    at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages( ImapMessageDao.java:89)
    at com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl.processUp datedTasks(TaskMessageServiceImpl.java:40)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryB ean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:26 0)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJob
  • 9. Re: Email-statusing -service error
    Sachin Gupta Pro
    Currently Being Moderated
    These settings does not seems to be correct to me. for example send.host should be something like "smtp.google.com". same is true for all other values like port or email id being used. using dummy values will not help.
  • 10. Re: Email-statusing -service error
    User190110 - Oracle Newbie
    Currently Being Moderated
    Thanks for the reply . Can you confirm what will the user-name i should provide for the below parameter's .

    p6.admin.user = admin
    imap.username = ?

    I am sure,IMAP is listening on 143 port and SMTP is listening on 25 port .
    Regards,
    Naga.
  • 11. Re: Email-statusing -service error
    958146 Newbie
    Currently Being Moderated
    hi, follow this,

    P6 Configuration
    p6.admin.user = admin

    Outgoing mail (SMTP Settings)
    send.host = test.local ( if you have own exchange server, enter the server name here) / smtp.xxx.com
    send.port = 25
    send.email = your.email@test.local / xxx.com
    send.password = enter here the password

    Incoming Mail (IMAP Settings)
    imap.host = test /xxx.com
    imap.port = 143 / if your exchange enabled SSL service, change to YES instead FALSE
    imap.username = example@test.local / @xxx.com
    imap.password = enter here the password

    try with above configuration and let me know the status.

    Ajishlal
  • 12. Re: Email-statusing -service error
    User190110 - Oracle Newbie
    Currently Being Moderated
    Hi,

    My send.host and IMAP.host both are same . i have not provided any value to send.password , as our smtp host does not ask for any password .

    Now for incoming mail

    imap.username = team memeber user or which user i need to provide (example@test.local / @xxx.com)
    imap.password = which password i need to provide here .

    I have tried what u mentioned below ,giving the parameters for imap.username = testuser(which i have created in P6 application _
    imap.password = password for test user ,but it showed me below error.

    2012-11-22 07:31:09,349 INFO --> Start initializing the P6 subsystem....
    2012-11-22 07:31:13,431 INFO --> Done initializing the P6 subsystem.
    2012-11-22 07:31:13,432 INFO --> System startup complete.
    2012-11-22 07:32:00,017 INFO --> Start - Processing updated tasks....
    2012-11-22 07:32:00,017 INFO --> Start - Retrieving all new messages.
    2012-11-22 07:32:02,867 ERROR --> Error while trying to load messages: Authentic ation failed.
    javax.mail.AuthenticationFailedException: Authentication failed.
    at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:660)
    at javax.mail.Service.connect(Service.java:295)
    at javax.mail.Service.connect(Service.java:176)
    at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages( ImapMessageDao.java:58)
    at com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl.processUp datedTasks(TaskMessageServiceImpl.java:40)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryB ean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:26 0)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJob Bean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j ava:546)
    2012-11-22 07:32:02,871 ERROR --> Error while trying to archive messages: Error while trying to load messages: Authentication failed.
    com.oracle.pgbu.teammember.messaging.dao.MessageDaoException: Error while trying to load messages: Authentication failed.
    at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages( ImapMessageDao.java:89)
    at com.oracle.pgbu.teammember.messaging.TaskMessageServiceImpl.processUp datedTasks(TaskMessageServiceImpl.java:40)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
    at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryB ean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:26 0)
    at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJob Bean.java:86)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j ava:546)
    Caused by: javax.mail.AuthenticationFailedException: Authentication failed.
    at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:660)
    at javax.mail.Service.connect(Service.java:295)
    at javax.mail.Service.connect(Service.java:176)
    at com.oracle.pgbu.teammember.messaging.dao.ImapMessageDao.loadMessages( ImapMessageDao.java:58)
    ... 10 more
    2012-11-22 07:32:02,874 INFO --> Done - Archive messages.
    2012-11-22 07:32:02,874 INFO --> Done - Processing updated tasks.

    Regards,
    Naga.
  • 13. Re: Email-statusing -service error
    958146 Newbie
    Currently Being Moderated
    Dear you should provide there one valid email id and password from your mail server.
    eg: eppm@yourserver.local/com
  • 14. Re: Email-statusing -service error
    gCubed Journeyer
    Currently Being Moderated
    User principal name (UPN) format is used to specify an Internet-style name, such as UserName@Example.Microsoft.com.

    http://msdn.microsoft.com/en-us/library/windows/desktop/aa380525(v=vs.85).aspx


    Also the typical ports for STMP and IMAP are:

    Non SSL
    SMTP: 25
    IMAP: 143

    SSL
    SMTP:465
    IMAP:993

    To see if which are listening: try netstat --listen on the 127.0.0.1 server (assuming you are an a linux os)

    Gene

    Edited by: gCubed on Nov 22, 2012 12:18 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points