Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

apparmor denied acces to mysqld #176

dl7oap opened this issue Jun 23, 2019 · 0 comments

apparmor denied acces to mysqld #176

dl7oap opened this issue Jun 23, 2019 · 0 comments


Copy link

@dl7oap dl7oap commented Jun 23, 2019

many mysql server errors and installation problems on ubuntu 18.10, 19.04 and 19.10 belongs to apparmor which denied the access to mysqld.

a typical error is:

mysqld: [ERROR] Could not open required defaults file: /home/ka/.config/cqrlog/database/mysql.cnf
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!

when looking in syslog after this mysqld error you will see the apparmor warnings in the log.
tail -100 /var/log/syslog

this problem can be solved with

#correction auf apparmor so mysld access is not denied

sudo sh -c "echo '@{HOME}/.config/cqrlog/database/ r,' >> /etc/apparmor.d/local/usr.sbin.mysqld"
sudo sh -c "echo '@{HOME}/.config/cqrlog/database/** rwk,' >> /etc/apparmor.d/local/usr.sbin.mysqld"
sudo service apparmor restart

the solution should be, that the installation of cqrlog already takes care for this entries in /etc/apparmor.d/local/usr.sbin.mysqld or it should be searched for a other solution.

maybe there was already a solution, because Petr mentioned this here:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
1 participant
You can’t perform that action at this time.