Hi Michael, I apologize. I thought I included the log detail. Here it is. The log states the following:
[2016-02-12 03:43:29 -0700] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational! [2016-02-12 03:43:39 -0700] critical/IdoMysqlConnection: Connection to database 'icinga' with user 'icinga' on 'localhost:3306' failed: "Access denied for user 'icinga'@'localhost' (using password: YES)" I am using Mariadb on RHEL7. I checked that Mariadb is up and running as well as Icinga2. Any suggestions would be grateful. Best Regards, Laura ________________________________________ From: icinga-users <[email protected]> on behalf of [email protected] <[email protected]> Sent: Friday, February 12, 2016 4:00 AM To: [email protected] Subject: icinga-users Digest, Vol 26, Issue 23 Send icinga-users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.icinga.org/mailman/listinfo/icinga-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of icinga-users digest..." Today's Topics: 1. Re: Still having issues with configuration (Laura DiMauro) 2. Re: Still having issues with configuration (Michael Friedrich) ---------------------------------------------------------------------- Message: 1 Date: Thu, 11 Feb 2016 17:39:19 +0000 From: Laura DiMauro <[email protected]> To: "[email protected]" <[email protected]> Subject: Re: [icinga-users] Still having issues with configuration Message-ID: <bn3pr0701mb1361cfdf12cb26ba714ec7aed3...@bn3pr0701mb1361.namprd07.prod.outlook.com> Content-Type: text/plain; charset="iso-8859-1" Hi, I started the build over again and this time did not do any upgrade. I am getting the error 'icinga_backend is currently not up and running'. My user is showing it is connecting to the database I created in mysql. The IDO modules have been installed correctly. I have enabled checker, command, ido-mysql, mainlog, notification. I am not sure what to check first. Error log shows that 'connection to database failed' and 'Exception during database operation: Verify that your database is operational!'. Any suggestions? ------------------------------ Message: 2 Date: Thu, 4 Feb 2016 18:04:56 +0000 From: Laura DiMauro <[email protected]> To: "[email protected]" <[email protected]> Subject: Re: [icinga-users] icinga-users Digest, Vol 26, Issue 8 Message-ID: <bn3pr0701mb13613cf025391b2d29b3e786d3...@bn3pr0701mb1361.namprd07.prod.outlook.com> Content-Type: text/plain; charset="iso-8859-1" Hello, Yes, I did the steps you mentioned below without a problem and I checked my users and passwords to make sure everything looked ok. I did forget about a step that I did yesterday. I did the 'upgrading the mysql database' part as well. It said to apply all database schema upgrade files incrementally. I saw the following in /usr/share/icinga2-ido-mysql/schema/upgrade: 2.0.2.sql 2.1.0.sql 2.2.0.sql 2.3.0.sql 2.4.0.sql I followed the instructions and used the following command for each version: mysql -u root -p icinga < /usr/share/icinga2-ido-mysql/schema/upgrade/<version>.sql After I did the first version it gave me the following error: ERROR 1060 (42S21) at line 10: Duplicate column name 'endpoint_name' Should I not have completed this as part of my first icinga2 installation? ________________________________________ From: icinga-users <[email protected]> on behalf of [email protected] <[email protected]> Sent: Wednesday, February 3, 2016 8:24 PM To: [email protected] Subject: icinga-users Digest, Vol 26, Issue 8 ------------------------------ Message: 2 Date: Wed, 3 Feb 2016 22:13:27 +0000 From: Laura DiMauro <[email protected]> To: "[email protected]" <[email protected]> Subject: [icinga-users] Icingaweb2 configuration - Monitoring IDO Resource Message-ID: <bn3pr0701mb1361719db139845b833f88f4d3...@bn3pr0701mb1361.namprd07.prod.outlook.com> Content-Type: text/plain; charset="iso-8859-1" Hello, I have installed Icinga2 and Icingaweb2 on RHEL7 (in a development server). I was able to configure icingaweb2 in the browser until the 'Monitoring IDO Resource' section. I can't seem to validate configuration. I am receiving the following: * There is currently no icinga instance writing to the IDO. Make sure that a icinga instance is configured and able to write to the IDO. Validation Log Connection to icinga as icinga on localhost: successful protocol_version: 10 version: 5.5.44-MariaDB version_compile_os: Linux It's probably something silly but I cannot seem to figure it out. Any suggestions would be grateful! Best Regards, Laura -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20160203/eba859f5/attachment-0001.html> ------------------------------ Message: 3 Date: Thu, 4 Feb 2016 10:24:39 +0700 From: Muhammad Panji <[email protected]> To: "Icinga User's Corner" <[email protected]> Subject: Re: [icinga-users] Icingaweb2 configuration - Monitoring IDO Resource Message-ID: <canbzdhmoeysj-ovswexz0sax84wosaha0-5oyp09_7txdfw...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" On Thu, Feb 4, 2016 at 5:13 AM, Laura DiMauro <[email protected]> wrote: > Hello, > > I have installed Icinga2 and Icingaweb2 on RHEL7 (in a development > server). I was able to configure icingaweb2 in the browser until > the 'Monitoring IDO Resource' section. > > > I can't seem to validate configuration. I am receiving the following: > > > - There is currently no icinga instance writing to the IDO. Make sure > that a icinga instance is configured and able to write to the IDO. > > *Validation Log* > > Connection to icinga as icinga on localhost: successful > protocol_version: 10 > version: 5.5.44-MariaDB > version_compile_os: Linux > > It's probably something silly but I cannot seem to figure it out. Any > suggestions would be grateful! > > 1. Install icinga-ido-mysql package 2. create database, user and privileges 3. import sql schema 4. enable ido-mysql feature the configuration for ido-mysql is on /etc/icinga2/features-available/ido-mysql.conf You can follow this part of the documentation : http://docs.icinga.org/icinga2/latest/doc/module/icinga2/chapter/getting-started#configuring-db-ido-mysql Thanks. Regards, -- Muhammad Panji http://www.panji.web.id http://www.kurungsiku.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20160204/6bb260c7/attachment.html> ------------------------------ Subject: Digest Footer _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users ------------------------------ End of icinga-users Digest, Vol 26, Issue 8 ******************************************* ------------------------------ Message: 3 Date: Fri, 5 Feb 2016 09:47:48 +0700 From: Muhammad Panji <[email protected]> To: "Icinga User's Corner" <[email protected]> Subject: Re: [icinga-users] icinga-users Digest, Vol 26, Issue 8 Message-ID: <canbzdhn61xp2st6q4s6r3voywm9ejtmnbmtu-_h-h8i-dq0...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" On Fri, Feb 5, 2016 at 1:04 AM, Laura DiMauro <[email protected]> wrote: > Hello, > Yes, I did the steps you mentioned below without a problem and I checked > my users and passwords to make sure everything looked ok. > I did forget about a step that I did yesterday. I did the 'upgrading the > mysql database' part as well. It said to apply all database schema upgrade > files incrementally. I saw the following in > /usr/share/icinga2-ido-mysql/schema/upgrade: > 2.0.2.sql 2.1.0.sql 2.2.0.sql 2.3.0.sql 2.4.0.sql > > I followed the instructions and used the following command for each > version: > mysql -u root -p icinga < > /usr/share/icinga2-ido-mysql/schema/upgrade/<version>.sql > > After I did the first version it gave me the following error: > ERROR 1060 (42S21) at line 10: Duplicate column name 'endpoint_name' > > Should I not have completed this as part of my first icinga2 installation? > > I only import sql on schema folder and not import anything on upgrade folder. Did you do upgrade from previous version or fresh install? Regards, -- Muhammad Panji http://www.panji.web.id http://www.kurungsiku.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20160205/4edd5556/attachment-0001.html> ------------------------------ Subject: Digest Footer _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users ------------------------------ End of icinga-users Digest, Vol 26, Issue 12 ******************************************** ------------------------------ Message: 2 Date: Thu, 11 Feb 2016 19:45:30 +0000 From: Michael Friedrich <[email protected]> To: "[email protected]" <[email protected]> Subject: Re: [icinga-users] Still having issues with configuration Message-ID: <[email protected]> Content-Type: text/plain; charset="utf-8" > Am 11.02.2016 um 18:39 schrieb Laura DiMauro <[email protected]>: > > > > Hi, > I started the build over again and this time did not do any upgrade. I am > getting the error 'icinga_backend is currently not up and running'. My user > is showing it is connecting to the database I created in mysql. The IDO > modules have been installed correctly. I have enabled checker, command, > ido-mysql, mainlog, notification. I am not sure what to check first. Error > log shows that 'connection to database failed' and 'Exception during database > operation: Verify that your database is operational!'. > Any suggestions? As requested earlier, post the full context from the logs. Kind regards, Michael > > > ------------------------------ > > Message: 2 > Date: Thu, 4 Feb 2016 18:04:56 +0000 > From: Laura DiMauro <[email protected]> > To: "[email protected]" <[email protected]> > Subject: Re: [icinga-users] icinga-users Digest, Vol 26, Issue 8 > Message-ID: > > <bn3pr0701mb13613cf025391b2d29b3e786d3...@bn3pr0701mb1361.namprd07.prod.outlook.com> > > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > Yes, I did the steps you mentioned below without a problem and I checked my > users and passwords to make sure everything looked ok. > I did forget about a step that I did yesterday. I did the 'upgrading the > mysql database' part as well. It said to apply all database schema upgrade > files incrementally. I saw the following in > /usr/share/icinga2-ido-mysql/schema/upgrade: > 2.0.2.sql 2.1.0.sql 2.2.0.sql 2.3.0.sql 2.4.0.sql > > I followed the instructions and used the following command for each version: > mysql -u root -p icinga < > /usr/share/icinga2-ido-mysql/schema/upgrade/<version>.sql > > After I did the first version it gave me the following error: > ERROR 1060 (42S21) at line 10: Duplicate column name 'endpoint_name' > > Should I not have completed this as part of my first icinga2 installation? > > ________________________________________ > From: icinga-users <[email protected]> on behalf of > [email protected] <[email protected]> > Sent: Wednesday, February 3, 2016 8:24 PM > To: [email protected] > Subject: icinga-users Digest, Vol 26, Issue 8 > > > ------------------------------ > > Message: 2 > Date: Wed, 3 Feb 2016 22:13:27 +0000 > From: Laura DiMauro <[email protected]> > To: "[email protected]" <[email protected]> > Subject: [icinga-users] Icingaweb2 configuration - Monitoring IDO > Resource > Message-ID: > > <bn3pr0701mb1361719db139845b833f88f4d3...@bn3pr0701mb1361.namprd07.prod.outlook.com> > > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > > I have installed Icinga2 and Icingaweb2 on RHEL7 (in a development server). > I was able to configure icingaweb2 in the browser until the 'Monitoring IDO > Resource' section. > > > I can't seem to validate configuration. I am receiving the following: > > * There is currently no icinga instance writing to the IDO. Make sure that > a icinga instance is configured and able to write to the IDO. > > Validation Log > > Connection to icinga as icinga on localhost: successful > protocol_version: 10 > version: 5.5.44-MariaDB > version_compile_os: Linux > > It's probably something silly but I cannot seem to figure it out. Any > suggestions would be grateful! > > > Best Regards, > > Laura > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.icinga.org/pipermail/icinga-users/attachments/20160203/eba859f5/attachment-0001.html> > > ------------------------------ > > Message: 3 > Date: Thu, 4 Feb 2016 10:24:39 +0700 > From: Muhammad Panji <[email protected]> > To: "Icinga User's Corner" <[email protected]> > Subject: Re: [icinga-users] Icingaweb2 configuration - Monitoring IDO > Resource > Message-ID: > <canbzdhmoeysj-ovswexz0sax84wosaha0-5oyp09_7txdfw...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > >> On Thu, Feb 4, 2016 at 5:13 AM, Laura DiMauro <[email protected]> wrote: >> >> Hello, >> >> I have installed Icinga2 and Icingaweb2 on RHEL7 (in a development >> server). I was able to configure icingaweb2 in the browser until >> the 'Monitoring IDO Resource' section. >> >> >> I can't seem to validate configuration. I am receiving the following: >> >> >> - There is currently no icinga instance writing to the IDO. Make sure >> that a icinga instance is configured and able to write to the IDO. >> >> *Validation Log* >> >> Connection to icinga as icinga on localhost: successful >> protocol_version: 10 >> version: 5.5.44-MariaDB >> version_compile_os: Linux >> >> It's probably something silly but I cannot seem to figure it out. Any >> suggestions would be grateful! >> >> 1. Install icinga-ido-mysql package > 2. create database, user and privileges > 3. import sql schema > 4. enable ido-mysql feature > > the configuration for ido-mysql is on > /etc/icinga2/features-available/ido-mysql.conf > > You can follow this part of the documentation : > http://docs.icinga.org/icinga2/latest/doc/module/icinga2/chapter/getting-started#configuring-db-ido-mysql > > Thanks. > Regards, > > -- > Muhammad Panji > http://www.panji.web.id > http://www.kurungsiku.com > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.icinga.org/pipermail/icinga-users/attachments/20160204/6bb260c7/attachment.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > icinga-users mailing list > [email protected] > https://lists.icinga.org/mailman/listinfo/icinga-users > > > ------------------------------ > > End of icinga-users Digest, Vol 26, Issue 8 > ******************************************* > > ------------------------------ > > Message: 3 > Date: Fri, 5 Feb 2016 09:47:48 +0700 > From: Muhammad Panji <[email protected]> > To: "Icinga User's Corner" <[email protected]> > Subject: Re: [icinga-users] icinga-users Digest, Vol 26, Issue 8 > Message-ID: > <canbzdhn61xp2st6q4s6r3voywm9ejtmnbmtu-_h-h8i-dq0...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > >> On Fri, Feb 5, 2016 at 1:04 AM, Laura DiMauro <[email protected]> wrote: >> >> Hello, >> Yes, I did the steps you mentioned below without a problem and I checked >> my users and passwords to make sure everything looked ok. >> I did forget about a step that I did yesterday. I did the 'upgrading the >> mysql database' part as well. It said to apply all database schema upgrade >> files incrementally. I saw the following in >> /usr/share/icinga2-ido-mysql/schema/upgrade: >> 2.0.2.sql 2.1.0.sql 2.2.0.sql 2.3.0.sql 2.4.0.sql >> >> I followed the instructions and used the following command for each >> version: >> mysql -u root -p icinga < >> /usr/share/icinga2-ido-mysql/schema/upgrade/<version>.sql >> >> After I did the first version it gave me the following error: >> ERROR 1060 (42S21) at line 10: Duplicate column name 'endpoint_name' >> >> Should I not have completed this as part of my first icinga2 installation? >> >> I only import sql on schema folder and not import anything on upgrade > folder. Did you do upgrade from previous version or fresh install? > Regards, > > > > > > > -- > Muhammad Panji > http://www.panji.web.id > http://www.kurungsiku.com > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.icinga.org/pipermail/icinga-users/attachments/20160205/4edd5556/attachment-0001.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > icinga-users mailing list > [email protected] > https://lists.icinga.org/mailman/listinfo/icinga-users > > > ------------------------------ > > End of icinga-users Digest, Vol 26, Issue 12 > ******************************************** > _______________________________________________ > icinga-users mailing list > [email protected] > https://lists.icinga.org/mailman/listinfo/icinga-users --? Michael Friedrich, DI (FH) Senior Developer NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg Tel: +49 911 92885-0 | Fax: +49 911 92885-77 CEO: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 http://www.netways.de | [email protected] ** OSDC 2016 - April - netways.de/osdc ** ** OSBConf 2016 - September - osbconf.org ** ------------------------------ Subject: Digest Footer _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users ------------------------------ End of icinga-users Digest, Vol 26, Issue 23 ******************************************** _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
