Max size for csv export / download

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Locked
jabi27
Posts: 34
Joined: Thu Jan 19, 2017 4:30 pm

Max size for csv export / download

Post by jabi27 »

Hi,

We need to export a large amount of logs (> 1 mio logs) and trying to use "export as csv". The session stops after a while and Nagios become "dead" However just dead for the exporting user. Other users can still enjoy Nagios.

Can this be done or should we do it in an other way?

Best and thanks

/Jan
User avatar
jdunitz
Posts: 235
Joined: Wed Feb 05, 2020 2:50 pm

Re: Max size for csv export / download

Post by jdunitz »

You might start by increasing the limits in php.ini, as described here:

https://support.nagios.com/kb/article/n ... e-611.html

You can also consider enabling output buffering in php.ini.

The document is for XI, but the same things should apply to Log Server as well.

Let me know if that makes a difference!

--Jeffrey
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
jabi27
Posts: 34
Joined: Thu Jan 19, 2017 4:30 pm

Re: Max size for csv export / download

Post by jabi27 »

Hi Jeffrey

I will ask the manager to raise the limit in ini.php.

Is it possible to query the database itself ?

Best and thanks

/Jan
User avatar
jdunitz
Posts: 235
Joined: Wed Feb 05, 2020 2:50 pm

Re: Max size for csv export / download

Post by jdunitz »

Sure, if you want to query elasticsearch directly, you can. You could do it via the API, or use something like elasticdump.

Then you'd have to do some post-processing to turn it into a CSV. Unless you don't specifically need it as a CSV, of course...

Hope that helps!

--Jeffrey
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked