Brian McKee wrote:
> On Mon, 2007-13-08 at 09:22 +0200, Duncan Webb wrote:
>> Brian McKee wrote:
>>> I get this error when I run freevo cache
>>>
>>> Were is it saving this sqlite database?
>>>
>>> Or it this indicative of a different problem?
>>>
>>> {snippage...}
>>> checking webserver thumbnails......................... 0 files
>>> creating audio metadata............................... done
>>> creating playlist metadata............................ done
>>> checking database.....................................
>>> Traceback (most recent call last):
>>> File "/usr/lib/python2.4/site-packages/freevo/helpers/cache.py", line
>>> 579, in ? create_metadata()
>>> File "/usr/lib/python2.4/site-packages/freevo/helpers/cache.py", line
>>> 380, in create_metadata
>>> util.extendedmeta.addPathDB(dir[1], dir[0], verbose=False)
>>> File "/usr/lib/python2.4/site-packages/freevo/util/extendedmeta.py",
>>> line 94, in addPathDB
>>> db.runQuery(make_query(song,dirtitle))
>>> File "/usr/lib/python2.4/site-packages/freevo/util/dbutil.py", line 94,
>>> in runQuery
>>> self.cursor.execute(query)
>>> File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 244, in
>>> execute self.rs = self.con.db.execute(SQL)
>>> _sqlite.DatabaseError: attempt to write a readonly database
>> Do you have sqlite installed?
>>
>> If so then maybe the owner is root and your running from a user with the
>> incorrect permissions. The database is in <cachedir>/freevo.sqlite,
>> where cachedir is /tmp/freevo or /var/cache/freevo
>>
>
>
> Thanks Duncan
> The owner was another user on the same box. I just ended up
> deleting /var/cach/freevo and letting freevo rebuild it.
>
> I've run into a couple of problems with freevo that in retrospect were
> possibly similar issues around running freevo under multiple accounts.
> For now I'll avoid it.
>
> To me that's a bug - I made an entry on the sourceforge site under
> bugs <http://sourceforge.net/tracker/?atid=446895&group_id=46652>
> referring to freevo cache but I'm not sure that's the only spot problems
> may occur. Wasn't there discussion earlier about a problem that didn't
> show up when freevo was run as root?
As this question comes up quite a bit on the list, I have just added a
wiki page http://freevo.sourceforge.net/cgi-bin/doc/MultiUser which need
some more detailed instructions.
The cache is shared and so need shared permissions. To set up freevo as
a multi-user system you will need to do a bit of Linux system
administration. To set the users and permissions correctly. After all it
is Linux that is stopping the access of the files and not Freevo.
Duncan
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Freevo-users mailing list
Freevo-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/freevo-users
