archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Porter <br...@apache.org>
Subject Re: Need some insight deploying 1.4-M2
Date Tue, 15 May 2012 01:15:42 GMT
:)

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 <predatorvi@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 <olamy@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 <predatorvi@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






Mime
View raw message