Subsonic 6.1.1 Postgres : only runs on Java 8, not 7 or 9

[kstephens]

Cost me some time, but I figured it out.

When enabling a PostgresDB on Linux (Ubuntu) Subsonic 6.1.1 doesn't run on Java 7.
It requires an updated JDBC postgres driver.
And Java 9 doesn't work because of an incompatablity with Spring and Beans.
After installing Sun jdk1.8.0_144, everything worked fine.

I can attach logs if anyone is interested.

The Installation page (http://www.subsonic.org/pages/installation.jsp) page should be updated to
reflect this.

Debian / Ubuntu installation
This installation option applies to Debian Linux, including Ubuntu.

First, install Java: sudo apt-get install openjdk-7-jre

Also:

http://www.subsonic.org/pages/database.jsp configures Subsonic to use the primary, privileged "postgres" user.

This is bad practice (also bad practice for MySQL/MariaDB "root" user).

Create a "subsonic" Postgres user role and create a "subsonic" database owned by the "subsonic" Postgres user.

Code: Select all

$ cat /proc/sys/kernel/random/uuid
f18e1563-d272-42b4-8259-7d1ff4b08497

$ sudo -u postgres psql
[sudo] password for USER:
psql (9.6.5)
Type "help" for help.

postgres=# create role subsonic with login password 'f18e1563-d272-42b4-8259-7d1ff4b08497';
postgres=# create database subsonic with owner = subsonic;


Code: Select all

# /etc/default/subsonic
...
SUBSONIC_ARGS="${SUBSONIC_ARGS} --db=jdbc:postgresql://localhost:5432/subsonic?user=subsonic&password=f18e1563-d272-42b4-8259-7d1ff4b08497"


[innerspaceboy]

Thank you SO MUCH! I just spent the last few hours grappling with a fresh install after upgrading to Ubuntu 17.10 and couldn't get localhost:4040 to connect after installing Java 9!

Rolling back to v8 instantly resolved the issue!

THANK YOU!