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