Page 1 of 1

Max size for csv export / download

Posted: Wed Mar 25, 2020 7:32 am
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

Re: Max size for csv export / download

Posted: Wed Mar 25, 2020 9:53 am
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

Re: Max size for csv export / download

Posted: Thu Mar 26, 2020 4:49 am
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

Re: Max size for csv export / download

Posted: Thu Mar 26, 2020 4:26 pm
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