Hi,
I have installed the Madsonic module using the instructions here https://wiki.nethserver.org/doku.php?id=madsonic
However, when I go to the url, I get an error:
HTTP ERROR: 503
Problem accessing /music. Reason:
Service Unavailable
Powered by Jetty:// 8.y.z-SNAPSHOT
I have googled the error and have tried stopping Madsonic, removing everything except the madsonic.properties from the madsonic/db directory and starting it again, but with no luck.
In the Nethserver web admin pages, Madsonic is not listed on the installed software pages, but there is a configuration page that lets me enable it, set it to public or private access and add samba users.
The samba share is showing up ⊠but now I cannot log into samba shares using Domain\username and password, but need to use the users email address and password. Donât know if this is related.
In the /var/madsonic/madsonic.log, I get
2017-05-25 09:53:19,867] WARN HsqlDaoHelper - Checking HSQLDB database schema ...
[2017-05-25 09:53:22,010] INFO HSqlSchema02 - Database table 'audio_ad' not found. Creating it.
[2017-05-25 09:53:22,040] ERROR HsqlDaoHelper - Failed to initialize HSQLDB database.
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table audio_ad (id identity,media_file_id int,weight double,comment varchar,enabled boolean default false not null,created datetime not null,changed datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade)]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MEDIA_FILE in statement [create table audio_ad (id identity,media_file_id int,weight double,comment varchar,enabled boolean default false not null,created datetime not null,changed datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade)]
So seems as though there is no database being set up for Madsonic to use.
Any help with this appreciated
Also - I notice on this page Nethserver-madsonic needs testers, it says to install 20161208_madsonic-6.2.9040.rpm, but the wiki page mentioned above says to only install the nethserver-madsonic module. Do I need to install madsonic separately?
Cheers,
Don