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?
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
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
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'
Checked the status, looks like some of the DB stuff is missing!
[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.
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
mysqldump -nt -unagiosna -pnagiosna nagiosna > /tmp/nagiosna-data.sql
mysql -unagiosna -pnagiosna nagiosna < nagiosna.sql
mysql -unagiosna -pnagiosna nagiosna < /tmp/nagiosna-data.sql
Then try restarting nagiosna.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Woot! That fixed it, guess I'll follow the exact same steps for the one I am building in the other datacenter and then make sure everything works and place the order
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
BanditBBS wrote:Woot! That fixed it, guess I'll follow the exact same steps for the one I am building in the other datacenter and then make sure everything works and place the order