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:[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]
***** Users Store Log *****
12/02/03 09:36:32 INFO users-store: AvalonUsersStore init...
12/02/03 09:36:32 DEBUG users-store: Starting
org.apache.james.userrepository.UsersFileRepository
12/02/03 09:36:32 DEBUG users-store:
org.apache.james.userrepository.UsersFileRepository created in file://var/users/\
12/02/03 09:36:32 INFO users-store: UsersRepository LocalUsers started.
12/02/03 09:36:32 DEBUG users-store: Starting
org.apache.james.userrepository.ListUsersJdbcRepository
12/02/03 09:36:32 DEBUG users-store:
org.apache.james.userrepository.ListUsersJdbcRepository.compose()
12/02/03 09:36:32 DEBUG users-store:
org.apache.james.userrepository.ListUsersJdbcRepository.configure()
12/02/03 09:36:32 DEBUG users-store: Parsed URL: table = 'lists', key = 'ctiug'
12/02/03 09:36:32 DEBUG users-store:
org.apache.james.userrepository.ListUsersJdbcRepository.initialize()
12/02/03 09:36:32 DEBUG users-store: Reading SQL resources from file:
C:\james-2.1\apps\james\conf\sqlResources.xml, section
org.apache.james.userrepository.ListUsersJdbcRepository.
12/02/03 09:36:33 DEBUG users-store: Using table: lists
12/02/03 09:36:33 INFO users-store: UsersRepository ctiug started.
12/02/03 09:36:33 INFO users-store: AvalonUsersStore ...init
12/02/03 09:36:34 WARN users-store: No users repository called: citug
***** Spool Manager Log *****
12/02/03 09:38:37 DEBUG spoolmanager: ==== Begin processing mail
Mail1045060717134-1====
12/02/03 09:38:37 DEBUG spoolmanager: Processing Mail1045060717134-1 through root
12/02/03 09:38:37 DEBUG spoolmanager.root: Servicing mail: Mail1045060717134-1
12/02/03 09:38:37 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.All@100bac2
12/02/03 09:38:37 DEBUG spoolmanager.root: Servicing Mail1045060717134-1 by Postmaster
aliasing mailet
12/02/03 09:38:37 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.RelayLimit@e51b2c
12/02/03 09:38:37 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.InSpammerBlacklist@941db6
12/02/03 09:38:54 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.InSpammerBlacklist@1cd66ea
12/02/03 09:39:11 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.InSpammerBlacklist@1be16f5
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.CommandForListserv@d56b37
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.RecipientIs@171f189
12/02/03 09:39:28 DEBUG spoolmanager.root: Servicing Mail1045060717134-1 by
AvalonListserv Mailet
12/02/03 09:39:28 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.java: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(ExecutableRunnable.java:47)
at
org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:80)
12/02/03 09:39:28 ERROR spoolmanager: An error occurred processing Mail1045060717134-1
through root
12/02/03 09:39:28 ERROR spoolmanager: Result was error
12/02/03 09:39:28 DEBUG spoolmanager: Processing Mail1045060717134-1 through error
12/02/03 09:39:28 DEBUG spoolmanager.error: Servicing mail: Mail1045060717134-1
12/02/03 09:39:28 DEBUG spoolmanager.error: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.All@17cec96
12/02/03 09:39:28 DEBUG spoolmanager.error: Servicing Mail1045060717134-1 by
ToRepository Mailet
12/02/03 09:39:28 DEBUG spoolmanager.error: Checking Mail1045060717134-1 with
org.apache.james.transport.matchers.All@ae3364
12/02/03 09:39:28 DEBUG spoolmanager.error: Servicing Mail1045060717134-1 by
NotifyPostmaster Mailet
12/02/03 09:39:28 DEBUG spoolmanager.error: Checking Mail1045060717134-1 with
org.apache.james.transport.LinearProcessor$1@21e554
12/02/03 09:39:28 DEBUG spoolmanager.error: Servicing Mail1045060717134-1 by
Terminating%Mailet%Name
12/02/03 09:39:28 DEBUG spoolmanager: ProcessedMail1045060717134-1 through error
12/02/03 09:39:28 DEBUG spoolmanager: Result was ghost
12/02/03 09:39:28 DEBUG spoolmanager: ==== Begin processing mail
Mail1045060768806-3====
12/02/03 09:39:28 DEBUG spoolmanager: Processing Mail1045060768806-3 through root
12/02/03 09:39:28 DEBUG spoolmanager.root: Servicing mail: Mail1045060768806-3
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.All@100bac2
12/02/03 09:39:28 DEBUG spoolmanager.root: Servicing Mail1045060768806-3 by Postmaster
aliasing mailet
12/02/03 09:39:28 DEBUG spoolmanager: ==== Removed from spool mail
Mail1045060717134-1====
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.RelayLimit@e51b2c
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.InSpammerBlacklist@941db6
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.InSpammerBlacklist@1cd66ea
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.InSpammerBlacklist@1be16f5
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.CommandForListserv@d56b37
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.RecipientIs@171f189
12/02/03 09:39:28 DEBUG spoolmanager.root: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.All@c3014
12/02/03 09:39:28 DEBUG spoolmanager.root: Servicing Mail1045060768806-3 by
ToProcessor Mailet
12/02/03 09:39:28 DEBUG spoolmanager: ProcessedMail1045060768806-3 through root
12/02/03 09:39:28 DEBUG spoolmanager: Result was transport
12/02/03 09:39:28 DEBUG spoolmanager: ==== Begin processing mail
Mail1045060768806-3====
12/02/03 09:39:28 DEBUG spoolmanager: Processing Mail1045060768806-3 through transport
12/02/03 09:39:28 DEBUG spoolmanager.transport: Servicing mail: Mail1045060768806-3
12/02/03 09:39:28 DEBUG spoolmanager.transport: Checking Mail1045060768806-3 with
org.apache.james.transport.matchers.RecipientIsLocal@8046f4
12/02/03 09:39:28 DEBUG spoolmanager.transport: Servicing Mail1045060768806-3 by Local
Delivery Mailet
12/02/03 09:39:29 DEBUG spoolmanager: ProcessedMail1045060768806-3 through transport
12/02/03 09:39:29 DEBUG spoolmanager: Result was ghost
12/02/03 09:39:29 DEBUG spoolmanager: ==== Removed from spool mail
Mail1045060768806-3====
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
