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.
regards,
Steve
[samorris.vcf]
begin:vcard
fn:Steve Morris
n:Morris;Steve
email;internet:samorris@...
x-mozilla-html:TRUE
version:2.1
end:vcard
