Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 668992 - dev-db/mysql-init-scripts and dev-db/mysql-5.7 : mysql-init-scripts still refers to the single /etc/mysql/my.cnf file while dev-db/mysql refers to multiple
Summary: dev-db/mysql-init-scripts and dev-db/mysql-5.7 : mysql-init-scripts still ref...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-10-19 03:35 UTC by Dyweni
Modified: 2018-11-02 03:11 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dyweni 2018-10-19 03:35:17 UTC
mysql 5.7 post installation notes indicates a change of configuration files from a single /etc/mysql/my.cnf to multiple /etc/mysql/mysql.d/*.cnf files.

mysql-init-scripts still refer to the single /etc/mysql/my.cnf file.

After upgrading from 5.7 to 5.7, I can no longer start mysql server.

# /etc/init.d/mysql start
 * Caching service dependencies ...                                                                                                                                                                          [ ok ]
 * Checking mysqld configuration for mysql ...
/etc/init.d/mysql: line 186: /sbin/mysqld: No such file or directory
 * mysql config check failed                                                                                                                                                                                 [ !! ]
 * ERROR: mysql failed to start
Comment 1 Tomáš Mózes 2018-10-19 06:58:25 UTC
Please post the output of $(emerge --info dev-db/mysql dev-db/mysql-init-scripts).
Comment 2 Brian Evans (RETIRED) gentoo-dev 2018-10-22 14:56:30 UTC
We don't have the whole story here.

/etc/mysql/my.cnf should still exist to pull in all of the  /etc/mysql/mysql.d/*.cnf files.

If a user fails to move their custom changes to that new directory and accept the changed file, I'm not sure of the outcome.

The /etc/mysql/my.cnf should have one, uncommented line:

!includedir /etc/mysql/mysql.d
Comment 3 Dyweni 2018-10-23 12:05:24 UTC
(In reply to Brian Evans from comment #2)
> We don't have the whole story here.
> 
> /etc/mysql/my.cnf should still exist to pull in all of the 
> /etc/mysql/mysql.d/*.cnf files.
> 
> If a user fails to move their custom changes to that new directory and
> accept the changed file, I'm not sure of the outcome.
> 
> The /etc/mysql/my.cnf should have one, uncommented line:
> 
> !includedir /etc/mysql/mysql.d



The second part (about keeping the file around with just the one include line) was not at all clear to me.  I do not remember seeing that line.

I simply updated the files in /etc/mysql/mysql.d and removed the /etc/mysql/my.cnf file.

I will try the upgrade again.
Comment 4 Dyweni 2018-11-02 02:27:09 UTC
I reinstalled Mysql 5.7 tonight.

However, this time, the /etc/mysql/my.cnf was not upgraded and I never got the warning about having to rebuilding anything linking with libmysqlclient.so.18.

I had to had copy the my.cnf-5.7 file into place and re-run the revdep rebuild command.

It is running.  Perhaps the issue is that I read the info message the first time and though that the my.cnf was going away and only the individual files were going to be used.

Also, no idea why the second time upgrading from 5.6 to 5.7 didn't give the usual upgrade steps (installing the new my.cnf file and telling the user to run revdeb rebuild).
Comment 5 Thomas Deutschmann (RETIRED) gentoo-dev 2018-11-02 03:11:11 UTC
(In reply to Dyweni from comment #4)
> I reinstalled Mysql 5.7 tonight.
> 
> However, this time, the /etc/mysql/my.cnf was not upgraded and I never got
> the warning about having to rebuilding anything linking with
> libmysqlclient.so.18.

I see nothing wrong here.

Keep in mind that config protect feature probably knows that you have already seen configuration file from 5.7 when you *re-install*. If you want to start over use emerge's "noconfmem" parameter.

Regarding missing libmysqlclient warning: Beginning with MySQL 5.7, we are masking "client-libs" USE flag. Therefore the code responsible for showing the rebuild warning you know from previous versions won't be called anymore...

Closing as invalid for now because given on the information you gave us it looks like you just missed elog after first upgrade and also portage's hint that you have pending configuration changes (e.g. you forgot to call dispatch-conf or etc-update).