The hastebin url apparently has expired.
Here is a new version:
as per https://www.zabbix.org/wiki/Docs/bug_reporting_guidelines#Reporting_an_issue, reposting request/response contents here
request :
{
"auth": "hash",
"id": 1,
"jsonrpc": "2.0",
"method": "action.create",
"params": {
"def_longdata": "Trigger: {TRIGGER.NAME}\nTrigger status: {TRIGGER.STATUS}\nTrigger severity: {TRIGGER.SEVERITY}\nTrigger URL: {TRIGGER.URL}\n\nItem values:\n\n1. {ITEM.NAME1} ({HOST.NAME1}:{ITEM.KEY1}): {ITEM.VALUE1}\n2. {ITEM.NAME2} ({HOST.NAME2}:{ITEM.KEY2}): {ITEM.VALUE2}\n3. {ITEM.NAME3} ({HOST.NAME3}:{ITEM.KEY3}): {ITEM.VALUE3}\n\nOriginal event ID: {EVENT.ID}",
"def_shortdata": "{TRIGGER.STATUS}: {TRIGGER.NAME}",
"esc_period": 300,
"eventsource": 0,
"filter": {
"conditions": [
{
"conditiontype": 16,
"formulaid": "A",
"operator": 7,
"value": ""
},
{
"conditiontype": 5,
"formulaid": "B",
"operator": 0,
"value": "1"
}
],
"evaltype": 3,
"formula": "A and B"
},
"name": "_UserSubscriptions_user",
"operations": [
{
"esc_period": 0,
"esc_step_from": 2,
"esc_step_to": 2,
"operationtype": 0,
"opmessage": {
"default_msg": 1,
"mediatypeid": 0
},
"opmessage_usr": {
"userid": "100100000000059"
}
}
],
"r_longdata": "Trigger: {TRIGGER.NAME}\nTrigger status: {TRIGGER.STATUS}\nTrigger severity: {TRIGGER.SEVERITY}\nTrigger URL: {TRIGGER.URL}\n\nItem values:\n\n1. {ITEM.NAME1} ({HOST.NAME1}:{ITEM.KEY1}): {ITEM.VALUE1}\n2. {ITEM.NAME2} ({HOST.NAME2}:{ITEM.KEY2}): {ITEM.VALUE2}\n3. {ITEM.NAME3} ({HOST.NAME3}:{ITEM.KEY3}): {ITEM.VALUE3}\n\nOriginal event ID: {EVENT.ID}",
"r_shortdata": "Solved: {TRIGGER.STATUS}: {TRIGGER.NAME}",
"recovery_msg": 1
}
}
response :
{
"error": {
"code": -32500,
"data": "SQL statement execution has failed \"INSERT INTO opmessage_usr (operationid,userid,opmessage_usrid) VALUES ('200200000000022','1','100100000000169')\".",
"message": "Application error."
},
"id": 1,
"jsonrpc": "2.0"
}
After debugging the zabbix API code, I found out that
"opmessage_usr": { "userid": "100100000000059" }
is incorrect, it should be an array of users, not a user object.
Perhaps some extra validation could help to catch these kinds of errors.
Let's close as a duplicate of ZBX-3783 then. 