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