Home of the Squeezebox™ & Transporter® network music players.
Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 44
  1. #21
    Junior Member andybjackson's Avatar
    Join Date
    Aug 2008
    Location
    Haslemere, UK
    Posts
    28

    SSOXX on LinkStation Live fails for lack of MySQL

    Thanks Flipflip,

    I am talking about running SSODS (or SSOXX). I will try your advice.

    I'd prefer to get the full version of SBS running lest I lose any functionality (I use IRBlaster and would like to get transcoding working). That said I don't actually know what I'd be giving up. I think I have read that the two streams will merge at some point in the future.

    You are a legend for helping.

    Thank you and best regards
    Andy Jackson

  2. #22
    Senior Member flipflip's Avatar
    Join Date
    Apr 2006
    Location
    Shameland
    Posts
    1,402
    You need to use an even older one. Also Audio::Scan has been updated in the mean time.
    I'm using r30249.

    I'll update the packages as soon as I find the time.
    Check out flipflip's Squeezebox Server On (some) DiskStation (SSODS) and on (some) TurboStations (SSOTS) and some other devices! Please do NOT file SSODS bugs in (SD's) bugzilla. Use the forums. And only the forums. Thanks.

  3. #23
    Junior Member andybjackson's Avatar
    Join Date
    Aug 2008
    Location
    Haslemere, UK
    Posts
    28

    Now have MySQL, but can't connect through socket

    Closer, but no cigar just yet.

    I have installed MySQL4 but get the error message shown in the log below. Is this because I need MySQL5 (which, when installing via Optware, was demanding some configuration that I didn't know how to complete) or because I need to do some config on MySQL in v4?

    [UPDATE] Also tried the embedded version but hit a dead end because the version of Scan is v0.61 and not 0.62 per flipflip's note above. See second server log.

    Thanks for any help.
    Andy

    0366: [10-03-08 22:06:15.6095] Slim::Utils::MySQLHelper::createSystemTables (500) FATAL: Couldn't connect to database: [Can't connect to local MySQL server through socket '/opt/ssods4/var/home/SqueezeboxServer/Cache/squeezebox-mysql.sock' (2)]
    0365:
    0364: 100308 22:05:41 [ERROR] /opt/ssods4/bin/mysqld: unknown variable 'innodb_fast_shutdown=1'
    0363: [10-03-08 22:05:37 ] ssctrl Setting nice level to +0
    0362: [10-03-08 22:05:37 ] ssctrl SqueezeboxServer started.
    0361: [10-03-08 22:05:36.0168] main::init (320) Starting Squeezebox Server (v7.4.2, r30215, Fri Feb 19 16:24:20 MST 2010) perl 5.010000
    0360: [10-03-08 22:05:36.0205] main::init (320) Starting Squeezebox Server (v7.4.2, r30215, Fri Feb 19 16:24:20 MST 2010) perl 5.010000
    0359: [10-03-08 22:05:01 ] ssctrl Command line = /opt/ssods4/var/home/SqueezeboxServer/slimserver.pl --daemon --pidfile /opt/ssods4/var/home/SqueezeboxServer/Cache/squeezecenter.pid --cachedir /opt/ssods4/var/home/SqueezeboxServer/Cache --logdir /opt/ssods4/var/home/SqueezeboxServer/Logs --prefsdir /opt/ssods4/var/home/SqueezeboxServer/Prefs --noupnp --priority 0 --user ssods --group ssods
    0358: [10-03-08 22:04:56 ] ssctrl Starting SqueezeboxServer 7.4.2-30215.

    0361: Audio::Scan (loaded 0.61, need 0.62)
    0360: The following CPAN modules were found but cannot work with Squeezebox Server:
    Last edited by andybjackson; 2010-03-08 at 15:35.

  4. #24
    Senior Member flipflip's Avatar
    Join Date
    Apr 2006
    Location
    Shameland
    Posts
    1,402
    > 0364: 100308 22:05:41 [ERROR] /opt/ssods4/bin/mysqld: unknown variable 'innodb_fast_shutdown=1'

    Not sure. I think it means that the mysqld binary does not have "innodb" support, which is some sort of database storage format or so that mysql can use, which SBS needs. Don't know. Never liked mysql anyway :-) Or maybe because /opt/ssods4/bin/mysqld is not a symlink and the mysqld cannot find its plugins/components.

    You could install "subversion" (svn) from optware and checkout an embedded branch version that should work as follows:

    cd /opt/ssods4/var/home/
    mv SqueezeboxServer SqueezeboxServer.old
    svn co -r30249 http://svn.slimdevices.com/repos/sli...mbedded/server SqueezeboxServer

    This version works here (crashes approx. once a week..).
    Check out flipflip's Squeezebox Server On (some) DiskStation (SSODS) and on (some) TurboStations (SSOTS) and some other devices! Please do NOT file SSODS bugs in (SD's) bugzilla. Use the forums. And only the forums. Thanks.

  5. #25
    Senior Member
    Join Date
    Jun 2006
    Posts
    739
    Any of you guys want to take a crack at writing a step-by-step instruction to install 7.5 by the method you're describing in this thread?

    I don't know much Linux, as the only Linux I've ever used is on my Squeezebox installs, so I probably won't be able to figure this out on my own. (I do not, for example, know the exact command line to input when someone says to "unpack a tarball".) But if I can get this running on my own LinkStations, I could probably clean up the instructions and flesh them out some more in a "for dummies" type of format, as in this thread http://forums.slimdevices.com/showthread.php?t=62842.

  6. #26
    Senior Member flipflip's Avatar
    Join Date
    Apr 2006
    Location
    Shameland
    Posts
    1,402
    You should be able to follow the instructions at http://oinkzwurgl.org/ssods_installation

    There are two things that are specific to a certain NAS:

    - The installation directory (e.g. /volume1/SSODS4 on a Diskstation). You have to figure out on what path your data partition is mounted. You can use the "df" command to find out.

    - Find a place to hook the SSODS autostart script into (usually /etc/rc2.d on Linux, but often different on NAS).

    I'm sure the folks who have installed it successfully can help here.

    I'd be happy to add LS specific instructions to my page.
    Check out flipflip's Squeezebox Server On (some) DiskStation (SSODS) and on (some) TurboStations (SSOTS) and some other devices! Please do NOT file SSODS bugs in (SD's) bugzilla. Use the forums. And only the forums. Thanks.

  7. #27
    Senior Member
    Join Date
    Jun 2006
    Posts
    739
    Quote Originally Posted by flipflip View Post
    You should be able to follow the instructions at http://oinkzwurgl.org/ssods_installation
    This looks promising. When I get a chance, I'll give it a go on one of my LinkStations.

  8. #28
    Senior Member
    Join Date
    Jun 2005
    Posts
    274
    I've previously run 7.3.something on my LS without the aid of SSODS (which I've just now discovered!) and wish to upgrade to 7.5.0. I've installed SSODS 4.8 and the SBS 7.5 tarball. The server tries to start but crashes on a mysql problem; the apparently relevant lines of the log are:

    0374: [10-04-11 21:43:24.5214] Slim::Utils::MySQLHelper::createSystemTables (506) FATAL: Couldn't connect to database: [Can't connect to local MySQL server through socket '/opt/ssods4/var/home/SqueezeboxServer/Cache/squeezebox-mysql.sock' (2)]
    0373:
    0372: 100411 21:42:51 [ERROR] Aborting
    0371: Check that the above file is the right version for this program!
    0370: but it should contain at least 475 error messages.
    0369: 100411 21:42:51 [ERROR] Error message file '/mnt/disk1/SSODS4/var/home/SqueezeboxServer/MySQL/errmsg.sys' had only 463 error messages,
    0368: [10-04-11 21:42:48 ] ssctrl Setting nice level to +0
    0367: [10-04-11 21:42:47 ] ssctrl SqueezeboxServer started.
    0366: [10-04-11 21:42:46.9027] main::init (323) Starting Squeezebox Server (v7.5.0, r30464, Thu Apr 1 06:28:42 MDT 2010) perl 5.010000
    0365: [10-04-11 21:42:46.9063] main::init (323) Starting Squeezebox Server (v7.5.0, r30464, Thu Apr 1 06:28:42 MDT 2010) perl 5.010000
    0364: [10-04-11 21:42:23 ] ssctrl Command line = /opt/ssods4/var/home/SqueezeboxServer/slimserver.pl --daemon --pidfile /opt/ssods4/var/home/SqueezeboxServer/Cache/squeezecenter.pid --cachedir /opt/ssods4/var/home/SqueezeboxServer/Cache --logdir /opt/ssods4/var/home/SqueezeboxServer/Logs --prefsdir /opt/ssods4/var/home/SqueezeboxServer/Prefs --noupnp --priority 0 --user ssods --group ssods
    0363: [10-04-11 21:42:21 ] ssctrl Patching /opt/ssods4/var/home/SqueezeboxServer/Bin/arm-linux/sls
    0362: [10-04-11 21:42:19 ] ssctrl Starting SqueezeboxServer 7.5.0-30464.
    System info from SSODS:
    System

    Hard-/Firmware : unknown (GenericLinux)
    Load / Uptime : 0.04 0.23 0.30 / 9d 21.17:30 (77% idle)
    Memory -- Swap : 80/123 MB (shr: 0, buf: 14, cache: 30, rss: 36) -- 51/133 MB

    SqueezeboxServer

    Version : 7.5.0-30464
    Process status : not running
    SSOXX/SBS flags: noupnp en_GB.UTF-8

    MySQL

    Version : 5.0.51a-24~bpo40+1 (system mysqld)
    Database size : 0
    Process status : not running
    uname:
    Linux storage 2.6.12.6-arm1 #77 Tue Dec 5 22:23:46 CST 2006 armv5tejl GNU/Linux
    My MySQL version:
    mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (arm) using readline 5.2
    That was installed for the old SS installation; should I remove it? Is its presence blocking something else?

    (Any other system info I should provide?)

    I've seen "embedded" mentioned here, but I don't know what that is exactly... is it a SBS branch? Should I be trying it? If I do, will it be compatible with my old SB2 as well as the Radio I'm intending to buy (if I can get 7.5 running first)?

    I also notice that the Prefs directory has no "server.prefs" (I checked to see if I could get clues about what it wanted to do with mysql). Is that just because it crashed before that could be created, or could it be relevant to my problem?

    Thanks for SSODS btw, flipflip. If I can get this running it will surely make my life easier in future; it's been a lot easier than for previous versions of SS so far! And thanks in advance for any advice you can offer me.

  9. #29
    Senior Member flipflip's Avatar
    Join Date
    Apr 2006
    Location
    Shameland
    Posts
    1,402
    If /opt/ssods4/bin/mysqld is a symlink to the mysqld (often /usr/libexec/mysqld, or /usr/local/libexec/mysqld) then SSODS (or more specifically, the ssctrl script) tries to locate the correct errmsg.sys and errmsg.txt files for your particular version of mysql. If it finds these it will copy them to /mnt/disk1/SSODS4/var/home/SqueezeboxServer/MySQL/ where SBS (?) will find them.

    It probably fails doing so. Try locating these files and copy them to /mnt/disk1/SSODS4/var/home/SqueezeboxServer/MySQL/

    find / -name "errmsg.sys"
    find / -name "errmsg.txt"

    You would often find the errmsg.sys file multiple times for different languages. Choose the english one.
    Check out flipflip's Squeezebox Server On (some) DiskStation (SSODS) and on (some) TurboStations (SSOTS) and some other devices! Please do NOT file SSODS bugs in (SD's) bugzilla. Use the forums. And only the forums. Thanks.

  10. #30
    Senior Member
    Join Date
    Jun 2005
    Posts
    274
    Quote Originally Posted by flipflip View Post
    It probably fails doing so. Try locating these files and copy them to /mnt/disk1/SSODS4/var/home/SqueezeboxServer/MySQL/

    find / -name "errmsg.sys"
    find / -name "errmsg.txt"

    You would often find the errmsg.sys file multiple times for different languages. Choose the english one.
    Thanks. I found it in "/usr/share/mysql/english/" -- but the "mysql" part there is actually a symlink to a directory on the data drive, which I use for holding large installations. Would the symlink have frustrated the script's attempt to find the file?

    I have copied the sys file (but can't find a txt file); here we go...

    Excellent! It seems to be running! Thanks so much. Next step: scanning and playing music.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •