Much clearer now. Thanks a bunch. I may have a few more minor questions as I get into setting it up. But I think I understand it now.
Now, if I could just get someone to take a look at the james.apache.org web site and tell me why I can no longer download any version of James greater than 2.1.... ?????? Thanks again. Jerry -----Original Message----- From: Clive Tonge [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 10:16 AM To: James Users List Subject: Re: Listserver and Database in 2.2.0axx Scott Hamilton wrote: >On Wed, 17 Mar 2004 17:13, Clive Tonge wrote: > > >>How do I setup the user repository in the database?? Can I ? >> >> > > Yes I am doing this with 2.2.0a14 in $JAMES_HOME/app/james/conf > > this is two files james-listmanager.xml and james-liststores.xml > I'm guessing you've already edited james-listmanager.xml to get > the list work, now edit james-liststores.xml and add something like; > > <repository name="list-first" > class="org.apache.james.userrepository.ListUsersJdbcRepository" > destinationURL="db://maildb/lists/first"> > <sqlFile>file://conf/sqlResources.xml</sqlFile> > </repository> > > <repository name="list-second" > class="org.apache.james.userrepository.ListUsersJdbcRepository" > destinationURL="db://maildb/lists/second"> > <sqlFile>file://conf/sqlResources.xml</sqlFile> > </repository> > > I then have a table in the database called LISTS > just make the table definition out of the sqlResources.xml file > for your particular database vendor.... > > > Hope that helps > Scott. > > Scott, That has done the trick. I am not sure if it was creating the table in the database or fixing the syntax in the xml file or both that worked, but it is up and running now. Thank you, Clive --------------------------------------------------------------------- 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]
