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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]