![](https://secure.gravatar.com/avatar/c7e6c08e057a54128df9332e0b5d9af0.jpg?s=120&d=mm&r=g)
Yes, I had considered Selinux as the problem. However, I had temporarily set it to 'permissive', then 'disabled', and that made no difference. -----Original Message----- From: Maria-discuss [mailto:maria-discuss-bounces+chris.a.adams=state.or.us@lists.launchpad.net] On Behalf Of Daniel Black Sent: Tuesday, January 24, 2017 3:00 PM To: maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] question about generating logs on MariaDB 10.1.21 On 25/01/17 09:27, Guillaume Lefranc wrote:
Hi Chris,
In CentOS 7, error logs are handled by systemd.
Use the "journalctl -u mariadb.service" command to view them.
I have no idea what's wrong with the general logs though. Maybe that's some permission issue. Please check that the mysql user can write in /var/log/mysql. You might have success by changing the log path to your datadir, e.g. to /mnt/mysqldbs/mysql.log, since mysqld can always write in its own datadir.
Regards GL
That was my thoughts also. Watch out for selinux permissions also: These are easy enough to correct without turning selinux off permanently: https://blogs.oracle.com/jsmyth/entry/selinux_and_mysql
On Tue, Jan 24, 2017 at 11:04 PM Chris Adams
mailto:chris.a.adams@state.or.us> wrote: Hello,____
__ __
I have just moved from a MySQL 5.6 server on CentOS 6.8 to a MariaDB 10.1.21 server on CentOS 7. It is installed and working. ____
__ __
I would like to set up some logging, but it has not gone as expected. I have binary logging working. However, I can't generate general logs or error logs. Here is part of the /etc/my.cnf file:____
__ __
user=mysql____
port = 3306____
socket = /var/lib/mysql/mysql.sock____
datadir = /mnt/mysqldbs____
log_error = /var/log/mysql/error.log____
general_log_file = /var/log/mysql/mysql.log____
general_log = 1____
log_bin = /mnt/mysqldbs/logs/mysql-bin____
__ __
I assume that after a restart, the logs will be generated, then logged to as events happen. As it is, no log files are generated. ____
__ __
Many thanks. ____
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net mailto:maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation
_______________________________________________ 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
_______________________________________________ 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