Configuration Wizard: MSSQL Database Error

[radoslaw95]

Hello,

Our admin team has recently ran into some issues with setting up monitoring for our MSSQL databases. It worked fine for a while however the more we added, the worse it got. We configure the monitoring for Connection Time, Database Size, Log file usage, log growths and log shrinks. After configuring the settings and clicking finish, there is a long wait on the screen saying "waiting for configuration verification..." followed by a screen with an error saying "Configuration failed to write to file". Nothing has been changed recently since we started working on this and we cannot find any cause for this error suddenly appearing, we are all using google chrome and Nagios XI 5.4.13.

[lmiltchev]

It would recommend starting with increasing the resource limits in the php.ini file as most probably you are running into timeouts. Edit the /etc/php.ini file and change the following from this:

Code: Select all

max_execution_time = 30
max_input_time = 60
memory_limit = 128M

to this:

Code: Select all

max_execution_time = 120
max_input_time = 240
memory_limit = 1024M

Add this to the bottom of that file

Code: Select all

max_input_vars=100000

Save the file and exit. Next, edit /etc/httpd/conf/httpd.conf by adding this to the bottom of that file:

Code: Select all

LimitRequestLine 100000

Save, exit and restart apache:

Code: Select all

service httpd restart

Let us know if this helped.

[radoslaw95]

Seems to be working now, thank you.

[lmiltchev]

I am glad I could help!