Hello Gilbert On 2005-02-09 Gilbert Laycock wrote: > If you try to start/restart mysql-server as root, and root has TMPDIR > set to something not writable by the mysql user (eg if you are using > libpam-tmpdir, so TMPDIR is typically /tmp/user/0 during a login > session), then it fails to restart - you get errors like this:
Hm, generally spoken, environment variables exists for a reason, if you start a program with such a one, you want it to use it so I can't blame MySQL. On the other hand, libpam-tmpdir seems to be a nice idea. Do you have a suggestion how to solve this problem? Root often starts services that change their uids shortly after running i.e. do not use "su" or "sudo" which would give them the right env variables. I Cc the libpam-tmpdir maintainer ;) In the meantime, just put "export TMPDIR=/tmp" into /etc/init.d/mysql. bye, -christian-
pgpaDz44DaD3Z.pgp
Description: PGP signature
