cant get login screen,error 503 ubuntu

[riktking]

hi

have got subsonic install on my server, was working brilliantly, then the power supply had popped, replaced it,all has come back except subsonic, cannot access it from anywhere, local host, android etc

HTTP ERROR: 503

SERVICE_UNAVAILABLE
RequestURI=/

Powered by jetty://

is all i get displayed when i try to log in

can anyone help me please

thanks

riktking

[BKKKPewsey]

PLEASE read the sticky "how to ask for help"

Is the service running?
Have you checked what the SS control panel is saying?
What does the SS log file say?
When the server power failed it may have corrupted a file so you may need to re-install SS.

[riktking]

thanks for the response, sorry about not reading the sticky :-S

SS is definatly running, i have verified it by webmin

which log file is needed?

cannot access the control panel at all!

i can post whatever log is needed

thanks for your help

riktking

[TechApprentice]

I have the exact same error message when trying to open the webinterface.

The problem showed up after I had shut down my Ubuntu server to add a harddisk. (sudo shutdown 1)

Problem Description: See above
Troubleshooting Steps: Restart the service, Tried an upgrade from 4.4 to 4.5 by running the install instructions as found on the website. Install without errors, but still no webinterface.
Playback Application and version: Webinterface
Subsonic Version: 4.4 and 4.5 (I think because I can not check
Server Version: ?
Hardware Platform: Ubuntu server 10.4.1 LTS
Java Memory Limit: 225mb
Problem Filename: NA
Output from ffmpeg -i: NA
Last ten log file lines: (from subsonic.log) edited, removed some lines with "endless" code, if its all needed lat me know I will post it.

Code: Select all

[2011-08-15 10:30:16,610] INFO DaoHelper - Checking database schema.
[2011-08-15 10:30:17,300] INFO Schema25 - Database table 'version' not found.  Creating it.
[2011-08-15 10:30:17,301] ERROR DaoHelper - Failed to initialize database.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: User not found: SA
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
.........more
[2011-08-15 10:30:18,208] INFO SearchService - Automatic index creation scheduled to run every 1 day(s), starting at Tue Aug 16 03:00:00 CEST 2011
[2011-08-15 10:30:21,556] WARN NetworkService - Failed to delete port mapping.
net.sbbi.upnp.messages.UPNPResponseException: Detailed error code :403, Detailed error description :Not available Action
        at net.sbbi.upnp.messages.ActionMessageResponseParser.startElement(ActionMessageResponseParser.java:145)
        at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
        at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
......more
[2011-08-16 03:00:00,209] INFO SearchService - Starting to create search index.
[2011-08-16 03:00:00,235] ERROR SearchService - Failed to create search index.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: User not found: SA
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:577)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
        at net.sourceforge.subsonic.dao.AbstractDao.query(AbstractDao.java:58)
        at net.sourceforge.subsonic.dao.MusicFolderDao.getAllMusicFolders(MusicFolderDao.java:49)
        at net.sourceforge.subsonic.service.SettingsService.getAllMusicFolders(SettingsService.java:895)
        at net.sourceforge.subsonic.service.SettingsService.getAllMusicFolders(SettingsService.java:885)
        at net.sourceforge.subsonic.service.SearchService.doCreateIndex(SearchService.java:136)
        at net.sourceforge.subsonic.service.SearchService.access$000(SearchService.java:62)
        at net.sourceforge.subsonic.service.SearchService$1.run(SearchService.java:115)
Caused by: java.sql.SQLException: User not found: SA
.......more


Use Subsonic a lot on my Android phone when in the country, when traveling and on wifi use the webinterface to enjoy my music. Works great, love it! Just this problem now is my first real issue. (Since 2 years)

[riktking]

hi

did some digging

http://pastebin.com/Hu2TgMXi

is my subsonic_sh.log

sounds like we are having the same issue?!!

thanks

riktking

[TechApprentice]

Bump,

Sorry for the bump, just noticed somebody posted a new topic, but he has the same problems. Any update on a solution?

I didn't have a lot of time to experiment myself, so I was hoping that some expert could help out.

[utopian]

had a quick search and came across this...

Following the hint about the db folder, I had a look there, and found the file subsonic.lck, an empty file probably related to database locking.
I stopped the subsonic service, removed the file, and restarted. The 503 error was gone

I've had it a couple of times on my windows 2008 r2 machine... i just deleted the db folder and that sorted it but you do lose any additional users you've setup and settings...

[TechApprentice]

I Stopped the service and looked in the db folder.
I could not find a .lck file. I did delete the complete db folder with contence and could, after a restart of the serice, reconfigure subsonic trough the web interface.

What could be the cause of this problem? Is it that SS does not close clean when rebooting or shutting down Ubuntu?
Can it be prevented by stopping the service manualy first?

Thanks anyway for the help so far. Finaly got my tunes back when on the road.

[utopian]

its happened to me when i've powered down my server rather than a graceful shutdown...

[mbro]

I'm experiencing something similar. My subsonic box has been running flawlessly for a long while. Alas, it was power cycle time to move some stuff around. Prior to disconnecting or moving anything, I did a controlled shutdown/restart of my ubuntu box that runs subsonic. It started up fine, subsonic service is running, everything appears ok, but no web interface (default :4040).

A little background - I'm probably the only person in the world doing this, but I'm running subsonic on a diskless ubuntu box. It doesn't really change anything, other than the boot-up sequence, but standard-issue default install directories, etc. To complicate things further, I stopped subsonic and started it again before rebooting, and the web interface was up.

I'm perplexed by what has happened and why no subsonic.

The contents of my /var/subsonic/subsonic_sh.log:

marlen@bonusroom:/var/subsonic/db$ cat /var/subsonic/db/subsonic.lck
cat: /var/subsonic/db/subsonic.lck: No such file or directory
marlen@bonusroom:/var/subsonic/db$ cat /var/subsonic/subsonic_sh.log
45 [main] INFO org.springframework.context.support.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@18a47e0: display name [org.springframework.context.support.ClassPathXmlApplicationContext@18a47e0]; startup date [Wed Apr 25 22:31:22 MDT 2012]; root of context hierarchy
184 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [applicationContext-deployer.xml]
[GC 4416K->242K(15872K), 0.0080530 secs]
[GC 4658K->522K(15872K), 0.0099250 secs]
1088 [main] INFO org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@18a47e0]: org.springframework.beans.factory.support.DefaultListableBeanFactory@129f3b5
1121 [main] INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@129f3b5: defining beans [service,org.springframework.remoting.rmi.RmiServiceExporter#0]; root of factory hierarchy
1177 [main] INFO org.mortbay.log - Logging to org.slf4j.impl.SimpleLogger(org.mortbay.log) via org.mortbay.log.Slf4jLog
Using WAR file: /usr/share/subsonic/subsonic.war
Extracting webapp to /var/subsonic/jetty/2585
Using WAR file: /usr/share/subsonic/subsonic.war
1273 [main] INFO org.mortbay.log - jetty-6.1.x
[GC 4938K->451K(15872K), 0.0111390 secs]
[GC 4863K->812K(15872K), 0.0080360 secs]
[GC 5228K->821K(15872K), 0.0043100 secs]
[GC 5237K->884K(15872K), 0.0029510 secs]
marlen@bonusroom:/var/subsonic/db$

Its definitely running... (output from a ps -ef:)
marlen 1318 1317 0 22:07 pts/0 00:00:01 -bash
root 1765 1 0 22:31 pts/0 00:00:02 java -Xmx100m -Dsubsonic.home=/var/subsonic -Dsubsonic.host=0.0.0.0 -Dsubsonic.port=4040 -Dsubsonic.httpsPort=0 -Dsubs
root 1811 1318 0 22:38 pts/0 00:00:00 sudo ps -ef

The service seems to respond properly to start and stop commands (sudo service subsonic stop or sudo service subsonic start).

How do I diagnose what might be going on here? I read another post about a database lock file (subsonic.lck) - It appears there isn't one on my machine...

marlen@bonusroom:/var/subsonic/db$ locate subsonic.lck
/var/subsonic/db/subsonic.lck
marlen@bonusroom:/var/subsonic/db$ cd /var/subsonic/db
marlen@bonusroom:/var/subsonic/db$ ls
subsonic.backup subsonic.data subsonic.properties subsonic.script
marlen@bonusroom:/var/subsonic/db$ ls -la
total 1569
drwxr-xr-x 2 root root 6 2012-04-25 22:31 .
drwxr-x--- 7 root root 11 2012-04-25 22:31 ..
-rwxr-xr-x 1 root root 20924 2012-04-25 22:06 subsonic.backup
-rwxr-xr-x 1 root root 1048576 2012-04-25 22:06 subsonic.data
-rwxr-xr-x 1 root root 418 2012-04-25 22:06 subsonic.properties
-rwxr-xr-x 1 root root 456326 2012-04-25 22:06 subsonic.script
marlen@bonusroom:/var/subsonic/db$


I need some help!

[mbro]

Ok, a brief update tonight. After not changing anything at all, I started up my subsonic box. No web UI. Oh well, I'll come back later and look at it. I go get some groceries, do a few necessary things, come back to have a look and its up! I just need more patience.

Rock on Subsonic!!!