On Mandrake 10.0, I installed libupnp (libupnp-1.2.1a.tar.gz) and sqlite3 (sqlite-3.3.3.tar.gz) with no error.
Then I installed mediatomb (configure, make, make install and tomb-install) : again, no error.
But when I launched mediatomb, I get this :
Sounds like you are right : .mediatomb/sqlite3.db is a 0 octet file.
I don't see any mediatomb directory in /usr/share.
Perhaps were you talking about /usr/local/share/mediatomb/sqlite3.sql ?
I tried with this one but I received this message :
CREATE TABLE cds_objects
(
id INTEGER PRIMARY KEY DEFAULT 0,
ref_id INTEGER,
parent_id INTEGER NOT NULL,
object_type INTEGER NOT NULL,
upnp_class VARCHAR(80),
dc_title VARCHAR(255),
is_restricted INTEGER NOT NULL DEFAULT 0,
is_virtual INTEGER NOT NULL DEFAULT 0,
location VARCHAR(255),
metadata TEXT,
auxdata TEXT,
resources TEXT,
update_id INTEGER NOT NULL DEFAULT 0,
is_searchable INTEGER NOT NULL DEFAULT 0,
mime_type VARCHAR(40),
action VARCHAR(255),
state VARCHAR(255),
flags INTEGER NOT NULL DEFAULT 0,
display_prio INTEGER NOT NULL DEFAULT 0
);
SQL error: disk I/O error
CREATE INDEX cds_objects_ref_id ON cds_objects(ref_id);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_parent_id ON cds_objects(parent_id);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_object_type ON cds_objects(object_type);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_is_virtual ON cds_objects(is_virtual);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_mime_type ON cds_objects(mime_type);
SQL error: no such table: main.cds_objects
INSERT INTO cds_objects(id, parent_id, object_type, dc_title, upnp_class)
VALUES (0, -1, 1, 'Root', 'object.container');
SQL error: no such table: cds_objects
INSERT INTO cds_objects(id, parent_id, object_type, dc_title, upnp_class)
VALUES (1, 0, 1, 'PC Directory', 'object.container');
SQL error: no such table: cds_objects
regarding the path: yes, you guessed right; depending on the installation the paths can vary.
now regarding your problem:
from what directory were you trying to run the command? do you have write permissions there?
is your disk full? the problem you are having is somehow related to your system; I doubt that it is directly linked to mediatomb or sqlite - it just seems you can not write to your disk, that's all...
greetings,
Jin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I ran the command from my home directory where I have all permissions. There's 17Go free on the disk.
I tried to run the command from the / as root and it worked so you were totally right : the problem comes from my system and not from mediatomb nor sqlite...
I'll try to solve this mystery with my system administrator.
Thanks for your help and availability,
Keep the good work !
cocob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hello,
On Mandrake 10.0, I installed libupnp (libupnp-1.2.1a.tar.gz) and sqlite3 (sqlite-3.3.3.tar.gz) with no error.
Then I installed mediatomb (configure, make, make install and tomb-install) : again, no error.
But when I launched mediatomb, I get this :
******************************************************
2006-01-01 15:05:32 INFO: ======== MediaTomb UPnP Server version 0.8.1 ========
2006-01-01 15:05:32 INFO: Loading configuration from ~/.mediatomb/config.xml
2006-01-01 15:05:32 INFO: Loading configuration from: /users/ceib7473/.mediatomb/config.xml
2006-01-01 15:05:32 INFO: UUID GENERATED!: bba7f32f-32fb-40ee-a455-73864304c160
2006-01-01 15:05:32 INFO: Checking configuration...
2006-01-01 15:05:32 INFO: Config: option not found: /server/servedir using default value:
2006-01-01 15:05:32 INFO: Config: option not found: /import/metadata-charset using default value: ISO-8859-1
2006-01-01 15:05:32 INFO: checking ip..
2006-01-01 15:05:32 INFO: Config: option not found: /server/ip using default value:
2006-01-01 15:05:32 INFO: Config: option not found: /server/bookmark using default value: mediatomb.html
2006-01-01 15:05:32 INFO: Config: option not found: /server/port using default value: 0
2006-01-01 15:05:32 INFO: Config: option not found: /server/alive using default value: 180
2006-01-01 15:05:32 INFO: Configuration check succeeded.
2006-01-01 15:05:32 INFO: Config: option not found: /server/ip using default value:
2006-01-01 15:05:32 INFO: got ip: (null)
2006-01-01 15:05:32 INFO: Initialized port: 49152
2006-01-01 15:05:32 INFO: Server bound to: 10.193.13.144
2006-01-01 15:05:32 INFO: upnp_init: webroot: /usr/local/share/mediatomb/web
2006-01-01 15:05:34 WARNING: SQLITE3: (1) no such table: cds_objects
Query:SELECT COUNT(*) FROM cds_objects WHERE object_type <> 1 AND is_virtual = 0
Exception: Sqlite3: query error
_STRACE_ 0 mediatomb [0x806f76f]
_STRACE_ 1 mediatomb [0x8055aa1]
_STRACE_ 2 mediatomb [0x80660ca]
_STRACE_ 3 mediatomb [0x80670d0]
_STRACE_ 4 mediatomb [0x804ba81]
_STRACE_ 5 mediatomb [0x8051f4d]
_STRACE_ 6 mediatomb [0x805208f]
_STRACE_ 7 /lib/tls/libpthread.so.0 [0x402f1b3c]
_STRACE_ 8 /lib/tls/libc.so.6(__clone+0x5a) [0x4028c93a]
*****************************************************
and if I try to browse mediatomb.html, Iget this message :
*****************************************************
An error has occured. Press Back in your browser to return to the previous page.
Error message: Sqlite3: query error
*****************************************************
Any idea of the source of the problem ?
cocob
hmm, it sounds like the database file has not been initialized, maybe tomb-install failed to create it properly?
you could try to create the database manually:
cat /usr/share/mediatomb/sqlite3.sql | sqlite3 sqlite3.db
put the sqlite3.db file in your ~/.mediatomb/ directory (or whatever you specified in the config.xml file)
does it solve the problem?
Jin
Sounds like you are right : .mediatomb/sqlite3.db is a 0 octet file.
I don't see any mediatomb directory in /usr/share.
Perhaps were you talking about /usr/local/share/mediatomb/sqlite3.sql ?
I tried with this one but I received this message :
********************************************************
CREATE TABLE cds_objects
(
id INTEGER PRIMARY KEY DEFAULT 0,
ref_id INTEGER,
parent_id INTEGER NOT NULL,
object_type INTEGER NOT NULL,
upnp_class VARCHAR(80),
dc_title VARCHAR(255),
is_restricted INTEGER NOT NULL DEFAULT 0,
is_virtual INTEGER NOT NULL DEFAULT 0,
location VARCHAR(255),
metadata TEXT,
auxdata TEXT,
resources TEXT,
update_id INTEGER NOT NULL DEFAULT 0,
is_searchable INTEGER NOT NULL DEFAULT 0,
mime_type VARCHAR(40),
action VARCHAR(255),
state VARCHAR(255),
flags INTEGER NOT NULL DEFAULT 0,
display_prio INTEGER NOT NULL DEFAULT 0
);
SQL error: disk I/O error
CREATE INDEX cds_objects_ref_id ON cds_objects(ref_id);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_parent_id ON cds_objects(parent_id);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_object_type ON cds_objects(object_type);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_is_virtual ON cds_objects(is_virtual);
SQL error: no such table: main.cds_objects
CREATE INDEX cds_objects_mime_type ON cds_objects(mime_type);
SQL error: no such table: main.cds_objects
INSERT INTO cds_objects(id, parent_id, object_type, dc_title, upnp_class)
VALUES (0, -1, 1, 'Root', 'object.container');
SQL error: no such table: cds_objects
INSERT INTO cds_objects(id, parent_id, object_type, dc_title, upnp_class)
VALUES (1, 0, 1, 'PC Directory', 'object.container');
SQL error: no such table: cds_objects
*******************************************************
disk I/O error ? seems that sqlite3 has some problems to write on my disk...
cocob
regarding the path: yes, you guessed right; depending on the installation the paths can vary.
now regarding your problem:
from what directory were you trying to run the command? do you have write permissions there?
is your disk full? the problem you are having is somehow related to your system; I doubt that it is directly linked to mediatomb or sqlite - it just seems you can not write to your disk, that's all...
greetings,
Jin
I ran the command from my home directory where I have all permissions. There's 17Go free on the disk.
I tried to run the command from the / as root and it worked so you were totally right : the problem comes from my system and not from mediatomb nor sqlite...
I'll try to solve this mystery with my system administrator.
Thanks for your help and availability,
Keep the good work !
cocob