You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 梁刚 <li...@qutoutiao.net> on 2019/01/30 06:45:10 UTC

Job notification-mail-port setting doesn't work. please help check. thanks!

Hi,

I encountered below error when using job notification mail function.

2019-01-29 16:10:48,810 ERROR [Scheduler 132755908 Job 87fcb944-0c64-4d30-8196-05747b4ace4b-3906] util.MailService:121 : Sending the email to the following server failed : mail. *******.net:25
org.apache.commons.mail.EmailException: Sending the email to the following server failed : mail.*******.net:25
         at org.apache.commons.mail.Email.sendMimeMessage(Email.java:1469)
         at org.apache.commons.mail.Email.send(Email.java:1496)
         at org.apache.kylin.common.util.MailService.sendMail(MailService.java:117)
         at org.apache.kylin.common.util.MailService.sendMail(MailService.java:72)
         at org.apache.kylin.job.execution.AbstractExecutable.doSendMail(AbstractExecutable.java:348)
         at org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:321)
         at org.apache.kylin.job.execution.DefaultChainedExecutable.onStatusChange(DefaultChainedExecutable.java:154)
         at org.apache.kylin.engine.mr.CubingJob.onStatusChange(CubingJob.java:269)
         at org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:100)
         at org.apache.kylin.engine.mr.CubingJob.onExecuteFinished(CubingJob.java:265)
         at org.apache.kylin.job.execution.AbstractExecutable.onExecuteFinishedWithRetry(AbstractExecutable.java:99)
         at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:182)
         at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
         at java.lang.Thread.run(Thread.java:748)
Caused by: com.sun.mail.util.MailConnectException: Couldn't connect to host, port: mail.*******.net, 25; timeout 60000;
  nested exception is:
         java.net.SocketTimeoutException: connect timed out
         at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2118)
         at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:712)
         at javax.mail.Service.connect(Service.java:388)
         at javax.mail.Service.connect(Service.java:246)
         at javax.mail.Service.connect(Service.java:195)
         at javax.mail.Transport.send0(Transport.java:254)
         at javax.mail.Transport.send(Transport.java:124)
         at org.apache.commons.mail.Email.sendMimeMessage(Email.java:1459)
         ... 15 more
Caused by: java.net.SocketTimeoutException: connect timed out
         at java.net.PlainSocketImpl.socketConnect(Native Method)
         at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
         at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
         at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
         at java.net.Socket.connect(Socket.java:589)
         at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:329)
         at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:238)
         at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2084)


The notification mail setting is like below snapshot. I set the port as 587, but the error log shows it still use port 25. I used the version 2.5.2, and confirmed the command of “telnet mail_host 587” was work.
Please help check whether it doesn’t work for new port setting. Thanks!
[cid:image001.png@01D4B8A7.2BFDCE90]

答复: Job notification-mail-port setting doesn't work. please help check. thanks!

Posted by 梁刚 <li...@qutoutiao.net>.
Thanks Na. it works.

Most of time, we
发件人: Na Zhai [mailto:na.zhai@kyligence.io]
发送时间: 2019年1月31日 12:22
收件人: user@kylin.apache.org
主题: 答复: Job notification-mail-port setting doesn't work. please help check. thanks!

Hi, lianggang.
You can set kylin.job.notification-mail-enable-starttls to false, then the port will be change.

发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用

________________________________
发件人: 梁刚 <li...@qutoutiao.net>>
发送时间: Wednesday, January 30, 2019 2:45:10 PM
收件人: user@kylin.apache.org<ma...@kylin.apache.org>
主题: Job notification-mail-port setting doesn't work. please help check. thanks!

Hi,

I encountered below error when using job notification mail function.

2019-01-29 16:10:48,810 ERROR [Scheduler 132755908 Job 87fcb944-0c64-4d30-8196-05747b4ace4b-3906] util.MailService:121 : Sending the email to the following server failed : mail. *******.net:25
org.apache.commons.mail.EmailException: Sending the email to the following server failed : mail.*******.net:25
         at org.apache.commons.mail.Email.sendMimeMessage(Email.java:1469)
         at org.apache.commons.mail.Email.send(Email.java:1496)
         at org.apache.kylin.common.util.MailService.sendMail(MailService.java:117)
         at org.apache.kylin.common.util.MailService.sendMail(MailService.java:72)
         at org.apache.kylin.job.execution.AbstractExecutable.doSendMail(AbstractExecutable.java:348)
         at org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:321)
         at org.apache.kylin.job.execution.DefaultChainedExecutable.onStatusChange(DefaultChainedExecutable.java:154)
         at org.apache.kylin.engine.mr.CubingJob.onStatusChange(CubingJob.java:269)
         at org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:100)
         at org.apache.kylin.engine.mr.CubingJob.onExecuteFinished(CubingJob.java:265)
         at org.apache.kylin.job.execution.AbstractExecutable.onExecuteFinishedWithRetry(AbstractExecutable.java:99)
         at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:182)
         at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
         at java.lang.Thread.run(Thread.java:748)
Caused by: com.sun.mail.util.MailConnectException: Couldn't connect to host, port: mail.*******.net, 25; timeout 60000;
  nested exception is:
         java.net.SocketTimeoutException: connect timed out
         at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2118)
         at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:712)
         at javax.mail.Service.connect(Service.java:388)
         at javax.mail.Service.connect(Service.java:246)
         at javax.mail.Service.connect(Service.java:195)
         at javax.mail.Transport.send0(Transport.java:254)
         at javax.mail.Transport.send(Transport.java:124)
         at org.apache.commons.mail.Email.sendMimeMessage(Email.java:1459)
         ... 15 more
Caused by: java.net.SocketTimeoutException: connect timed out
         at java.net.PlainSocketImpl.socketConnect(Native Method)
         at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
         at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
         at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
         at java.net.Socket.connect(Socket.java:589)
         at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:329)
         at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:238)
         at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2084)


The notification mail setting is like below snapshot. I set the port as 587, but the error log shows it still use port 25. I used the version 2.5.2, and confirmed the command of “telnet mail_host 587” was work.
Please help check whether it doesn’t work for new port setting. Thanks!
[cid:image001.png@01D4B98F.2C5E33A0]

答复: Job notification-mail-port setting doesn't work. please help check. thanks!

Posted by Na Zhai <na...@kyligence.io>.
Hi, lianggang.
You can set kylin.job.notification-mail-enable-starttls to false, then the port will be change.

发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用

________________________________
发件人: 梁刚 <li...@qutoutiao.net>
发送时间: Wednesday, January 30, 2019 2:45:10 PM
收件人: user@kylin.apache.org
主题: Job notification-mail-port setting doesn't work. please help check. thanks!

Hi,

I encountered below error when using job notification mail function.

2019-01-29 16:10:48,810 ERROR [Scheduler 132755908 Job 87fcb944-0c64-4d30-8196-05747b4ace4b-3906] util.MailService:121 : Sending the email to the following server failed : mail. *******.net:25
org.apache.commons.mail.EmailException: Sending the email to the following server failed : mail.*******.net:25
         at org.apache.commons.mail.Email.sendMimeMessage(Email.java:1469)
         at org.apache.commons.mail.Email.send(Email.java:1496)
         at org.apache.kylin.common.util.MailService.sendMail(MailService.java:117)
         at org.apache.kylin.common.util.MailService.sendMail(MailService.java:72)
         at org.apache.kylin.job.execution.AbstractExecutable.doSendMail(AbstractExecutable.java:348)
         at org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:321)
         at org.apache.kylin.job.execution.DefaultChainedExecutable.onStatusChange(DefaultChainedExecutable.java:154)
         at org.apache.kylin.engine.mr.CubingJob.onStatusChange(CubingJob.java:269)
         at org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:100)
         at org.apache.kylin.engine.mr.CubingJob.onExecuteFinished(CubingJob.java:265)
         at org.apache.kylin.job.execution.AbstractExecutable.onExecuteFinishedWithRetry(AbstractExecutable.java:99)
         at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:182)
         at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
         at java.lang.Thread.run(Thread.java:748)
Caused by: com.sun.mail.util.MailConnectException: Couldn't connect to host, port: mail.*******.net, 25; timeout 60000;
  nested exception is:
         java.net.SocketTimeoutException: connect timed out
         at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2118)
         at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:712)
         at javax.mail.Service.connect(Service.java:388)
         at javax.mail.Service.connect(Service.java:246)
         at javax.mail.Service.connect(Service.java:195)
         at javax.mail.Transport.send0(Transport.java:254)
         at javax.mail.Transport.send(Transport.java:124)
         at org.apache.commons.mail.Email.sendMimeMessage(Email.java:1459)
         ... 15 more
Caused by: java.net.SocketTimeoutException: connect timed out
         at java.net.PlainSocketImpl.socketConnect(Native Method)
         at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
         at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
         at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
         at java.net.Socket.connect(Socket.java:589)
         at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:329)
         at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:238)
         at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2084)


The notification mail setting is like below snapshot. I set the port as 587, but the error log shows it still use port 25. I used the version 2.5.2, and confirmed the command of “telnet mail_host 587” was work.
Please help check whether it doesn’t work for new port setting. Thanks!
[cid:image001.png@01D4B8A7.2BFDCE90]