2012/5/15 Jeff <[email protected]>: > 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 <[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> !! -- Olivier Lamy Talend: http://coders.talend.com http://twitter.com/olamy | http://linkedin.com/in/olamy
