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

> Steve Morris skrev:
>> 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.
>>
>
>
> How did you install mysql ?
>
> normally you simply have to do:
> urpmi mysql
> service mysqld start
>
> to get a working mysql
>
> --
> Thomas
>