PDA

View Full Version : SS6.0.1-1, RH7.2, db do failed, readonly



Richard Elen
2005-04-08, 11:08
Hi... Had a look in the archives but couldn't find this one, apologies
if it's already been discussed.

Just upgraded from "6.0.1" (which said "6.0.0" on the server page) to
"6.0.1-1", the Linux RPM on the download page 8 Apr.

I'm running RH7.2 and installed using rpm -Uvh over the previous.

On starting it using
../slimserver.pl --user slimserver
(I have to do this due to init file problems at present)
I get the now-familiar XML::parser message; but now rather later I get this:

DBD::SQLite:: db do failed: attempt to write a readonly database(1) at
dbdimp.c line 401 at
/var/local/slimserver/Slim/DataStores/DBI/DataModel.pm line 68, <$fh>
line 21.

- and of course it no longer works.

Do I need to trash the database and if so where is it?
Or something else?

Thanks,
--Richard E

Richard Elen
2005-04-08, 11:34
The server started up fine when run as root.
Permissions issue?
--Richard E

Richard Elen wrote:
> DBD::SQLite:: db do failed: attempt to write a readonly database(1) at
> dbdimp.c line 401 at
> /var/local/slimserver/Slim/DataStores/DBI/DataModel.pm line 68, <$fh>
> line 21.

Patrick Dixon
2005-04-08, 12:21
I'm NOT a Linux expert (!) but I had a similar problem when I first tried on
FC3. I think you've probably installed as root and then started slimserver
as root when the slimserver daemon script didn't work as part of the
install. As a result slimserver is using /root/ as the home directory and
has put slimserversql.db and slimserver.db in /root/, and various other
stuff under /root/usr/local/slimserver...

You probably need to kill these and their locations in a config file
somewhere (sorry not sure where), and then restart slimserver as a normal
user (preferably slimserver:slimserver), whereupon it will create them
somewhere more appropriate.

HTH, Patrick

-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com]On Behalf Of Richard Elen
Sent: 08 April 2005 19:35
To: Slim Devices Discussion
Subject: Re: [slim] SS6.0.1-1, RH7.2, db do failed, readonly


The server started up fine when run as root.
Permissions issue?
--Richard E

Richard Elen wrote:
> DBD::SQLite:: db do failed: attempt to write a readonly database(1) at
> dbdimp.c line 401 at
> /var/local/slimserver/Slim/DataStores/DBI/DataModel.pm line 68, <$fh>
> line 21.

Richard Elen
2005-04-08, 14:06
Hmmm... I read a discussion about that earlier, and I've never run
Version 6 as root. In this case I installed the new version over the old
one using the Upgrade option which should uninstall the old version
first. My understanding is that the install script should create the
user slimserver and give it ownership of the relevant bits. I took care
not to run the new version as root - I used:
../slimserver --user slimserver
to avoid that; so that when it was run 'first time' it wouldn't create
files and permissions that were awkward. This is the same as the
procedure I used upgrading from 5.4.1 to 6.0.0.

My suspicion is that the ownership of something has changed and I need
to delete some files and let the app recreate them, but which and where
I know not...

Thanks for your helpful comments, though, because if I hadn't run it as
root before, I certainly have now! I just need to know what and where
are the files to delete etc!

--Richard E

Patrick Dixon wrote:
> I'm NOT a Linux expert (!) but I had a similar problem when I first tried on
> FC3. I think you've probably installed as root and then started slimserver
> as root when the slimserver daemon script didn't work as part of the
> install. As a result slimserver is using /root/ as the home directory and
> has put slimserversql.db and slimserver.db in /root/, and various other
> stuff under /root/usr/local/slimserver...
>
> You probably need to kill these and their locations in a config file
> somewhere (sorry not sure where), and then restart slimserver as a normal
> user (preferably slimserver:slimserver), whereupon it will create them
> somewhere more appropriate.
>
> HTH, Patrick

mherger
2005-04-08, 15:28
[..]
> My suspicion is that the ownership of something has changed and I need
> to delete some files and let the app recreate them, but which and where
> I know not...

Give /usr/local/slimserver/Cache/.slimserversql.db a try.

> Thanks for your helpful comments, though, because if I hadn't run it as
> root before, I certainly have now! I just need to know what and where
> are the files to delete etc!
>
> --Richard E
>
> Patrick Dixon wrote:
>> I'm NOT a Linux expert (!) but I had a similar problem when I first
>> tried on
>> FC3. I think you've probably installed as root and then started
>> slimserver
>> as root when the slimserver daemon script didn't work as part of the
>> install. As a result slimserver is using /root/ as the home directory
>> and
>> has put slimserversql.db and slimserver.db in /root/, and various other
>> stuff under /root/usr/local/slimserver...
>> You probably need to kill these and their locations in a config file
>> somewhere (sorry not sure where), and then restart slimserver as a
>> normal
>> user (preferably slimserver:slimserver), whereupon it will create them
>> somewhere more appropriate.
>> HTH, Patrick
>
>

Patrick Dixon
2005-04-08, 15:44
Sorry Richard, but that's about the extent of my knowledge. :-(

I can only suggest that you do a search for slimserversql.db and
slimserver.db and the ../usr/local/slimserver.. stuff to see where it's put
them and go from there.

It sounds like you did all the right things (unlike me), so I'm not sure
quite where it's gone wrong for you.

-----Original Message-----
From: discuss-bounces (AT) lists (DOT) slimdevices.com
[mailto:discuss-bounces (AT) lists (DOT) slimdevices.com]On Behalf Of Richard Elen
Sent: 08 April 2005 22:06
To: Slim Devices Discussion
Subject: Re: [slim] SS6.0.1-1, RH7.2, db do failed, readonly


Hmmm... I read a discussion about that earlier, and I've never run
Version 6 as root. In this case I installed the new version over the old
one using the Upgrade option which should uninstall the old version
first. My understanding is that the install script should create the
user slimserver and give it ownership of the relevant bits. I took care
not to run the new version as root - I used:
../slimserver --user slimserver
to avoid that; so that when it was run 'first time' it wouldn't create
files and permissions that were awkward. This is the same as the
procedure I used upgrading from 5.4.1 to 6.0.0.

My suspicion is that the ownership of something has changed and I need
to delete some files and let the app recreate them, but which and where
I know not...

Thanks for your helpful comments, though, because if I hadn't run it as
root before, I certainly have now! I just need to know what and where
are the files to delete etc!

--Richard E

Patrick Dixon wrote:
> I'm NOT a Linux expert (!) but I had a similar problem when I first tried
on
> FC3. I think you've probably installed as root and then started
slimserver
> as root when the slimserver daemon script didn't work as part of the
> install. As a result slimserver is using /root/ as the home directory and
> has put slimserversql.db and slimserver.db in /root/, and various other
> stuff under /root/usr/local/slimserver...
>
> You probably need to kill these and their locations in a config file
> somewhere (sorry not sure where), and then restart slimserver as a normal
> user (preferably slimserver:slimserver), whereupon it will create them
> somewhere more appropriate.
>
> HTH, Patrick