Database error occured

This support forum board is for support questions relating to Nagios Network Analyzer, our network traffic and bandwidth analysis solution.
Locked
operations_asavie
Posts: 33
Joined: Tue Dec 22, 2015 7:07 am

Database error occured

Post 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/
bwallace
Posts: 1145
Joined: Tue Nov 17, 2015 1:57 pm

Re: Database error occured

Post 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
Be sure to check out the Knowledgebase for helpful articles and solutions!
operations_asavie
Posts: 33
Joined: Tue Dec 22, 2015 7:07 am

Re: Database error occured

Post 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)
bwallace
Posts: 1145
Joined: Tue Nov 17, 2015 1:57 pm

Re: Database error occured

Post 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.
Be sure to check out the Knowledgebase for helpful articles and solutions!
operations_asavie
Posts: 33
Joined: Tue Dec 22, 2015 7:07 am

Re: Database error occured

Post by operations_asavie »

Can you detail to me how to uninstall Network Analyzer from the server please?
bwallace
Posts: 1145
Joined: Tue Nov 17, 2015 1:57 pm

Re: Database error occured

Post 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
Be sure to check out the Knowledgebase for helpful articles and solutions!
Locked