I’m trying to install Icinga-Web2 by following the readme in github. I have the
database on a secondary server. I have setup postgres’ pg_hba.conf file to and
created a role for icingaweb, and I even created the database. However I can’t
finish the setup wizard. I get the following error on the webpage, at the end
of the “Configuration” section of the setup when it asks for my database
username and password:
Server error: SQLSTATE[08006] [7] could not connect to server: No such file or
directory
Along with that error is the following in syslog:
Nov 26 17:30:05 elsg-stk01-ici-app01 icingaweb[16721]:
Zend_Db_Adapter_Exception in
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php:139
with message: SQLSTATE[08006] [7] could not connect to server: No such file or
directory#012#011Is the server running locally and accepting#012#011connections
on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? <- PDOException in
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php:125
with message: SQLSTATE[08006] [7] could not connect to server: No such file or
directory#012#011Is the server running locally and accepting#012#011connections
on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Nov 26 17:30:05 elsg-stk01-ici-app01 icingaweb[16721]: Stacktrace: #0
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Db/Adapter/Pdo/Pgsql.php(86):
Zend_Db_Adapter_Pdo_Abstract->_connect()#012#1
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Db/Adapter/Abstract.php(450):
Zend_Db_Adapter_Pdo_Pgsql->_connect()#012#2
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232):
Zend_Db_Adapter_Abstract->query('SELECT has_data...', Array)#012#3
/usr/share/nginx/html/icingaweb/modules/setup/library/Setup/Utils/DbTool.php(406):
Zend_Db_Adapter_Pdo_Abstract->query('SELECT has_data...', Array)#012#4
/usr/share/nginx/html/icingaweb/modules/setup/library/Setup/Utils/DbTool.php(731):
Icinga\Module\Setup\Utils\DbTool->query('SELECT has_data...', Array)#012#5
/usr/share/nginx/html/icingaweb/modules/setup/library/Setup/Utils/DbTool.php(451):
Icinga\Module\Setup\Utils\DbTool->checkPgsqlPrivileges(Array, false, NULL,
NULL)#012#6
/usr/share/nginx/html/icingaweb/modules/setup/application/forms/DatabaseCreationPage.php(183):
Icinga\Module\Setup\Utils\DbTool->checkPrivileges(Array)#012#7
/usr/share/nginx/html/icingaweb/library/Icinga/Web/Wizard.php(215):
Icinga\Module\Setup\Forms\DatabaseCreationPage->isValid(Array)#012#8
/usr/share/nginx/html/icingaweb/modules/setup/application/controllers/IndexController.php(38):
Icinga\Web\Wizard->handleRequest()#012#9
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Controller/Action.php(507):
Setup_IndexController->indexAction()#012#10
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Controller/Dispatcher/Standard.php(303):
Zend_Controller_Action->dispatch('indexAction')#012#11
/usr/share/nginx/html/icingaweb/library/vendor/Zend/Controller/Front.php(937):
Zend_Controller_Dispatcher_Standard->dispatch(Object(Icinga\Web\Request),
Object(Icinga\Web\Response))#012#12
/usr/share/nginx/html/icingaweb/library/Icinga/Application/Web.php(159):
Zend_Controller_Front->dispatch(Object(Icinga\Web\Request),
Object(Icinga\Web\Response))#012#13
/usr/share/nginx/html/icingaweb/library/Icinga/Application/webrouter.php(112):
Icinga\Application\Web->dispatch()#012#14
/usr/share/nginx/html/icingaweb/public/index.php(5):
require_once('/usr/share/ngin...')#012#15 {main}
So it seems that even though I’ve specified a remote IP for the database
creation, the setup wizard is trying to connect to a local instance of
postgresql, which does not exist.
I’m not sure if this is the correct place to post this, as it seems like a bug
and not a config issue. But if anybody has any tips on getting it installed, I
would appreciate the help. I suppose my next plan is to install postgres
locally, just so I can get the install to finish, then go about finding a way
to move to the actual database server. But I’d rather keep it cleaner and just
get it working the way it’s supposed to.
Chris Newkirk
Network Engineer
[email protected]<mailto:[email protected]>
661.431.1613
www.lightspeedsystems.com<http://www.lightspeedsystems.com/>
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.icinga.org/mailman/listinfo/icinga-users
