@Mick
I am using Mysql version 4.1.21-standard
Here are archiva.xml
<Context path="/archiva"
docBase="${catalina.base}/wars/apache-archiva-1.0.war">
<Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource
"
username="archiva"
password="archiva"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/archiva" />
<Resource name="jdbc/archiva" auth="Container" type="
javax.sql.DataSource"
username="archiva"
password="archiva"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/archiva" />
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"
mail.smtp.host="popmail01.corporate.connextions.net"/>
</Context>
@Wayne
Thanks! I will post there from now on after this question :)
-Zemian
On Jan 7, 2008 2:05 PM, Wayne Fay <[EMAIL PROTECTED]> wrote:
> As Wendy says... ;-)
>
> Archiva has separate mailing lists... please come join us there if you
> have questions: http://maven.apache.org/archiva/mail-lists.html
>
> Wayne
>
> On 1/7/08, Mick Knutson <[EMAIL PROTECTED]> wrote:
> > What MySql Version?
> >
> > Can you post your archiva.xml?
> >
> >
> > On Jan 7, 2008 10:57 AM, Zemian Deng <[EMAIL PROTECTED]> wrote:
> >
> > > Hi list,
> > > I didn't see a separated list for archiva, so I post question here.
> > >
> > > I am installing archiva with default derby worked fine. Now I am
> trying to
> > > configure to use Mysql. When I run my Tomcat server, I get the
> following
> > > error:
> > >
> > > 2008-01-07 13:18:12,481 [main] INFO
> > > org.apache.catalina.core.ContainerBase
> .[Catalina].[localhost].[/archiva]
> > > - Loading plexus context properties from: '/WEB-INF/plexus.properties'
> > > 2008-01-07 13:18:12,488 [main] INFO
> > > org.apache.catalina.core.ContainerBase
> .[Catalina].[localhost].[/archiva]
> > > - Could not load plexus context properties from:
> > > '/WEB-INF/plexus.properties'
> > > 2008-01-07 13:18:13,365 [main] INFO
> org.codehaus.plexus.PlexusContainer -
> > > Loading on start [role,roleHint]: [
> > > org.apache.maven.archiva.web.startup.ArchivaStartup,default]
> > > 2008-01-07 13:18:15,031 [main] WARN
> > > net.sf.ehcache.config.ConfigurationFactory - No configuration found.
> > > Configuring ehcache from ehcache-failsafe.xml found in the classpath:
> > > jar:file:/opt/apache-tomcat-5.5.17
> > > /instances/buildman/webapps/archiva/WEB-INF/lib/ehcache-
> > > 1.3.0.jar!/ehcache-failsafe.xml
> > > 2008-01-07 13:18:16,497 [main] WARN JPOX.General - SQL warning:
> > > java.sql.SQLWarning: 'TYPE=storage_engine' is deprecated; use
> > > 'ENGINE=storage_engine' instead
> > > 2008-01-07 13:18:17,387 [main] ERROR JPOX.RDBMS - Error thrown
> executing
> > > CREATE TABLE `SECURITY_OPERATIONS`
> > > (
> > > `NAME` VARCHAR(256) BINARY NOT NULL,
> > > `DESCRIPTION` VARCHAR(256) BINARY NULL,
> > > `PERMANENT` BIT NOT NULL,
> > > `RESOURCE_REQUIRED` BIT NOT NULL,
> > > PRIMARY KEY (`NAME`)
> > > ) TYPE=INNODB : BLOB/TEXT column 'NAME' used in key specification
> without
> > > a
> > > key length
> > > com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column
> > > 'NAME'
> > > used in key specification without a key length
> > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
> > >
> > > I assume that I have to specific somewhere that I am using Mysql
> dialect?
> > > Can't find where to configure this. Can someone help me here? Thanks.
> > >
> > > -Zemian
> > >
> >
> >
> >
> > --
> > Thanks,
> > Mick Knutson
> >
> > http://www.baselogic.com
> > http://www.blincmagazine.com
> > http://www.djmick.com
> > http://www.myspace.com/mickknutson
> > http://www.myspace.com/BLiNCMagazine
> > http://tahoe.baselogic.com
> > ---
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
