[slim] Re: 6.5.0 Unable to scan
stuorguk;137998 Wrote: > Fixed! I upgraded to MySQL 5, then on restarting Slimserver, it said > DBD wasn't found. So I reinstalled the perl module, and now it's > working. Excellent. Dan's also provided a good fix for my problem (in the bug I referenced earlier on), so we're both happy. I'm going to give the MySQL wiki page a bit of a tickle since it's a little out of date now we have 6.5.0. Stuart -- hickinbottoms -"Never put off until tomorrow what you can put off until the day after - with 'Lazy Searching' (http://hickinbottom.demon.co.uk/lazysearch)!"- hickinbottoms's Profile: http://forums.slimdevices.com/member.php?userid=255 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
Fixed! I upgraded to MySQL 5, then on restarting Slimserver, it said DBD wasn't found. So I reinstalled the perl module, and now it's working. -- stuorguk stuorguk's Profile: http://forums.slimdevices.com/member.php?userid=521 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
hickinbottoms;137923 Wrote: > > Also, you say you're using your own instance now - have you seen a > message soon after launching SlimServer saying that SlimServer isn't > starting its own because you've got your own instance? > Stuart Yeah, I did check that thanks - only my own MySQL is running. I guess the next step is to upgrade MySQL to version 5.0, although I can't see that making any difference if Slims own version also gives me the same error. -- stuorguk stuorguk's Profile: http://forums.slimdevices.com/member.php?userid=521 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
stuorguk;137921 Wrote: > Thanks Stuart, but that wasn't it. :( Shame - although I'm sure you're right it does look similar in that the main server process starts up fine and can do all manner of database stuff, but the child 'scanner.pl' process doesn't seem to have the same success. I'm sure I remember seeing some other forum posts from a week or so ago that mentioned "transactions not supported" - perhaps they might help. I've not seen that particular one myself. Also, you say you're using your own instance now - have you seen a message soon after launching SlimServer saying that SlimServer isn't starting its own because you've got your own instance? That should be the case, but best to check in case there's some confusion and it's starting one anyway. Stuart -- hickinbottoms -"Never put off until tomorrow what you can put off until the day after - with 'Lazy Searching' (http://hickinbottom.demon.co.uk/lazysearch)!"- hickinbottoms's Profile: http://forums.slimdevices.com/member.php?userid=255 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
hickinbottoms;137917 Wrote: > I think I can help you there... > Thanks Stuart, but that wasn't it. :( -- stuorguk stuorguk's Profile: http://forums.slimdevices.com/member.php?userid=521 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
stuorguk;137908 Wrote: > I have now switched over to my own local instance of mysql, and the > tables have been created, but still the same error :( I think I can help you there... Take a look at this bug - I think it might be the same thing: http://bugs.slimdevices.com/show_bug.cgi?id=4160 I'm currently looking into that on my system, but KDF noted a possible workaround in there that does work for me. Give that a go and if you have the same problem perhaps you could drop something into that bug (and add yourself to the CC list). Stuart -- hickinbottoms -"Never put off until tomorrow what you can put off until the day after - with 'Lazy Searching' (http://hickinbottom.demon.co.uk/lazysearch)!"- hickinbottoms's Profile: http://forums.slimdevices.com/member.php?userid=255 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
I have now switched over to my own local instance of mysql, and the tables have been created, but still the same error :( -- stuorguk stuorguk's Profile: http://forums.slimdevices.com/member.php?userid=521 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
> > * whether you have mysql present on Gentoo already, and if so, what > version > 4.1.21 > > * whether you're expecting to use that existing instance, or the one > that comes with SlimServer (I admit I've only used my own instance). > Left it as is for now. I asked in another thread if it was better to use my existing mysql to save on recourses. > > Probably a longer snip from the log might be useful - run the server > with "--d_import --d_server --d_mysql --d_sql" so that it logs some > more useful stuff. > Code: 2006-09-21 12:28:58.3114 Firmware init... 2006-09-21 12:28:58.3133 SlimServer Info init... 2006-09-21 12:28:58.8933 SlimServer IR init... 2006-09-21 12:28:58.9184 SlimServer Request init... 2006-09-21 12:28:58.9248 SlimServer Buttons init... 2006-09-21 12:28:58.9317 SlimServer Graphic Fonts init... 2006-09-21 12:28:58.9442 UDP init... 2006-09-21 12:28:58.9463 Slimproto Init... 2006-09-21 12:28:58.9481 mDNS init... 2006-09-21 12:28:58.9487 Async Networking init... 2006-09-21 12:28:58.9794 UPnP init... 2006-09-21 12:28:58.9869 SlimServer HTTP init... 2006-09-21 12:28:58.9950 mDNS startAdvertising... 2006-09-21 12:28:59.0095 Source conversion init.. 2006-09-21 12:28:59.0143 SlimServer Plugins init... 2006-09-21 12:28:59.7309 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicm agic_mixable FROM genres me: 2006-09-21 12:28:59.9239 SlimServer checkDataSource... 2006-09-21 12:28:59.9280 SELECT COUNT( * ) FROM tracks me: 2006-09-21 12:28:59.9423 SlimServer persist playlists... 2006-09-21 12:28:59.9426 SlimServer done init... 2006-09-21 12:29:04.9551 SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknu m, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.c over, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagvers ion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, m e.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:2 0:05:b2:e7' 2006-09-21 12:29:46.9705 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-09-21 12:29:48.3653 SlimServer OSDetect init... 2006-09-21 12:29:48.3658 SlimServer OS Specific init... 2006-09-21 12:29:48.3659 SlimServer settings init... 2006-09-21 12:29:48.3927 SlimServer strings init... 2006-09-21 12:29:48.7752 SlimServer Info init... 2006-09-21 12:29:49.3629 SlimServer changing process priority to 0 2006-09-21 12:29:49.3682 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-09-21 12:29:49.3812 Import: Adding Slim::Music::PlaylistFolderScan Scan 2006-09-21 12:29:49.3816 Import: Adding Slim::Music::MusicFolderScan Scan 2006-09-21 12:29:49.3817 SlimServer done init... 2006-09-21 12:29:49.3826 ERROR: Scanner: Failed to update isScanning: [Transactions not supported by database at /usr/local/ slimserver/CPAN/DBI.pm line 1657. ] Transactions not supported by database at /usr/local/slimserver/scanner.pl line 140. 2006-09-21 12:29:49.3835 Got to the END. 2006-09-21 12:29:49.3837 Got sigint. 2006-09-21 12:29:49.3838 SlimServer cleaning up. 2006-09-21 12:29:49.3862 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' BEGIN WORK 2006-09-21 12:30:16.9989 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2006-09-21 12:30:17.0033 Import: Wiped all in-memory caches. 2006-09-21 12:30:17.0077 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicm agic_mixable FROM genres me: -- stuorguk stuorguk's Profile: http://forums.slimdevices.com/member.php?userid=521 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] Re: 6.5.0 Unable to scan
stuorguk;137885 Wrote: > Help! I'm running Gentoo. Hopefully not a general statement! I run on Gentoo as well, with my own instance of MySQL. Can you describe some things about your config: * whether you have mysql present on Gentoo already, and if so, what version * whether you're expecting to use that existing instance, or the one that comes with SlimServer (I admit I've only used my own instance). * if you want to use your own instance, what you put in your slimserver.pref (although not your password, of course!). Probably a longer snip from the log might be useful - run the server with "--d_import --d_server --d_mysql --d_sql" so that it logs some more useful stuff. Stuart -- hickinbottoms -"Never put off until tomorrow what you can put off until the day after - with 'Lazy Searching' (http://hickinbottom.demon.co.uk/lazysearch)!"- hickinbottoms's Profile: http://forums.slimdevices.com/member.php?userid=255 View this thread: http://forums.slimdevices.com/showthread.php?t=27632 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
