You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@archiva.apache.org by Jeff <pr...@gmail.com> on 2012/05/11 01:12:17 UTC

Need some insight deploying 1.4-M2

I'm sure I'm missing something completely obvious but I'm not seeing it and
need some seasoned folks to provide some perspective.

I'm starting fresh with Tomcat 6 on CentOS 6 and want to install Archiva
1.4-M2 but get errors like this.

2012-05-10 16:42:28,913
[ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
'/archiva/derbydb/users', see the next exception for details.)
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to create database
'/archiva/derbydb/users', see the next exception for details.)

Caused by: javax.jdo.JDODataStoreException: 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 database
'/archiva/derbydb/users', see the next exception for details.)
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to create database
'/archiva/derbydb/users', see the next exception for details.)

org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'repositoryMetadataBuilder': Initialization of bean failed;
nested exception is org.springframework.beans.TypeMismatchException: Failed
to convert property value of type [java.lang.String] to required type
[java.lang.Class] for property 'role'; nested exception is
java.lang.IllegalArgumentException: Cannot find class
[org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to create database
'/archiva/derbydb/users', see the next exception for details.)

Caused by: javax.jdo.JDODataStoreException: 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 database
'/archiva/derbydb/users', see the next exception for details.)
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Failed to create database
'/archiva/derbydb/users', see the next exception for details.)


I've created the folders to isolate the files so if needed, I can mount
remote filesystems and run a couple front end servers:

/archiva
     /derbydb
          /users
     /repositories
     /indexes

I have the following in my tomcat6.conf:

CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
-Dappserver.base=$CATALINA_HOME"

My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:

<Context path="/"
          docBase="${catalina.home}/archiva/archiva.war">
        <Resource name="jdbc/users" auth="Container"
type="javax.sql.DataSource"
           username="sa"
           password=""
           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
           url="jdbc:derby:/archiva/derbydb/users;create=true" />

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

I have added the following JAR files into my $CATALINA_HOME/lib directory:

activation-1.1.jar
derby-10.1.3.1.jar
derbytools-10.1.3.1.jar
mail-1.4.jar


Am I missing something?

Thanks!
-- 

Jeff Vincent
predatorvi@gmail.com
See my LinkedIn profile at:
http://www.linkedin.com/in/rjeffreyvincent
I ♥ DropBox <http://db.tt/9O6LfBX> !!

Re: Need some insight deploying 1.4-M2

Posted by Olivier Lamy <ol...@apache.org>.
2012/5/15 Jeff <pr...@gmail.com>:
> I could add a section on Troubleshooting titled, "You might be a bonehead
> if ..." :-).

cool !
*NOTE* All documentation formats are accepted :P


>
> On Mon, May 14, 2012 at 7:15 PM, Brett Porter <br...@apache.org> wrote:
>
>> :)
>>
>> Are there some enhancements you'd like to suggest for our docs? Feel free
>> to update the wiki or submit a patch to the 1.4 documentation.
>>
>> - Brett
>>
>> On 15/05/2012, at 9:50 AM, Jeff wrote:
>>
>> > Have you ever had one of those weeks? ....
>> >
>> > I was mistakenly using an older 1.3.5 WAR file (though would have bet the
>> > farm that I had deployed v.1.4-M2) and it obviously needed the
>> jdbc/archiva
>> > config which I had removed because I was trying to deploy 1.4-M2.
>> >
>> > It is now working ... thanks!!
>> >
>> > On Mon, May 14, 2012 at 2:44 PM, Jeff <pr...@gmail.com> wrote:
>> >
>> >> Okay, finally getting back to this:
>> >>
>> >> The user that runs the tomcat process is 'tomcat' and ownership of
>> >> /archiva and all sub folders are tomcat:tomcat with permissions 755.
>> >>
>> >> I added this to my tomcat6.conf:
>> >>
>> >>       JAVA_OPTS="$JAVA_OPTS
>> >> -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver"
>> >>
>> >> and now I see files getting created in the /archiva/derbydb/users
>> folder:
>> >>
>> >> dbex.lck  db.lck  log  seg0  service.properties  tmp
>> >>
>> >> but I see this error in my catalina.out:
>> >>
>> >>     2012-05-14 19:48:16.103 GMT Thread[main,5,main]
>> >> java.io.FileNotFoundException: derby.log (Permission denied)
>> >>
>> >> but don't know where it is trying to create/open derby.log.  I dug
>> around
>> >> and added:
>> >>
>> >>     -Dderby.system.home=/archiva/derbydb
>> >>
>> >> to my tomcat6.conf startup parameters.  I also changed the archiva.xml
>> >> jdbc url to be relative to derbydb such as:
>> >>
>> >>     url="jdbc:derby:*users*;create=true"
>> >>
>> >> and now get the following errors:
>> >>
>> >>
>> >> 2012-05-14 14:27:59,190 [main] WARN  JPOX.RDBMS  - Error initialising
>> >> derby schema : Schema 'SA' does not exist
>> >> ERROR 42Y07: Schema 'SA' does not exist
>> >> ...
>> >> 012-05-14 14:27:59,205 [main] WARN  JPOX.RDBMS  - Error initialising
>> derby
>> >> schema : 'DROP FUNCTION' cannot be performed on 'JPOX_MATCHES' because
>> it
>> >> does not exist.
>> >> ...
>> >> 2012-05-14 14:28:02,481 [main] 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 JDBC driver of class '' for connect URL 'null'
>> >>
>> >>
>> >> I can't see anything else I could be missing and feels like I'm back at
>> >> square 1.  Any additional hints/suggestions are much appreciated.
>> >>
>> >> Jeff
>> >>
>> >> On Fri, May 11, 2012 at 2:10 AM, Olivier Lamy <ol...@apache.org> wrote:
>> >>
>> >>
>> >>> weird that should work.
>> >>> Simple question did question fs permissions for /archiva/derbydb/ ?
>> >>> Does the uid which start tomcat has write access to /archiva/derbydb ?
>> >>>
>> >>> 2012/5/11 Jeff <pr...@gmail.com>:
>> >>>
>> >>>> I'm sure I'm missing something completely obvious but I'm not seeing
>> it
>> >>> and
>> >>>> need some seasoned folks to provide some perspective.
>> >>>>
>> >>>> I'm starting fresh with Tomcat 6 on CentOS 6 and want to install
>> Archiva
>> >>>> 1.4-M2 but get errors like this.
>> >>>>
>> >>>> 2012-05-10 16:42:28,913
>> >>>> [ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>> >>>> PoolableConnectionFactory (Failed to create database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>>
>> >>>> Caused by: javax.jdo.JDODataStoreException: 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 database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>> >>>> PoolableConnectionFactory (Failed to create database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>>
>> >>>> org.springframework.beans.factory.BeanCreationException: Error
>> creating
>> >>>> bean with name 'repositoryMetadataBuilder': Initialization of bean
>> >>> failed;
>> >>>> nested exception is org.springframework.beans.TypeMismatchException:
>> >>> Failed
>> >>>> to convert property value of type [java.lang.String] to required type
>> >>>> [java.lang.Class] for property 'role'; nested exception is
>> >>>> java.lang.IllegalArgumentException: Cannot find class
>> >>>>
>> >>>
>> [org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]
>> >>>>
>> >>>> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
>> >>>> PoolableConnectionFactory (Failed to create database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>>
>> >>>> Caused by: javax.jdo.JDODataStoreException: 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 database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>> >>>> PoolableConnectionFactory (Failed to create database
>> >>>> '/archiva/derbydb/users', see the next exception for details.)
>> >>>>
>> >>>>
>> >>>> I've created the folders to isolate the files so if needed, I can
>> mount
>> >>>> remote filesystems and run a couple front end servers:
>> >>>>
>> >>>> /archiva
>> >>>>    /derbydb
>> >>>>         /users
>> >>>>    /repositories
>> >>>>    /indexes
>> >>>>
>> >>>> I have the following in my tomcat6.conf:
>> >>>>
>> >>>> CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
>> >>>> -Dappserver.base=$CATALINA_HOME"
>> >>>>
>> >>>> My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:
>> >>>>
>> >>>> <Context path="/"
>> >>>>         docBase="${catalina.home}/archiva/archiva.war">
>> >>>>       <Resource name="jdbc/users" auth="Container"
>> >>>> type="javax.sql.DataSource"
>> >>>>          username="sa"
>> >>>>          password=""
>> >>>>          driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>> >>>>          url="jdbc:derby:/archiva/derbydb/users;create=true" />
>> >>>>
>> >>>>       <Resource name="mail/Session" auth="Container"
>> >>>>           type="javax.mail.Session"
>> >>>>           mail.smtp.host="localhost"/>
>> >>>> </Context>
>> >>>>
>> >>>> I have added the following JAR files into my $CATALINA_HOME/lib
>> >>> directory:
>> >>>>
>> >>>> activation-1.1.jar
>> >>>> derby-10.1.3.1.jar
>> >>>> derbytools-10.1.3.1.jar
>> >>>> mail-1.4.jar
>> >>>>
>> >>>>
>> >>>> Am I missing something?
>> >>>>
>> >>>> Thanks!
>> >>>> --
>> >>>>
>> >>>> Jeff Vincent
>> >>>> predatorvi@gmail.com
>> >>>> See my LinkedIn profile at:
>> >>>> http://www.linkedin.com/in/rjeffreyvincent
>> >>>
>> >>>> I ♥ DropBox <http://db.tt/9O6LfBX> !!
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> Olivier Lamy
>> >>> Talend: http://coders.talend.com
>> >>> http://twitter.com/olamy | http://linkedin.com/in/olamy
>> >>>
>> >>>
>> >>>
>> >>
>> >>
>> >> --
>> >>
>> >> Jeff Vincent
>> >> predatorvi@gmail.com
>> >> See my LinkedIn profile at:
>> >> http://www.linkedin.com/in/rjeffreyvincent
>> >> I ♥ DropBox <http://db.tt/9O6LfBX> !!
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> > Jeff Vincent
>> > predatorvi@gmail.com
>> > See my LinkedIn profile at:
>> > http://www.linkedin.com/in/rjeffreyvincent
>> > I ♥ DropBox <http://db.tt/9O6LfBX> !!
>>
>> --
>> Brett Porter
>> brett@apache.org
>> http://brettporter.wordpress.com/
>> http://au.linkedin.com/in/brettporter
>> http://twitter.com/brettporter
>>
>>
>>
>>
>>
>>
>
>
> --
> Jeff Vincent
> predatorvi@gmail.com
> See my LinkedIn profile at:
> http://www.linkedin.com/in/rjeffreyvincent
> I ♥ DropBox <http://db.tt/9O6LfBX> !!



-- 
Olivier Lamy
Talend: http://coders.talend.com
http://twitter.com/olamy | http://linkedin.com/in/olamy

Re: Need some insight deploying 1.4-M2

Posted by Jeff <pr...@gmail.com>.
I could add a section on Troubleshooting titled, "You might be a bonehead
if ..." :-).

On Mon, May 14, 2012 at 7:15 PM, Brett Porter <br...@apache.org> wrote:

> :)
>
> Are there some enhancements you'd like to suggest for our docs? Feel free
> to update the wiki or submit a patch to the 1.4 documentation.
>
> - Brett
>
> On 15/05/2012, at 9:50 AM, Jeff wrote:
>
> > Have you ever had one of those weeks? ....
> >
> > I was mistakenly using an older 1.3.5 WAR file (though would have bet the
> > farm that I had deployed v.1.4-M2) and it obviously needed the
> jdbc/archiva
> > config which I had removed because I was trying to deploy 1.4-M2.
> >
> > It is now working ... thanks!!
> >
> > On Mon, May 14, 2012 at 2:44 PM, Jeff <pr...@gmail.com> wrote:
> >
> >> Okay, finally getting back to this:
> >>
> >> The user that runs the tomcat process is 'tomcat' and ownership of
> >> /archiva and all sub folders are tomcat:tomcat with permissions 755.
> >>
> >> I added this to my tomcat6.conf:
> >>
> >>       JAVA_OPTS="$JAVA_OPTS
> >> -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver"
> >>
> >> and now I see files getting created in the /archiva/derbydb/users
> folder:
> >>
> >> dbex.lck  db.lck  log  seg0  service.properties  tmp
> >>
> >> but I see this error in my catalina.out:
> >>
> >>     2012-05-14 19:48:16.103 GMT Thread[main,5,main]
> >> java.io.FileNotFoundException: derby.log (Permission denied)
> >>
> >> but don't know where it is trying to create/open derby.log.  I dug
> around
> >> and added:
> >>
> >>     -Dderby.system.home=/archiva/derbydb
> >>
> >> to my tomcat6.conf startup parameters.  I also changed the archiva.xml
> >> jdbc url to be relative to derbydb such as:
> >>
> >>     url="jdbc:derby:*users*;create=true"
> >>
> >> and now get the following errors:
> >>
> >>
> >> 2012-05-14 14:27:59,190 [main] WARN  JPOX.RDBMS  - Error initialising
> >> derby schema : Schema 'SA' does not exist
> >> ERROR 42Y07: Schema 'SA' does not exist
> >> ...
> >> 012-05-14 14:27:59,205 [main] WARN  JPOX.RDBMS  - Error initialising
> derby
> >> schema : 'DROP FUNCTION' cannot be performed on 'JPOX_MATCHES' because
> it
> >> does not exist.
> >> ...
> >> 2012-05-14 14:28:02,481 [main] 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 JDBC driver of class '' for connect URL 'null'
> >>
> >>
> >> I can't see anything else I could be missing and feels like I'm back at
> >> square 1.  Any additional hints/suggestions are much appreciated.
> >>
> >> Jeff
> >>
> >> On Fri, May 11, 2012 at 2:10 AM, Olivier Lamy <ol...@apache.org> wrote:
> >>
> >>
> >>> weird that should work.
> >>> Simple question did question fs permissions for /archiva/derbydb/ ?
> >>> Does the uid which start tomcat has write access to /archiva/derbydb ?
> >>>
> >>> 2012/5/11 Jeff <pr...@gmail.com>:
> >>>
> >>>> I'm sure I'm missing something completely obvious but I'm not seeing
> it
> >>> and
> >>>> need some seasoned folks to provide some perspective.
> >>>>
> >>>> I'm starting fresh with Tomcat 6 on CentOS 6 and want to install
> Archiva
> >>>> 1.4-M2 but get errors like this.
> >>>>
> >>>> 2012-05-10 16:42:28,913
> >>>> [ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
> >>>> PoolableConnectionFactory (Failed to create database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>>
> >>>> Caused by: javax.jdo.JDODataStoreException: 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 database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
> >>>> PoolableConnectionFactory (Failed to create database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>>
> >>>> org.springframework.beans.factory.BeanCreationException: Error
> creating
> >>>> bean with name 'repositoryMetadataBuilder': Initialization of bean
> >>> failed;
> >>>> nested exception is org.springframework.beans.TypeMismatchException:
> >>> Failed
> >>>> to convert property value of type [java.lang.String] to required type
> >>>> [java.lang.Class] for property 'role'; nested exception is
> >>>> java.lang.IllegalArgumentException: Cannot find class
> >>>>
> >>>
> [org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]
> >>>>
> >>>> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> >>>> PoolableConnectionFactory (Failed to create database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>>
> >>>> Caused by: javax.jdo.JDODataStoreException: 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 database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
> >>>> PoolableConnectionFactory (Failed to create database
> >>>> '/archiva/derbydb/users', see the next exception for details.)
> >>>>
> >>>>
> >>>> I've created the folders to isolate the files so if needed, I can
> mount
> >>>> remote filesystems and run a couple front end servers:
> >>>>
> >>>> /archiva
> >>>>    /derbydb
> >>>>         /users
> >>>>    /repositories
> >>>>    /indexes
> >>>>
> >>>> I have the following in my tomcat6.conf:
> >>>>
> >>>> CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
> >>>> -Dappserver.base=$CATALINA_HOME"
> >>>>
> >>>> My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:
> >>>>
> >>>> <Context path="/"
> >>>>         docBase="${catalina.home}/archiva/archiva.war">
> >>>>       <Resource name="jdbc/users" auth="Container"
> >>>> type="javax.sql.DataSource"
> >>>>          username="sa"
> >>>>          password=""
> >>>>          driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> >>>>          url="jdbc:derby:/archiva/derbydb/users;create=true" />
> >>>>
> >>>>       <Resource name="mail/Session" auth="Container"
> >>>>           type="javax.mail.Session"
> >>>>           mail.smtp.host="localhost"/>
> >>>> </Context>
> >>>>
> >>>> I have added the following JAR files into my $CATALINA_HOME/lib
> >>> directory:
> >>>>
> >>>> activation-1.1.jar
> >>>> derby-10.1.3.1.jar
> >>>> derbytools-10.1.3.1.jar
> >>>> mail-1.4.jar
> >>>>
> >>>>
> >>>> Am I missing something?
> >>>>
> >>>> Thanks!
> >>>> --
> >>>>
> >>>> Jeff Vincent
> >>>> predatorvi@gmail.com
> >>>> See my LinkedIn profile at:
> >>>> http://www.linkedin.com/in/rjeffreyvincent
> >>>
> >>>> I ♥ DropBox <http://db.tt/9O6LfBX> !!
> >>>
> >>>
> >>>
> >>> --
> >>> Olivier Lamy
> >>> Talend: http://coders.talend.com
> >>> http://twitter.com/olamy | http://linkedin.com/in/olamy
> >>>
> >>>
> >>>
> >>
> >>
> >> --
> >>
> >> Jeff Vincent
> >> predatorvi@gmail.com
> >> See my LinkedIn profile at:
> >> http://www.linkedin.com/in/rjeffreyvincent
> >> I ♥ DropBox <http://db.tt/9O6LfBX> !!
> >>
> >>
> >
> >
> >
> > --
> > Jeff Vincent
> > predatorvi@gmail.com
> > See my LinkedIn profile at:
> > http://www.linkedin.com/in/rjeffreyvincent
> > I ♥ DropBox <http://db.tt/9O6LfBX> !!
>
> --
> Brett Porter
> brett@apache.org
> http://brettporter.wordpress.com/
> http://au.linkedin.com/in/brettporter
> http://twitter.com/brettporter
>
>
>
>
>
>


-- 
Jeff Vincent
predatorvi@gmail.com
See my LinkedIn profile at:
http://www.linkedin.com/in/rjeffreyvincent
I ♥ DropBox <http://db.tt/9O6LfBX> !!

Re: Need some insight deploying 1.4-M2

Posted by Brett Porter <br...@apache.org>.
:)

Are there some enhancements you'd like to suggest for our docs? Feel free to update the wiki or submit a patch to the 1.4 documentation.

- Brett

On 15/05/2012, at 9:50 AM, Jeff wrote:

> Have you ever had one of those weeks? ....
> 
> I was mistakenly using an older 1.3.5 WAR file (though would have bet the
> farm that I had deployed v.1.4-M2) and it obviously needed the jdbc/archiva
> config which I had removed because I was trying to deploy 1.4-M2.
> 
> It is now working ... thanks!!
> 
> On Mon, May 14, 2012 at 2:44 PM, Jeff <pr...@gmail.com> wrote:
> 
>> Okay, finally getting back to this:
>> 
>> The user that runs the tomcat process is 'tomcat' and ownership of
>> /archiva and all sub folders are tomcat:tomcat with permissions 755.
>> 
>> I added this to my tomcat6.conf:
>> 
>>       JAVA_OPTS="$JAVA_OPTS
>> -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver"
>> 
>> and now I see files getting created in the /archiva/derbydb/users folder:
>> 
>> dbex.lck  db.lck  log  seg0  service.properties  tmp
>> 
>> but I see this error in my catalina.out:
>> 
>>     2012-05-14 19:48:16.103 GMT Thread[main,5,main]
>> java.io.FileNotFoundException: derby.log (Permission denied)
>> 
>> but don't know where it is trying to create/open derby.log.  I dug around
>> and added:
>> 
>>     -Dderby.system.home=/archiva/derbydb
>> 
>> to my tomcat6.conf startup parameters.  I also changed the archiva.xml
>> jdbc url to be relative to derbydb such as:
>> 
>>     url="jdbc:derby:*users*;create=true"
>> 
>> and now get the following errors:
>> 
>> 
>> 2012-05-14 14:27:59,190 [main] WARN  JPOX.RDBMS  - Error initialising
>> derby schema : Schema 'SA' does not exist
>> ERROR 42Y07: Schema 'SA' does not exist
>> ...
>> 012-05-14 14:27:59,205 [main] WARN  JPOX.RDBMS  - Error initialising derby
>> schema : 'DROP FUNCTION' cannot be performed on 'JPOX_MATCHES' because it
>> does not exist.
>> ...
>> 2012-05-14 14:28:02,481 [main] 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 JDBC driver of class '' for connect URL 'null'
>> 
>> 
>> I can't see anything else I could be missing and feels like I'm back at
>> square 1.  Any additional hints/suggestions are much appreciated.
>> 
>> Jeff
>> 
>> On Fri, May 11, 2012 at 2:10 AM, Olivier Lamy <ol...@apache.org> wrote:
>> 
>> 
>>> weird that should work.
>>> Simple question did question fs permissions for /archiva/derbydb/ ?
>>> Does the uid which start tomcat has write access to /archiva/derbydb ?
>>> 
>>> 2012/5/11 Jeff <pr...@gmail.com>:
>>> 
>>>> I'm sure I'm missing something completely obvious but I'm not seeing it
>>> and
>>>> need some seasoned folks to provide some perspective.
>>>> 
>>>> I'm starting fresh with Tomcat 6 on CentOS 6 and want to install Archiva
>>>> 1.4-M2 but get errors like this.
>>>> 
>>>> 2012-05-10 16:42:28,913
>>>> [ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>>>> PoolableConnectionFactory (Failed to create database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> 
>>>> Caused by: javax.jdo.JDODataStoreException: 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 database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>>>> PoolableConnectionFactory (Failed to create database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> 
>>>> org.springframework.beans.factory.BeanCreationException: Error creating
>>>> bean with name 'repositoryMetadataBuilder': Initialization of bean
>>> failed;
>>>> nested exception is org.springframework.beans.TypeMismatchException:
>>> Failed
>>>> to convert property value of type [java.lang.String] to required type
>>>> [java.lang.Class] for property 'role'; nested exception is
>>>> java.lang.IllegalArgumentException: Cannot find class
>>>> 
>>> [org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]
>>>> 
>>>> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
>>>> PoolableConnectionFactory (Failed to create database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> 
>>>> Caused by: javax.jdo.JDODataStoreException: 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 database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>>>> PoolableConnectionFactory (Failed to create database
>>>> '/archiva/derbydb/users', see the next exception for details.)
>>>> 
>>>> 
>>>> I've created the folders to isolate the files so if needed, I can mount
>>>> remote filesystems and run a couple front end servers:
>>>> 
>>>> /archiva
>>>>    /derbydb
>>>>         /users
>>>>    /repositories
>>>>    /indexes
>>>> 
>>>> I have the following in my tomcat6.conf:
>>>> 
>>>> CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
>>>> -Dappserver.base=$CATALINA_HOME"
>>>> 
>>>> My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:
>>>> 
>>>> <Context path="/"
>>>>         docBase="${catalina.home}/archiva/archiva.war">
>>>>       <Resource name="jdbc/users" auth="Container"
>>>> type="javax.sql.DataSource"
>>>>          username="sa"
>>>>          password=""
>>>>          driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>>>>          url="jdbc:derby:/archiva/derbydb/users;create=true" />
>>>> 
>>>>       <Resource name="mail/Session" auth="Container"
>>>>           type="javax.mail.Session"
>>>>           mail.smtp.host="localhost"/>
>>>> </Context>
>>>> 
>>>> I have added the following JAR files into my $CATALINA_HOME/lib
>>> directory:
>>>> 
>>>> activation-1.1.jar
>>>> derby-10.1.3.1.jar
>>>> derbytools-10.1.3.1.jar
>>>> mail-1.4.jar
>>>> 
>>>> 
>>>> Am I missing something?
>>>> 
>>>> Thanks!
>>>> --
>>>> 
>>>> Jeff Vincent
>>>> predatorvi@gmail.com
>>>> See my LinkedIn profile at:
>>>> http://www.linkedin.com/in/rjeffreyvincent
>>> 
>>>> I ♥ DropBox <http://db.tt/9O6LfBX> !!
>>> 
>>> 
>>> 
>>> --
>>> Olivier Lamy
>>> Talend: http://coders.talend.com
>>> http://twitter.com/olamy | http://linkedin.com/in/olamy
>>> 
>>> 
>>> 
>> 
>> 
>> --
>> 
>> Jeff Vincent
>> predatorvi@gmail.com
>> See my LinkedIn profile at:
>> http://www.linkedin.com/in/rjeffreyvincent
>> I ♥ DropBox <http://db.tt/9O6LfBX> !!
>> 
>> 
> 
> 
> 
> -- 
> Jeff Vincent
> predatorvi@gmail.com
> See my LinkedIn profile at:
> http://www.linkedin.com/in/rjeffreyvincent
> I ♥ DropBox <http://db.tt/9O6LfBX> !!

--
Brett Porter
brett@apache.org
http://brettporter.wordpress.com/
http://au.linkedin.com/in/brettporter
http://twitter.com/brettporter






Re: Need some insight deploying 1.4-M2

Posted by Jeff <pr...@gmail.com>.
Have you ever had one of those weeks? ....

I was mistakenly using an older 1.3.5 WAR file (though would have bet the
farm that I had deployed v.1.4-M2) and it obviously needed the jdbc/archiva
config which I had removed because I was trying to deploy 1.4-M2.

It is now working ... thanks!!

On Mon, May 14, 2012 at 2:44 PM, Jeff <pr...@gmail.com> wrote:

> Okay, finally getting back to this:
>
> The user that runs the tomcat process is 'tomcat' and ownership of
> /archiva and all sub folders are tomcat:tomcat with permissions 755.
>
> I added this to my tomcat6.conf:
>
>        JAVA_OPTS="$JAVA_OPTS
> -Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver"
>
> and now I see files getting created in the /archiva/derbydb/users folder:
>
> dbex.lck  db.lck  log  seg0  service.properties  tmp
>
> but I see this error in my catalina.out:
>
>      2012-05-14 19:48:16.103 GMT Thread[main,5,main]
> java.io.FileNotFoundException: derby.log (Permission denied)
>
> but don't know where it is trying to create/open derby.log.  I dug around
> and added:
>
>      -Dderby.system.home=/archiva/derbydb
>
> to my tomcat6.conf startup parameters.  I also changed the archiva.xml
> jdbc url to be relative to derbydb such as:
>
>      url="jdbc:derby:*users*;create=true"
>
> and now get the following errors:
>
>
> 2012-05-14 14:27:59,190 [main] WARN  JPOX.RDBMS  - Error initialising
> derby schema : Schema 'SA' does not exist
> ERROR 42Y07: Schema 'SA' does not exist
> ...
> 012-05-14 14:27:59,205 [main] WARN  JPOX.RDBMS  - Error initialising derby
> schema : 'DROP FUNCTION' cannot be performed on 'JPOX_MATCHES' because it
> does not exist.
> ...
> 2012-05-14 14:28:02,481 [main] 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 JDBC driver of class '' for connect URL 'null'
>
>
> I can't see anything else I could be missing and feels like I'm back at
> square 1.  Any additional hints/suggestions are much appreciated.
>
> Jeff
>
> On Fri, May 11, 2012 at 2:10 AM, Olivier Lamy <ol...@apache.org> wrote:
>
>
>> weird that should work.
>> Simple question did question fs permissions for /archiva/derbydb/ ?
>> Does the uid which start tomcat has write access to /archiva/derbydb ?
>>
>> 2012/5/11 Jeff <pr...@gmail.com>:
>>
>> > I'm sure I'm missing something completely obvious but I'm not seeing it
>> and
>> > need some seasoned folks to provide some perspective.
>> >
>> > I'm starting fresh with Tomcat 6 on CentOS 6 and want to install Archiva
>> > 1.4-M2 but get errors like this.
>> >
>> > 2012-05-10 16:42:28,913
>> > [ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> > org.apache.commons.dbcp.SQLNestedException: Cannot create
>> > PoolableConnectionFactory (Failed to create database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> >
>> > Caused by: javax.jdo.JDODataStoreException: 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 database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> > org.apache.commons.dbcp.SQLNestedException: Cannot create
>> > PoolableConnectionFactory (Failed to create database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> >
>> > org.springframework.beans.factory.BeanCreationException: Error creating
>> > bean with name 'repositoryMetadataBuilder': Initialization of bean
>> failed;
>> > nested exception is org.springframework.beans.TypeMismatchException:
>> Failed
>> > to convert property value of type [java.lang.String] to required type
>> > [java.lang.Class] for property 'role'; nested exception is
>> > java.lang.IllegalArgumentException: Cannot find class
>> >
>> [org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]
>> >
>> > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
>> > PoolableConnectionFactory (Failed to create database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> >
>> > Caused by: javax.jdo.JDODataStoreException: 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 database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> > org.apache.commons.dbcp.SQLNestedException: Cannot create
>> > PoolableConnectionFactory (Failed to create database
>> > '/archiva/derbydb/users', see the next exception for details.)
>> >
>> >
>> > I've created the folders to isolate the files so if needed, I can mount
>> > remote filesystems and run a couple front end servers:
>> >
>> > /archiva
>> >     /derbydb
>> >          /users
>> >     /repositories
>> >     /indexes
>> >
>> > I have the following in my tomcat6.conf:
>> >
>> > CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
>> > -Dappserver.base=$CATALINA_HOME"
>> >
>> > My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:
>> >
>> > <Context path="/"
>> >          docBase="${catalina.home}/archiva/archiva.war">
>> >        <Resource name="jdbc/users" auth="Container"
>> > type="javax.sql.DataSource"
>> >           username="sa"
>> >           password=""
>> >           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>> >           url="jdbc:derby:/archiva/derbydb/users;create=true" />
>> >
>> >        <Resource name="mail/Session" auth="Container"
>> >            type="javax.mail.Session"
>> >            mail.smtp.host="localhost"/>
>> > </Context>
>> >
>> > I have added the following JAR files into my $CATALINA_HOME/lib
>> directory:
>> >
>> > activation-1.1.jar
>> > derby-10.1.3.1.jar
>> > derbytools-10.1.3.1.jar
>> > mail-1.4.jar
>> >
>> >
>> > Am I missing something?
>> >
>> > Thanks!
>> > --
>> >
>> > Jeff Vincent
>> > predatorvi@gmail.com
>> > See my LinkedIn profile at:
>> > http://www.linkedin.com/in/rjeffreyvincent
>>
>> > I ♥ DropBox <http://db.tt/9O6LfBX> !!
>>
>>
>>
>> --
>> Olivier Lamy
>> Talend: http://coders.talend.com
>> http://twitter.com/olamy | http://linkedin.com/in/olamy
>>
>>
>>
>
>
> --
>
> Jeff Vincent
> predatorvi@gmail.com
> See my LinkedIn profile at:
> http://www.linkedin.com/in/rjeffreyvincent
> I ♥ DropBox <http://db.tt/9O6LfBX> !!
>
>



-- 
Jeff Vincent
predatorvi@gmail.com
See my LinkedIn profile at:
http://www.linkedin.com/in/rjeffreyvincent
I ♥ DropBox <http://db.tt/9O6LfBX> !!

Re: Need some insight deploying 1.4-M2

Posted by Jeff <pr...@gmail.com>.
Okay, finally getting back to this:

The user that runs the tomcat process is 'tomcat' and ownership of /archiva
and all sub folders are tomcat:tomcat with permissions 755.

I added this to my tomcat6.conf:

       JAVA_OPTS="$JAVA_OPTS
-Djdbc.drivers=org.apache.derby.jdbc.EmbeddedDriver"

and now I see files getting created in the /archiva/derbydb/users folder:

dbex.lck  db.lck  log  seg0  service.properties  tmp

but I see this error in my catalina.out:

     2012-05-14 19:48:16.103 GMT Thread[main,5,main]
java.io.FileNotFoundException: derby.log (Permission denied)

but don't know where it is trying to create/open derby.log.  I dug around
and added:

     -Dderby.system.home=/archiva/derbydb

to my tomcat6.conf startup parameters.  I also changed the archiva.xml jdbc
url to be relative to derbydb such as:

     url="jdbc:derby:*users*;create=true"

and now get the following errors:


2012-05-14 14:27:59,190 [main] WARN  JPOX.RDBMS  - Error initialising derby
schema : Schema 'SA' does not exist
ERROR 42Y07: Schema 'SA' does not exist
...
012-05-14 14:27:59,205 [main] WARN  JPOX.RDBMS  - Error initialising derby
schema : 'DROP FUNCTION' cannot be performed on 'JPOX_MATCHES' because it
does not exist.
...
2012-05-14 14:28:02,481 [main] 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 JDBC driver of class '' for connect URL 'null'


I can't see anything else I could be missing and feels like I'm back at
square 1.  Any additional hints/suggestions are much appreciated.

Jeff

On Fri, May 11, 2012 at 2:10 AM, Olivier Lamy <ol...@apache.org> wrote:


> weird that should work.
> Simple question did question fs permissions for /archiva/derbydb/ ?
> Does the uid which start tomcat has write access to /archiva/derbydb ?
>
> 2012/5/11 Jeff <pr...@gmail.com>:
>
> > I'm sure I'm missing something completely obvious but I'm not seeing it
> and
> > need some seasoned folks to provide some perspective.
> >
> > I'm starting fresh with Tomcat 6 on CentOS 6 and want to install Archiva
> > 1.4-M2 but get errors like this.
> >
> > 2012-05-10 16:42:28,913
> > [ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
> > '/archiva/derbydb/users', see the next exception for details.)
> > org.apache.commons.dbcp.SQLNestedException: Cannot create
> > PoolableConnectionFactory (Failed to create database
> > '/archiva/derbydb/users', see the next exception for details.)
> >
> > Caused by: javax.jdo.JDODataStoreException: 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 database
> > '/archiva/derbydb/users', see the next exception for details.)
> > org.apache.commons.dbcp.SQLNestedException: Cannot create
> > PoolableConnectionFactory (Failed to create database
> > '/archiva/derbydb/users', see the next exception for details.)
> >
> > org.springframework.beans.factory.BeanCreationException: Error creating
> > bean with name 'repositoryMetadataBuilder': Initialization of bean
> failed;
> > nested exception is org.springframework.beans.TypeMismatchException:
> Failed
> > to convert property value of type [java.lang.String] to required type
> > [java.lang.Class] for property 'role'; nested exception is
> > java.lang.IllegalArgumentException: Cannot find class
> > [org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]
> >
> > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> > PoolableConnectionFactory (Failed to create database
> > '/archiva/derbydb/users', see the next exception for details.)
> >
> > Caused by: javax.jdo.JDODataStoreException: 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 database
> > '/archiva/derbydb/users', see the next exception for details.)
> > org.apache.commons.dbcp.SQLNestedException: Cannot create
> > PoolableConnectionFactory (Failed to create database
> > '/archiva/derbydb/users', see the next exception for details.)
> >
> >
> > I've created the folders to isolate the files so if needed, I can mount
> > remote filesystems and run a couple front end servers:
> >
> > /archiva
> >     /derbydb
> >          /users
> >     /repositories
> >     /indexes
> >
> > I have the following in my tomcat6.conf:
> >
> > CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
> > -Dappserver.base=$CATALINA_HOME"
> >
> > My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:
> >
> > <Context path="/"
> >          docBase="${catalina.home}/archiva/archiva.war">
> >        <Resource name="jdbc/users" auth="Container"
> > type="javax.sql.DataSource"
> >           username="sa"
> >           password=""
> >           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
> >           url="jdbc:derby:/archiva/derbydb/users;create=true" />
> >
> >        <Resource name="mail/Session" auth="Container"
> >            type="javax.mail.Session"
> >            mail.smtp.host="localhost"/>
> > </Context>
> >
> > I have added the following JAR files into my $CATALINA_HOME/lib
> directory:
> >
> > activation-1.1.jar
> > derby-10.1.3.1.jar
> > derbytools-10.1.3.1.jar
> > mail-1.4.jar
> >
> >
> > Am I missing something?
> >
> > Thanks!
> > --
> >
> > Jeff Vincent
> > predatorvi@gmail.com
> > See my LinkedIn profile at:
> > http://www.linkedin.com/in/rjeffreyvincent
>
> > I ♥ DropBox <http://db.tt/9O6LfBX> !!
>
>
>
> --
> Olivier Lamy
> Talend: http://coders.talend.com
> http://twitter.com/olamy | http://linkedin.com/in/olamy
>
>
>


-- 

Jeff Vincent
predatorvi@gmail.com
See my LinkedIn profile at:
http://www.linkedin.com/in/rjeffreyvincent
I ♥ DropBox <http://db.tt/9O6LfBX> !!

Re: Need some insight deploying 1.4-M2

Posted by Olivier Lamy <ol...@apache.org>.
weird that should work.
Simple question did question fs permissions for /archiva/derbydb/ ?
Does the uid which start tomcat has write access to /archiva/derbydb ?

2012/5/11 Jeff <pr...@gmail.com>:
> I'm sure I'm missing something completely obvious but I'm not seeing it and
> need some seasoned folks to provide some perspective.
>
> I'm starting fresh with Tomcat 6 on CentOS 6 and want to install Archiva
> 1.4-M2 but get errors like this.
>
> 2012-05-10 16:42:28,913
> [ContainerBackgroundProcessor[StandardEngine[Catalina]]] 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 database
> '/archiva/derbydb/users', see the next exception for details.)
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Failed to create database
> '/archiva/derbydb/users', see the next exception for details.)
>
> Caused by: javax.jdo.JDODataStoreException: 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 database
> '/archiva/derbydb/users', see the next exception for details.)
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Failed to create database
> '/archiva/derbydb/users', see the next exception for details.)
>
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'repositoryMetadataBuilder': Initialization of bean failed;
> nested exception is org.springframework.beans.TypeMismatchException: Failed
> to convert property value of type [java.lang.String] to required type
> [java.lang.Class] for property 'role'; nested exception is
> java.lang.IllegalArgumentException: Cannot find class
> [org.apache.maven.artifact.repository.metadata.RepositoryMetadataBuilder]
>
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Failed to create database
> '/archiva/derbydb/users', see the next exception for details.)
>
> Caused by: javax.jdo.JDODataStoreException: 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 database
> '/archiva/derbydb/users', see the next exception for details.)
> org.apache.commons.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory (Failed to create database
> '/archiva/derbydb/users', see the next exception for details.)
>
>
> I've created the folders to isolate the files so if needed, I can mount
> remote filesystems and run a couple front end servers:
>
> /archiva
>     /derbydb
>          /users
>     /repositories
>     /indexes
>
> I have the following in my tomcat6.conf:
>
> CATALINA_OPTS="-Dappserver.home=$CATALINA_HOME
> -Dappserver.base=$CATALINA_HOME"
>
> My $CATALINA_HOME/conf/Catalina/localhost/archiva.xml is:
>
> <Context path="/"
>          docBase="${catalina.home}/archiva/archiva.war">
>        <Resource name="jdbc/users" auth="Container"
> type="javax.sql.DataSource"
>           username="sa"
>           password=""
>           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>           url="jdbc:derby:/archiva/derbydb/users;create=true" />
>
>        <Resource name="mail/Session" auth="Container"
>            type="javax.mail.Session"
>            mail.smtp.host="localhost"/>
> </Context>
>
> I have added the following JAR files into my $CATALINA_HOME/lib directory:
>
> activation-1.1.jar
> derby-10.1.3.1.jar
> derbytools-10.1.3.1.jar
> mail-1.4.jar
>
>
> Am I missing something?
>
> Thanks!
> --
>
> Jeff Vincent
> predatorvi@gmail.com
> See my LinkedIn profile at:
> http://www.linkedin.com/in/rjeffreyvincent
> I ♥ DropBox <http://db.tt/9O6LfBX> !!



-- 
Olivier Lamy
Talend: http://coders.talend.com
http://twitter.com/olamy | http://linkedin.com/in/olamy