"Could not get JDBC Connection" error on setup
Posted: Wed Apr 03, 2013 8:14 am
Hi,
I'm attempting to install MusicCabinet over Subsonic (installed via RPM) on CentOS 6.3.
I've done the following (pretty much following these instructions: http://virtuallyhyper.com/2013/02/installing-musiccabinet-on-top-of-subsonic/, except where they varied slightly):
Installed Java 1.7
Installed Postgresql 9.2 and initialised the database
Copied the .jar and .war files over the existing files in /usr/share/subsonic
Restarted everything
When I try to enter the Settings menu once it's all fired up, I get a "Message Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!" error.
The subsonic.log file is as below:
[2013-04-03 09:04:58,113] INFO PodcastService - Automatic Podcast update scheduled to run every 24 hour(s), starting at Wed Apr 03 09:09:58 BST 2013
[2013-04-03 09:04:58,160] WARN Util - Failed to resolve local IP address.
java.net.UnknownHostException: mediaserver.colinshouse: mediaserver.colinshouse: Name or service not known
at java.net.InetAddress.getLocalHost(InetAddress.java:1438)
at net.sourceforge.subsonic.util.Util.getLocalIpAddress(Util.java:100)
at net.sourceforge.subsonic.service.NetworkService$URLRedirectionTask.execute(NetworkService.java:232)
at net.sourceforge.subsonic.service.NetworkService$Task.run(NetworkService.java:302)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
Does anyone have any suggestions?
I'm attempting to install MusicCabinet over Subsonic (installed via RPM) on CentOS 6.3.
I've done the following (pretty much following these instructions: http://virtuallyhyper.com/2013/02/installing-musiccabinet-on-top-of-subsonic/, except where they varied slightly):
Installed Java 1.7
Installed Postgresql 9.2 and initialised the database
Copied the .jar and .war files over the existing files in /usr/share/subsonic
Restarted everything
When I try to enter the Settings menu once it's all fired up, I get a "Message Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!" error.
The subsonic.log file is as below:
[2013-04-03 09:04:58,113] INFO PodcastService - Automatic Podcast update scheduled to run every 24 hour(s), starting at Wed Apr 03 09:09:58 BST 2013
[2013-04-03 09:04:58,160] WARN Util - Failed to resolve local IP address.
java.net.UnknownHostException: mediaserver.colinshouse: mediaserver.colinshouse: Name or service not known
at java.net.InetAddress.getLocalHost(InetAddress.java:1438)
at net.sourceforge.subsonic.util.Util.getLocalIpAddress(Util.java:100)
at net.sourceforge.subsonic.service.NetworkService$URLRedirectionTask.execute(NetworkService.java:232)
at net.sourceforge.subsonic.service.NetworkService$Task.run(NetworkService.java:302)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
Does anyone have any suggestions?