[Commits] Rev 88: MBug#674413: Misconfigured debian-sys-maint user, warnings from default my.cnf in http://bazaar.launchpad.net/~maria-captains/maria/5.1

knielsen at knielsen-hq.org knielsen at knielsen-hq.org
Fri Nov 19 15:39:33 EET 2010


At http://bazaar.launchpad.net/~maria-captains/maria/5.1

------------------------------------------------------------
revno: 88
revision-id: knielsen at knielsen-hq.org-20101119133933-wb5g8sdjynao018w
parent: sergii at pisem.net-20101101082355-iz0bl4bjqjvhl8yq
committer: knielsen at knielsen-hq.org
branch nick: ourdelta-montyprogram-fixes
timestamp: Fri 2010-11-19 14:39:33 +0100
message:
  MBug#674413: Misconfigured debian-sys-maint user, warnings from default my.cnf
  
  Fix two problems reported in MBug#674413:
  
   - The debian-sys-maint account was not created, due to new field auth_string
     added in mysql.user in 5.2 with no default value and postinst script
     not updated.
  
   - Default my.cnf in 5.1+ uses log_slow_admin_statements without enabling
     the slow log, causing warnings. Fix by commenting out this by default.
=== modified file 'bakery/debian-5.1/additions/my.cnf'
--- a/bakery/debian-5.1/additions/my.cnf	2009-10-28 23:15:05 +0000
+++ b/bakery/debian-5.1/additions/my.cnf	2010-11-19 13:39:33 +0000
@@ -6,7 +6,6 @@
 # 2009-10-07
 #
 # This is *not* an optimised config, merely a more sane baseline:
-# - binary and slow log enabled, with enhancements
 # - InnoDB default (e.g., ACID out-of-the-box, same as on Windows)
 # - strict mode (for proper input checks, same as on Windows)
 # - various other useful settings
@@ -117,14 +116,15 @@ query_cache_size		= 64M
 # we do want to know about network errors and such
 log_warnings            = 2
 #
-# Here you can see queries with especially long duration
-log_slow_file           = /var/log/mysql/mariadb-slow.log
+# Enable the slow query log to see queries with especially long duration
+#slow_query_log[={0|1}]
+slow_query_log_file     = /var/log/mysql/mariadb-slow.log
 long_query_time = 10
 #log_slow_rate_limit    = 1000
 log_slow_verbosity      = query_plan
 
 #log-queries-not-using-indexes
-log_slow_admin_statements
+#log_slow_admin_statements
 #
 # The following can be used as easy to replay backup logs or for replication.
 # note: if you are setting up a replication slave, see README.Debian about

=== modified file 'bakery/debian-5.2/additions/my.cnf'
--- a/bakery/debian-5.2/additions/my.cnf	2010-03-11 04:27:08 +0000
+++ b/bakery/debian-5.2/additions/my.cnf	2010-11-19 13:39:33 +0000
@@ -6,7 +6,6 @@
 # 2009-10-07
 #
 # This is *not* an optimised config, merely a more sane baseline:
-# - binary and slow log enabled, with enhancements
 # - InnoDB default (e.g., ACID out-of-the-box, same as on Windows)
 # - strict mode (for proper input checks, same as on Windows)
 # - various other useful settings
@@ -117,14 +116,15 @@ query_cache_size		= 64M
 # we do want to know about network errors and such
 log_warnings            = 2
 #
-# Here you can see queries with especially long duration
-log_slow_file           = /var/log/mysql/mariadb-slow.log
+# Enable the slow query log to see queries with especially long duration
+#slow_query_log[={0|1}]
+slow_query_log_file     = /var/log/mysql/mariadb-slow.log
 long_query_time = 10
 #log_slow_rate_limit    = 1000
 log_slow_verbosity      = query_plan
 
 #log-queries-not-using-indexes
-log_slow_admin_statements
+#log_slow_admin_statements
 #
 # The following can be used as easy to replay backup logs or for replication.
 # note: if you are setting up a replication slave, see README.Debian about

=== modified file 'bakery/debian-5.2/dist/Debian/mariadb-server-5.2.postinst'
--- a/bakery/debian-5.2/dist/Debian/mariadb-server-5.2.postinst	2010-03-18 11:07:22 +0000
+++ b/bakery/debian-5.2/dist/Debian/mariadb-server-5.2.postinst	2010-11-19 13:39:33 +0000
@@ -205,7 +205,9 @@ EOF
         "  Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', "\
         "  Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', "\
         "  Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y',"\
-        "  ssl_cipher='', x509_issuer='', x509_subject='';"`;
+        "  ssl_type='', ssl_cipher='', x509_issuer='', x509_subject='',"\
+        "  max_questions=0, max_updates=0, max_connections=0,"\
+        "  max_user_connections=0, plugin='', auth_string='';"`;
     # Engines supported by etch should be installed per default. The query sequence is supposed
     # to be aborted if the CREATE TABLE fails due to an already existent table in which case the
     # admin might already have chosen to remove one or more plugins. Newlines are necessary.

=== modified file 'bakery/debian-5.2/dist/Ubuntu/mariadb-server-5.2.postinst'
--- a/bakery/debian-5.2/dist/Ubuntu/mariadb-server-5.2.postinst	2010-03-18 11:07:22 +0000
+++ b/bakery/debian-5.2/dist/Ubuntu/mariadb-server-5.2.postinst	2010-11-19 13:39:33 +0000
@@ -206,7 +206,9 @@ EOF
         "  Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', "\
         "  Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', "\
         "  Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y',"\
-        "  ssl_cipher='', x509_issuer='', x509_subject='';"`;
+        "  ssl_type='', ssl_cipher='', x509_issuer='', x509_subject='',"\
+        "  max_questions=0, max_updates=0, max_connections=0,"\
+        "  max_user_connections=0, plugin='', auth_string='';"`;
     # Engines supported by etch should be installed per default. The query sequence is supposed
     # to be aborted if the CREATE TABLE fails due to an already existent table in which case the
     # admin might already have chosen to remove one or more plugins. Newlines are necessary.

=== modified file 'bakery/debian-5.3/additions/my.cnf'
--- a/bakery/debian-5.3/additions/my.cnf	2010-11-01 08:23:55 +0000
+++ b/bakery/debian-5.3/additions/my.cnf	2010-11-19 13:39:33 +0000
@@ -6,7 +6,6 @@
 # 2009-10-07
 #
 # This is *not* an optimised config, merely a more sane baseline:
-# - binary and slow log enabled, with enhancements
 # - InnoDB default (e.g., ACID out-of-the-box, same as on Windows)
 # - strict mode (for proper input checks, same as on Windows)
 # - various other useful settings
@@ -117,14 +116,15 @@ query_cache_size		= 64M
 # we do want to know about network errors and such
 log_warnings            = 2
 #
-# Here you can see queries with especially long duration
-log_slow_file           = /var/log/mysql/mariadb-slow.log
+# Enable the slow query log to see queries with especially long duration
+#slow_query_log[={0|1}]
+slow_query_log_file     = /var/log/mysql/mariadb-slow.log
 long_query_time = 10
 #log_slow_rate_limit    = 1000
 log_slow_verbosity      = query_plan
 
 #log-queries-not-using-indexes
-log_slow_admin_statements
+#log_slow_admin_statements
 #
 # The following can be used as easy to replay backup logs or for replication.
 # note: if you are setting up a replication slave, see README.Debian about

=== modified file 'bakery/debian-5.3/dist/Debian/mariadb-server-5.3.postinst'
--- a/bakery/debian-5.3/dist/Debian/mariadb-server-5.3.postinst	2010-11-01 08:23:55 +0000
+++ b/bakery/debian-5.3/dist/Debian/mariadb-server-5.3.postinst	2010-11-19 13:39:33 +0000
@@ -205,7 +205,9 @@ EOF
         "  Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', "\
         "  Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', "\
         "  Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y',"\
-        "  ssl_cipher='', x509_issuer='', x509_subject='';"`;
+        "  ssl_type='', ssl_cipher='', x509_issuer='', x509_subject='',"\
+        "  max_questions=0, max_updates=0, max_connections=0,"\
+        "  max_user_connections=0, plugin='', auth_string='';"`;
     # Engines supported by etch should be installed per default. The query sequence is supposed
     # to be aborted if the CREATE TABLE fails due to an already existent table in which case the
     # admin might already have chosen to remove one or more plugins. Newlines are necessary.

=== modified file 'bakery/debian-5.3/dist/Ubuntu/mariadb-server-5.3.postinst'
--- a/bakery/debian-5.3/dist/Ubuntu/mariadb-server-5.3.postinst	2010-11-01 08:23:55 +0000
+++ b/bakery/debian-5.3/dist/Ubuntu/mariadb-server-5.3.postinst	2010-11-19 13:39:33 +0000
@@ -206,7 +206,9 @@ EOF
         "  Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', "\
         "  Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', "\
         "  Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y',"\
-        "  ssl_cipher='', x509_issuer='', x509_subject='';"`;
+        "  ssl_type='', ssl_cipher='', x509_issuer='', x509_subject='',"\
+        "  max_questions=0, max_updates=0, max_connections=0,"\
+        "  max_user_connections=0, plugin='', auth_string='';"`;
     # Engines supported by etch should be installed per default. The query sequence is supposed
     # to be aborted if the CREATE TABLE fails due to an already existent table in which case the
     # admin might already have chosen to remove one or more plugins. Newlines are necessary.



More information about the commits mailing list