Page 1 of 1

ERROR 1007 (HY000) at line 1: Can't create database 'nagios'

Posted: Wed Mar 18, 2020 4:40 am
by Nayananr
install.log
Hi,
I am trying to install Nagios XI in Ubuntu-16.04 LTS and fallowing the link below..
Link : https://assets.nagios.com/downloads/nag ... -Linux.pdf

I have got below ERROR while installing:
INSTALL: POST-INSTALL: Starting NDOUtils post install...
kernel.msgmnb = 131072000
kernel.msgmax = 131072000
kernel.shmmax = 4294967295
kernel.shmall = 268435456
NOTE: If prompted, enter the MySQL root password
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1007 (HY000) at line 1: Can't create database 'nagios'; database exists
ERROR: Subcomponent 'ndoutils' installation failed - exiting.
Subcomponents installation failed - exiting

Can any one guide me further to resolve the issue.

Attached below install.log.

Re: ERROR 1007 (HY000) at line 1: Can't create database 'nag

Posted: Wed Mar 18, 2020 7:48 am
by scottwilkerson
Looks like this was already ran past this point before

Let's do the following to skip this step

Code: Select all

cd /tmp/nagiosxi
cat /dev/null > /tmp/nagiosxi/subcomponents/ndoutils/post-install
./fullinstall

Re: ERROR 1007 (HY000) at line 1: Can't create database 'nag

Posted: Wed Mar 18, 2020 10:47 pm
by Nayananr
Hi,
Thanks for the reply, i have tried to suggestions.... but still i am facing the issue as shown below.

ERROR: NDOUtils database install appears to have failed - exiting.
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'

Regards,
Nayana

Re: ERROR 1007 (HY000) at line 1: Can't create database 'nag

Posted: Fri Mar 20, 2020 7:13 am
by scottwilkerson
Let's skip the ndoutils install completely

Code: Select all

cd /tmp/nagiosxi
cat /dev/null > /tmp/nagiosxi/subcomponents/ndoutils/install
./fullinstall

Re: ERROR 1007 (HY000) at line 1: Can't create database 'nag

Posted: Fri Mar 20, 2020 10:15 am
by Nayananr
Hi ,

ERROR: Subcomponent 'ccm' 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'

Re: ERROR 1007 (HY000) at line 1: Can't create database 'nag

Posted: Fri Mar 20, 2020 10:30 am
by scottwilkerson
It failed with this error

Code: Select all

ERROR 1819 (HY000) at line 3: Your password does not satisfy the current policy requirements
From the install guide
Important: Nagios Enterprises highly recommends and will only support installing Nagios XI on a newly installed, "clean" system (a bare minimal install with nothing else installed or configured).
https://assets.nagios.com/downloads/nag ... -Linux.pdf

You should not implement restrictions before installing the application, you should be starting with a clean minimal install system