Page 1 of 1

Configuration Wizard: MSSQL Database Error

Posted: Wed May 23, 2018 12:33 pm
by 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.

Re: Configuration Wizard: MSSQL Database Error

Posted: Wed May 23, 2018 1:20 pm
by 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.

Re: Configuration Wizard: MSSQL Database Error

Posted: Wed May 23, 2018 2:19 pm
by radoslaw95
Seems to be working now, thank you.

Re: Configuration Wizard: MSSQL Database Error

Posted: Wed May 23, 2018 3:32 pm
by lmiltchev
I am glad I could help! :)