[Announce] Database Optimizer plugin

[Roland0]

I've just published a new version. There are quite a number of changes, so if you notice something, feel free to provide feedback.

[SpiderJon]

Which perl version are you using?

Find your current module:

find /usr/share/squeezeboxserver -name SQLite.so

and then run (substituting your path)

file /usr/share/squeezeboxserver/CPAN/arch/5.28/armv7l-linux-thread-multi/auto/DBD/SQLite/SQLite.so

and post both results

I ran

find /usr/share/squeezeboxserver -name SQLite.so

which gave

/usr/share/squeezeboxserver/CPAN/arch/5.20/arm-linux-gnueabi-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.20/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.26/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.26/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.22/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.28/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.28/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.24/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.24/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so

Not sure why so many are listed (?), but according to my LMS info page:

Perl Version: 5.28.1 - arm-linux-gnueabihf-thread-multi-64int

So I ran

file /usr/share/squeezeboxserver/CPAN/arch/5.28/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so

which gave

/usr/share/squeezeboxserver/CPAN/arch/5.28/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so: ELF 32-bit LSB shared object, ARM, EABI5 version 1 (SYSV), dynamically linked, stripped

Hope that's what you need.

[Roland0]

I ran

find /usr/share/squeezeboxserver -name SQLite.so

which gave

/usr/share/squeezeboxserver/CPAN/arch/5.20/arm-linux-gnueabi-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.20/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.26/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.26/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.22/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.28/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.28/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.24/aarch64-linux-thread-multi/auto/DBD/SQLite/SQLite.so
/usr/share/squeezeboxserver/CPAN/arch/5.24/arm-linux-gnueabihf-thread-multi-64int/auto/DBD/SQLite/SQLite.so

Not sure why so many are listed (?), but according to my LMS info page:

Perl Version: 5.28.1 - arm-linux-gnueabihf-thread-multi-64int

The debian package contains binaries for various perl version/platform combinations, not only the one you are actually using.
The relevant path for you is:
/usr/share/squeezeboxserver/CPAN/arch/5.28/arm-linux-gnueabihf-thread-multi-64int/

I've created a package you can download here

Replace your modules with the ones contained in the archive (i.e. only DBD DBI DBI.pm Image auto/DBD auto/DBI auto/Image)

Note:
- I'm not 100% sure these will work on an RPi (I've build them on an Odroid 32bit Arm, so they should be compatible, but I can't actually test it)
- First, make a backup (e.g. tar cf - /usr/share/squeezeboxserver/CPAN/arch/5.28/arm-linux-gnueabihf-thread-multi-64int/|gzip -9 > ~/lms_mods_arm-linux-gnueabihf-thread-multi-64int.tar.gz)
- worst case you can always re-install LMS from the debian package
- make sure you get all the paths right
- if something about the procedure is unclear, just ask