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
Wednesday, November 18, 2015
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.
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.
Subscribe to:
Posts (Atom)