Can't Set MySQL General Log to Named Pipe

WiddleWabbit

Registered
Oct 12, 2017
3
0
1
Australia
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463