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

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Nayananr
Posts: 19
Joined: Wed Mar 18, 2020 4:29 am

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

Post 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.
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

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

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Nayananr
Posts: 19
Joined: Wed Mar 18, 2020 4:29 am

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

Post 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
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

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

Post by scottwilkerson »

Let's skip the ndoutils install completely

Code: Select all

cd /tmp/nagiosxi
cat /dev/null > /tmp/nagiosxi/subcomponents/ndoutils/install
./fullinstall
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Nayananr
Posts: 19
Joined: Wed Mar 18, 2020 4:29 am

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

Post 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'
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

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

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked