Hi Danny,
It looks like my problem has morphed. Now, when I send the message it is
getting queued in the outgoing directory. I think it may have to do with my
DNS setup(i haven't been able to get anyone at my ISP to respond yet), so
please forgive me if this is just a stupid mistake.
I'm definately trying to have a user account and a user, but lord only knows
if I've configured it properly. :) I created a user account via the telnet
interface and I've enabled the JDBCVirtualUserTable in config.xml:
<processor name="transport">
<mailet match="All" class="JDBCVirtualUserTable">
<table>db://maildb/email_alias</table>
<sqlquery>
select email_alias.destination_address
from email_alias, email_alias as VUTDomains
where (email_alias.user like ? or email_alias.user like "\%") and
(email_alias.domain like ? or
(email_alias.domain like "\%" and VUTDomains.domain like ?))
order by concat(email_alias.user,'@',email_alias.domain) desc
limit 1
</sqlquery>
</mailet>
...
</processor>
It appears that in all my fiddling I forgot to fill in the virtual user
table after I destroyed and recreated it last time. In the database I _now_
have (exported as xml):
<email_alias>
<row>
<id>1</id>
<destination_address>kmail</destination_address>
<user>kenny</user>
<domain>hedwig.journalscape.com</domain>
</row>
</email_alias>
Here is what is showing up in the log:
25/10/02 10:18:00 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566220143-21-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:18:00 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:18:00 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566220143-21-to-localhost) sent successfully to localhost
25/10/02 10:18:01 INFO smtpserver: Connection from 192.168.0.3
(192.168.0.3)
25/10/02 10:19:00 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566280570-23-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:19:00 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:19:01 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566280570-23-to-localhost) sent successfully to localhost
25/10/02 10:20:01 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566282793-27-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:20:01 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:20:01 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566282793-27-to-localhost) sent successfully to localhost
25/10/02 10:21:01 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566401397-31-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:21:01 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:21:01 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566401397-31-to-localhost) sent successfully to localhost
25/10/02 10:22:02 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566340978-29-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:22:02 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:22:02 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566340978-29-to-localhost) sent successfully to localhost
25/10/02 10:23:02 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566461773-33-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:23:02 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:23:02 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566461773-33-to-localhost) sent successfully to localhost
25/10/02 10:24:03 INFO James.Mailet: RemoteDelivery: Attempting delivery of
Mail1035566522310-35-to-localhost to host localhost to [kmail@localhost]
25/10/02 10:24:03 INFO smtpserver: Connection from localhost.localdomain
(127.0.0.1)
25/10/02 10:24:03 INFO James.Mailet: RemoteDelivery: Mail
(Mail1035566522310-35-to-localhost) sent successfully to localhost
Thanks for any help or pointers to where I can research my problem,
Kenny Smith
JournalScape.com
> -----Original Message-----
> From: Danny Angus [mailto:danny@;apache.org]
> Sent: Friday, October 25, 2002 9:57 AM
> To: James Users List
> Subject: RE: Newbie Setup Question
>
>
> Shoudl at least deliver local mail as it is, it works for me,
> youve got the servername, and a user account for the user I take it?
>
> d.
>
> > -----Original Message-----
> > From: Kenny Smith [mailto:kenny@;journalscape.com]
> > Sent: 25 October 2002 17:37
> > To: James Users List
> > Subject: RE: Newbie Setup Question
> >
> >
> > Hi Danny,
> >
> > Yes, I'm using 2.1a1 and I updated my code this morning and
> rebuilt. As to
> > which Matcher is getting hit, I tailed the default.log and all that was
> > logged during me sending the mail was:
> >
> > 25/10/02 09:23:55 INFO smtpserver: Connection from 192.168.0.3
> > (192.168.0.3)
> > 25/10/02 09:23:58 INFO James.Mailet: ToRepository: Storing mail
> > Mail1035563037449-1 in file://var/mail/error/
> >
> > I'm in the process of figuring out how to upgrade Phoenix to
> fix the known
> > bug Noel mentioned.
> >
> > Kenny Smith
> > JournalScape.com
> >
> > > -----Original Message-----
> > > From: Danny Angus [mailto:danny@;apache.org]
> > > Sent: Friday, October 25, 2002 9:15 AM
> > > To: James Users List
> > > Subject: RE: Newbie Setup Question
> > >
> > >
> > > no, logging is all going into default log at the moment owing to
> > > an Avalon bug we're blocked by.
> > > Logging is controlled by environment.xml in SAR-INF/ (youre using
> > > 2.1a1 right?)
> > >
> > > > -----Original Message-----
> > > > From: Kenny Smith [mailto:kenny@;journalscape.com]
> > > > Sent: 25 October 2002 16:46
> > > > To: James Users List
> > > > Subject: RE: Newbie Setup Question
> > > >
> > > >
> > > > Hi Noel,
> > > >
> > > > I've got the fully qualified... >hedwig.journalscape.com<.
> > > >
> > > > As for debug.log, I can't find it anywhere, my apps/james/logs/
> > > directory
> > > > has plenty of log files (but not debug.log), but the only
> > > non-zero length
> > > > one is default.log. Is there something in the config.xml that
> > I need to
> > > > change to turn debugging on?
> > > >
> > > > Thanks,
> > > > Kenny Smith
> > > > JournalScape.com
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Noel J. Bergman [mailto:noel@;devtech.com]
> > > > > Sent: Friday, October 25, 2002 1:59 AM
> > > > > To: James Users List
> > > > > Subject: RE: Newbie Setup Question
> > > > >
> > > > >
> > > > > Kenny,
> > > > >
> > > > > do you have
> > > > >
> > > > > <servername>hedwig</servername>
> > > > >
> > > > > or
> > > > >
> > > > > <servername>hedwig.journalscape.com</servername>
> > > > >
> > > > > in config.xml? Also, check debug.log for the sequence of
> > > matchers that
> > > > > preceed the ToRepository. The one immediately prior to the
> > > > > ToRepository is
> > > > > the one that matched.
> > > > >
> > > > > --- Noel
> > > > >
> > > > > -----Original Message-----
> > > > > From: Kenny Smith [mailto:kenny@;journalscape.com]
> > > > > Sent: Friday, October 25, 2002 4:41
> > > > > To: James Users List
> > > > > Subject: RE: Newbie Setup Question
> > > > >
> > > > >
> > > > > Hi Noel,
> > > > >
> > > > > Thanks, I've got hedwig in the servers list, and I am running
> > > > Phoenix 4.0.
> > > > > I'll go try to figure out how to upgrade that bit. :)
> > > > >
> > > > > Thanks!
> > > > > Kenny
> > > > >
> > > > > > Make sure that hedwig.journalscape.come is in the
> <servers> list.
> > > > > >
> > > > > > Sounds as if you're running with Phoenix 4.0. Known bug in
> > > > Phoenix that
> > > > > > they have fixed.
> > > > > >
> > > > > > --- Noel
> > > > >
> > > > >
> > > > > --
> > > > > To unsubscribe, e-mail:
> > > > > <mailto:james-user-unsubscribe@;jakarta.apache.org>
> > > > > For additional commands, e-mail:
> > > > > <mailto:james-user-help@;jakarta.apache.org>
> > > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe, e-mail:
> > > <mailto:james-user-unsubscribe@;jakarta.apache.org>
> > > For additional commands, e-mail:
> > > <mailto:james-user-help@;jakarta.apache.org>
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > > <mailto:james-user-unsubscribe@;jakarta.apache.org>
> > > For additional commands, e-mail:
> > > <mailto:james-user-help@;jakarta.apache.org>
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:james-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:james-user-help@;jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:james-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:james-user-help@;jakarta.apache.org>
>
--
To unsubscribe, e-mail: <mailto:james-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:james-user-help@;jakarta.apache.org>
