|
|
Posted by Jerry Stuckle on 09/04/07 10:52
The Natural Philosopher wrote:
> The Natural Philosopher wrote:
>> This is so weird.
>>
>> What I am trying to do is to upload files and stuff them in a mysql
>> database.
>>
>> Everything works except the file content is zero.
>>
>> using the load_file command from mysql command line as 'root' works
>> and i can download the inserted file ok.
>>
>> using the load_file command from mysql as 'web-user' (my default web
>> user?) didn't work until I gave that user every permission I could
>> find, and *restarted mysqld*. (why? *shrug*)
>>
>> using the load_file command from php/Mysql to load the temporary files
>> fails miserably all the time. Not one success. Everything else is
>> fine..I get the name and the size coming through,and I've 'echo'ed
>> the command string that goes to mysql_query() and tried it in the
>> command line stuff, and that works provided I give it a file that
>> actually exists.
>>
>>
>> If the file does NOT exist then I get no error, just no data..
>>
>> So that is a possibility..
>>
>> Ah. I copied the temporary file to somewhere else (/tmp/foo), and then
>> handed it to MySQL..THAT WORKED..
>>
>> So it's something about how the temporary file is - or isn't - being
>> written to disk maybe.
>>
>> Is there a way to force a close on the file..maybe that's the problem
>> Mysql is opening a file that is not flushed to disk maybe?
>>
> Mmm I tried move_uploaded_file() and THAT didn't work either.
>
> Something is badly broken/misconfigured in PHP I think.
> I gew the feeling its maintaining its own picture of file objects, and
> doesn't actually flush to the disk unless you do a copy or close php..
No, PHP doesn't maintain it's own copy. However, it's possible the OS
hasn't flushed a file to disk. Unlikely, though.
This sounds very much like a permissions problem - does MySQL have read
access to the directory the file is in, also?
Of course, with no code, everything's a guess...
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|