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.

/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:
    1
    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,475
    Likes Received:
    20
    Trophy Points:
    38
    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.
     
  3. Lor

    Lor Well-Known Member

    Joined:
    Apr 29, 2005
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    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,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Already mentioned as option 3 in my post directly above.
     
Loading...

Share This Page