You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com> on 2003/02/08 22:22:09 UTC
Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file
08/02/03 16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.java:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tableRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:80)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root
08/02/03 16:04:57 ERROR spoolmanager: Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
Noel,
Here are the relevant elements in the config.xml file.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost"
class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://ctiug/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Tuesday, February 11, 2003 1:56 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
I'd have to see all of the list related elements to see what's wrong
now. Apparently, you do have a list table that was written by the list
manager.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Tuesday, February 11, 2003 13:34
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Noel,
Okay I made the adjustment to my config.xml file and I am still
receiving the same error message. I did see the new table "lists" with
the columns listName, ListSubscriber. I have entries in there like:
listName listSubscriber
--------------------------
Ctiug rcarter@localhost
I have also, tried installing a newer build version of James with the
same configuration and also received the same error.
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 12:26 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
It isn't an incomplete record. It is the wrong record type. Based upon
your earlier messages, the entry in config.xml should be:
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
ListUsersJdbcRepository and JamesUsersJdbcRepository uses different
record types.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 12:10
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
The record comes from a user table called 'lists'. Is that an
incomplete record?
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 11:56 AM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
Noel,
Great news. That did it. Thanks for your help. It's always the little
things that mess ya up.
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Wednesday, February 12, 2003 12:39 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
> In the UserStore log I noticed something weird. It
> say that 'ctiug' user store does not exist.
Look again. The message is:
users-store: No users repository called: citug
c-I-T-u-g, instead of c-T-I-u-g. You have a spelling error in the
repositoryName element for the listserv mailet. It is spelled properly
for the repository and listserv manager configuration, but not for the
listserv, itself.
--- Noel
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost"
class="AvalonListserv">
<repositoryName>citug</repositoryName>
<!-- ^^^^^ oops - should be ctiug -->
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://ctiug/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
> In the UserStore log I noticed something weird. It
> say that 'ctiug' user store does not exist.
Look again. The message is:
users-store: No users repository called: citug
c-I-T-u-g, instead of c-T-I-u-g. You have a spelling error in the
repositoryName element for the listserv mailet. It is spelled properly for
the repository and listserv manager configuration, but not for the listserv,
itself.
--- Noel
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost"
class="AvalonListserv">
<repositoryName>citug</repositoryName>
<!-- ^^^^^ oops - should be ctiug -->
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://ctiug/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
Noel,
Here is the latest. I have run an SQL trace to see if anything shows up
on that end. I did see James, upon start-up, verify the 'lists' table
exist. When I send a mail to the list there is nothing in the SQL
trace. So, it appears the getMembers function does not even query the
database. I was thinking that it might be a column data type
conversion.
I have attached a file that contains debug information from the Spooler
and UserStore logs. In the UserStore log I noticed something weird. It
say that 'ctiug' user store does not exist. However, in my config.xml
the only reference to 'ctiug' is the list not any particular user
storage.
---
Robert
PS - I apologize about the last message having the certificate.
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Tuesday, February 11, 2003 1:56 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
I'd have to see all of the list related elements to see what's wrong
now. Apparently, you do have a list table that was written by the list
manager.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Tuesday, February 11, 2003 13:34
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Noel,
Okay I made the adjustment to my config.xml file and I am still
receiving the same error message. I did see the new table "lists" with
the columns listName, ListSubscriber. I have entries in there like:
listName listSubscriber
--------------------------
Ctiug rcarter@localhost
I have also, tried installing a newer build version of James with the
same configuration and also received the same error.
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 12:26 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
It isn't an incomplete record. It is the wrong record type. Based upon
your earlier messages, the entry in config.xml should be:
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
ListUsersJdbcRepository and JamesUsersJdbcRepository uses different
record types.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 12:10
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
The record comes from a user table called 'lists'. Is that an
incomplete record?
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 11:56 AM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
Robert,
I'd have to see all of the list related elements to see what's wrong now.
Apparently, you do have a list table that was written by the list manager.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Tuesday, February 11, 2003 13:34
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Noel,
Okay I made the adjustment to my config.xml file and I am still
receiving the same error message. I did see the new table "lists" with
the columns listName, ListSubscriber. I have entries in there like:
listName listSubscriber
--------------------------
Ctiug rcarter@localhost
I have also, tried installing a newer build version of James with the
same configuration and also received the same error.
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 12:26 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
It isn't an incomplete record. It is the wrong record type. Based upon
your earlier messages, the entry in config.xml should be:
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
ListUsersJdbcRepository and JamesUsersJdbcRepository uses different
record types.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 12:10
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
The record comes from a user table called 'lists'. Is that an
incomplete record?
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 11:56 AM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
Noel,
Okay I made the adjustment to my config.xml file and I am still
receiving the same error message. I did see the new table "lists" with
the columns listName, ListSubscriber. I have entries in there like:
listName listSubscriber
--------------------------
Ctiug rcarter@localhost
I have also, tried installing a newer build version of James with the
same configuration and also received the same error.
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 12:26 PM
To: James Users List
Subject: RE: Problems with Mail List Functionality
It isn't an incomplete record. It is the wrong record type. Based upon
your earlier messages, the entry in config.xml should be:
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
ListUsersJdbcRepository and JamesUsersJdbcRepository uses different
record types.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 12:10
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
The record comes from a user table called 'lists'. Is that an
incomplete record?
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 11:56 AM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
It isn't an incomplete record. It is the wrong record type. Based upon
your earlier messages, the entry in config.xml should be:
<repository name="ctiug"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/ctiug">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
ListUsersJdbcRepository and JamesUsersJdbcRepository uses different record
types.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 12:10
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
The record comes from a user table called 'lists'. Is that an
incomplete record?
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 11:56 AM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
The record comes from a user table called 'lists'. Is that an
incomplete record?
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Monday, February 10, 2003 11:56 AM
To: James Users List
Subject: RE: Problems with Mail List Functionality
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
Robert,
That is just a user database record. Where is the mailing list table?
There should be a table called lists, which has the list names and
subscriber addresses.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Monday, February 10, 2003 11:18
To: 'James Users List'
Subject: RE: Problems with Mail List Functionality
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
Thanks for all your help thus far. I configured a MS-SQL database and
made all the necessary adjustments in the config.xml file. However, I
am still receiving the same error message. In addition, my database has
the following record:
Username pwdHash pwdAlgorithm useForward
forwardDestination useAlias alias
------------------------------------------------------------------------
-----------------
rcarter@localhost hashinfo SHA 0 <NULL>
0 <NULL>
---
Robert
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
You just need to create the database and setup the entries in
config.xml. James will create and manage the tables. For James v3, we
may include an embedded database in the distribution to provide a SQL
database in all cases. Those of us who use MySQL or other real server
would simply change over, which we have to do today anyway. The benefit
would be for the ~50% of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only
useful for encrypting your messages amongst trading partners. Otherwise
it just creates more steps when replying to you, so please turn that off
when sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
Robert,
You just need to create the database and setup the entries in config.xml.
James will create and manage the tables. For James v3, we may include an
embedded database in the distribution to provide a SQL database in all
cases. Those of us who use MySQL or other real server would simply change
over, which we have to do today anyway. The benefit would be for the ~50%
of users who aren't using a database.
--- Noel
P.S. Please do not CC me on messages to the list. If I wanted that, I
would set my Reply-To field accordingly, as yours is (Reply-To:
<ro...@abs-consulting.com>). Also, an unverified signature is only useful
for encrypting your messages amongst trading partners. Otherwise it just
creates more steps when replying to you, so please turn that off when
sending to this list.
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
For now I am using localhost just to test and make sure that it works.
>From there I will migrate it to use our domain name and fetch from POP.
Right now I am implementing a list server with outlook 2002 and VB. I
have not tried the database option. I guess I could look into it. I
was looking for the fastest way to get it up an running. As far as the
database option, do I need to do any initial database creation? Or does
James have SQL/DDL to build the database?
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 8:43 PM
To: James-User Mailing List
Subject: RE: Problems with Mail List Functionality
Robert,
Are you really configuring your e-mail addresses @localhost? You won't
be able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
Robert,
Are you really configuring your e-mail addresses @localhost? You won't be
able to use it from any other box.
I've never used the file system repositories for lists. Have you tried
using the database?
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: noel@devtech.com
Subject: RE: Problems with Mail List Functionality
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Robert Carter (ABS, Inc.)" <ro...@abs-consulting.com>.
Yeah, I followed those instructions to get to where I am today. Here
are the relevant lines in my config.xml file: One more thing... I am
using Outlook express Client Version 6. I also use the JAMES Remote
Administrator to validate the user repository, i.e. check to see if
users exist in there. When I list the users it shows up as
'rcarter@locahost'.
<mailet match="CommandForListserv=ctiug@localhost"
class="AvalonListservManager">
<repositoryName>ctiug</repositoryName>
</mailet>
<mailet match="RecipientIs=ctiug@localhost" class="AvalonListserv">
<repositoryName>citug</repositoryName>
<membersonly> true </membersonly>
<attachmentsallowed> true </attachmentsallowed>
<replytolist> true </replytolist>
<subjectprefix>ctiug</subjectprefix>
</mailet>
<repository name="ctiug"
class="org.apache.james.userrepository.UsersFileRepository">
<destination URL="file://var/lists/ctiug/"/>
</repository>
-----Original Message-----
From: Noel J. Bergman [mailto:noel@devtech.com]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; robert@abs-consulting.com
Subject: RE: Problems with Mail List Functionality
Robert,
Looking over your stack trace, it appears that there is some problem
with your user repository. How are yours list relate elements
configured? Here are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find
this documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file 08/02/03
16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonLists
erv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListse
rv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.j
ava:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:
315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Execu
tabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.ja
va:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root 08/02/03 16:04:57 ERROR spoolmanager:
Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: Problems with Mail List Functionality
Posted by "Noel J. Bergman" <no...@devtech.com>.
Robert,
Looking over your stack trace, it appears that there is some problem with
your user repository. How are yours list relate elements configured? Here
are the elements that make up a list. In transport:
<mailet match="CommandForListserv=interests@my.org"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="RecipientIs=interests@my.org" class="AvalonListserv">
<repositoryName>list-interests</repositoryName>
<membersonly>true</membersonly>
<attachmentsallowed>true</attachmentsallowed>
<replytolist>true</replytolist>
<autobracket>false</autobracket>
<subjectprefix xml:space="preserve">[INTERESTS] </subjectprefix>
</mailet>
In the <users-store> element, there is a new child:
<repository name="list-interests"
class="org.apache.james.userrepository.ListUsersJdbcRepository"
destinationURL="db://maildb/lists/list-interests">
<sqlFile>file://conf/sqlResources.xml</sqlFile>
</repository>
That's it. I have a dozen or so, and they all work fine. You can find this
documented with more detail at:
http://james.apache.org/mailing_lists_2_1.html.
--- Noel
-----Original Message-----
From: Robert Carter (ABS, Inc.) [mailto:robert@abs-consulting.com]
Sent: Saturday, February 08, 2003 16:22
To: james-user@jakarta.apache.org
Subject: Problems with Mail List Functionality
Platform: Win2K, JRE 1.4.1_01, James 2.1
Problem: Following error message in the spoolmanager.log file
08/02/03 16:04:57 ERROR spoolmanager: Exception in processor <root>
java.lang.NullPointerException
at
org.apache.james.transport.mailets.AvalonListserv.getMembers(AvalonListserv.
java:132)
at
org.apache.james.transport.mailets.GenericListserv.service(GenericListserv.j
ava:156)
at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:
362)
at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:
385)
at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:315)
at
org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Executabl
eRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:8
0)
08/02/03 16:04:57 ERROR spoolmanager: An error occurred processing
Mail1044738268676-3 through root
08/02/03 16:04:57 ERROR spoolmanager: Result was error
What I did:
POP3 and SMTP works. Subscribing to the list server works. I get this
error message when I try to send to the list server.
I did some research in the mail list archives and there are some
messages concerning this error, but no solutions where posted. Thanks
for your time.
----
Robert Carter
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org