Logitech Media Server v7.2.2 (aka LMS) optware make packages [1 Attachment]

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Logitech Media Server v7.2.2 (aka LMS) optware make packages [1 Attachment]

Sergey Talchuk
<*>[Attachment(s) from Sergey Talchuk included below]

Hi ALL!

I’m a happy user of Squeezebox Touch. What a luck that SqueezeCenter v7.3.3 is available in optware repository!
However, with a time a problem occurred: very often Squeezebox Touch rendered a message stating that Steam Server is outdated and should be updated. And the only way to listen to the music library on my NAS was to restart SqueezeCenter. This was a really annoying problem. That is why I decided to build the most current slimserver version (aka Logitech Medias Server v7.7.2).
By default LMS v7.7.2 uses SQLite DB. But I would like to use MySQL just because:
1) I like MySQL more than SQLite
2) MySQL has native utf-8 support and it is fast
3) Without ICU SQLite can have problems in searching for case sensitive non-latin characters
4) With ICU SQLite becomes bigger and slower.

Unfortunately, I didn’t manage to resolve the following issue with perl-dbd-mysql: ‘Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::mysql::st execute failed: Column 'contributor' cannot be null’. Also it didn’t help:
-building with ‘mysql5’;
-downgrading ‘perl-dbd-mysql’ to v3.0002 (make file and patch can be found in ‘_downgrades’ dir; See attachment.)
I believe the problem is somewhere between DBI, DBIx::Class, DBD::mysql.

LMS v7.7.2 works fine for me with SQLite since all my media files are in utf-8 encoding. But I hope that some users with better experience can resolve the issue with MySQL and other issues (see ‘KnownIssues.txt’ for more details), adjust, optimize my make files, build LMS v7.7.2 as optware package and upload it and the dependent packages for public use.

Thank you,
Sergey

P.S. Here is the instruction how to build, install and use LMS v7.7.2 (‘cs05q1armel’ platform as an example).
NOTE: To successfully build LMS v7.7.2 you will need ‘inotify.h’ for you platform.

COMPILATION
===========
1. Copy the SVN tree as root:
        $ svn co http://svn.nslu2-linux.org/svnroot/optware/trunk optware
2. Build the toolchain:
        $ cd optware
        $ platform=cs05q1armel
        $ make ${platform}-target
        $ cd ${platform}
        $ make directories toolchain ipkg-utils
3. Unpack the attachment with LMS v7.2.2 make files:
        tar Jxvf LMS_7.7.2_optware_make_files.tar.xz
4. Build LMS 7.7.2
        for f in `cat myPackageList.txt` ; do make ${f}-ipk ; done

INSTALLATION:
============
NOTE: LMS v7.7.2 depends on some new and existing upgraded/downgraded optware packages. That is why the installation is performed in several stages:
1)
        ipkg install giflib_4.1.6-1_arm.ipk libexif libjpeg libpng libdb52 ffmpeg perl-compress-zlib perl-digest-sha1 perl-encode-detect perl-template-toolkit mysql
2)
        ipkg install libmediascan_0.1-1_arm.ipk
3) Install all the rest of perl-*.ipk packages
        for f in perl-*.ipk ; do ipkg install $f ; done
4) Comment optware packages feed URL:
        sed -i '1s/^/#/' /opt/etc/ipkg/*.conf
5) Remove incompatible package versions:
        ipkg -force-depends remove ffmpeg perl-dbi
6) Install some downgraded packages and LMS v7.7.2:
        ipkg install perl-dbi_1.616-1_arm.ipk ffmpeg_0.8.4-1_arm.ipk logitechmediaserver_7.7.2-1_arm.ipk
7) Uncomment optware packages feed URL:
        sed -i '1s/#//' /opt/etc/ipkg/*.conf

GETTING STARTED:
===============
/opt/etc/init.d/S99logitechmediaserver start

If LMS v7.7.2 starts ok, remove ‘--diag --d_server --d_startup` from the config file ‘/opt/etc/logitechmediaserver.conf’, edit it to suit you setup and restart LMS v7.2.2

More debug options here: http://wiki.slimdevices.com/index.php/Logitech_Media_Server_log_file

STARTING LMS v7.7.2 with MySQL DB
=================================
Set:
1) ‘LOGITECHMEDIASERVER_DBTYPE="MySQL”’ in ‘/opt/etc/logitechmediaserver.conf’
2) ‘dbtype: MySQL’ in ‘/home/squeezebox/prefs/server.prefs’
and restart LMS v7.7.2


<*>Attachment(s) from Sergey Talchuk:


<*> 1 of 1 File(s) http://groups.yahoo.com/group/nslu2-linux/attachments/folder/1344937833/item/list 
  <*> LMS_7.7.2_optware_make_files.tar.xz

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/nslu2-linux/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/nslu2-linux/join
    (Yahoo! ID required)

<*> To change settings via email:
    [hidden email]
    [hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Logitech Media Server v7.2.2 (aka LMS) optware make packages

Sergey Talchuk
Initial build script and repository:

http://svn.slimdevices.com/repos/slim/7.7/trunk/vendor/CPAN/
http://svn.slimdevices.com/repos/slim/7.7/trunk/vendor/CPAN/buildme.sh

To connect to MySQL DB (slimserver)

mysql -P9092 -h127.0.0.1 slimserver
use slimserver;
show tables;

Thanks,
Sergey

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Logitech Media Server v7.7.2 (aka LMS) optware make packages

Sergey Talchuk


Hi All,

LMS works fine for me with SQLite DB.
Packages updated [see attachment]

Here are the packages for cs05q1armel if someone needs:
http://rapidshare.com/files/2697408202/LMS_7.7.2_ipk_for_cs05q1armel.tar.xz

Thanks,
Sergey

-----
I] KNOWN ISSUES
---------------
1) perl-ev.mk
        1-1) 'inotify.h' exists in source_dir for cs05q1armel only; [SEE NOTE#1 in perl-ev.mk]
2) perl-linux-inotify2
        2-1) 'inotify.h' exists in source_dir for cs05q1armel only; [SEE NOTE#1 in perl-linux-inotify2.mk]
3) ffmpeg
        3-1) version 0.8.4 or higher is required
        3-2) Toolchain eabi_attiribut specific build issue [ARM]: libavcodec/arm/dsputil_arm.S:25: Error: unknown pseudo-op: `.eabi_attribute'; (SOLUTION: --disable-asm); A patch is required
4) LMS doesn't work with MySQL: 'Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::mysql::st execute failed: Column 'contributor' cannot be null'

II] TODO
---------
1) libmediascan & perl-media-scan: better to build as one package
2) resolve an issue with importing data to MySQL DB (Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::mysql::st execute failed: Column 'contributor' cannot be null)
    SEE: http://forums.slimdevices.com/showthread.php?97990-DBI-Exception-DBD-mysql-st-execute-failed-Column-contributor-cannot-be-null
    -compilation with 'mysql5' didn't resolve the issue as discribed here: http://forums.slimdevices.com/showthread.php?75214-SBS-7-4-1-fails-to-run-missing-symbol-boot_Class__C3__XS&p=517505&viewfull=1#post517505
    -downgrading 'perl-dbd-mysql' to version 3.0002 didn't resolve the issue: (see '_downgrades' folder for perl-dbd-mysql_3.0002 make file & patch)

III] NOTE
1) perl-class-c3-xs required for perl-5.8
2) perl-locale-hebrew - optional package


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Logitech Media Server v7.7.2 (aka LMS) optware make packages

Sergey Talchuk
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Logitech Media Server v7.7.2 (aka LMS) optware make packages [1 Attachment]

Sergey Talchuk
In reply to this post by Sergey Talchuk
Hi ALL,

Please find the make file LMS_7.7.3_make_file.zip attached.

Thanks,
Sergey


On Thu, Mar 21, 2013 at 5:07 PM, tals1975 <[hidden email]> wrote:

> **
>
>
>
>
> Hi All,
>
> LMS works fine for me with SQLite DB.
> Packages updated [see attachment]
>
> Here are the packages for cs05q1armel if someone needs:
> http://rapidshare.com/files/2697408202/LMS_7.7.2_ipk_for_cs05q1armel.tar.xz
>
> Thanks,
> Sergey
>
> -----
> I] KNOWN ISSUES
> ---------------
> 1) perl-ev.mk
> 1-1) 'inotify.h' exists in source_dir for cs05q1armel only; [SEE NOTE#1 in
> perl-ev.mk]
> 2) perl-linux-inotify2
> 2-1) 'inotify.h' exists in source_dir for cs05q1armel only; [SEE NOTE#1 in
> perl-linux-inotify2.mk]
> 3) ffmpeg
> 3-1) version 0.8.4 or higher is required
> 3-2) Toolchain eabi_attiribut specific build issue [ARM]:
> libavcodec/arm/dsputil_arm.S:25: Error: unknown pseudo-op:
> `.eabi_attribute'; (SOLUTION: --disable-asm); A patch is required
> 4) LMS doesn't work with MySQL: 'Slim::Schema::Storage::throw_exception
> (122) Error: DBI Exception: DBD::mysql::st execute failed: Column
> 'contributor' cannot be null'
>
> II] TODO
> ---------
> 1) libmediascan & perl-media-scan: better to build as one package
> 2) resolve an issue with importing data to MySQL DB
> (Slim::Schema::Storage::throw_exception (122) Error: DBI Exception:
> DBD::mysql::st execute failed: Column 'contributor' cannot be null)
> SEE:
> http://forums.slimdevices.com/showthread.php?97990-DBI-Exception-DBD-mysql-st-execute-failed-Column-contributor-cannot-be-null
> -compilation with 'mysql5' didn't resolve the issue as discribed here:
> http://forums.slimdevices.com/showthread.php?75214-SBS-7-4-1-fails-to-run-missing-symbol-boot_Class__C3__XS&p=517505&viewfull=1#post517505
> -downgrading 'perl-dbd-mysql' to version 3.0002 didn't resolve the issue:
> (see '_downgrades' folder for perl-dbd-mysql_3.0002 make file & patch)
>
> III] NOTE
> 1) perl-class-c3-xs required for perl-5.8
> 2) perl-locale-hebrew - optional package
>
>  
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Logitech Media Server v7.7.2 (aka LMS) optware make packages

Sergey Talchuk
Hi ALL,

some updates
LMS-7.7.3 optware make files:
http://rapidshare.com/files/907111688/LMS_7.7.3_optware_make_files_20130904.tar.xz
LMS-7.7.3 optware packages for cs05q1armel:
http://rapidshare.com/files/3746499879/LMS_7.7.3_ipk_for_cs05q1armel.tar.xz

Thanks,
Sergey


On Thu, Aug 29, 2013 at 10:35 AM, Sergey Talchuk <[hidden email]> wrote:

> Hi ALL,
>
> Please find the make file LMS_7.7.3_make_file.zip attached.
>
> Thanks,
> Sergey
>
>
> On Thu, Mar 21, 2013 at 5:07 PM, tals1975 <[hidden email]> wrote:
>
>> **
>>
>>
>>
>>
>> Hi All,
>>
>> LMS works fine for me with SQLite DB.
>> Packages updated [see attachment]
>>
>> Here are the packages for cs05q1armel if someone needs:
>>
>> http://rapidshare.com/files/2697408202/LMS_7.7.2_ipk_for_cs05q1armel.tar.xz
>>
>> Thanks,
>> Sergey
>>
>> -----
>> I] KNOWN ISSUES
>> ---------------
>> 1) perl-ev.mk
>> 1-1) 'inotify.h' exists in source_dir for cs05q1armel only; [SEE NOTE#1
>> in perl-ev.mk]
>> 2) perl-linux-inotify2
>> 2-1) 'inotify.h' exists in source_dir for cs05q1armel only; [SEE NOTE#1
>> in perl-linux-inotify2.mk]
>> 3) ffmpeg
>> 3-1) version 0.8.4 or higher is required
>> 3-2) Toolchain eabi_attiribut specific build issue [ARM]:
>> libavcodec/arm/dsputil_arm.S:25: Error: unknown pseudo-op:
>> `.eabi_attribute'; (SOLUTION: --disable-asm); A patch is required
>> 4) LMS doesn't work with MySQL: 'Slim::Schema::Storage::throw_exception
>> (122) Error: DBI Exception: DBD::mysql::st execute failed: Column
>> 'contributor' cannot be null'
>>
>> II] TODO
>> ---------
>> 1) libmediascan & perl-media-scan: better to build as one package
>> 2) resolve an issue with importing data to MySQL DB
>> (Slim::Schema::Storage::throw_exception (122) Error: DBI Exception:
>> DBD::mysql::st execute failed: Column 'contributor' cannot be null)
>> SEE:
>> http://forums.slimdevices.com/showthread.php?97990-DBI-Exception-DBD-mysql-st-execute-failed-Column-contributor-cannot-be-null
>> -compilation with 'mysql5' didn't resolve the issue as discribed here:
>> http://forums.slimdevices.com/showthread.php?75214-SBS-7-4-1-fails-to-run-missing-symbol-boot_Class__C3__XS&p=517505&viewfull=1#post517505
>> -downgrading 'perl-dbd-mysql' to version 3.0002 didn't resolve the issue:
>> (see '_downgrades' folder for perl-dbd-mysql_3.0002 make file & patch)
>>
>> III] NOTE
>> 1) perl-class-c3-xs required for perl-5.8
>> 2) perl-locale-hebrew - optional package
>>
>>  
>>
>
>
Loading...