Nagios Support Forum

lmiltchev wrote:Try:

Code: Select all

mysql -h 10.200.1.152 -u nagios -pnagios nagios -e 'TRUNCATE TABLE nagios_logentries'

from the Nagios XI server or ssh into the offloaded mysql server, and run the command locally:

Code: Select all

mysql -u nagios -pnagios nagios -e 'TRUNCATE TABLE nagios_logentries'

[root@NagiosXI nagiosxi]# grep ndoutils -5 /usr/local/nagiosxi/html/config.inc.php |grep pwd
"pwd" => 'xxxxxx',

mysql -h 10.200.1.152 -u nagios -pxxxxxx nagios -e 'TRUNCATE TABLE nagios_logentries'

mysql -h 10.200.1.152 -u nagios -pwelcome nagios -e 'TRUNCATE TABLE nagios_logentries'

lmiltchev wrote:Is your password "nagios"? You didn't actually show it, so I am not sure...

[root@NagiosXI nagiosxi]# grep ndoutils -5 /usr/local/nagiosxi/html/config.inc.php |grep pwd
"pwd" => 'xxxxxx',

You need to use the actual password as defined in the /usr/local/nagiosxi/html/config.inc.php file.

Run:

Code: Select all

mysql -h 10.200.1.152 -u nagios -pxxxxxx nagios -e 'TRUNCATE TABLE nagios_logentries'

substituting "xxxxxx" with your actual password. For example, if your password was "welcome", you would run:

Code: Select all

mysql -h 10.200.1.152 -u nagios -pwelcome nagios -e 'TRUNCATE TABLE nagios_logentries'

I also hope that you followed all of the steps, outlined in our document here: https://assets.nagios.com/downloads/nag ... Server.pdf, granting permissions, testing the connection, etc. I would recommend that you double check that.

jatindeepsharma wrote:

lmiltchev wrote:Is your password "nagios"? You didn't actually show it, so I am not sure...

[root@NagiosXI nagiosxi]# grep ndoutils -5 /usr/local/nagiosxi/html/config.inc.php |grep pwd
"pwd" => 'xxxxxx',

You need to use the actual password as defined in the /usr/local/nagiosxi/html/config.inc.php file.

Run:

Code: Select all

mysql -h 10.200.1.152 -u nagios -pxxxxxx nagios -e 'TRUNCATE TABLE nagios_logentries'

substituting "xxxxxx" with your actual password. For example, if your password was "welcome", you would run:

Code: Select all

mysql -h 10.200.1.152 -u nagios -pwelcome nagios -e 'TRUNCATE TABLE nagios_logentries'

I also hope that you followed all of the steps, outlined in our document here: https://assets.nagios.com/downloads/nag ... Server.pdf, granting permissions, testing the connection, etc. I would recommend that you double check that.

I have two servers, one is NagiosXI(10.200.1.150) & other is 10.200.1.152(nagiossql), I ran above command on nagios sql server but its providing me output as: