|
On 05/07/2018 12:18 AM, Reindl Harald
wrote:
It contains on a single line: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.cnfHow 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 MariaDBlog-error=/opt/mariadb-data/mariadb.err * have you ever considered to look at that file? 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 Access: (0755/drwxr-xr-x) Uid: ( 0/ root) Gid: ( 0/ root)* what are the permissions for /opt Access: (0700/drwx------) Uid: ( 999/ mariadb) Gid: ( 999/ mariadb)* what are the permissions for /opt/mariadb-data Access: (0700/-rwx------) Uid: ( 999/ mariadb) Gid: ( 999/ mariadb)"stat /opt/mariadb-data/my.cnf" say? -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi |
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
