Yes, this machine was previously Nagios XI, but because of problems with access rights, it was decided to reinstall. I deleted all databases and configured MySQL. But error after error appears. With VMWare, can I clear everything and write Nagios XI again?npolovenko wrote:@SysErrors, I wonder why you already had the Nagios xi database. Did you used to have another XI on that same system? I highly recommend wiping the whole system instead and installing Nagios XI from a clean state. We also have VMWare images on the website that you can use right out of the box.
Nagios XI install error
Re: Nagios XI install error
Re: Nagios XI install error
I'm using Nagios XI on Centos 7 and maybe there's a command to completely clean up everything that Nagios does?
-
npolovenko
- Support Tech
- Posts: 3457
- Joined: Mon May 15, 2017 5:00 pm
Re: Nagios XI install error
@SysErrors, There is a script for that:
https://assets.nagios.com/downloads/nag ... ios_XI.pdf
I still recommend completely wiping the system and starting from scratch, if possible. This can potentially save lots of time in the future when some small thing from the previous installation comes up.
By the way, do you need to keep the old service and hosts checks at all?
https://www.nagios.com/downloads/nagios-xi/
Essentially, our OVA is a precompiled Nagios XI virtual Machine that comes ready "out of the box".
https://assets.nagios.com/downloads/nag ... ios_XI.pdf
I still recommend completely wiping the system and starting from scratch, if possible. This can potentially save lots of time in the future when some small thing from the previous installation comes up.
By the way, do you need to keep the old service and hosts checks at all?
You'd just download a precompiled OVA and spin it up. No need to uninstall anything.With VMWare, can I clear everything and write Nagios XI again?
https://www.nagios.com/downloads/nagios-xi/
Essentially, our OVA is a precompiled Nagios XI virtual Machine that comes ready "out of the box".
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Nagios XI install error
I did everything according to your instructions. I downloaded the script to remove it and deleted everything. Then it again gives an error. Although I have reduced the password requests in MySQL.npolovenko wrote:@SysErrors, There is a script for that:
https://assets.nagios.com/downloads/nag ... ios_XI.pdf
I still recommend completely wiping the system and starting from scratch, if possible. This can potentially save lots of time in the future when some small thing from the previous installation comes up.
By the way, do you need to keep the old service and hosts checks at all?You'd just download a precompiled OVA and spin it up. No need to uninstall anything.With VMWare, can I clear everything and write Nagios XI again?
https://www.nagios.com/downloads/nagios-xi/
Essentially, our OVA is a precompiled Nagios XI virtual Machine that comes ready "out of the box".
Code: Select all
NOTE: If prompted, enter the MySQL root password
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1819 (HY000) at line 3: Your password does not satisfy the current policy requirements
ERROR: Subcomponent 'ndoutils' installation failed - exiting.
Subcomponents installation failed - exiting
RESULT=1
===================
INSTALLATION ERROR!
===================
Re: Nagios XI install error
Also, deleting the database by removing the plugin in mysql. I'm getting the old error.npolovenko wrote:@SysErrors, There is a script for that:
https://assets.nagios.com/downloads/nag ... ios_XI.pdf
I still recommend completely wiping the system and starting from scratch, if possible. This can potentially save lots of time in the future when some small thing from the previous installation comes up.
By the way, do you need to keep the old service and hosts checks at all?You'd just download a precompiled OVA and spin it up. No need to uninstall anything.With VMWare, can I clear everything and write Nagios XI again?
https://www.nagios.com/downloads/nagios-xi/
Essentially, our OVA is a precompiled Nagios XI virtual Machine that comes ready "out of the box".
Code: Select all
Checking MySQL status...
MySQL running - continuing...
Setting up Nagios XI database...
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1067 (42000) at line 25: Invalid default value for 'event_time'
ERROR: Nagios XI database was not setup properly - exiting.
RESULT=1
===================
INSTALLATION ERROR!
===================
Re: Nagios XI install error
I found the same problem on your forum, but it also received no response. How and where to fix "event_time" to get rid of this error?npolovenko wrote:@SysErrors, I wonder why you already had the Nagios xi database. Did you used to have another XI on that same system? I highly recommend wiping the whole system instead and installing Nagios XI from a clean state. We also have VMWare images on the website that you can use right out of the box.
https://support.nagios.com/forum/viewto ... 3&start=10
Re: Nagios XI install error
Nagios supports installing Nagios XI only on a newly installed, clean systems.
Since you already had Nagios XI installed on this server, I would strongly recommend removing ALL XI data, DBs, configs, etc. and start with a clean system. I believe you could remove all (or at least most of the old) data by running:
Next, install Nagios XI by running:
https://assets.nagios.com/downloads/nag ... stallationImportant: Nagios Enterprises highly recommends and will only support installing Nagios XI on a newly installed, "clean" system. Attempting to install Nagios XI on a pre-existing system with other applications already installed can cause the Nagios XI installation process to fail, critical system components and settings (e.g. database servers) to be modified in a way that negatively affects other applications, and previously installed applications to be automatically upgraded or removed. While installing XI on a system with other applications is possible, it is not recommended due to the possible interactions and complexity of multiple components that are required for Nagios XI to function. If you choose to ignore these warnings, you do so at your own risk.
Since you already had Nagios XI installed on this server, I would strongly recommend removing ALL XI data, DBs, configs, etc. and start with a clean system. I believe you could remove all (or at least most of the old) data by running:
Code: Select all
service nagios stop
service ndo2db stop
service npcd stop
rm -rf /etc/init.d/nagios /etc/init.d/npcd /etc/init.d/ndo2db
userdel -r nagios
groupdel nagcmd
rm -f /etc/sudoers.d/nagiosxi /etc/cron.d/nagiosxi
rm -rf /usr/local/nagios /usr/local/nagiosxi
rm -rf /etc/nagiosql /var/www/html/nagiosql /var/lib/mysql /var/lib/pgsql
rm -f /etc/httpd/conf.d/nagios.conf /etc/httpd/conf.d/nagiosxi.conf /etc/httpd/conf.d/nagiosql.conf /etc/httpd/conf.d/nrdp.conf
service httpd restart
rm -f /etc/xinetd.d/nrpe /etc/xinetd.d/nsca /etc/xinetd.d/nrdp
service xinetd restart
yum remove mysql postgresql -y
rm -rf /var/lib/mysql
rm -f /root/scripts/automysqlbackup
rm -f /root/scripts/autopostgresqlbackupCode: Select all
cd /tmp/nagiosxi
./fullinstall -n
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Nagios XI install error
I follow your full instructions. But I get an error. Thus, when selecting the second or the first component, there is a setup of MariaDB which conflicts for some reason.
Code: Select all
It looks like MySQL and MariaDB are available on your system. Please pick one:
1 - MariaDB (Default)
2 - MySQL Community
----------------------------------------
Which DB server would you like to use? [2]: 2
Загружены модули: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.omnilance.com
* epel: mirror.omnilance.com
* extras: mirror.omnilance.com
* updates: mirror.omnilance.com
Пакет mysql-community-devel-5.7.21-1.el7.x86_64 уже установлен, и это последняя версия.
Разрешение зависимостей
--> Проверка сценария
---> Пакет MariaDB-client.x86_64 0:5.5.59-1.el7.centos помечен для установки
--> Обработка зависимостей: MariaDB-common пакета: MariaDB-client-5.5.59-1.el7.centos.x86_64
---> Пакет mysql-community-server.x86_64 0:5.7.21-1.el7 помечен для установки
--> Обработка зависимостей: mysql-community-client(x86-64) >= 5.7.9 пакета: mysql-community-server-5.7.21-1.el7.x86_64
--> Проверка сценария
---> Пакет MariaDB-common.x86_64 0:5.5.59-1.el7.centos помечен для установки
---> Пакет mysql-community-client.x86_64 0:5.7.21-1.el7 помечен для установки
--> Проверка зависимостей окончена
Зависимости определены
================================================================================
Package Архитектура
Версия Репозиторий Размер
================================================================================
Установка:
MariaDB-client x86_64 5.5.59-1.el7.centos mariadb 8.6 M
mysql-community-server x86_64 5.7.21-1.el7 mysql57-community 164 M
Установка зависимостей:
MariaDB-common x86_64 5.5.59-1.el7.centos mariadb 23 k
mysql-community-client x86_64 5.7.21-1.el7 mysql57-community 24 M
Итого за операцию
================================================================================
Установить 2 пакета (+2 зависимых)
Общий размер: 197 M
Объем изменений: 889 M
Downloading packages:
Running transaction check
Running transaction test
Transaction check error:
file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/armscii8.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/ascii.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/cp1250.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/cp1256.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/cp1257.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/cp850.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/cp852.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/cp866.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/dec8.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/geostd8.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/greek.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/hebrew.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/hp8.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/keybcs2.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/koi8r.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/koi8u.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/latin1.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/latin2.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/latin5.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/latin7.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/macce.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/macroman.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/share/mysql/charsets/swe7.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
file /usr/bin/mysql conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqladmin conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqlbinlog conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqlcheck conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqldump conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqlimport conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqlshow conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/bin/mysqlslap conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysql.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqladmin.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqlbinlog.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqlcheck.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqldump.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqlimport.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqlshow.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /usr/share/man/man1/mysqlslap.1.gz conflicts between attempted installs of MariaDB-client-5.5.59-1.el7.centos.x86_64 and mysql-community-client-5.7.21-1.el7.x86_64
file /etc/my.cnf conflicts between attempted installs of mysql-community-server-5.7.21-1.el7.x86_64 and MariaDB-common-5.5.59-1.el7.centos.x86_64
file /usr/bin/mysql_plugin conflicts between attempted installs of mysql-community-server-5.7.21-1.el7.x86_64 and MariaDB-client-5.5.59-1.el7.centos.x86_64
file /usr/share/man/man1/mysql_plugin.1.gz conflicts between attempted installs of mysql-community-server-5.7.21-1.el7.x86_64 and MariaDB-client-5.5.59-1.el7.centos.x86_64
Сводка ошибок
-------------
RESULT=1
===================
INSTALLATION ERROR!
===================
Re: Nagios XI install error
Cleaned everything you can and where you can. Installation is underway. Missing the conflict MariaDB but after setting it produces an error
in the list installed
Code: Select all
Proceeding with installation...
Checking MySQL credentials...
MySQL not yet installed - that's okay.
Running './0-repos'...
Repos already configured - exiting.
RESULT=0
Running './1-prereqs'...
Prereqs already installed - skipping...
Note: If you want to update the RPMs installed on this system, run your package manager's update command
RESULT=0
Running './2-usersgroups'...
Users/groups already configured - skipping.
RESULT=0
Running './3-dbservers'...
MySQL installed OK - continuing...
Starting MySQL...
Redirecting to /bin/systemctl restart mariadb.service
Failed to restart mariadb.service: Unit not found.
ERROR: MySQL failed to start - exiting.
RESULT=1
===================
INSTALLATION ERROR!
===================
Code: Select all
MariaDB-Galera-server.x86_64 5.5.59-1.el7.centos @mariadb
MariaDB-client.x86_64 5.5.59-1.el7.centos @mariadb
MariaDB-common.x86_64 5.5.59-1.el7.centos @mariadb
MariaDB-devel.x86_64 5.5.59-1.el7.centos @mariadb
MariaDB-shared.x86_64 5.5.59-1.el7.centos @mariadb -
kyang
Re: Nagios XI install error
Try removing the mysql-community-commonfile /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-5.5.59-1.el7.centos.x86_64 conflicts with file from package mysql-community-common-5.7.21-1.el7.x86_64
Code: Select all
yum erase mysql-community-common.x86_64Code: Select all
yum erase mysql-community-common-5.7.21-1.el7.x86_64