install error (mandrake 9 specific)

Hi Steve,

You should find an answer in the following message.
The problem seems to be with the default Mandrake 9 mysql install, and  
the SORT sql command.

Stephane


Begin forwarded message:

> From: Stephane Daury
> Date: Fri Nov 8, 2002  10:23:48  PM America/Montreal
> To: "Arturo J. Morales"
> Subject: Re: Help, please...
>
> Hi there,
>
> I logged into your system, and tried to run the sql query that the  
> netjuke is failing on in search.php.
>
> <sample_query status="error" >
> SELECT tr.name, ar.name, al.name, ge.name, tr.location, tr.id, ar.id,  
> al.id, ge.id, tr.time, tr.track_number, tr.img_src, ar.img_src,  
> al.img_src, tr.size from netjuke_tracks tr, netjuke_artists ar,  
> netjuke_albums al, netjuke_genres ge where ge_id = '33' and ar.id =  
> tr.ar_id and al.id = tr.al_id and ge.id = tr.ge_id order by  
> upper(ge.name), upper(al.name), tr.track_number, tr.location;
> </sample_query>
>
> <mysql_error>
> ERROR 1: Can't create/write to file '/root/tmp/#sql183b_f4_0.MYI'  
> (Errcode: 13)
> </mysql_error>
>
> I ran a google search on it, and it seems that  the problem is with  
> mysql, since error code 13 means permissions error. I noticed that  
> running the same query without the "order by" clause runs fine.
>
> <sample_query status="success">
> SELECT tr.name, ar.name, al.name, ge.name, tr.location, tr.id, ar.id,  
> al.id, ge.id, tr.time, tr.track_number, tr.img_src, ar.img_src,  
> al.img_src, tr.size from netjuke_tracks tr, netjuke_artists ar,  
> netjuke_albums al, netjuke_genres ge where ge_id = '33' and ar.id =  
> tr.ar_id and al.id = tr.al_id and ge.id = tr.ge_id;
> </sample_query>
>
> Is the mysql install from the mandrake rpm?
>
> There are a lots of hits in google for similar errors, and it usually  
> turns out to be because of the way mysql is configured.
>
> -  
> http://www.google.com/search?hl=en&ie=ISO-8859- 
> 1&q=mysql+%22ERROR+1%3A+Can%27t+create%2Fwrite+to+file%22&meta=
>
> -  
> http://www.google.com/search?hl=en&ie=ISO-8859- 
> 1&q=mysql+mandrake+%22ERROR+1%3A+Can%27t+create%2Fwrite+to+file%22&meta 
> =
>
> Here are a few suggestions suggestions:
>
> - BEST: Find out why mysqld is trying to write to /root/tmp/ when  
> logged in as me, instead of in /tmp/ or /home/stephane/tmp/.  
> Linux-mandrake.com (and related sites) will most likely help with this  
> better than I can. If this isn't fixed, it is also most likely that  
> you'll encounter other problems with mysql, and with other  
> applications that use it as the netjuke does.
>
> - EASY + SECURE: try using the netjuke with postgres, which is also  
> delivered with mandrake. Don't forget to also add the php-postgres  
> extension if it is not installed.
>
> - EASY: as root, run "mkdir /root/tmp", then "chmod -R 777 /root/tmp"  
> (easy, but not the most secure...)
>
> Hope it helps. Let me know.
>
> Stephane
>
>
>
> On Wednesday, November 6, 2002, at 07:59 AM, Arturo J. Morales wrote:
>
>>
>> Done, thanks!
>>
>> Art
>>
>> -----Original Message-----
>> From: Stephane Daury
>> Sent: Tuesday, November 05, 2002 11:49 PM
>> To: Arturo Morales
>> Subject: Re: Help, please...
>>
>>
>>
>> same for filter.php
>>
>>
>>
>> On Tuesday, November 5, 2002, at 11:44 PM, Stephane Daury wrote:
>>
>>>
>>> I'd need to edit the search.php script to print the sql statement  
>>> that
>>> cerates a problem on screen when loading the page. Could you chmod or
>>> chown it so I can modify it please.
>>>
>>> Stephane
>>>
>>>
>>>
>>> On Tuesday, November 5, 2002, at 09:13 AM, Arturo Morales wrote:
>>>
>>>>
>>>> Hi Stephane,
>>>>
>>>> Your netjuke account name is: <value removed> with password:
>>>> <value removed>
>>>>
>>>> Your login account is: <value removed> and password is: <value  
>>>> removed> also
>>>>
>>>> The machine is at: <value removed>
>>>>
>>>> netjuke is under /var/www/html/netjuke
>>>>
>>>> the server: http:/<value removed>/netjuke/index.php
>>>>
>>>> Thanks again!
>>>>
>>>> Art
>>>>
>>>>>
>>>>> I there Arturo,
>>>>>
>>>>> Sorry, but I could have sworn that I had somehow replied to this
>>>>> earlier. My mistake I guess...
>>>>>
>>>>> Giving me ssh access to the server will probably be the only way
>>>>> I'll have t help you out, since I can't seem to duplicate the error
>>>>> on any of my machines. Besides, there is no line #305 in the
>>>>> play.php, hence why I truly do not understand what the problem  
>>>>> could be...
>>>>>
>>>>> What I would need is ssh access to the netjuke directory, and an
>>>>> account in your current netjuke install.
>>>>>
>>>>> Let's work on this together, and we'll get it for sure. ;o)
>>>>>
>>>>> Stephane
>>>>>
>>>>>
>>>>>
>>>>> On Monday, November 4, 2002, at 03:37  PM, Arturo Morales wrote:
>>>>>
>>>>>>
>>>>>> Hi Stephane,
>>>>>>
>>>>>> I loved the earlier versions of Netjuke, great job!
>>>>>>
>>>>>> I have posted this problem to a few places and I've seen others
>>>>>> having
>>>>>>  the
>>>>>> same problem, but I haven't seen a response.  I'm hoping that you
>>>>>> may
>>>>>> have
>>>>>> an insight as to why it is happening :)
>>>>>> I am running a stock Mandrake 9 install with the latest netjuke
>>>>>> 1b16,
>>>>>> but
>>>>>> I tried with the cvs 1b15 before and had the same problems.
>>>>>> I can install w/o problems and can populate the database.  After
>>>>>> this is
>>>>>> done, I see the main page with all the genre's etc, but when I  
>>>>>> click
>>>>>> on one of them, I get this error:
>>>>>> Fatal error: Call to a member function on a non-object in
>>>>>> /var/www/html/netjuke/search.php on line 305
>>>>>> I get a similar looking error whenever I try to do anything with  
>>>>>> the
>>>>>> database.  It is very weird, because It could definitively write  
>>>>>> to it
>>>>>>  at first, and it can read from it, given that it's telling me  
>>>>>> what songs
>>>>>> (genre's) I have and tells me the statistics in the front page  
>>>>>> where
>>>>>> in the content summary area.
>>>>>> I have been trying to figure what's going on, but have no clue.
>>>>>> (Unfortunately I don't know enough PHP to be of much help)
>>>>>> I can give you access to the machine if you need to try and debug  
>>>>>> it
>>>>>> or I'll get any other info you need.  Unfortunately, that's the  
>>>>>> only
>>>>>> error I
>>>>>> can detect anywhere, and It's not telling me much :)  I've seen at
>>>>>> least
>>>>>> one more post in the netjuke forum about someone having the same
>>>>>> problem... must be something hard to find, but unfortunately I  
>>>>>> can't
>>>>>> use
>>>>>> netjuke until it's fixed...
>>>>>> Thanks!
>>>>>>
>>>>>> Art
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hi there,
>>>>>>>
>>>>>>> 1.0b16 is available for download from http://netjuke.sf.net/
>>>>>>>
>>>>>>> Please see the homepage or changelog below for more information.



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf