14 Replies Latest reply: Nov 22, 2012 2:20 PM by gCubed RSS

    Email-statusing -service error

    User190110 -Oracle
      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
          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
            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
              Hi,

              Check your IMAP SSL is enabled or not. IMAP default port is 143.
              • 4. Re: Email-statusing -service error
                User190110 -Oracle
                Is IMAP SSL is mandatory ,as SSL parameter is set to false in config.properties
                • 5. Re: Email-statusing -service error
                  Sachin Gupta
                  yes, set it to yes and try again.
                  • 6. Re: Email-statusing -service error
                    User190110 -Oracle
                    #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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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