← Back to team overview

maria-discuss team mailing list archive

  1. maria-discuss team
  2. Mailing list archive
  3. Message #04294

Re: question about generating logs on MariaDB 10.1.21

  Thread Previous • Date Previous • • Thread Next 


Am 24.01.2017 um 23:42 schrieb Reindl Harald:



Am 24.01.2017 um 23:27 schrieb Guillaume Lefranc:

Hi Chris,

In CentOS 7, error logs are handled by systemd.


as well as stdout and hence mariadb should *really* fix spit that
startup lines into the general systemlog when "log-error" and
"general_log_file" are configured - the fact that the service was
started/stopped is logged by systemd anyways

mysqld: 2017-01-24 22:16:10 139841788156224 [Note] /usr/libexec/mysqld
(mysqld 10.1.21-MariaDB) starting as process 14782..

https://lists.launchpad.net/maria-discuss/msg02858.html
and i even seeked the source code after your useless "You don't give any meaningful context at all to solve this issue. What's the distribution you using? What commands do you use to start mariadb? Where do you see this message?" when it's reproduceable by just call /usr/libexec/mysqld in a terminal 

* mysqld.cc
* line 4075

if (!opt_help)
sql_print_information("%s (mysqld %s) starting as process %lu ...", my_progname, server_version, (ulong) getpid()); 



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

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.
____


_______________________________________________
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


--

Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / CISO / Software-Development
m: +43 676 40 221 40
p: +43 1 595 3999 33
http://www.thelounge.net/

References

  Thread Previous • Date Previous • • Thread Next