Wednesday, November 18, 2015

Debian 8 and Varnish 4 Problem

The Varnish service was starting OK but it wasn't using any of the parameters, set in /etc/default/varnish.

For example, set the listening port to be 80, but Varnish would always start with port 6081.

The Varnish service (/lib/systemd/system/varnish.service) wasn't using any parameter files - instead it was hard coded to start with the default values only.

The temporary fix is to edit the varnish.service file and manually configure the parameters to match your needs.

reference: https://www.varnish-cache.org/forum/topic/5206

Thursday, November 12, 2015

Disable MySQL Strict mode in Debian 8 permanently

All blogs say:

 for turning off strict mode you must add following line to /etc/mysql/my.cnf:

sql_mode=""

and restart the mysql server.

That was not working me.

I have found another setting file for mysql: /usr/my.cnf

and in this file exists sql_mode parameter too.

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

this line must be commented out too:

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Don't forget to restart the mysql server.