ERROR 1396 (HY000) at line 3: Operation CREATE USER failed f

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
fraguillen
Posts: 47
Joined: Fri May 18, 2018 11:40 am

ERROR 1396 (HY000) at line 3: Operation CREATE USER failed f

Post by fraguillen »

ERROR 1396 (HY000) at line 3: Operation CREATE USER failed for 'ndoutils'@'localhost'

I uninstalled the Nagiosxi, I uninstalled Mariadb and I deleted the directories /var/lib/mysql/nagios, /usr/local/nagios and when I ran the full installation of version 5.5.2 (I also tried previous versions) and it gave me the error that I show below, reviewing I see that only the nagios database was created but the tables were not created, so when it comes to creating the user ndoutils can not create it because there are no tables for it to do so.

What should I review to correct this problem?

Best regards...

INSTALL: POST-INSTALL: Starting NDOUtils post install...
kernel.msgmnb = 262144000
kernel.msgmax = 262144000
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.msgmni = 512000
NOTE: If prompted, enter the MySQL root password
ERROR 1396 (HY000) at line 3: Operation CREATE USER failed for 'ndoutils'@'localhost'
ERROR: Subcomponent 'ndoutils' installation failed - exiting.
Subcomponents installation failed - exiting
RESULT=1

===================
INSTALLATION ERROR!
===================
Installation step failed - exiting.
Check for error messages in the install log (install.log).

If you require assistance in resolving the issue, please include install.log
in your communications with Nagios XI technical support.

The script that failed was: './A-subcomponents'
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: ERROR 1396 (HY000) at line 3: Operation CREATE USER fail

Post by lmiltchev »

Nagios XI installs are supported only on "clean" systems.
Important: 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.
https://assets.nagios.com/downloads/nag ... stallation

Having said that, we could try to recreate the issue in house, and find a workaround for you. Can you provide us with all of the commands that you used to uninstall the "old" Nagios XI server? Also, post the entire install.log file.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked