JJZolx;490711 Wrote:
> I'm unable to get MySQL to work at all. I've set MySQL as the database
> in performance settings, but when the scanner is launched it still uses
> SQLite. The main server appears to think MySQL is the database, as it
> has no idea that a scan is running, shows no progress, and zero tracks
> once the scan completes. Every time the server is started it launches a
> scan because it sees an empty database.
Results using Ubuntu 9.10 server very similar to the above. The SQLite
scan runs well and returns a working database; however after switching
to MySQL, altho' the scanner runs, including mysqld, it returns a 0
track list.
I deleted the MySQL cache in
/var/lib/squeezeboxserver/cache/MySQL/slimserver, and a new SQL db
appeared in it after the scan, but SBS could not use the db.
Log entries for each shown:
Code:
--------------------
SQLite scan
[09-12-02 10:14:44.2450] main::main (202) Starting Squeezebox Server scanner
(v7.5.0, r29492, Fri Nov 27 04:33:24 PST 2009) perl 5.010000
[09-12-02 10:15:03.5141] main::main (312) Removing artwork cache...
[09-12-02 10:15:16.3501] Slim::Music::Import::runImporter (496) Starting
Slim::Music::MusicFolderScan scan
[09-12-02 10:15:16.3544] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in /mnt/sdb1/Music
[09-12-02 10:15:44.1146] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-02 10:15:44.1184] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (4564)
[09-12-02 10:21:11.8689] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-02 10:21:11.8742] Slim::Music::Import::endImporter (630) Completed
Slim::Music::MusicFolderScan Scan in 355 seconds.
[09-12-02 10:21:12.4688] Slim::Music::Import::runImporter (496) Starting
Slim::Music::PlaylistFolderScan scan
[09-12-02 10:21:12.4992] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in /mnt/sdb1/Playlists2
[09-12-02 10:21:15.2344] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-02 10:21:15.2382] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (0)
[09-12-02 10:21:15.2416] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-02 10:21:15.2462] Slim::Music::Import::runScanPostProcessing (366)
Starting merge of various artists albums
[09-12-02 10:21:15.8349] Slim::Music::Import::endImporter (630) Completed
mergeVariousAlbums Scan in 0 seconds.
[09-12-02 10:21:17.6490] Slim::Music::Artwork::precacheAllArtwork (488)
Starting precacheArtwork for 267 albums
[09-12-02 10:24:17.4980] Slim::Music::Import::endImporter (630) Completed
precacheArtwork Scan in 181 seconds.
[09-12-02 10:24:17.5925] Slim::Music::Import::runScanPostProcessing (413)
Starting Database optimization.
[09-12-02 10:24:29.7345] Slim::Music::Import::endImporter (630) Completed
dbOptimize Scan in 12 seconds.
--------------------
Code:
--------------------
MySQL scan Log
[09-12-02 09:59:38.6626] main::main (202) Starting Squeezebox Server scanner
(v7.5.0, r29492, Fri Nov 27 04:33:24 PST 2009) perl 5.010000
[09-12-02 09:59:47.2778] Slim::Utils::SQLiteHelper::checkDataSource (214)
Warning: Scanner database found, checking for a newer scan...
[09-12-02 09:59:47.3152] Slim::Utils::SQLiteHelper::checkDataSource (235)
Warning: Scanner database contains a newer scan, using it
[09-12-02 10:00:00.0090] main::main (312) Removing artwork cache...
[09-12-02 10:00:14.3046] Slim::Music::Import::runImporter (496) Starting
Slim::Music::MusicFolderScan scan
[09-12-02 10:00:14.3089] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in /mnt/sdb1/Music
[09-12-02 10:00:43.3336] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-02 10:00:43.3374] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (4564)
[09-12-02 10:06:17.4674] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-02 10:06:17.4722] Slim::Music::Import::endImporter (630) Completed
Slim::Music::MusicFolderScan Scan in 363 seconds.
[09-12-02 10:06:18.4210] Slim::Music::Import::runImporter (496) Starting
Slim::Music::PlaylistFolderScan scan
[09-12-02 10:06:18.4615] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in /mnt/sdb1/Playlists2
[09-12-02 10:06:23.4909] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-02 10:06:23.4958] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (0)
[09-12-02 10:06:23.5017] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-02 10:06:23.5063] Slim::Music::Import::runScanPostProcessing (366)
Starting merge of various artists albums
[09-12-02 10:06:24.1322] Slim::Music::Import::endImporter (630) Completed
mergeVariousAlbums Scan in 0 seconds.
[09-12-02 10:06:26.0986] Slim::Music::Artwork::precacheAllArtwork (488)
Starting precacheArtwork for 267 albums
[09-12-02 10:09:24.6318] Slim::Music::Import::endImporter (630) Completed
precacheArtwork Scan in 180 seconds.
[09-12-02 10:09:24.6954] Slim::Music::Import::runScanPostProcessing (413)
Starting Database optimization.
[09-12-02 10:09:38.3301] Slim::Music::Import::endImporter (630) Completed
dbOptimize Scan in 13 seconds.
--------------------
--
Ramage
P2 266MHz, ubuntu server 9.10 SBS 7.5.0embedded r29492
AMD64x2 ubuntu 9.10, SBS 7.4.2 r29296
Dell 10v WinXP SBS 7.4.2-29296
Dell 10v ubuntu 9.10 netbook remix, SBS 7.5.0embedded r29492
Players: Classic, Duet, Boom
------------------------------------------------------------------------
Ramage's Profile: http://forums.slimdevices.com/member.php?userid=5343
View this thread: http://forums.slimdevices.com/showthread.php?t=71768
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
