You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Clive Tonge <cv...@sympatico.ca> on 2004/03/17 07:13:26 UTC
Listserver and Database in 2.2.0axx
I finally have the listserver working in version 2.2.0a13
Note to others: If you are having problems with listserve - check and
double check the list names and the repository names in your
configuration files.
While it is up and running I would like to be using it with the database
as the user repository. There isn't a sample of that in
james-liststores.xml. I did try the sample from the documentation for
version 2.13 but that didn't work.
How do I setup the user repository in the database?? Can I ?
Thanks for the help.
Clive
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
RE: Listserver and Database in 2.2.0axx
Posted by J Malcolm <te...@malcolms.com>.
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:cvt.news@sympatico.ca]
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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: Listserver and Database in 2.2.0axx
Posted by Clive Tonge <cv...@sympatico.ca>.
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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: Listserver and Database in 2.2.0axx
Posted by Scott Hamilton <sc...@det.nsw.edu.au>.
On Wed, 17 Mar 2004 17:13, Clive Tonge wrote:
> I finally have the listserver working in version 2.2.0a13
>
> Note to others: If you are having problems with listserve - check and
> double check the list names and the repository names in your
> configuration files.
>
> While it is up and running I would like to be using it with the database
> as the user repository. There isn't a sample of that in
> james-liststores.xml. I did try the sample from the documentation for
> version 2.13 but that didn't work.
>
> 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.
>
> Thanks for the help.
> Clive
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
**********************************************************************
This message is intended for the addressee named and may contain
privileged information or confidential information or both. If you
are not the intended recipient please delete it and notify the sender.
**********************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org