Install failure: Database 'db/WavsepConfigDB' not found

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Install war file
2. go to http://localhost:8080/wavsep/wavsep-install/install.jsp
3. fill in mysql password and hit enter

What is the expected output? What do you see instead?

Expect database initialization.

Get error message:

javax.servlet.ServletException: java.sql.SQLException: Database 
'db/WavsepConfigDB' not found.

What version of the product are you using? On what operating system?
1.1.1, xubuntu 12.04, with system openjdk-6 and tomcat-6

Please provide any additional information below.

org.apache.jasper.JasperException: An exception occurred processing JSP page 
/wavsep-install/install.jsp at line 109

106:    
107:    
108:    try {
109:        conn = ConnectionPoolManager.getDerbyConnection();
110:        
111:        
112:        //#############################################

Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:412)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

javax.servlet.ServletException: java.sql.SQLException: Database 
'db/WavsepConfigDB' not found.
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:865)

Original issue reported on code.google.com by steve.pi...@gmail.com on 28 Feb 2012 at 9:30

Attachments:

• wavsep-full-trace.txt

[GoogleCodeExporter]

Same failure on ubuntu 10.04 LTS with official java 1.6.0_24 and system tomcat 
6.0.24 

Original comment by steve.pi...@gmail.com on 28 Feb 2012 at 10:58

[GoogleCodeExporter]

Solved. 

For those who may come behind me:

Make sure the dir:

$CATALINA_BASE/db

is there and writable by the tomcat process.

On Ubuntu, that's /var/lib/tomcat6 so:

sudo mkdir /var/lib/tomcat6/db
sudo chown tomcat6:tomcat6 /var/lib/tomcat6/db/

Original comment by steve.pi...@gmail.com on 29 Feb 2012 at 12:47

[GoogleCodeExporter]

I had the same problem. Steve's solution fixed it. Thanks! :)

Original comment by cosmin.s...@gmail.com on 25 May 2012 at 1:59

[GoogleCodeExporter]

The quickest (and ugliest) way to handle the issue is to run the tomcat process 
with root/admin privileges (although I admit Steve's solution is more elegant) 
- will do the trick in linux/win7, and won't be necessary in most XP 
installations.

Since in the upcoming version of wavsep, some specific test cases will require 
wavsep to run as root, I'm still not sure how to address this issue, 
but my current intention to to find a way to mitigate it by storing the derby 
repository in a location owned by the tomcat user.

Original comment by sectoola...@gmail.com on 30 May 2012 at 10:51

[GoogleCodeExporter]

This problem occurs on Ubuntu 11.10 with Tomcat7 even after following the above 
fixes. Any suggestions?

Original comment by m...@errancarey.com on 17 Aug 2012 at 6:10

[GoogleCodeExporter]

In newer version, the catalina base that is passed to tomcat is 
/usr/share/tomcat6 which has symbolic links pointing to /var/lib/tomcat6 
directories. So you need to create a new symbolic link db which points to 
directory /var/lib/tomcat6/db as below:

cd /usr/share/tomcat6
ln -s /var/lib/tomcat6/db

Make sure you do this with root user.

Original comment by casaraw...@qualys.com on 2 Jul 2015 at 9:00