Thanks, that worked, but I'm still confused on the syntax. I understand what table name means, but I don't understand what repository means. Does that have some meaning in mysql? Is there a write up someplace the explains? -Peter Serge Knystautas <[EMAIL PROTECTED]> wrote: Ah, the problem is how you're configuring those repositories (a product of another wonderful avalon error message).
The old James was using a library called Town that used a naming convention to get to a conf file, e.g., db://conf/mail-error.properties. The new version of James obviates that conf file and uses a new naming convention, namely db://[datasource]/[tablename]/[repository-name] So instead of db://conf/mail-error.properties, you'll want to use db://maildb/messages/error (or whatever you want that table and repository name to be). You can see for the inbox configuration in your conf file that it's using db://maildb/inbox (for the inboxes James uses the username as the repository name, so it's not specified in the repository URL). -- Serge Knystautas Loki Technologies - Unstoppable Websites http://www.lokitech.com/ Peter Kellner wrote: > Sorry for the sketch last email. I just downloaded from CVS, rebuild with build.bat, >copied in my modified config.xml and re-ran. It creates the tables >"inbox,lists,messages,users", then stack traces with the following error. I think it >is trying to create spool. I've also pasted the original email I'm referring to. In >addition, I put my config.xml at the bottom. > thanks, -Peter > ----------------------------------------------------- > I added some of my old notes to the JDBC spool repository, and that lead me > to spot a flaw that was pretty clearly causing the minute delays for > messages in the spool repository. That's been patched, so now messages > should leave shortly after entering.... if you've had this problem, I'd > appreciate you checking the next nightly build (or latest from CVS) and > letting me know if it doesn't. > > Serge Knystautas > Loki Technologies - Unstoppable Websites > http://www.lokitech.com/ > I added some of my old notes to the JDBC spool repository, and that lead me > to spot a flaw that was pretty clearly causing the minute delays for > messages in the spool repository. That's been patched, so now messages > should leave shortly after entering.... if you've had this problem, I'd > appreciate you checking the next nightly build (or latest from CVS) and > letting me know if it doesn't. > > ------------------------------------------------------------------------------------ > > > Application file:/C:/james_cvs/jakarta-james/dist/apps/james.sar uses a deprecat > ed packaging format. > James 2.0a3-cvs > org.apache.avalon.framework.component.ComponentException: Unable to provide Data > SourceComponent for conf > at org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSele > ctor.select(DefaultDataSourceSelector.java:144) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.avalon.phoenix.components.application.BlockInvocationHandl > er.invoke(BlockInvocationHandler.java:91) > at $Proxy2.select(Unknown Source) > at org.apache.james.mailrepository.JDBCMailRepository.initialize(JDBCMai > lRepository.java:194) > at org.apache.james.core.AvalonMailStore.select(AvalonMailStore.java:207 > ) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.avalon.phoenix.components.application.BlockInvocationHandl > er.invoke(BlockInvocationHandler.java:91) > at $Proxy3.select(Unknown Source) > at org.apache.james.transport.mailets.ToRepository.init(ToRepository.jav > a:50) > at org.apache.mailet.GenericMailet.init(GenericMailet.java:123) > at org.apache.james.transport.MailetLoader.getMailet(MailetLoader.java:5 > 8) > at org.apache.james.transport.JamesSpoolManager.initialize(JamesSpoolMan > ager.java:151) > at org.apache.avalon.phoenix.components.application.LifecycleHelper.star > tup(LifecycleHelper.java:199) > at org.apache.avalon.phoenix.components.application.DefaultApplication.r > unPhase(DefaultApplication.java:176) > at org.apache.avalon.phoenix.components.application.DefaultApplication.s > tart(DefaultApplication.java:88) > at org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(Def > aultKernel.java:122) > at org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplicat > ion(DefaultKernel.java:169) > at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy( > DefaultDeployer.java:166) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployF > ile(DefaultEmbeddor.java:467) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployF > ile(DefaultEmbeddor.java:461) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployF > iles(DefaultEmbeddor.java:449) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployD > efaultApplications(DefaultEmbeddor.java:439) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute > (DefaultEmbeddor.java:182) > at org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:115) > at org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:101) > > at org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:67) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:88) > at org.apache.avalon.phoenix.launcher.Main.main(Main.java:51) > org.apache.avalon.framework.component.ComponentException: Unable to provide Data > SourceComponent for conf > at org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSele > ctor.select(DefaultDataSourceSelector.java:144) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.avalon.phoenix.components.application.BlockInvocationHandl > er.invoke(BlockInvocationHandler.java:91) > at $Proxy2.select(Unknown Source) > at org.apache.james.mailrepository.JDBCMailRepository.initialize(JDBCMai > lRepository.java:194) > at org.apache.james.core.AvalonMailStore.select(AvalonMailStore.java:207 > ) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.avalon.phoenix.components.application.BlockInvocationHandl > er.invoke(BlockInvocationHandler.java:91) > at $Proxy3.select(Unknown Source) > at org.apache.james.transport.mailets.RemoteDelivery.init(RemoteDelivery > .java:101) > at org.apache.mailet.GenericMailet.init(GenericMailet.java:123) > at org.apache.james.transport.MailetLoader.getMailet(MailetLoader.java:5 > 8) > at org.apache.james.transport.JamesSpoolManager.initialize(JamesSpoolMan > ager.java:151) > at org.apache.avalon.phoenix.components.application.LifecycleHelper.star > tup(LifecycleHelper.java:199) > at org.apache.avalon.phoenix.components.application.DefaultApplication.r > unPhase(DefaultApplication.java:176) > at org.apache.avalon.phoenix.components.application.DefaultApplication.s > tart(DefaultApplication.java:88) > at org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(Def > aultKernel.java:122) > at org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplicat > ion(DefaultKernel.java:169) > at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy( > DefaultDeployer.java:166) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployF > ile(DefaultEmbeddor.java:467) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployF > ile(DefaultEmbeddor.java:461) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployF > iles(DefaultEmbeddor.java:449) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployD > efaultApplications(DefaultEmbeddor.java:439) > at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute > (DefaultEmbeddor.java:182) > at org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:115) > at org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:101) > at org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:67) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:88) > at org.apache.avalon.phoenix.launcher.Main.main(Main.java:51) > Started POP3 Server plain:110 > Started SMTP Server plain:25 > Started NNTP Server plain:119 > > > > > > > > README! > > This configuration file is designed to run without alteration, for simple > tests. > It assumes you have a DNS server on localhost and assigns a root pasword > of root. > > For production use, or in case the defaults do not suit you, the items > you are most likely to need to change are preceeded by a > CHECKME! or > CONFIRM? comment in the left > margin. > > This is $Revision: 1.19 $ > Committed on $Date: 2001/12/05 22:31:18 $ by: $Author: serge $ > --> > > > > > > Postmaster@localhost > > > > of James. > If autodetect is TRUE, James wil attempt to discover its own name AND use > any specified servernames. If autodetect is FALSE, James will use only > the specified servernames. By default, the servername 'localhost' is > specified. This can be removed, if required. --> > > > To override autodetected server names > uncomment this. --> > localhost > > > > > > enableForwarding="TRUE"/> > > > > > > > > type="MAIL"> > > > > > --> > > /" > - is the datasource name set up in the > database-connections block, below > - is the name of the table to store user inboxes in > The user name is used as for this repository config. > --> > > > type="MAIL"> > > > > > > > > > > > 10 > > > > org.apache.james.transport.mailets > > > org.apache.james.transport.matchers > > > > root is the first processor all mails enter --> > > > Important for spam prevention. --> > > > spam > > --> > > > > > > > class="ToProcessor"> > spam > Rejected - see http://www.mail-abuse.org/rbl/ > > > > class="ToProcessor"> > spam > Dialup - see http://www.mail-abuse.org/dul/ > > > > class="ToProcessor"> > spam > Open spam relay - see http://www.mail-abuse.org/rss/ > > > > > > > > local or remote delivery --> > > transport > > > > > failure conditions enter --> > > > > file://var/mail/error/ --> > db://conf/mail-error.properties > true > > > > spam, uncomment this > > > --> > > > as spam, uncomment this > > > --> > > > > processor for local or remote delivery --> > > > > > > > locally delivered, this is an invalid recipient --> > > error > > > > Anti-relay mailet: Add your network address here, > e.g. "RemoteAddrNotInNetwork=127.0.0.1, abc.de.*" > --> > > > this, you risk making your mail server an open relay point for > spammers . > NOTE 1: the order of matcher-mailets is important: it must come after > valid local recipients have been dealt with but before any attempt is > made to delivery the mail remotely. > NOTE 2: Add your own network, if you want to relay mail outwards > NOTE 3: If you use SMTP AUTH, you may want to comment this > so users who are on the road can still use the server --> > > spam > > > > spool, > using delay time to retry delivery and the maximum number of > retries --> > > file://var/mail/outgoing/ --> > db://conf/mail-outgoing.properties > 21600000 > 5 > > > > > as relaying or other problems will get sent. You can either log these, > bounce these, or just ignore them. --> > > > matcher/mailet > > > --> > > > spam, uncomment this > > > --> > > > as spam, uncomment this > > > --> > > > > file://var/mail/spam/ > > > > > > > > > 206.13.28.12 > put extra dns server address here --> > > false > > > > 4555 > uncomment this if you want to bind to a specific > inetaddress --> > TRUE uncomment this if you want to use TLS (SSL) > on this port --> > > > use to identify itself for example, in SMTP and POP3 greetings. If > autodetect is TRUE, James will attempt to discover its own name OR > use 'localhost'. If autodetect is FALSE, James will use the value > given OR 'localhost' --> > myMailServer > > > > > administrator accounts (cannot be blank) --> > > > > 60000 > > > > > 110 > 995 --> > > ie over SSL/TLS --> > uncomment this if you want to bind to a specific > inetaddress--> > TRUE uncomment this if you want to use TLS (SSL) > on this port --> > > > use to identify itself for example, in SMTP and POP3 greetings. If > autodetect is TRUE, James will attempt to discover its own name OR > use 'localhost'. If autodetect is FALSE, James will use the value > given OR 'localhost' --> > myMailServer > 120000 > > > > > 25 > uncomment this if you want to bind to a specific > inetaddress --> > TRUE uncomment this if you want to use TLS (SSL) > on this port --> > > > use to identify itself for example, in SMTP and POP3 greetings. If > autodetect is TRUE, James will attempt to discover its own name OR > use 'localhost'. If autodetect is FALSE, James will use the value > given OR 'localhost' --> > myMailServer > 360000 > > true uncomment this if you want > SMTP AUTH support. This is useful if you have users who need to use > the email server on the road, while not having your server act as an > open relay! --> > > true uncomment this if you want > to verify that the MAIL FROM: address is the same user that > authenticated. This prevents a user of your mail server from acting > as somebody else --> > > > in KBytes. The value defaults to 0, which means no limit. --> > 0 > > > > > > 119 > 563 --> > > ie over SSL/TLS --> > uncomment this if you want to bind to a specific > inetaddress--> > TRUE uncomment this if you want to use TLS (SSL) > on this port --> > > > use to identify itself for example, in SMTP and POP3 greetings. If > autodetect is TRUE, James will attempt to discover its own name OR > use 'localhost'. If autodetect is FALSE, James will use the value > given OR 'localhost' --> > myMailServer > 120000 > > > > > > false > > > > > false > file:///var/nntp/groups > file:///var/nntp/temp > file:///var/nntp/articleid > news.james.apache.org > > > org.apache.james.dev > org.apache.james.user > org.apache.avalon.dev > org.apache.avalon.user > > > > file:///var/nntp/spool > > 1 > > if it has nothing to do --> > 1000 > > > > > > > > > class="org.apache.james.mailrepository.AvalonMailRepository"> > > file > > > MAIL > > > > class="org.apache.james.mailrepository.AvalonSpoolRepository"> > > file > > > SPOOL > > > > > > class="org.apache.james.mailrepository.JDBCMailRepository"> > > db > > > MAIL > > > file://conf/sqlResources.xml > > > > class="org.apache.james.mailrepository.JDBCSpoolRepository"> > > db > > > SPOOL > > > file://conf/sqlResources.xml > > > > > class="org.apache.james.mailrepository.JDBCMailRepository"> > > dbfile > > > MAIL > > > file://conf/sqlResources.xml > file://var/dbmail > > > > class="org.apache.james.mailrepository.JDBCSpoolRepository"> > > dbfile > > > SPOOL > > > file://conf/sqlResources.xml > file://var/dbmail > > > > > > > are temporarily stored before being processed. > (ex. file://c:/james/spool/) --> > > > > > > > type="SPOOL"> > > > --> > > > > > type="SPOOL"> > > > > > > > > User repositories are required for the following purposes: > - hold information about Users of the James mail server > - hold lists of users for the listserv mailet > > Currently, 2 different storage options are available: > - file-based storage using Java serialisation > - database-backed storage > (Use of database or file-system is defined on a "per-repository" basis) > > Note: Two user repositories are required for default configuration: > LocalUsers - the users for whom you are providing POP3, NNTP, or > AUTH service > list-james - the users of the james@localhost mailiinglist > --> > > > Use these configurations to store user info in the filesystem --> > > > > > > >class="org.apache.james.userrepository.UsersFileRepository"> > > > > --> > > > > > >class="org.apache.james.userrepository.UsersFileRepository"> > > > --> > > > Use these configurations to store user info in a database. > Note: the element must refer to a connection configured > in the configuration section. --> > > > > > class="org.apache.james.userrepository.JamesUsersJdbcRepository" > destinationURL="db://maildb/users"> > file://conf/sqlResources.xml > > > > > class="org.apache.james.userrepository.ListUsersJdbcRepository" > destinationURL="db://maildb/lists/list-james"> > file://conf/sqlResources.xml > > > > > specified. Uses the default value from the sql definition file. --> > > > class="org.apache.james.userrepository.ListUsersJdbcRepository" > destinationURL="db://maildb/lists"> > file://conf/sqlResources.xml > > --> > > > > >class="org.apache.james.userrepository.DefaultUsersJdbcRepository" > destinationURL="db://maildb/DefaultUsers"> > file://conf/sqlResources.xml > > --> > > > > > > These connections are referred to by name elsewhere in the config file --> > > > > --> > > class="org.apache.james.util.mordred.JdbcDataSource"> > org.gjt.mm.mysql.Driver > jdbc:mysql://localhost/mail > root > mysql > > > class="org.apache.james.util.mordred.JdbcDataSource"> > com.inet.tds.TdsDriver > jdbc:inetdae7:127.0.0.1?database=James > sa_james > blahblah > > --> > > > > > NOTHING BELOW THIS SHOULD NEED CHANGING, > (unless you want secure sockets (TLS)) --> > > > > > > > file > > > OBJECT > > > SYNCHRONOUS > ASYNCHRONOUS > CACHE > > > > > file > > > STREAM > > > SYNCHRONOUS > ASYNCHRONOUS > CACHE > > > > > > > > > > class="org.apache.avalon.cornerstone.blocks.sockets.DefaultServerSocketFactory" /> > > > >class="org.apache.avalon.cornerstone.blocks.sockets.TLSServerSocketFactory"> > > conf/keystore > secret > JKS > TLS > SunX509 > false > > > --> > > > > > class="org.apache.avalon.cornerstone.blocks.sockets.DefaultSocketFactory" /> > > > > > > default > > > 5 > > > false > > 40 > > 20 > 20 > > > > > > > > > > > > > > Serge Knystautas wrote: > Can you expand by what you mean "spool error"? I don't remember the > message thread about this problem. -- To unsubscribe, e-mail: For additional commands, e-mail: -Peter Kellner
