:) 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 <[email protected]> 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 <[email protected]> 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 <[email protected]>: >>> >>>> 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 >>>> [email protected] >>>> 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 >> [email protected] >> See my LinkedIn profile at: >> http://www.linkedin.com/in/rjeffreyvincent >> I ♥ DropBox <http://db.tt/9O6LfBX> !! >> >> > > > > -- > Jeff Vincent > [email protected] > See my LinkedIn profile at: > http://www.linkedin.com/in/rjeffreyvincent > I ♥ DropBox <http://db.tt/9O6LfBX> !! -- Brett Porter [email protected] http://brettporter.wordpress.com/ http://au.linkedin.com/in/brettporter http://twitter.com/brettporter
