[icinga-users] Error while trying to create user membership

Tal Bar-Or tbaror at gmail.com
Mon Jan 9 16:11:03 CET 2017


Hello ,

I have my Icingaweb2 server connected to our domain controller for users
,all users are imported correctly but  when i am trying to Create New
Membership
<https://212.143.237.23/icingaweb2/user/createmembership?backend=Dalet_ad&user=dlasry>
i get following error below
Same when i am trying to get user group details
ant idea
Please advice
Thanks

Create New Membership
<https://212.143.237.23/icingaweb2/user/createmembership?backend=Dalet_ad&user=dlasry>*
error*

> SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gm.group_id' in
> 'on clause', query was: SELECT g.name AS group_name FROM
> icingaweb_group_membership AS gm
> INNER JOIN icingaweb_group AS g ON gm.group_id = g.id WHERE (gm.username
> = 'tbaror')
> ------------------------------
>
> #0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
> #1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)
> #2 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('SELECT g.name A...', Array)
> #3 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(782): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
> #4 /usr/share/php/Icinga/Data/Db/DbConnection.php(290): Zend_Db_Adapter_Abstract->fetchCol(Object(Zend_Db_Select))
> #5 /usr/share/php/Icinga/Data/SimpleQuery.php(590): Icinga\Data\Db\DbConnection->fetchColumn(Object(Icinga\Data\Db\DbQuery))
> #6 /usr/share/php/Icinga/Repository/RepositoryQuery.php(569): Icinga\Data\SimpleQuery->fetchColumn()
> #7 /usr/share/icingaweb2/application/forms/Config/User/CreateMembershipForm.php(164): Icinga\Repository\RepositoryQuery->fetchColumn()
> #8 /usr/share/icingaweb2/application/forms/Config/User/CreateMembershipForm.php(97): Icinga\Forms\Config\User\CreateMembershipForm->createDataSource()
> #9 /usr/share/php/Icinga/Web/Form.php(1183): Icinga\Forms\Config\User\CreateMembershipForm->onRequest()
> #10 /usr/share/icingaweb2/application/controllers/UserController.php(237): Icinga\Web\Form->handleRequest()
> #11 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): Icinga\Controllers\UserController->createmembershipAction()
> #12 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch('createmembershi...')
> #13 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
> #14 /usr/share/php/Icinga/Application/Web.php(389): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
> #15 /usr/share/php/Icinga/Application/webrouter.php(109): Icinga\Application\Web->dispatch()
> #16 /usr/share/icingaweb2/public/index.php(4): require_once('/usr/share/php/...')
> #17 {main}
>
> * group details error*

> SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gm.group_id' in
> 'on clause', query was: SELECT gm.username AS user_name FROM
> icingaweb_group_membership AS gm
> INNER JOIN icingaweb_group AS g ON gm.group_id = g.id WHERE (g.name =
> 'gefen_users') LIMIT 25
> ------------------------------
>
> #0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
> #1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)
> #2 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('SELECT gm.usern...', Array)
> #3 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(744): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
> #4 /usr/share/php/Icinga/Data/Db/DbConnection.php(278): Zend_Db_Adapter_Abstract->fetchRow(Object(Zend_Db_Select))
> #5 /usr/share/php/Icinga/Data/SimpleQuery.php(577): Icinga\Data\Db\DbConnection->fetchRow(Object(Icinga\Data\Db\DbQuery))
> #6 /usr/share/php/Icinga/Data/SimpleQuery.php(453): Icinga\Data\SimpleQuery->fetchRow()
> #7 /usr/share/php/Icinga/Repository/RepositoryQuery.php(450): Icinga\Data\SimpleQuery->hasResult()
> #8 zend.view:///usr/share/icingaweb2/application/views/scripts/group/show.phtml(67): Icinga\Repository\RepositoryQuery->hasResult()
> #9 /usr/share/php/Icinga/Web/View.php(231): include('zend.view:///us...')
> #10 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(877): Icinga\Web\View->_run('/usr/share/icin...')
> #11 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(904): Zend_View_Abstract->render()
> #12 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(925): Zend_Controller_Action_Helper_ViewRenderer->renderScript('group/show.phtm...', NULL)
> #13 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(964): Zend_Controller_Action_Helper_ViewRenderer->render()
> #14 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/HelperBroker.php(272): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
> #15 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(518): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
> #16 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch('showAction')
> #17 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
> #18 /usr/share/php/Icinga/Application/Web.php(389): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
> #19 /usr/share/php/Icinga/Application/webrouter.php(109): Icinga\Application\Web->dispatch()
> #20 /usr/share/icingaweb2/public/index.php(4): require_once('/usr/share/php/...')
> #21 {main}
>
>
-
Tal Bar-or
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20170109/5a04d203/attachment.html>


More information about the icinga-users mailing list