Re: Problem using db store for the first time

[Brian Brewer]

Don't use localhost for your connect string - use the boxes local IP or 
127.0.0.1 and make sure you have a relevant entry in your database users 
table.  mySql has some problems with resolving localhost.  I don't 
remember the specifics, but I've had similar problems in the past. 

Brian Brewer

J Malcolm wrote:

I've been using file storage until now.  I'm attempting to move to db
storage.  So this is an initial bringup problem.  I'm getting the
following error:
ERROR   2004-04-01 23:16:02.258 [Phoenix.] (): Component named
"mailstore" failed to pass through the Initialization stage. (Reason:
org.apache.avalon.framework.component.ComponentException: Cannot find or
init repository).
Here are the relevant blocks in the config file:

  <mailstore>
     <repository
class="org.apache.james.mailrepository.JDBCMailRepository">
        <protocols>
           <protocol>db</protocol>
        </protocols>
        <types>
           <type>MAIL</type>
        </types>
        <config>
<sqlFile>file:///c:/james-2.1.3/apps/james/conf/sqlResources.xml</sqlFil
e>
        </config>
     </repository>
     <repository
class="org.apache.james.mailrepository.JDBCSpoolRepository">
        <protocols>
           <protocol>db</protocol>
        </protocols>
        <types>
           <type>SPOOL</type>
        </types>
        <config>
<sqlFile>file:///c:/james-2.1.3/apps/james/conf/sqlResources.xml</sqlFil
e>
        </config>
     </repository>
     <spoolRepository>
        <repository destinationURL="db://maildb/spool/spool"
type="SPOOL"/>
     </spoolRepository>
  </mailstore>
  <database-connections>
     <data-sources>
        <data-source name="maildb"
class="org.apache.james.util.mordred.JdbcDataSource">
           <driver>org.gjt.mm.mysql.Driver</driver>
<dburl>jdbc:mysql://localhost/mail?autoReconnect=true</dburl>
           <user>xxxxx</user>
           <password>xxxxxxxx</password>
           <max>40</max>
        </data-source>
     </data-sources>
  </database-connections>
========================================================================
==================
I created a db named "mail" in mysql.  It didn't appear from docs that I
have to create tables or anything.  

I tried renaming the data source and get the same error, which implies
to me it's not even getting that far.  But the error message implies
that it is.
Any ideas where I've gone wrong?  Any way to turn on high debug level in
phoenix (debug loglevel in mailstore doesn't yield any additional info).
One other question... if the url syntax is "db:<datasource>/<table>",
what does "db:/maildb/spool/spool" resolve to?  Is there a table created
named "spool/spool"
Thanks as always.

Jerry

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]