percona 5.6 install on debian fails due to default config reference to /etc/mysql/conf.d
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Stewart Smith | |||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
High
|
Stewart Smith | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
The default install of percona server 5.6 fails on debian using apt-get. I think because the default config has a reference to bring in /etc/mysql/conf.d, but that directory does not exist and is not created if it does not.
Also - when I upgraded an existing 5.5 server, it appeared to remove the conf.d directory before the install of 5.6 so that did not work either.
The bottom of the default my.conf contains this:
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
output from install:
% sudo -i DEBIAN_
executing command
stdin: is not a tty
Reading package lists...
Building dependency tree...
Reading state information...
The following extra packages will be installed:
libaio1 libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl
libplrpc-perl percona-
Suggested packages:
tinyca
The following packages will be REMOVED:
mysql-common
The following NEW packages will be installed:
libaio1 libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
percona-
percona-
The following packages will be upgraded:
libmysqlclient18
1 upgraded, 8 newly installed, 1 to remove and 61 not upgraded.
Need to get 38.6 MB of archives.
After this operation, 129 MB of additional disk space will be used.
Get:1 http://
Get:2 http://
Get:3 http://
Get:4 http://
Get:5 http://
Get:6 http://
Get:7 http://
Get:8 http://
Get:9 http://
Preconfiguring packages ...
Fetched 38.6 MB in 12s (3,003 kB/s)
(Reading database ...
58231 files and directories currently installed.)
Preparing to replace libmysqlclient18 5.5.31-
Unpacking replacement libmysqlclient18 ...
Processing triggers for install-info ...
install-info: warning:
no info dir entry in `/usr/share/
(Reading database ...
58232 files and directories currently installed.)
Removing mysql-common ...
Selecting previously unselected package libaio1.
(Reading database ...
58228 files and directories currently installed.)
Unpacking libaio1 (from .../libaio1_
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-
Selecting previously unselected package percona-
Unpacking percona-
Selecting previously unselected package percona-
Unpacking percona-
Selecting previously unselected package percona-
Unpacking percona-
Processing triggers for man-db ...
Processing triggers for ureadahead ...
Setting up libmysqlclient18 (1:5.5.
Setting up libaio1 (0.3.109-2ubuntu1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.616-1build2) ...
Setting up libdbd-mysql-perl (4.020-1build2) ...
Setting up percona-
Setting up percona-
Setting up percona-
* Stopping MySQL (Percona Server) mysqld
/usr/sbin/mysqld
:
Can't read dir of '/etc/mysql/
Fatal error in defaults handling. Program aborted
...done.
* Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
* Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
* See http://
/usr/sbin/mysqld
:
Can't read dir of '/etc/mysql/
Fatal error in defaults handling. Program aborted
* Starting MySQL (Percona Server) database server mysqld
Related branches
- Laurynas Biveinis (community): Needs Fixing
- Alexey Bychko (community): Approve
-
Diff: 9433 lines (+7292/-745)94 files modified.bzrignore (+6/-6)
CMakeLists.txt (+1/-1)
Makefile-ps (+4/-20)
README (+11/-0)
UDF/Makefile.am (+2/-0)
UDF/configure.ac (+2/-3)
VERSION (+1/-1)
build-ps/build-binary.sh (+8/-9)
build-ps/build-rpm.sh (+2/-2)
build-ps/debian/control (+30/-34)
build-ps/debian/copyright (+787/-86)
build-ps/debian/libperconaserverclient18.1.install (+1/-1)
build-ps/debian/libperconaserverclient18.1.postinst (+2/-0)
build-ps/debian/libperconaserverclient18.lintian-overrides (+6/-0)
build-ps/debian/percona-server-client-5.6.files (+0/-1)
build-ps/debian/percona-server-client-5.6.lintian-overrides (+18/-0)
build-ps/debian/percona-server-server-5.6.docs (+2/-3)
build-ps/debian/percona-server-server-5.6.files (+3/-4)
build-ps/debian/percona-server-server-5.6.lintian-overrides (+10/-0)
build-ps/debian/percona-server-server-5.6.postinst (+19/-15)
build-ps/debian/percona-server-server-5.6.postrm (+1/-1)
build-ps/debian/percona-server-server-5.6.preinst (+12/-17)
build-ps/debian/percona-server-source-5.6.files (+1/-0)
build-ps/debian/percona-server-test-5.6.files (+0/-1)
build-ps/debian/po/POTFILES.in (+1/-0)
build-ps/debian/po/ar.po (+252/-0)
build-ps/debian/po/ca.po (+227/-0)
build-ps/debian/po/cs.po (+346/-0)
build-ps/debian/po/da.po (+382/-0)
build-ps/debian/po/de.po (+239/-0)
build-ps/debian/po/es.po (+390/-0)
build-ps/debian/po/eu.po (+236/-0)
build-ps/debian/po/fr.po (+251/-0)
build-ps/debian/po/gl.po (+249/-0)
build-ps/debian/po/it.po (+223/-0)
build-ps/debian/po/ja.po (+229/-0)
build-ps/debian/po/nb.po (+297/-0)
build-ps/debian/po/nl.po (+290/-0)
build-ps/debian/po/pt.po (+307/-0)
build-ps/debian/po/pt_BR.po (+443/-0)
build-ps/debian/po/ro.po (+319/-0)
build-ps/debian/po/ru.po (+229/-0)
build-ps/debian/po/sk.po (+219/-0)
build-ps/debian/po/sv.po (+229/-0)
build-ps/debian/po/templates.pot (+187/-0)
build-ps/debian/po/tr.po (+342/-0)
build-ps/debian/rules (+290/-75)
build-ps/debian/source/format (+1/-0)
build-ps/percona-server.spec (+18/-57)
build/build-dpkg.sh (+0/-138)
build/debian/libmysqlclient-dev.README.Maintainer (+0/-4)
build/debian/libmysqlclient-dev.install (+0/-6)
build/debian/libmysqlclient-dev.links (+0/-2)
build/debian/libmysqlclient18.1.links (+0/-1)
build/debian/percona-server-client-5.6.menu (+0/-3)
build/debian/source/format (+0/-1)
build/rpm/mysql-dubious-exports.patch (+0/-103)
client/CMakeLists.txt (+12/-12)
cmake/info_macros.cmake.in (+1/-1)
cmake/libutils.cmake (+3/-3)
cmake/make_dist.cmake.in (+10/-0)
cmake/mysql_version.cmake (+4/-4)
doc/source/installation.rst (+78/-70)
doc/source/management/pam_plugin.rst (+1/-1)
doc/source/upgrading_guide_55_56.rst (+1/-1)
libmysql/CMakeLists.txt (+14/-14)
libmysql/libmysql.map (+4/-4)
libmysql/libmysql.ver.in (+1/-1)
man/mysql_config.1 (+3/-3)
mysql-test/CMakeLists.txt (+0/-1)
packaging/rpm-uln/mysql.spec.sh (+5/-5)
plugin/percona-pam-for-mysql/CMakeLists.txt (+1/-1)
scripts/CMakeLists.txt (+2/-2)
scripts/mysql_config.pl.in (+3/-3)
scripts/mysql_config.sh (+2/-2)
sql/password.c (+1/-1)
storage/ndb/ndbapi-examples/mgmapi_logevent/Makefile (+1/-1)
storage/ndb/ndbapi-examples/mgmapi_logevent2/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_async/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_async1/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_blob/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_blob_ndbrecord/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_event/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_recattr_vs_record/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_retries/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_s_i_ndbrecord/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_scan/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_simple/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_simple_dual/Makefile (+1/-1)
storage/ndb/ndbapi-examples/ndbapi_simple_index/Makefile (+1/-1)
storage/ndb/test/run-test/CMakeLists.txt (+1/-1)
support-files/MySQL-shared-compat.spec.sh (+1/-1)
support-files/mysql.spec.sh (+3/-3)
tests/CMakeLists.txt (+2/-2)
tags: | added: pkg |
Reproduce it with Debian 6.0.7 and PS 5.6.12. If there is no /etc/mysql/conf.d dir created, installer gives error but not creating by itself.
root@debian: /etc/mysql# lsb_release -a /etc/mysql# B
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 6.0.7 (squeeze)
Release: 6.0.7
Codename: squeeze
root@debian:
root@debian: /etc/mysql# sudo -i DEBIAN_ FRONTEND= noninteractive apt-get install percona- server- server- 5.6 percona- server- client- 5.6 template- perl server- common- 5.6 server- common server- client- 5.6 percona- server- common- 5.6 percona- server- server- 5.6 server- common- 5.6 percona- server- client- 5.6 percona- server- server- 5.6 debianmirror. nkn.in/ debian/ squeeze/main libaio1 amd64 0.3.107-7 [7,928 B] repo.percona. com/apt/ squeeze/main libmysqlclient18 amd64 5.5.32- rel31.0- 549.squeeze [844 kB] repo.percona. com/apt/ squeeze/main percona- server- common- 5.6 amd64 5.6.12- rc60.4- 394.squeeze [2,748 B] repo.percona. com/apt/ squeeze/main percona- server- client- 5.6 amd64 5.6.12- rc60.4- 394.squeeze [10.3 MB] repo.percona. com/apt/ squeeze/main percona- server- server- 5.6 amd64 5.6.12- rc60.4- 394.squeeze [26.4 MB] server- common ... 0.3.107- 7_amd64. deb) ... ent18_5. 5.32-rel31. 0-549.squeeze_ amd64.deb) ... server- common- 5.6. server- common- 5.6 (from .../percona- server- common- 5.6_5.6. 12-rc60. 4-394.squeeze_ amd64.deb) ... server- client- 5.6. server- client- 5.6 (from .../percona- server- client- 5.6_5.6. 12-rc60. 4-394.squeeze_ amd64.deb) ... server- server- 5.6. server- server- 5.6 (from .../percona- server- server- 5.6_5.6. 12-rc60. 4-394.squeeze_ amd64.deb) ...
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
libhtml-
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
libaio1 libmysqlclient18 percona-
Suggested packages:
tinyca
The following packages will be REMOVED:
percona-
The following NEW packages will be installed:
libaio1 libmysqlclient18 percona-
0 upgraded, 5 newly installed, 1 to remove and 0 not upgraded.
Need to get 37.5 MB of archives.
After this operation, 131 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
WARNING: The following packages cannot be authenticated!
libaio1 libmysqlclient18 percona-
Install these packages without verification [y/N]? y
Get:1 http://
Get:2 http://
Get:3 http://
Get:4 http://
Get:5 http://
Fetched 37.5 MB in 1min 47s (349 kB/s)
Preconfiguring packages ...
(Reading database ... 130049 files and directories currently installed.)
Removing percona-
Selecting previously deselected package libaio1.
(Reading database ... 130047 files and directories currently installed.)
Unpacking libaio1 (from .../libaio1_
Selecting previously deselected package libmysqlclient18.
Unpacking libmysqlclient18 (from .../libmysqlcli
Selecting previously deselected package percona-
Unpacking percona-
Selecting previously deselected package percona-
Unpacking percona-
Selecting previously deselected package percona-
Unpacking percona-
Proce...