Hi,
My use case is to automate email report via Watcher from a kibana Canvas report.
ELK Stack => 7.14.0
I have already build a Canvas report. And from this same Canvas report I copied automatically generated Watcher context that help me to automate sending the report via e-mail as attachment.
Now when I Execute the Watcher simulator manually, It perfectly create the report and send it as a email attachment. All work to perfection. However, when the Watcher execute it on its own trigger interval It throws the following error.
"message":"[security_exception: [security_exception] Reason: unable to authenticate user [custom_reporting_user] for REST request [/_security/_authenticate]]: unable to authenticate user [custom_reporting_user] for REST request [/_security/_authenticate]"
See the full error here
[2021-08-12T11:51:10,908][ERROR][o.e.x.w.a.e.ExecutableEmailAction] [elastic.local] failed to execute action [b56bbc5e-ac3a-4387-8e0c-9b3fcdc9555d/email_admin]
org.elasticsearch.ElasticsearchException: Watch[b56bbc5e-ac3a-4387-8e0c-9b3fcdc9555d] reporting[Report.pdf] Error response when trying to trigger reporting generation host[172.88.41.18], port[5601] method[POST], path[/api/reporting/generate/printablePdf], response[status=[401], headers=[[date: [Thu, 12 Aug 2021 15:50:24 GMT]], [content-length: [297]], [kbn-name: [elastic.local]], [keep-alive: [timeout=120]], [kbn-license-sig: [27cff87299da52c6010e984e859132fa22edda1a0b46a6e398763e8a3dea229f]], [x-content-type-options: [nosniff]], [referrer-policy: [no-referrer-when-downgrade]], [connection: [keep-alive]], [content-type: [application/json; charset=utf-8]], [cache-control: [private, no-cache, no-store, must-revalidate]]], body=[{"statusCode":401,"error":"Unauthorized","message":"[security_exception: [security_exception] Reason: unable to authenticate user [custom_reporting_user] for REST request [/_security/_authenticate]]: unable to authenticate user [custom_reporting_user] for REST request [/_security/_authenticate]"}]]
at org.elasticsearch.xpack.watcher.notification.email.attachment.ReportingAttachmentParser.requestReportGeneration(ReportingAttachmentParser.java:262) ~[x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.notification.email.attachment.ReportingAttachmentParser.toAttachment(ReportingAttachmentParser.java:164) ~[x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.notification.email.attachment.ReportingAttachmentParser.toAttachment(ReportingAttachmentParser.java:53) ~[x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.actions.email.ExecutableEmailAction.execute(ExecutableEmailAction.java:63) [x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.core.watcher.actions.ActionWrapper.execute(ActionWrapper.java:166) [x-pack-core-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.execution.ExecutionService.executeInner(ExecutionService.java:534) [x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.execution.ExecutionService.execute(ExecutionService.java:320) [x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.execution.ExecutionService.lambda$executeAsync$5(ExecutionService.java:421) [x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.xpack.watcher.execution.ExecutionService$WatchExecutionTask.run(ExecutionService.java:627) [x-pack-watcher-7.14.0.jar:7.14.0]
at org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingRunnable.run(ThreadContext.java:673) [elasticsearch-7.14.0.jar:7.14.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) [?:?]
at java.lang.Thread.run(Thread.java:831) [?:?]
Watcher Rule
{
"trigger": {
"schedule": {
"interval": "5m"
}
},
"input": {
"none": {}
},
"condition": {
"always": {}
},
"actions": {
"email_admin": {
"email": {
"profile": "standard",
"attachments": {
"Report.pdf": {
"reporting": {
"url": "https://172.88.41.18:5601/api/reporting/generate/printablePdf?jobParams=%28browserTimezone%3AAsia%2FKuala_Lumpur%2Clayout%3A%28dimensions%3A%28height%3A792%2Cwidth%3A612%29%2Cid%3Acanvas%2Cselectors%3A%28itemsCountAttribute%3Adata-shared-items-count%2CrenderComplete%3A%5Bdata-shared-item%5D%2Cscreenshot%3A%5Bdata-shared-items-container%5D%2CtimefilterDurationAttribute%3Adata-shared-timefilter-duration%29%29%2CobjectType%3A%27canvas%20workpad%27%2CrelativeUrls%3A%21%28%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F1%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F2%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F3%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F4%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F5%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F6%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F7%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F8%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F9%2C%2Fapp%2Fcanvas%23%2Fexport%2Fworkpad%2Fpdf%2Fworkpad-6f12432a-ff60-4545-8029-7da11667dfa8%2Fpage%2F10%29%2Ctitle%3ATest%29",
"retries": 40,
"interval": "300s",
"auth": {
"basic": {
"username": "custom_reporting_user",
"password": "::es_encrypted::/2GcP+B+xxxxxxxxxxxxxxxxxx"
}
}
}
}
},
"to": [
"user@example.com"
],
"subject": "Report"
}
}
}
}
@spinscale If you are busy, not a hurry. If not, can you please help us to fix this issue. Thanks in advanced.