archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff <predato...@gmail.com>
Subject Re: Need some insight deploying 1.4-M2
Date Tue, 15 May 2012 16:18:23 GMT
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 <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> !!

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message