|
|
Posted by The Natural Philosopher on 09/04/07 11:35
Jerry Stuckle wrote:
> 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?
>
It cannot be permissions as simply COPYING the file somewhere else first
works.,
> Of course, with no code, everything's a guess...
>
Navigation:
[Reply to this message]
|