Re: [Cooker] [2009.1] What is errcode: 13 when trying to allocate files as root

> On 01/07/09 08:40, Colin Guthrie wrote:
>> 'Twas brillig, and Frank Griffin at 30/06/09 21:49 did gyre and gimble:
>>> Steve Morris wrote:
>>>> /usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibSy10pn'
>>>> (Errcode: 13)
>>>>
>>>> What does this mean and why does it occur even if I issue chmod 777
>>>> /root/tmp
>>>>
>>> Start with /usr/include/errno.h and follow the #includes until you find
>>> the standard errno numbers.
>>>
>>> Then realize that you can't create in /root/tmp if you can't cd to
>>> /root, which has perms rwx------.  ;)
>> Have a look in the /etc/sysconfig/mysql file and in particular .rpmnew
>> variants.
>>
>> Of particular interest are the lines:
>>
>> # (oe) set TMPDIR and TMP environment variables
>> TMPDIR="/var/tmp"
>> TMP="${TMPDIR}"
>>
>> These variables ensure things work form the init scripts etc. but wont
>> cover running them manually. If you set these vars yourself and export
>> them, things will work as expected.
>>
>> Col
>>
> What init scripts are you talking about? At the current time running
> mysqld from a shell under root is the only way to start it as
> /etc/rc.d/init.d/mysqld does not work when started from  a shell under
> root (mysql is not listed as a service in mcc and as far as I can tell
> there is no script in /etc/rc.d/rc5.d), and the recommended script to
> run of mysql_safe as far as I can tell is not provided by the Mandriva
> rpms, and as at the stage of getting this error I had not explicitly
> specified the temporary file path in /etc/my.cnf in the mysqld section,
> it should be using the Mandriva defaults which based on what you have
> said it isn't, hence why not? I have also created /home/mysql even
> though this is not required.
>