search

Icinga / icingaweb2

A lightweight and extensible web interface to keep an eye on your environment. Analyse problems and act on them.
https://icinga.com/get-started/
GNU General Public License v2.0
806 stars 280 forks source link

[dev.icinga.com #10916] Unable to create user group "Administrators" #2227

Closed icinga-migration closed 8 years ago

icinga-migration commented 8 years ago

This issue has been migrated from Redmine: https://dev.icinga.com/issues/10916

Created by gilbertaispuro on 2015-12-28 17:58:23 +00:00

Assignee: (none) Status: Closed (closed on 2016-02-18 15:59:15 +00:00) Target Version: (none) Last Update: 2016-02-18 15:59:15 +00:00 (in Redmine)

Hello,

I am having issues setting up Icingaweb.

I can go through the whole setup with no issues but when I click finish at the last page, i receive the following prompt:

User Group Backend configuration has been successfully written to: /etc/icingaweb2/groups.ini Unable to create user group "Administrators". An error occured: ERROR: Zend_Db_Statement_Exception in /usr/share/php/Zend/Db/Statement/Pdo.php:235 with message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icingaweb2.icingaweb_group' doesn't exist, query was: SELECT COUNT AS cnt FROM icingaweb_group AS g WHERE (g.name = 'Administrators')

I have no SQL experience by the way.

Please help.

Thank you!

Attachments

Relations:

icinga-migration commented 8 years ago

Updated by elippmann on 2016-01-05 08:28:03 +00:00

icinga-migration commented 8 years ago

Updated by elippmann on 2016-01-05 08:30:08 +00:00

Hi,

It seems that the database has not been set up correctly. Which version of Web 2 are you using? Did you use the database icingaweb2 for both Web 2 (authentication and preferences) and Icinga / IDO (monitoring data)?

Cheers, Eric

icinga-migration commented 8 years ago

Updated by gilbertaispuro on 2016-01-05 17:26:35 +00:00

Hello,

I failed to follow these directions I believe:

"The package provides a new configuration file that is installed in /etc/icinga2/features-available/ido-pgsql.conf. You will need to update the database credentials in this file."

http://docs.icinga.org/icinga2/latest/doc/module/icinga2/chapter/getting-started#running-icinga2

Thank you.

icinga-migration commented 8 years ago

Updated by elippmann on 2016-01-07 08:29:10 +00:00

Hi,

Is Icinga 2 writing into the icingaweb2 database? Which version of Web 2 are you using?

Cheers, Eric

icinga-migration commented 8 years ago

Updated by gilbertaispuro on 2016-01-07 14:59:20 +00:00

No, I just forgot to add the credentials.

Version 2.1.2

icinga-migration commented 8 years ago

Updated by elippmann on 2016-02-18 15:59:15 +00:00

meilaniagnesia commented 6 years ago

Hello, I am facing this same issue

User Group Backend configuration has been successfully written to: /etc/icingaweb2/groups.ini Unable to create user group "Administrators". An error occured: ERROR: Zend_Db_Adapter_Exception in /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php:139 with message: SQLSTATE[28000] [1045] Access denied for user 'apache'@'localhost' (using password: YES)

Anyone could help fix this issue will be highly appreciated. Thank you.

corsairetc commented 6 years ago

Hello, I have same problem. Unable to create user group "Administrators". An error occured: ERROR: Zend_Db_Statement_Exception in /usr/share/icingaweb2/library/vendor/Zend/Db/Statement/Pdo.php:225 with message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icinga_users.icingaweb_group' doesn't exist, query was: SELECT COUNT(*) AS cnt FROM icingaweb_group AS g WHERE (g.name = 'Administrators') Mysql schema: MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | icinga_users | | icingadb | | information_schema | | mysql | | performance_schema | +--------------------+ I have very low skills with sql. Thank you for any advice. I try it install on fresh Debian 9 x64 installation in VMs.

pkhadka56 commented 6 years ago

same problem as @corsairetc

pkhadka56 commented 6 years ago

Well, I changed database name other than icingaweb2 and icinga2 and it worked. Just change database name.

jlownie commented 4 years ago

I had the same issue, I was getting the same error as in gilbertaispuro's initial post and then I did the same as pkhadka56 - I created a new user, gave them access to the icingaweb2 DB then clicked back through the config wizard and changed the DB user for icingaweb2 to the new user, and then the wizard completed successfully.

I checked that the normal user was valid and could login using the mysql cli. It looks like a bug to me. I'm using Ubuntu 18.04, I installed Icinga from the icinga repos.

ii icinga2 2.11.3-1.bionic ii icinga2-bin 2.11.3-1.bionic ii icinga2-common 2.11.3-1.bionic ii icinga2-doc 2.11.3-1.bionic ii icinga2-ido-mysql 2.11.3-1.bionic ii icingacli 2.7.3-1.bionic ii icingaweb2 2.7.3-1.bionic ii icingaweb2-common 2.7.3-1.bionic ii icingaweb2-module-doc 2.7.3-1.bionic ii icingaweb2-module-monitoring 2.7.3-1.bionic