@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] > >