hi, a couple of minutes ago my ubuntu brought up some updates in which I was asked to replace my /etc/mysql/my.cnf file with the new one. I use Ubuntu 12.04.2 LTS (Precise Pangolin)) ISPConfig 3.0.5.1 The changes show the following: Code: 45 # 46 # Instead of skip-networking the default is now to listen only on 47 # localhost which is more compatible and is not less secure. 48-#bind-address = 127.0.0.1 +bind-address = 127.0.0.1 49 # 50 # * Fine Tuning 51 # […] 73 #general_log_file = /var/log/mysql/mysql.log 74 #general_log = 1 75 # 76-# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. +# Error log - should be very few entries. +# +log_error = /var/log/mysql/error.log 77 # 78 # Here you can see queries with especially long duration 79 #log_slow_queries = /var/log/mysql/mysql-slow.log well I know that bind-address should be as it was commented out Code: #bind-address = 127.0.0.1 but what about this new entry ?: Code: log_error = /var/log/mysql/error.log what shall I do with it ? temporarily I got it commented out thanks for your great help! edit: these should be the updates: Code: Data from: 2013-03-04 01:00 Reading package lists... Building dependency tree... Reading state information... The following packages will be upgraded: evince evince-common libevince3-3 libmysqlclient18 mysql-client mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5 11 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Inst mysql-common [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [all]) Inst libmysqlclient18 [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Inst mysql-server [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [all]) Conf mysql-common (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [all]) Inst mysql-server-5.5 [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) [] Inst mysql-client [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [all]) [] Inst mysql-client-5.5 [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) [] Inst mysql-client-core-5.5 [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) [] Inst mysql-server-core-5.5 [5.5.29-0ubuntu0.12.04.1] (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Inst evince [3.4.0-0ubuntu1.4] (3.4.0-0ubuntu1.5 Ubuntu:12.04/precise-updates [i386]) [] Inst libevince3-3 [3.4.0-0ubuntu1.4] (3.4.0-0ubuntu1.5 Ubuntu:12.04/precise-updates [i386]) Inst evince-common [3.4.0-0ubuntu1.4] (3.4.0-0ubuntu1.5 Ubuntu:12.04/precise-updates [all]) Conf libmysqlclient18 (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Conf mysql-client-core-5.5 (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Conf mysql-client-5.5 (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Conf mysql-server-core-5.5 (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Conf mysql-server-5.5 (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [i386]) Conf mysql-server (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [all]) Conf mysql-client (5.5.29-0ubuntu0.12.04.2 Ubuntu:12.04/precise-updates [all]) Conf libevince3-3 (3.4.0-0ubuntu1.5 Ubuntu:12.04/precise-updates [i386]) Conf evince-common (3.4.0-0ubuntu1.5 Ubuntu:12.04/precise-updates [all]) Conf evince (3.4.0-0ubuntu1.5 Ubuntu:12.04/precise-updates [i386])
Dont think the error log entry will do much. You can just comment out the bind and go ahead with rest of changes. If error log grows much, just comment that out too. Nothing critical is lost by not having it.
Thanks for the reply Norman, ..so you think this error log change won't conflict with ispconfig in some way ? thanks
