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!

Can't Set MySQL General Log to Named Pipe

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

  1. WiddleWabbit

    WiddleWabbit Registered

    Joined:
    Oct 12, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,885
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice