• Registered: 2010-05-27
  • Posts: 2

Topic: Issue when starting Frevvo. Creation of formsdb files.

When I start frevvo by going to the Frevvo root (currently, /opt/frevvo) and then starting by doing:

tomcat/bin/startup.sh

A few files are dumped into /opt/frevvo, formsdb.lock, formsdb.properties, etc.

This is okay when starting Frevvo manually. However, we use Solaris 10, which uses the Sun Management Facility. I have working scripts for Tomcat and when attempting to use this for Frevvo, the tomcat part works just fine. Unfortunately, when setting Frevvo to run as an unprivileged user (nobody), the startup script essentially runs startup.sh from /opt, not /opt/frevvo, and as such is denied writing to this directory.

Is there any way to tell Frevvo specifically where to put these files on startup?

  • Registered: 2009-02-23
  • Posts: 145

Re: Issue when starting Frevvo. Creation of formsdb files.

Yes you can control the location via frevvo's configuration file:

   1.  Edit <frevvo-home>\tomcat\conf\Catalina\localhost\context.xml.default
   2. Configure the HSQLDB jdbc/frevvoDS Resource
   3. Change url="jdbc:hsqldb:file:formsdb" to an absolute directory e.g. url="jdbc:hsqldb:file:c:\tmp\frevvo-data\formsdb" or you can also make it relative to frevvo's installation via url="jdbc:hsqldb:file:${catalina.home}/../data/db/forms" or some other relative location.