Mick, My exact error are gone now after I restart Tomcat again. It's weird.
But anyways, to your replied, I think the following works actually:
1.) default mysql jdbc url is to 3306. The exception did not complain
connection problem, but an SQLException when creating table.
2.) the two databases are assuming user table are in different
location(which is a good feature). But if I wanted them all in the same db,
it should create wihtou problem as it has different table names than the
rest of the application. So pointing two db settings back into one db should
works.
Thanks for quick response.
-Zemian
On Jan 7, 2008 3:17 PM, Mick Knutson <[EMAIL PROTECTED]> wrote:
> 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
> ---
>
