Nagios Support Forum

Code: Select all

Running 'backend'...
backend step completed OK
Running 'db'...
Redirecting to /bin/systemctl restart mariadb.service
ERROR 1007 (HY000) at line 1: Can't create database 'nagiosna'; database exists
ERROR: could not create database. Invalid root MySQL password?

Code: Select all

    prompt_mysqlpass
    {
        echo "CREATE DATABASE nagiosna; "
        echo -n "CREATE USER 'nagiosna'@'localhost' IDENTIFIED BY 'nagiosna'; "
        echo -n "GRANT ALL ON nagiosna.* TO 'nagiosna'@'localhost';"
    } | mysql -u root ${mysqlpass:+"-p$mysqlpass"} ||
    error "could not create database. Invalid root MySQL password?"

    # Create tables and add some fixtures
    mysql -unagiosna -pnagiosna nagiosna < nagiosna.sql

Code: Select all

wkhtmltopdf step completed OK
Running 'webroot'...
Created symlink /etc/systemd/system/multi-user.target.wants/httpd.service → /usr/lib/systemd/system/httpd.service.
webroot step completed OK
Running 'daemons'...
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
Synchronizing state of nagiosna.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable nagiosna
Created symlink /etc/systemd/system/multi-user.target.wants/nagiosna.service → /usr/lib/systemd/system/nagiosna.service.
Job for nagiosna.service failed because the control process exited with error code.
See "systemctl status nagiosna.service" and "journalctl -xe" for details.

===================
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 Enterprises technical support.

The step that failed was: 'daemons'

Code: Select all

[root@cms-365-nna01 nagiosna]# systemctl status nagiosna.service
● nagiosna.service - NagiosNA Daemon
   Loaded: loaded (/usr/lib/systemd/system/nagiosna.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2021-03-10 17:57:32 PST; 2min 13s ago
  Process: 89326 ExecStart=/etc/rc.d/init.d/nagiosna start (code=exited, status=1/FAILURE)

Mar 10 17:57:31 cms-365-nna01.itciss.com systemd[1]: Starting NagiosNA Daemon...
Mar 10 17:57:32 cms-365-nna01.itciss.com nagiosna[89326]: Error connecting to the database. (1146, "Table 'nagiosna.nagiosna_Sources' doesn't exist")
Mar 10 17:57:32 cms-365-nna01.itciss.com systemd[1]: nagiosna.service: Control process exited, code=exited status=1
Mar 10 17:57:32 cms-365-nna01.itciss.com systemd[1]: nagiosna.service: Failed with result 'exit-code'.
Mar 10 17:57:32 cms-365-nna01.itciss.com systemd[1]: Failed to start NagiosNA Daemon.

Code: Select all

mysqldump -nt -unagiosna -pnagiosna nagiosna > /tmp/nagiosna-data.sql
mysql -unagiosna -pnagiosna nagiosna < nagiosna.sql
mysql -unagiosna -pnagiosna nagiosna < /tmp/nagiosna-data.sql