Announce: SBS 7.4.2 for Broadcom/MIPSEL

[tadc]

Well... I got Optware running, and attempted the Squeezeserver package tonight. Following is the output, that mySQL error seems concerning. Any comments whether this is fatal?

I do have the SqueezeboxServer showing as running when I do a service command, also shows under ps... but the log shows "Squeezebox server died" over and over... and it occurred to me that I don't know how to configure this thing. Any hints?

Thanks!

squeezeboxserver_7.4.2-1_mipsel.ipk
Installing squeezeboxserver (7.4.2-1) to /opt/...
package squeezeboxserver suggests installing flac
Installing adduser (1.10.3-1) to /opt/...
Downloading 

http://ipkg.nslu2-linux.org/feeds/optware/ddwrt/cross/stable/add

user
_1.10.3-1_mipsel.ipk
Installing mysql5 (5.0.88-1) to /opt/...
Downloading 

http://ipkg.nslu2-linux.org/feeds/optware/ddwrt/cross/stable/mys

ql5_
5.0.88-1_mipsel.ipk
Configuring adduser
update-alternatives: Linking //opt/bin/su to coreutils-su
Configuring mysql5
Installing MySQL system tables...
120726 21:58:46 [Warning] option 

'myisam_max_extra_sort_file_size': unsigned val
ue 2147483648 adjusted to 2147483647
120726 21:58:46 [Warning] option 'thread_stack': unsigned value 

65536 adjusted t
o 131072
OK
Filling help tables...
120726 21:58:47 [Warning] option 

'myisam_max_extra_sort_file_size': unsigned val
ue 2147483648 adjusted to 2147483647
120726 21:58:47 [Warning] option 'thread_stack': unsigned value 

65536 adjusted t
o 131072
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/bin/mysqladmin -u root password 'new-password'
/opt/bin/mysqladmin -u root -h router password 'new-password'

Alternatively you can run:
/opt/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt ; /opt/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /opt/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at 

http://shop.mysql.com
Starting MySQL. ERROR! Manager of pid-file quit without updating 

file.
postinst script returned status 1
ERROR: mysql5.postinst returned 1
Configuring squeezeboxserver
Enter SQUEEZEBOXSERVER_HOME location [/home/squeezeboxserver]:

[anonymous247]

FYI: I've been plugging away at this approach - natively compiling the modules on the hardware. Wow, it is quite the ordeal, they have added MANY modules in the transition from 7.4 to 7.7, and many of them have problems compiling in that environment. It doesn't help that the MakeMaker module that comes with Perl 5.8.8 is so out-of-date. I've made some progress, but I really don't know if I'll end up with a work-able end product or not. My hastily scribbled notes on the progress so far are below.

Presuming I get to the end of all these library builds. What's the procedure for taking them and making a self-contained static perl build from them?

./buildme.sh Audio::Scan
	-Had to force linking of zlib ('EXTRALIBS="-L/opt/lib -lz" LDFLAGS="-L/opt/lib -Wl,-rpath,/opt/lib -Wl,-rpath,/opt/lib/perl5/5.8.8/mipsel-linux/CORE"')
./buildme.sh Class::C3::XS                                                                                                            
./buildme.sh Class::XSAccessor                                                                                                        
./buildme.sh Compress::Raw::Zlib                                                                                                      
SKIPPED./buildme.sh build DBI                                                                                                                     
SKIPPED./buildme.sh DBD::mysql                                                                                                        
SKIPPED./buildme.sh DBD::SQLite                                                                                                             
./buildme.sh Digest::SHA1                                                                                                             
./buildme.sh EV
	-Had to force linking of pthread library (EXTRALIBS="-L/opt/lib -lpthread")
./buildme.sh Encode::Detect
	-Had to build as shared.  Maybe would have worked if just linked to libperl.a. ('extra_linker_flags="-lstdc++ -shared"')
./buildme.sh Font::FreeType                                                                                                            
./buildme.sh HTML::Parser                                                                                                             
FAILED./buildme.sh Image::Scale 
	-Compilation fails due to handling of MYEXTLIB parameter by MakeMaker.
./buildme.sh IO::AIO
./buildme.sh IO::Interface
./buildme.sh JSON::XS
FAILED./buildme.sh Linux::Inotify2                           
FAILED./buildme.sh Locale::Hebrew                                                                                                           
SKIPPED ./buildme.sh Mac::FSEvents
./buildme.sh Media::Scan
	-Fixes to ffmpeg (HAVE_ROUND, HAVE_TRUC needed to be defined)
	-Fixes to bdb (fix for assembly issue in src/dbinc/mutex_int.h, needed to use .set mips2 in MUTEX_UNSET code)
PENDING./buildme.sh MP3::Cut::Gapless        
PENDING./buildme.sh Sub::Name
PENDING./buildme.sh Template                                                                                            
PENDING./buildme.sh XML::Parser
PENDING./buildme.sh YAML::LibYAML

[Steevee28]

Wow, it is quite the ordeal, they have added MANY modules in the transition from 7.4 to 7.7, and many of them have problems compiling in that environment. It doesn't help that the MakeMaker module that comes with Perl 5.8.8 is so out-of-date. I've made some progress, but I really don't know if I'll end up with a work-able end product or not. My hastily scribbled notes on the progress so far are below.

Presuming I get to the end of all these library builds. What's the procedure for taking them and making a self-contained static perl build from them?

SKIPPED./buildme.sh DBD::mysql                                                                                                        
FAILED./buildme.sh Linux::Inotify2                           
FAILED./buildme.sh Locale::Hebrew

I'll keep my fingers crossed...
Note that Inotify cannot work because of missing Inotify support of dd-wrt => just ignore.
Hebrew => ignore (sorry hebrews...)
Mysql/Sqlite: take the ones from optware (others as well if possible)

statically linking perl in the end: see http://perldoc.perl.org/ExtUtils/Mak...ew-Perl-Binary as a start.

Oh, one more note: I wrote some little keep-alive script on my own (see squeezeboxserver_safe in my ipkg), which is required to restart sbs in case mysql is restarted which obviously happened from time to time for some reason. So I believe that you want to include this script in your ipkg too.

[anonymous247]

Both Media::Scan and Image::Scale are having problems compiling due to the way MakeMaker seems to handle the MYEXTLIB parameter. This is the segment of the makefile that it generates:

MYEXTLIB = /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libmediascan$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libavformat$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libavcodec$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libswscale$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libavutil$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libexif$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libjpeg$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libpng$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libgif$(LIB_EXT) /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libdb$(LIB_EXT) 

...

# --- MakeMaker static_lib section:                                
                                                                                                                                    
$(INST_STATIC) : $(OBJECT) $(MYEXTLIB) $(INST_ARCHAUTODIR)$(DFSEP).exists
        $(RM_RF) $@                                                                                                                 
        $(CP) $(MYEXTLIB) $@                                             
        $(AR) $(AR_STATIC_ARGS) $@ $(OBJECT) && $(RANLIB) $@             
        $(CHMOD) $(PERM_RWX) $@                                          
        $(NOECHO) $(ECHO) "$(EXTRALIBS)" > $(INST_ARCHAUTODIR)/extralibs.ld

And this is an example of what happens when it tries to run:

rm -rf blib/arch/auto/Media/Scan/Scan.a
cp /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libmediascan.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libavformat.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libavcodec.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libswscale.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libavutil.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libexif.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libjpeg.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libpng.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libgif.a /opt/tmp/lmsbuild/vendor/CPAN/build/include/../lib/libdb.a  blib/arch/auto/Media/Scan/Scan.a
target `blib/arch/auto/Media/Scan/Scan.a' is not a directory
make: *** [blib/arch/auto/Media/Scan/Scan.a] Error 1

So it fails because it is trying to copy a bunch of static libs to a destination named "blib/arch/auto/Media/Scan/Scan.a". Why is it trying to do this? That destination is not a directory. Looking at the code for MakeMaker itself, it says:

      # If this extension has it's own library (eg SDBM_File)
      # then copy that to $(INST_STATIC) and add $(OBJECT) into it.
      $m .= <<'END'  if $self->{MYEXTLIB};
  	$self->{CP} $(MYEXTLIB) $@

But that's no help. MYEXTLIB is a list of libs, how can it try and copy it to a single, non-directory location? Shouldn't it just include them in the subsequent AR command? Someone else must have built these modules (andyg seems to be the author for both). Any advice on the right way to resolve the problem?

[tadc]

HI again. I have Optware installed now and attempted installing the SBS package but seem to have run into an issue.

First problem, I realized I don't know how to configure the server! During the package install, I get prompted for the home location, but then the install "terminates successfully".

At that point I can see the Squeezebox Service is running according to the service command, but in the server.log, all I see is a whole lot of

 2012-07-26 22:13:34 Squeezebox Server died. Restarting.

over and over again.
Also, during the install I got the following during the MySQL install. Is this fatal? Any clues on what went wrong or troubleshooting tips?

Starting MySQL. ERROR! Manager of pid-file quit without updating 

file.
postinst script returned status 1
ERROR: mysql5.postinst returned 1

Thanks!

[Steevee28]

At that point I can see the Squeezebox Service is running according to the service command, but in the server.log, all I see is a whole lot of

 2012-07-26 22:13:34 Squeezebox Server died. Restarting.

over and over again.
Also, during the install I got the following during the MySQL install. Is this fatal? Any clues on what went wrong or troubleshooting tips?

Hi, I believe that MySQL causes SBS to crash. I barely remember that there was some problem with the SQL databases initially created/deployed with SBS.
Some time ago, I wrote a little startup script /opt/etc/init.d/S69initMysqlDB that helps in situations when /opt/var points to /tmp (ramfs).

#!/bin/sh

# this script creates some basic system databases for mysqld if not already present in /opt/var/mysql.
# this is especially useful when /opt/var is moved to ramfs and thus empty after reboot

# NOTE: this script assumes that the MySQL datadir is set to /opt/var/mysql

if [ ! -d /opt/var/mysql ] && [ -x /opt/bin/mysql_install_db ]; then
        mkdir /opt/var/mysql
        /opt/bin/mysql_install_db --basedir=/opt --datadir=/opt/var/mysql --user=mysql
fi

Actually, this should not influence SBS, because it creates its own server with own settings, but perhaps this helps tracking down the issue.
Regards,
Stefan

[anonymous247]

Regarding the update to Logitech Media Server 7.7.2. I have good news and bad news.

The good:
-I got the perl binary libs compiled
-I got a static perl binary compiled
-I got the perl binary bundled using nslu2 packaging templates from squeezecenter
-It installs & runs, and I can access the webserver and go through the initial config wizard.

The bad:
-It freezes/crashes shortly after that (believe while running scanner.pl).
-It consumes more memory than 7.4.2 (96MB for slimserver.pl alone)

Logs (even when using all the debug command-line params) do not give a clear indication as to what is going wrong. I have posted the IPK here:

http://www.sendspace.com/file/x739ae

If anyone has an interest in debugging further to get it working, that's great, but I've reached the limits of what my tinkering curiosity will allow me to do. I've run out of free evenings and sacrificial chickens to fuel this endeavour. Which sucks, because it does feel close to functioning. At this point, I just want a working build and 7.4.2 should be enough for that. If anyone wants more info (eg: the build directory used to produce the custom perl binary, or the packaging directory used to build the IPK), I'd be happy to post it.

[Steevee28]

At that point I can see the Squeezebox Service is running according to the service command, but in the server.log, all I see is a whole lot of

 2012-07-26 22:13:34 Squeezebox Server died. Restarting.

over and over again.

Hi tadc,
I'm just curious: did you finally get it working?

[tadc]

Hi tadc,
I'm just curious: did you finally get it working?

I'm afraid not. My time (and Linux skills) are pretty limited for troubleshooting.

I ended up taking the easy way out - I coincidentally had an old netbook with a failed battery, so I decided to make that a dedicated SB server.