Can't Set MySQL General Log to Named Pipe

[WiddleWabbit]

Hi,

I'm trying to set the MySQL general log to log to a named pipe.

I have had no issues turning the log on or logging to a custom file (mysql ownership, 660 permissions) in the mysql default logging directory. However every time I try to have it log to a named pipe instead of a regular file with exactly the same permissions setup I get the below error.

Could not open /test/general.log for logging (error 2). Turning logging off...

Trying to set the error log instead to exactly the same pipe with the no changes results in the error log piping perfectly. It only seems to be the general log having issues.

I have tried setting this up in the mysql cli as well. However I recieve the below error.

ERROR 1231 (42000): Variable 'general_log_file' can't be set to the value of '/test/general.log'

Everything seems to point to there being an issue with the pipe or its permissions however the error log works fine to the same pipe.

I'm running a Centos 7, cPanel Server, with MySQL 5.6.

Has anyone got any ideas?

 

[cPanelMichael]

Hello,

Here are a few third-party links where this topic is discussed:

How do I output MySQL logs to syslog?
Help Outputing MySQL General Log to Named Pipe
Unable to set general log to fifo pipe
MySQL Lists: mysql: Re: Named Pipe for General Query Log

Let us know if this helps.

Thank you.