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]