Ad Widget

Collapse

Autoregistration SQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • LSP
    Junior Member
    • Apr 2021
    • 1

    #1

    Autoregistration SQL error

    Hello Gurus,

    I'm trying to configure active agent autoregistration on Zabbix 5.2.6/Postgres and am getting a SQL error in the server logs and not much else.

    The autoregistration rule I created has the following actions:
    Code:
    [B]Add host[/B]
    [B]Add to host groups: [/B]foo
    [B]Remove from host groups: [/B]Discovered hosts
    [B]Link to templates: [/B]Windows by Zabbix agent - active <- copied and modfied from passive template
    I have manually added this host and it works nicely, but when I deleted the host and added the above autoregistration rule this starts to apper in the server log:
    Code:
    1595856:20210416:161137.557 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: null value in column "description" of relation "hosts" violates not-null constraint
    DETAIL: Failing row contains (11694, null, MYHOSTNAME, 0, 0, , 0, 0, 0, -1, 2, , , 0, 0, 0, 0, null, 0, 0, 0, 0, 0, , , 0, 0, 0, , MYHOSTNAME, 0, null, null, 1, 1, , , , , , 1, 0, 0).
    [insert into hosts (hostid,proxy_hostid,host,name) values (11694,null,'MYHOSTNAME','MYHOSTNAME');
    Happy to file a bug report if that's more appropriate.

    L



Working...