tomcat6 and OpenSuse 11.1

[Erwin Mueller]

Hello, I have problem to setup Archiva 1.2 M1 with Tomcat 6 on OpenSuse
11.1. Tomcat is working fine, the examples are all working. I have
followed the instructions on the website and in the wiki.

$CATALINA_HOME is /usr/share/tomcat6

1. created dir $CATALINA_HOME/archiva
2. downloaded war file for 1.2 M1
3. edited/created $CATALINA_HOME/conf/Catalina/localhost/archiva.xml to

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/archiva"
         docBase="${catalina.home}/archiva/apache-archiva-1.2-M1.war">

<Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource"
          username="sa"
          password=""
          driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
          url="jdbc:derby:/path/to/database/users;create=true" />

<Resource name="jdbc/archiva" auth="Container"
type="javax.sql.DataSource"
          username="sa"
          password=""
          driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
          url="jdbc:derby:/path/to/database/archiva;create=true" />

<Resource name="mail/Session" auth="Container"
           type="javax.mail.Session"
           mail.smtp.host="localhost"/>

</Context>

4. Copied the derby-10.1.3.1.jar and mail-1.4.jar to $CATALINA_HOME/lib/

5. Edited /etc/tomcat6/tomcat6.conf to add
CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME -Dappserver.base=
$CATALINA_HOME"

6. Edited /etc/sysconfig/tomcat6 to add
CATALINA_OPTS="-Dappserver.home=/usr/share/tomcat6
-Dappserver.base=/usr/share/tomcat6"

7. Edited /usr/bin/dtomcat6 to add
CATALINA_OPTS="-Dappserver.home=/usr/share/tomcat6
-Dappserver.base=/usr/share/tomcat6"

Because I don't know with config file I should edit in Suse so I just
edited all three, after testing with only number 1, number 1 and 2.

In tomcat homepage under "List application" I have now the Archiva:


/archiva Apache Archiva false 0  Start   Stop   Reload   Undeploy  

if I click not to "Start" I get the error: FAIL - Application at context
path /archiva could not be started

I tryed to edit $CATALINA_HOME/webapps/archiva/META-INF/context.xml and
set the same as to archiva.xml.

I get the exception in archiva.log:

2009-01-02 06:28:17,343 [http-8080-1] ERROR JPOX.RDBMS.Schema  - Failed
initialising database. Please check that your database JDBC driver is
 accessible, and the database URL and username/password are correct.
Exception : Cannot create PoolableConnectionFactory (Failed to create da
tabase '/path/to/database/users', see the next exception for details.)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to create database
'/path/to/database/users',
 see the next exception for details.)

Do I need to create a user  with username="sa" and no password? How do I
do this?

Here are the information about the system:
Tomcat Version JVM Version JVM Vendor OS Name OS Version OS Architecture
Apache Tomcat/6.0.18 1.6.0_07-b06 Sun Microsystems Inc. Linux
2.6.27.7-9-xen i386

Yours, Erwin.