You did not specify the port :3306 in your jdbc URL And you need 2 DB's. 1 for archiva, and 1 for users.
On Jan 7, 2008 11:34 AM, Zemian Deng <[EMAIL PROTECTED]> wrote: > @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] > > > > > -- 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 ---