On 05/07/2018 12:18 AM, Reindl Harald
wrote:
Am 06.05.2018 um 22:53 schrieb Muhammad Bashir Al-Noimi:
I use /etc/systemd/system/mariadb.service as mentioned before but I
struggle with a new problem and I spent a whole day trying to fix it but
I failed :(
I always get this error message through journalctl -xe although my.cnf
already exists and has a prober permissions!
May 06 23:26:41 domain.com mysqld[26621]: Could not open required
defaults file: /opt/mariadb-data/my.cnf
How to to fix this issue?
* /opt/mariadb-data/my.cnf
https://gist.github.com/mbnoimi/b9daceca0e0e21da86b048b9883c5edf
* /etc/systemd/system/mariadb.service
https://gist.github.com/mbnoimi/5920301ff79dcb88aab3ef7fa459733e
* I use this steps for installing MariaDB
log-error=/opt/mariadb-data/mariadb.err
* have you ever considered to look at that file?
It contains on a single line:
2018-05-06 23:26:35 140367938119424 [Warning] Failed to load slave
replication state from table mysql.gtid_slave_pos: 1146: Table
'mysql.gtid_slave_pos' doesn't exist
* what are the permissions for /opt
Access: (0755/drwxr-xr-x) Uid: ( 0/ root) Gid: ( 0/
root)
* what are the permissions for /opt/mariadb-data
Access: (0700/drwx------) Uid: ( 999/ mariadb) Gid: ( 999/
mariadb)
"stat /opt/mariadb-data/my.cnf" say?
Access: (0700/-rwx------) Uid: ( 999/ mariadb) Gid: ( 999/
mariadb)
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi