Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can't Set MySQL General Log to Named Pipe

Discussion in 'Database Discussion' started by WiddleWabbit, Mar 8, 2018.

  1. WiddleWabbit

    WiddleWabbit Registered

    Oct 12, 2017
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    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?
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

Share This Page