Page 1 of 1
Database error occured
Posted: Wed Mar 02, 2016 7:00 am
by operations_asavie
Hi,
I am trying to install Network Analyzer, output is telling me the Installation is a success but can see this error in the console. Can you please help me with this?
<body>
<div id="container">
<h1>A Database Error Occurred</h1>
<p>Unable to connect to your database server using the provided settings.</p><p>Filename: core/Loader.php</p><p>Line Number: 346</p> </div>
</body>
</html>
Nagios Network Analyzer Installation Success!
You can finish the final setup steps for Nagios Network Analyzer by visiting:
http://172.17.X.XXX/nagiosna/
Re: Database error occured
Posted: Wed Mar 02, 2016 10:55 am
by bwallace
What version of CentOS or Red Hat was NNA installed on, and are these 'clean' systems with nothing else installed or configured?
Also, the Nagios Network Analyzer requires PHP version 5.3 or higher - refer to our install doc is you haven't already:
https://assets.nagios.com/downloads/nag ... ctions.pdf
If everything checks out, then lets gather some info. Please provide the following with your next reply, thanks!
Code: Select all
tail -n 100 /var/log/messages
tail -n 100 /var/log/httpd/error_log
df -h
echo "use nagiosna; show table status;" | mysql > /tmp/table_status_nagiosna.txt
Re: Database error occured
Posted: Wed Mar 02, 2016 11:15 am
by operations_asavie
See below and attached for the answers to your questions. Can you please get back to me on this ASAP?
Red Hat Enterprise Linux 6 was used, it's a clean system with only Nagios XI running.
[root@NAG-IXDUB-02 nagiosna]# php --version
PHP 5.3.3 (cli) (built: Feb 9 2016 10:36:17)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
[root@NAG-IXDUB-02 nagiosna]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_nagixdub02-lv_root
14G 5.5G 7.5G 43% /
tmpfs 7.7G 0 7.7G 0% /dev/shm
/dev/sda1 477M 83M 369M 19% /boot
tmpfs 500M 0 500M 0% /var/nagiosramdisk
[root@NAG-IXDUB-02 nagiosna]# echo "use nagiosna; show table status;" | mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Re: Database error occured
Posted: Wed Mar 02, 2016 12:01 pm
by bwallace
Thanks for that info, the problem is you've installed NNA on a server already running Nagios XI. This is not supported and each must be installed on their own server. Hopefully you have another server available on which to install NNA and more importantly, this will not cause problems with your existing XI installation. To avoid the latter, definitely remove anything NNA related from this server.
Re: Database error occured
Posted: Wed Mar 02, 2016 12:05 pm
by operations_asavie
Can you detail to me how to uninstall Network Analyzer from the server please?
Re: Database error occured
Posted: Wed Mar 02, 2016 12:39 pm
by bwallace
Here you go --
1) delete the nagiosna directory and all of it's sub directories
.../usr/local/nagiosna
2) delete nagiosna from init.d
.../etc/rc.d/init.d/nagiosna
3) in /tmp delete all 'nagiosna' items
Afterwards, check if anything else remains, run:
find -name nagiosna