[KYLIN-4789] connect maile failed

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.6.6
• Component/s: Tools, Build and Test
• Assignee: Yaqian Zhang
• Reporter: mzz
• Created: 15/Oct/20 10:25
• Updated: 19/Oct/20 06:05

Description

Using kylin's email is to report an error：

2020-10-15 18:17:41,566 INFO  [Scheduler 1589746335 Job 340f1d7a-e950-b4e3-0833-595f885748a3-222] execution.AbstractExecutable:347 : prepare to send email to:[[e-mail]]
2020-10-15 18:17:41,566 INFO  [Scheduler 1589746335 Job 340f1d7a-e950-b4e3-0833-595f885748a3-222] execution.AbstractExecutable:348 : job name:BUILD CUBE - mail - 20201001000000_20201002000000 - GMT+08:00 2020-10-15 18:15:17
2020-10-15 18:17:41,566 INFO  [Scheduler 1589746335 Job 340f1d7a-e950-b4e3-0833-595f885748a3-222] execution.AbstractExecutable:349 : submitter:ADMIN
2020-10-15 18:17:41,566 INFO  [Scheduler 1589746335 Job 340f1d7a-e950-b4e3-0833-595f885748a3-222] execution.AbstractExecutable:350 : notify list:[[e-mail]]

2020-10-15 18:18:41,698 ERROR [Scheduler 1589746335 Job 340f1d7a-e950-b4e3-0833-595f885748a3-222] util.MailService:132 : Sending the email to the following server failed : smtp.exmail.qq.com:25
org.apache.commons.mail.EmailException: Sending the email to the following server failed : smtp.exmail.qq.com: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:127)
        at org.apache.kylin.common.util.MailService.sendMail(MailService.java:71)
        at org.apache.kylin.job.execution.AbstractExecutable.doSendMail(AbstractExecutable.java:351)
        at org.apache.kylin.job.execution.AbstractExecutable.notifyUserStatusChange(AbstractExecutable.java:324)
        at org.apache.kylin.job.execution.DefaultChainedExecutable.onStatusChange(DefaultChainedExecutable.java:156)
        at org.apache.kylin.engine.mr.CubingJob.onStatusChange(CubingJob.java:274)
        at org.apache.kylin.job.execution.DefaultChainedExecutable.onExecuteFinished(DefaultChainedExecutable.java:137)
        at org.apache.kylin.engine.mr.CubingJob.onExecuteFinished(CubingJob.java:270)
        at org.apache.kylin.job.execution.AbstractExecutable.onExecuteFinishedWithRetry(AbstractExecutable.java:102)
        at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:185)
        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: smtp.exmail.qq.com, 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:607)
        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)
        ... 22 more

properties:

kylin.job.notification-enabled=true
kylin.job.notification-mail-enable-starttls=true
kylin.job.notification-mail-host=smtp.exmail.qq.com
kylin.job.notification-mail-port=465
kylin.job.notification-mail-username=[e-mail]
kylin.job.notification-mail-password=xxxxx
kylin.job.notification-mail-sender=[e-mail]

I configured 465, which is still connected to the default value of 25.

My configuration item kylin.job.notification-mail-port is not in effect.

Is this the problem with this version？ thx.