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!

/scripts/Securetmp and mysqld

Discussion in 'General Discussion' started by Mariusz Jokiel, Jan 5, 2006.

  1. Mariusz Jokiel

    Mariusz Jokiel Active Member

    Joined:
    Nov 8, 2004
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    151
    Welcome,

    I would like to ask you about securetmp. I am running securetmp scripts on start server in rc.local, but during server mysql doesn't want to start.

    In mysqld error log i can find:

    mysql: Can't create write to file /tmp/ibZMx78x' (ErrorCode: 13).

    It's strange because there are proper privilleges on tmp folder.

    After manually start mysql from WHM it works properly.

    Best regards,
    MJ.
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,470
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    That's probably because the /tmp partition isn't mounted when MySQL starts during the boot process. A few ways round it:

    1. Remove the /scripts/securetmp line from /etc/rc.d/rc.local and add the following to /etc/fstab:

    /usr/tmpDSK /tmp ext2 loop,noexec,nosuid,nodev 0 0

    Or

    2. Umount /tmp (you'll have to stop processes accessing it, e.g. httpd, mysql, etc) and then check for the existense of an original /tmp directory and ensure it's chmod 1777

    Or

    3. At a line after the line in rc.local that starts MySQL:

    /etc/init.d/mysql start

    I always do 1.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Lor

    Lor Well-Known Member

    Joined:
    Apr 29, 2005
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    156
    How to keep it /scripts/securetmp in rc.local but fix the problem?
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,470
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    Already mentioned as option 3 in my post directly above.
     
    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