Jerry, Please include the actual exception trace when reporting errors like this, it would help diagnose your problem. Lacking that, here are some tips which may help you proceed:
- you do not need to edit the <sqlFile/> tags in the config.xml, the default relative paths work just fine. - test the JDBC connection using a tool like Squirrel http://squirrel-sql.sourceforge.net/ to ensure that the URL, username and password are correct. Cheers Steve > -----Original Message----- > From: J Malcolm [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 01, 2004 9:32 PM > To: James Users List > Subject: Problem using db store for the first time > > > 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.x > ml</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.x > ml</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]
