no selinux , checked this as well.
We generally dont use selinux and disable it completely from installation.
I have also gone through the firewall settings and that is only rules
for connections.
On 09/10/2012 02:40 PM, Ananda Kumar wrote:
> did u check if there any firewall settings, forbidding you to create
> files, check if " SELinux is disabled"
>
> On Mon, Sep 10, 2012 at 6:08 PM, Machiel Richards - Gmail
> <machiel.richards@stripped <mailto:machiel.richards@stripped>> wrote:
>
> Hi
>
>
> at the moment this does not really matter to us.
>
> we have even tried to create a temp table with only one field
> in order to insert one row for testing, but we are currently not
> able to create any temporary tables whatsoever as even the
> simplest form of table still gives the same error.
>
> Regards
>
>
>
> On 09/10/2012 02:33 PM, Ananda Kumar wrote:
>> this temp table will hold how many rows, what would be its size.
>>
>> On Mon, Sep 10, 2012 at 5:03 PM, Machiel Richards - Gmail
>> <machiel.richards@stripped <mailto:machiel.richards@stripped>>
>> wrote:
>>
>> Hi,
>> We confirmed that the /tmp directory permissions is set
>> to rwxrwxrwxt and is owned by root , the same as all our
>> other servers.
>>
>> There is also about 60Gb of free space on the filesystem
>> where /tmp resides.
>>
>> Regards
>>
>>
>>
>>
>>
>> On 09/10/2012 01:11 PM, Rik Wasmus wrote:
>>
>> the message "ERROR 1005 (HY000): Can't create table
>> '/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"
>>
>> Basics first:
>> 1) Is the /tmp directory write & readable for the user
>> mysql runs as?
>> 2) Has the /tmp directory enough free space?
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql
>>
>>
>
>
