Error nagvis using backend pgsql

  • I'm using nagvis 1.9.3, icinga2 2.7.1-1.stretch, postgresql-9.6 9.6.5-1.pgdg90 + 1, icingaweb2 2.4.1-2.stretch, with pgsql backend. But when I select the host this message appears. If I use the live_1 of the refused connection.


    Failed to get objects: Error: (0) Undefined property: CorePDOHandler::$data

    URL: /nagvis/server/core/ajax_handler.php?mod=Map&act=addModify&show=escvilhena&type=host&x=455&y=91&_ajaxid=1506512914

    File: /usr/share/nagvis/share/server/core/classes/CorePDOHandler.php

    Line: 306

    #0 /usr/share/nagvis/share/server/core/classes/CorePDOHandler.php(306): nagvisExceptionErrorHandler(8, 'Undefined prope...', '/usr/share/nagv...', 306, Array)
    #1 /usr/share/nagvis/share/server/core/classes/CorePDOHandler.php(332): CorePDOHandler->prep('SELECT name1,na...')
    #2 /usr/share/nagvis/share/server/core/classes/GlobalBackendPDO.php(250): CorePDOHandler->query('SELECT name1,na...', Array)
    #3 /usr/share/nagvis/share/server/core/mapcfg/default.php(145): GlobalBackendPDO->getObjects('host', '', '')
    #4 /usr/share/nagvis/share/server/core/mapcfg/default.php(159): getObjectNames('host', Object(GlobalMapCfg), NULL, Array)
    #5 /usr/share/nagvis/share/server/core/classes/ViewMapAddModify.php(394): listHostNames(Object(GlobalMapCfg), NULL, Array)
    #6 /usr/share/nagvis/share/server/core/classes/ViewMapAddModify.php(509): ViewMapAddModify->drawField('host_name', Array, Array)
    #7 /usr/share/nagvis/share/server/core/classes/ViewMapAddModify.php(537): ViewMapAddModify->drawFields(Array)
    #8 /usr/share/nagvis/share/server/core/classes/ViewMapAddModify.php(620): ViewMapAddModify->drawForm()
    #9 /usr/share/nagvis/share/server/core/classes/CoreModMap.php(133): ViewMapAddModify->parse()
    #10 /usr/share/nagvis/share/server/core/functions/index.php(120): CoreModMap->handleAction()
    #11 /usr/share/nagvis/share/server/core/ajax_handler.php(59): require('/usr/share/nagv...')
    #12 {main}
    Output:

    Code
    1. <form id="addmodify" name="addmodify" action="javascript:submitForm('/nagvis/server/core/ajax_handler.php?mod=Map&amp;act=addModify', 'addmodify');" method="POST"> <input type="hidden" id="_form_name" name="_form_name" value="addmodify" /> <input type="hidden" id="_update" name="_update" value="0" /> <input type="hidden" id="sec" name="sec" value="general" /> <ul class="nav" id="nav"><li id="nav_general" class="active"><a href="javascript:toggle_section('general')">General</a></li><li id="nav_appearance" ><a href="javascript:toggle_section('appearance')">Appearance</a></li><li id="nav_state" ><a href="javascript:toggle_section('state')">Status</a></li><li id="nav_actions" ><a href="javascript:toggle_section('actions')">Actions</a></li><li id="nav_label" ><a href="javascript:toggle_section('label')">Label</a></li><li id="nav_worldmap" ><a href="javascript:toggle_section('worldmap')">Worldmap</a></li></ul><div id="sec_general" class="section" style=""><table class="mytable"><tr class="must"><td class=tdlabel>host_name</td><td class=tdbox></td><td class=tdfield>
  • I put the bank of the icinga and now the message is:

    Failed to get objects: There are no tables in the database matching given prefix "nagios_". (Backend-ID: icinga2)