← Back to team overview

maria-discuss team mailing list archive

Re: 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 <chris.a.adams@xxxxxxxxxxx
> <mailto:chris.a.adams@xxxxxxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx
>     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>     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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
> 



Follow ups

References