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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 11:49 PM
To: James Users List; [EMAIL PROTECTED]
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:
<[EMAIL PROTECTED]>). 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:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 22:58
To: 'James Users List'
Cc: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 18:24
To: 'James Users List'
Cc: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 5:14 PM
To: James Users List; [EMAIL PROTECTED]
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="[EMAIL PROTECTED]"
class="AvalonListservManager">
<repositoryName>list-interests</repositoryName>
</mailet>
<mailet match="[EMAIL PROTECTED]" 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:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 16:22
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
smime.p7s
Description: application/pkcs7-signature
