Re: Listserver and Database in 2.2.0axx

[Clive Tonge]

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]