archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Lamy <ol...@apache.org>
Subject Re: Need some insight deploying 1.4-M2
Date Tue, 15 May 2012 16:24:10 GMT
2012/5/15 Jeff <predatorvi@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 <brett@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 <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
>>
>>
>>
>>
>>
>>
>
>
> --
> 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

Mime
View raw message