Skip to content
This repository has been archived by the owner on Sep 8, 2021. It is now read-only.

Unable to connect to MySQL Database #329

Closed
issuemover631 opened this issue Mar 30, 2017 · 7 comments
Closed

Unable to connect to MySQL Database #329

issuemover631 opened this issue Mar 30, 2017 · 7 comments

Comments

@issuemover631
Copy link

Issue by texxasrulez
Thursday Mar 30, 2017 at 00:44 GMT
Originally opened as https://github.com/Libresonic/libresonic/issues/327

I am trying out the external DB feature and I get this error:

PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.Driver]

For Java classname = com.mysql.jdbc.Driver
for jdbc url = jdbc:mysql://localhost:3306/libresonic?

I appreciate your work. Thank you
@issuemover631
Copy link
Author

Comment by joshuaboniface
Thursday Mar 30, 2017 at 00:50 GMT

Do you have the JDBC connector installed in /var/lib/tomcat8/lib?

@issuemover631
Copy link
Author

Comment by texxasrulez
Thursday Mar 30, 2017 at 02:06 GMT

I do. I have worked passed this and am in the middle of figuring it out. My database was populated but I still cannot get libresonic to start. Will post more on my finding when I am done.

@issuemover631
Copy link
Author

Comment by texxasrulez
Thursday Mar 30, 2017 at 02:16 GMT

I am stuck at the creation of databases but cannot get libresonic to start using mysql. It runs on internal DB.
Also, I see the passwords for mysql database are not encrypted. Just a suggestion to have passwords encrypted. Thanks again

Here are my logs if anyone can see something:

 _      _ _                               _       ______
 | |    (_) |                             (_)      \ \ \ \
 | |     _| |__  _ __ ___  ___  ___  _ __  _  ___   | | | |
 | |    | | '_ \| '__/ _ \/ __|/ _ \| '_ \| |/ __|  | | | |
 | |____| | |_) | | |  __/\__ \ (_) | | | | | (__   | | | |
 |______|_|_.__/|_|  \___||___/\___/|_| |_|_|\___|  | | | |
                                                   /_/_/_/
                                

2017-03-29 21:11:28.076  INFO --- o.l.player.boot.Application              : Starting Application on betsy with PID 17560 (/var/lib/tomcat8/webapps/libresonic-beta/WEB-INF/classes/org/libresonic/player/boot/Application.class started by tomcat8 in /var/lib/tomcat8)
2017-03-29 21:11:28.083  INFO --- o.l.player.boot.Application              : The following profiles are active: embed
2017-03-29 21:11:31.023  INFO --- o.l.p.service.SettingsService            : Java: 1.8.0_121, OS: Linux
2017-03-29 21:11:47.585  INFO --- liquibase                                : Successfully acquired change log lock
2017-03-29 21:11:49.210  INFO --- liquibase                                : Reading from libresonic.DATABASECHANGELOG
2017-03-29 21:11:49.385  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/6.2/add-user-pagination.xml::add-user-pagination_001::muff1nman: Rolling Back Changeset:classpath:liquibase/6.2/add-user-pagination.xml::add-user-pagination_001::muff1nman
2017-03-29 21:11:49.392  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/6.2/remove-show-chat.xml::remove-show-chat_001::muff1nman: Rolling Back Changeset:classpath:liquibase/6.2/remove-show-chat.xml::remove-show-chat_001::muff1nman
2017-03-29 21:11:49.400  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema100.xml::schema100_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema100.xml::schema100_001::muff1nman
2017-03-29 21:11:49.406  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema62.xml::schema62_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema62.xml::schema62_002::muff1nman
2017-03-29 21:11:49.410  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema62.xml::schema62_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema62.xml::schema62_001::muff1nman
2017-03-29 21:11:49.413  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema61.xml::schema61_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema61.xml::schema61_003::muff1nman
2017-03-29 21:11:49.417  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema61.xml::schema61_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema61.xml::schema61_002::muff1nman
2017-03-29 21:11:49.419  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema61.xml::schema61_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema61.xml::schema61_001::muff1nman
2017-03-29 21:11:49.421  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_007::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_007::muff1nman
2017-03-29 21:11:49.423  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_006::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_006::muff1nman
2017-03-29 21:11:49.425  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_005::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_005::muff1nman
2017-03-29 21:11:49.427  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_004::muff1nman
2017-03-29 21:11:49.431  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_003::muff1nman
2017-03-29 21:11:49.444  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_002_1::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_002_1::muff1nman
2017-03-29 21:11:49.448  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_002::muff1nman
2017-03-29 21:11:49.451  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema53.xml::schema53_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema53.xml::schema53_001::muff1nman
2017-03-29 21:11:49.453  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema52.xml::schema52_005::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema52.xml::schema52_005::muff1nman
2017-03-29 21:11:49.456  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema52.xml::schema52_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema52.xml::schema52_004::muff1nman
2017-03-29 21:11:49.458  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema52.xml::schema52_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema52.xml::schema52_003::muff1nman
2017-03-29 21:11:49.460  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema52.xml::schema52_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema52.xml::schema52_002::muff1nman
2017-03-29 21:11:49.466  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema52.xml::schema52_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema52.xml::schema52_001::muff1nman
2017-03-29 21:11:49.470  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema51.xml::schema51_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema51.xml::schema51_004::muff1nman
2017-03-29 21:11:49.477  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema51.xml::schema51_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema51.xml::schema51_003::muff1nman
2017-03-29 21:11:49.480  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema51.xml::schema51_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema51.xml::schema51_002::muff1nman
2017-03-29 21:11:49.484  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema51.xml::schema51_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema51.xml::schema51_001::muff1nman
2017-03-29 21:11:49.490  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema50.xml::schema50_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema50.xml::schema50_003::muff1nman
2017-03-29 21:11:49.492  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema50.xml::schema50_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema50.xml::schema50_002::muff1nman
2017-03-29 21:11:49.495  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema50.xml::schema50_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema50.xml::schema50_001::muff1nman
2017-03-29 21:11:49.501  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema49.xml::schema49_005::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema49.xml::schema49_005::muff1nman
2017-03-29 21:11:49.504  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema49.xml::schema49_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema49.xml::schema49_004::muff1nman
2017-03-29 21:11:49.507  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema49.xml::schema49_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema49.xml::schema49_003::muff1nman
2017-03-29 21:11:49.510  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema49.xml::schema49_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema49.xml::schema49_002::muff1nman
2017-03-29 21:11:49.512  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema49.xml::schema49_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema49.xml::schema49_001::muff1nman
2017-03-29 21:11:49.516  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_013::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_013::muff1nman
2017-03-29 21:11:49.520  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_012::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_012::muff1nman
2017-03-29 21:11:49.524  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_011::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_011::muff1nman
2017-03-29 21:11:49.527  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_010::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_010::muff1nman
2017-03-29 21:11:49.531  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_009::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_009::muff1nman
2017-03-29 21:11:49.535  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_008::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_008::muff1nman
2017-03-29 21:11:49.542  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_007::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_007::muff1nman
2017-03-29 21:11:49.547  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_006::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_006::muff1nman
2017-03-29 21:11:49.551  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_005_2::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_005_2::muff1nman
2017-03-29 21:11:49.556  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_005::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_005::muff1nman
2017-03-29 21:11:49.562  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_004::muff1nman
2017-03-29 21:11:49.567  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_003::muff1nman
2017-03-29 21:11:49.570  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_002::muff1nman
2017-03-29 21:11:49.577  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema47.xml::schema47_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema47.xml::schema47_001::muff1nman
2017-03-29 21:11:49.578  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema46.xml::schema46_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema46.xml::schema46_004::muff1nman
2017-03-29 21:11:49.581  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema46.xml::schema46_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema46.xml::schema46_003::muff1nman
2017-03-29 21:11:49.586  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema46.xml::schema46_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema46.xml::schema46_002::muff1nman
2017-03-29 21:11:49.590  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema46.xml::schema46_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema46.xml::schema46_001::muff1nman
2017-03-29 21:11:49.593  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema45.xml::schema45_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema45.xml::schema45_003::muff1nman
2017-03-29 21:11:49.597  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema45.xml::schema45_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema45.xml::schema45_002::muff1nman
2017-03-29 21:11:49.600  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema45.xml::schema45_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema45.xml::schema45_001::muff1nman
2017-03-29 21:11:49.602  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema43.xml::schema43_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema43.xml::schema43_003::muff1nman
2017-03-29 21:11:49.603  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema43.xml::schema43_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema43.xml::schema43_002::muff1nman
2017-03-29 21:11:49.608  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema43.xml::schema43_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema43.xml::schema43_001::muff1nman
2017-03-29 21:11:49.609  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema40.xml::schema40_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema40.xml::schema40_001::muff1nman
2017-03-29 21:11:49.612  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema38.xml::schema38_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema38.xml::schema38_003::muff1nman
2017-03-29 21:11:49.615  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema38.xml::schema38_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema38.xml::schema38_002::muff1nman
2017-03-29 21:11:49.619  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema38.xml::schema38_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema38.xml::schema38_001::muff1nman
2017-03-29 21:11:49.622  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema37.xml::schema37_006::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema37.xml::schema37_006::muff1nman
2017-03-29 21:11:49.625  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema37.xml::schema37_005::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema37.xml::schema37_005::muff1nman
2017-03-29 21:11:49.627  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema37.xml::schema37_004::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema37.xml::schema37_004::muff1nman
2017-03-29 21:11:49.630  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema37.xml::schema37_003::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema37.xml::schema37_003::muff1nman
2017-03-29 21:11:49.632  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema37.xml::schema37_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema37.xml::schema37_002::muff1nman
2017-03-29 21:11:49.634  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema37.xml::schema37_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema37.xml::schema37_001::muff1nman
2017-03-29 21:11:49.636  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema36.xml::schema36_002::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema36.xml::schema36_002::muff1nman
2017-03-29 21:11:49.638  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema36.xml::schema36_001::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema36.xml::schema36_001::muff1nman
2017-03-29 21:11:49.640  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Study::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Study::muff1nman
2017-03-29 21:11:49.643  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Laugh::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Laugh::muff1nman
2017-03-29 21:11:49.648  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Cool::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Cool::muff1nman
2017-03-29 21:11:49.654  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Vinyl::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Vinyl::muff1nman
2017-03-29 21:11:49.659  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Turntable::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Turntable::muff1nman
2017-03-29 21:11:49.664  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Mic::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Mic::muff1nman
2017-03-29 21:11:49.667  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Headphones::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Headphones::muff1nman
2017-03-29 21:11:49.669  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Drum::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Drum::muff1nman
2017-03-29 21:11:49.672  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Fire-Guitar::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Fire-Guitar::muff1nman
2017-03-29 21:11:49.675  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Uptight::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Uptight::muff1nman
2017-03-29 21:11:49.677  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Troll::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Troll::muff1nman
2017-03-29 21:11:49.680  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_The-Referee::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_The-Referee::muff1nman
2017-03-29 21:11:49.682  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_The-Guru::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_The-Guru::muff1nman
2017-03-29 21:11:49.686  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Tech-Support::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Tech-Support::muff1nman
2017-03-29 21:11:49.689  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Statistician::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Statistician::muff1nman
2017-03-29 21:11:49.693  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Sozzled-Surfer::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Sozzled-Surfer::muff1nman
2017-03-29 21:11:49.697  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Rumor-Junkie::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Rumor-Junkie::muff1nman
2017-03-29 21:11:49.699  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Ringmaster::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Ringmaster::muff1nman
2017-03-29 21:11:49.701  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-4::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-4::muff1nman
2017-03-29 21:11:49.703  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-3::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-3::muff1nman
2017-03-29 21:11:49.706  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-2::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-2::muff1nman
2017-03-29 21:11:49.708  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-1::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Red-Hot-Chili-Peppers-1::muff1nman
2017-03-29 21:11:49.712  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Ray-Of-Sunshine::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Ray-Of-Sunshine::muff1nman
2017-03-29 21:11:49.715  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Push-My-Button::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Push-My-Button::muff1nman
2017-03-29 21:11:49.718  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Performer::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Performer::muff1nman
2017-03-29 21:11:49.722  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_No-Dissent::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_No-Dissent::muff1nman
2017-03-29 21:11:49.726  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Newbie::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Newbie::muff1nman
2017-03-29 21:11:49.730  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Moderator::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Moderator::muff1nman
2017-03-29 21:11:49.733  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Lurker::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Lurker::muff1nman
2017-03-29 21:11:49.735  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Joker::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Joker::muff1nman
2017-03-29 21:11:49.737  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Jekyll-And-Hyde::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Jekyll-And-Hyde::muff1nman
2017-03-29 21:11:49.739  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Hopelessly-Addicted::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Hopelessly-Addicted::muff1nman
2017-03-29 21:11:49.742  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Gamer::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Gamer::muff1nman
2017-03-29 21:11:49.744  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Forum-Flirt::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Forum-Flirt::muff1nman
2017-03-29 21:11:49.746  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Commie-Pinko::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Commie-Pinko::muff1nman
2017-03-29 21:11:49.749  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Clown::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Clown::muff1nman
2017-03-29 21:11:49.753  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_All-Caps::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_All-Caps::muff1nman
2017-03-29 21:11:49.756  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Beatnik::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Beatnik::muff1nman
2017-03-29 21:11:49.760  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Army-Officer::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Army-Officer::muff1nman
2017-03-29 21:11:49.768  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Windows-Zealot::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Windows-Zealot::muff1nman
2017-03-29 21:11:49.770  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Mac-Zealot::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Mac-Zealot::muff1nman
2017-03-29 21:11:49.772  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Linux-Zealot::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Linux-Zealot::muff1nman
2017-03-29 21:11:49.774  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Green-Boy::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Green-Boy::muff1nman
2017-03-29 21:11:49.779  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Footballer::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Footballer::muff1nman
2017-03-29 21:11:49.783  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Engineer::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Engineer::muff1nman
2017-03-29 21:11:49.785  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_010_Formal::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_010_Formal::muff1nman
2017-03-29 21:11:49.788  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_009::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_009::muff1nman
2017-03-29 21:11:49.795  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_008::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_008::muff1nman
2017-03-29 21:11:49.798  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_007::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_007::muff1nman
2017-03-29 21:11:49.805  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_006::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_006::muff1nman
2017-03-29 21:11:49.807  INFO --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman: Rolling Back Changeset:classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman
2017-03-29 21:11:49.811  INFO --- liquibase                                : Successfully released change log lock
2017-03-29 21:11:49.943  INFO --- liquibase                                : Successfully acquired change log lock
2017-03-29 21:11:49.962  INFO --- liquibase                                : Reading from libresonic.DATABASECHANGELOG
2017-03-29 21:11:50.036 ERROR --- liquibase                                : classpath:liquibase/db-changelog.xml: classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman: Change Set classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman failed.  Error: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
2017-03-29 21:11:50.100  INFO --- liquibase                                : classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman: Successfully released change log lock
2017-03-29 21:11:50.102 ERROR --- o.l.p.spring.SpringLiquibase             : ===============================================
2017-03-29 21:11:50.102 ERROR --- o.l.p.spring.SpringLiquibase             : An exception occurred during database migration
2017-03-29 21:11:50.102 ERROR --- o.l.p.spring.SpringLiquibase             : A rollback file has been generated at /var/libresonic/rollback.sql
2017-03-29 21:11:50.103 ERROR --- o.l.p.spring.SpringLiquibase             : Execute it within your database to rollback any changes
2017-03-29 21:11:50.126 ERROR --- o.l.p.spring.SpringLiquibase             : The exception is as follows


liquibase.exception.MigrationFailedException: Migration failed for change set classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman:
     Reason: liquibase.exception.DatabaseException: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:605) ~[ChangeSet.class:na]
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) ~[UpdateVisitor.class:na]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) ~[ChangeLogIterator.class:na]
	at liquibase.Liquibase.update(Liquibase.java:214) ~[Liquibase.class:na]
	at liquibase.Liquibase.update(Liquibase.java:192) ~[Liquibase.class:na]
	at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:434) ~[SpringLiquibase.class:na]
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:391) ~[SpringLiquibase.class:na]
	at org.libresonic.player.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:24) ~[SpringLiquibase.class:na]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) [AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) [AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) [AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) [AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) [AbstractBeanFactory$1.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [DefaultSingletonBeanRegistry.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) [AbstractBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [AbstractBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) [DefaultListableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866) [AbstractApplicationContext.class:4.3.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) [AbstractApplicationContext.class:4.3.7.RELEASE]
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) [EmbeddedWebApplicationContext.class:1.4.5.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:762) [SpringApplication.class:1.4.5.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:372) [SpringApplication.class:1.4.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [SpringApplication.class:1.4.5.RELEASE]
	at org.springframework.boot.web.support.SpringBootServletInitializer.run(SpringBootServletInitializer.java:151) [SpringBootServletInitializer.class:1.4.5.RELEASE]
	at org.springframework.boot.web.support.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:131) [SpringBootServletInitializer.class:1.4.5.RELEASE]
	at org.springframework.boot.web.support.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:86) [SpringBootServletInitializer.class:1.4.5.RELEASE]
	at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:169) [SpringServletContainerInitializer.class:4.3.7.RELEASE]
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5245) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1265) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:673) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:221) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:644) [tomcat8-servlet-api-8.0.14.jar:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) [tomcat8-servlet-api-8.0.14.jar:na]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:213) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat8-websocket-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:618) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1570) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1527) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat8-util-8.0.14.jar:8.0.14]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
Caused by: liquibase.exception.DatabaseException: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) ~[JdbcExecutor$ExecuteStatementCallback.class:na]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[JdbcExecutor.class:na]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) ~[JdbcExecutor.class:na]
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273) ~[AbstractJdbcDatabase.class:na]
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255) ~[AbstractJdbcDatabase.class:na]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568) ~[ChangeSet.class:na]
	... 61 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'created_date'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_121]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_121]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_121]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_121]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[lib/:na]
	at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[lib/:na]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[lib/:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497) ~[lib/:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455) ~[lib/:na]
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) ~[lib/:na]
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) ~[lib/:na]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299) ~[JdbcExecutor$ExecuteStatementCallback.class:na]
	... 66 common frames omitted

2017-03-29 21:11:50.128 ERROR --- o.l.p.spring.SpringLiquibase             : ===============================================
2017-03-29 21:11:50.129  WARN --- ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [applicationContext-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman:
     Reason: liquibase.exception.DatabaseException: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
2017-03-29 21:11:50.160 ERROR --- o.s.boot.SpringApplication               : Application startup failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [applicationContext-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman:
     Reason: liquibase.exception.DatabaseException: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628) ~[AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[AbstractBeanFactory$1.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[DefaultSingletonBeanRegistry.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[AbstractBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[AbstractBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) ~[DefaultListableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866) ~[AbstractApplicationContext.class:4.3.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) ~[AbstractApplicationContext.class:4.3.7.RELEASE]
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[EmbeddedWebApplicationContext.class:1.4.5.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:762) ~[SpringApplication.class:1.4.5.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:372) ~[SpringApplication.class:1.4.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) ~[SpringApplication.class:1.4.5.RELEASE]
	at org.springframework.boot.web.support.SpringBootServletInitializer.run(SpringBootServletInitializer.java:151) [SpringBootServletInitializer.class:1.4.5.RELEASE]
	at org.springframework.boot.web.support.SpringBootServletInitializer.createRootApplicationContext(SpringBootServletInitializer.java:131) [SpringBootServletInitializer.class:1.4.5.RELEASE]
	at org.springframework.boot.web.support.SpringBootServletInitializer.onStartup(SpringBootServletInitializer.java:86) [SpringBootServletInitializer.class:1.4.5.RELEASE]
	at org.springframework.web.SpringServletContainerInitializer.onStartup(SpringServletContainerInitializer.java:169) [SpringServletContainerInitializer.class:4.3.7.RELEASE]
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5245) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1265) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:673) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:221) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:644) [tomcat8-servlet-api-8.0.14.jar:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) [tomcat8-servlet-api-8.0.14.jar:na]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:213) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat8-websocket-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:618) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537) [tomcat8-catalina-8.0.14.jar:8.0.14]
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1570) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1527) [tomcat8-coyote-8.0.14.jar:8.0.14]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat8-util-8.0.14.jar:8.0.14]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:liquibase/legacy/schema35.xml::schema35_005::muff1nman:
     Reason: liquibase.exception.DatabaseException: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:605) ~[ChangeSet.class:na]
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) ~[UpdateVisitor.class:na]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) ~[ChangeLogIterator.class:na]
	at liquibase.Liquibase.update(Liquibase.java:214) ~[Liquibase.class:na]
	at liquibase.Liquibase.update(Liquibase.java:192) ~[Liquibase.class:na]
	at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:434) ~[SpringLiquibase.class:na]
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:391) ~[SpringLiquibase.class:na]
	at org.libresonic.player.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:24) ~[SpringLiquibase.class:na]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) ~[AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) ~[AbstractAutowireCapableBeanFactory.class:4.3.7.RELEASE]
	... 52 common frames omitted
Caused by: liquibase.exception.DatabaseException: Invalid default value for 'created_date' [Failed SQL: CREATE TABLE libresonic.system_avatar (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) NULL, created_date datetime DEFAULT NOW() NOT NULL, mime_type VARCHAR(512) NOT NULL, width INT NOT NULL, height INT NOT NULL, data BLOB NOT NULL, CONSTRAINT PK_SYSTEM_AVATAR PRIMARY KEY (id))]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301) ~[JdbcExecutor$ExecuteStatementCallback.class:na]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[JdbcExecutor.class:na]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107) ~[JdbcExecutor.class:na]
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273) ~[AbstractJdbcDatabase.class:na]
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255) ~[AbstractJdbcDatabase.class:na]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568) ~[ChangeSet.class:na]
	... 61 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'created_date'
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_121]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_121]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_121]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_121]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[lib/:na]
	at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[lib/:na]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) ~[lib/:na]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[lib/:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497) ~[lib/:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455) ~[lib/:na]
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) ~[lib/:na]
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) ~[lib/:na]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299) ~[JdbcExecutor$ExecuteStatementCallback.class:na]

@issuemover631
Copy link
Author

Comment by muff1nman
Thursday Mar 30, 2017 at 03:51 GMT

In the future, maybe throw all of that in a paste bin or something. Kinda hard to read through ;) Password discussion is in #69. Feel free to chime in there. As far as your startup error, you need to use a newer version of MySQL - at least 5.6.5. Unfortunately we haven't documented supported databases yet.

@issuemover631
Copy link
Author

Comment by texxasrulez
Friday Mar 31, 2017 at 00:34 GMT

I hear ya it is hard to read. I don't do much posting as I can figure most things out on my own. I fixed the post with proper markdown.

I have MySQL 5.7.17 on my actual server and I am working on my backup which has 5.5 and was thinking I am more updated. Stupid Mistake. I will upgrade and check it out some more. Thanks ..

@issuemover631
Copy link
Author

Comment by texxasrulez
Friday Mar 31, 2017 at 01:25 GMT

I got one step further. I updated mysql to 5.7.17 and now Libresonic starts up, but I get an error page as follows:

,,,
Status 500
Error Internal Server Error
Message No message available
Path /libresonic-beta/home.view
Time Thu Mar 30 20:23:05 CDT 2017
Exception java.lang.NullPointerException
Java version Oracle Corporation 1.8.0_121
Operating system Linux 3.16.0-4-amd64
Server Apache Tomcat/8.0.14 (Debian)
Memory Used 93 of 123 MB
Stack trace

                    java.lang.NullPointerException
at org.libresonic.player.controller.HomeController.handleRequestInternal(HomeController.java:67)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.libresonic.player.filter.MetricsFilter.doFilter(MetricsFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.libresonic.player.filter.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.libresonic.player.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.libresonic.player.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:56)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.libresonic.player.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:158)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.libresonic.player.security.RESTRequestParameterProcessingFilter.doFilter(RESTRequestParameterProcessingFilter.java:84)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:117)
at org.springframework.boot.web.support.ErrorPageFilter.access$000(ErrorPageFilter.java:61)
at org.springframework.boot.web.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:92)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1570)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1527)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

,,,

@issuemover631
Copy link
Author

Comment by texxasrulez
Friday Mar 31, 2017 at 19:59 GMT

Deleted libresonic database and started fresh. I am connected and saving to mysql. It is SLOWWW, but it does work ...

This issue was due to loose nut behind keyboard ....

This was referenced Jul 4, 2017
Closed
Closed
muff1nman pushed a commit that referenced this issue Jul 4, 2017
@EugeneKay
Merge Pull Request #329 into develop
fd59f20
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@issuemover631