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 <chris.a.ad...@state.or.us > <mailto:chris.a.ad...@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
