[SOLVED] ESET Remote Administrator Server - Database issue

Hi.

I'm supposed to install ERAS on one of my servers, and have decided to go with a MySQL database, because of some compatibility issues with other software. The problem is that during my install, when trying to populate the database, I receive the following error:

It is not possible to store big blocks of data in the database. Please reconfigure the database server first.

As far as I can tell from other posts I've found, this should be caused by a bad value at max_allowed_packet in the my.ini-file. I've changed this to the recommended 256M (must be above 33M) and restarted the service, and the OS, but the error still persists.

MySQL Server 5.7 is compatible with the latest ERAS versions, as far as I can tell, so that should not be an issue.

I converted the my.ini to a txt file, so you can go through the configuration here.

Thank you, in advance,
Mr.Moseng

Finally solved this one! Took a lot of digging, but now it's installed, tested, and it's working properly.

There are a few things that needs to be done to make this work:
First of all, make sure to use the correct my.ini file. The default location is C:\ProgramData\MySQL\MySQL Server 5.7\
Do not confuse this path with the C:\Program Files\MySQL\MySQL Server 5.7\, where there also is a my.ini file located.

When you have located the correct my.ini file, set the following parameters:
For MySQL 5.6.20 and later - innodb_log_file_size needs to be set to at least 200MB
For MySQL >= 5.6.22 - innodb_log_file_size*innodb_log_files_in_group needs to be set to at least 200MB. * is multiplication, a product of the two parameters must be >= 200MB.

The test has been preformed on a Windows Server 2012R2 server, and is planned to be installed on a 2008R2 server, with less resources. I might also do a small reply on the result from the older, less spiced server.

Bw,
Mr. Moseng

Since you're a system admin and there are not many of us here that can help you, I'll point you over to http://www.reddit.com/r/sysadmin