RE: Re[2]: James as a List Server

[Danny Angus <da...@thought.co.uk>]

sqlresources is in conf/

if you set up your MySQL database settings in config.xml like this (create
database Mail):

        <data-source name="maildb"

class="org.apache.avalon.excalibur.datasource.JdbcDataSource">
            <driver>org.gjt.mm.mysql.Driver</driver>
            <dburl>jdbc:mysql://127.0.0.1/Mail</dburl>
            <user>user</user>
            <password>pass</password>
        </data-source>


then you can use the db list repository

       <repository name="list-james"
 class="org.apache.james.userrepository.ListUsersJdbcRepository"
                   destinationURL="db://maildb/lists/list-james">
           <sqlFile>file://conf/sqlResources.xml</sqlFile>
       </repository>


James creates its own tables, so you don't need to worry about that, the
only heads up is that if a table exists and is not the right structure James
fails disgracefully with an endless loop of exceptions.

once you are using database for users and lists making a web based James
admin becomes as simple as writing a jsp/servlet application to administer
the db.


d.


> -----Original Message-----
> From: styb [mailto:scuba_styb@yahoo.com]
> Sent: Tuesday, November 27, 2001 4:52 PM
> To: James Users List
> Subject: Re[2]: James as a List Server
>
>
> Hello Mr. Angus,
>
> could u please give me more details about this one :
> >       <repository name="list-james"
> >
> > class="org.apache.james.userrepository.ListUsersJdbcRepository"
> >                   destinationURL="db://maildb/lists/list-james">
> >           <sqlFile>file://conf/sqlResources.xml</sqlFile>
> >       </repository>
>
> how does this work exactly? what does sqlResources.xml look like?
> im curious about using mysql server for our list server in james.
> can u guys share some example xml code?
> and if its possible to convert my current user list to mysql db,
> how do i go about it?
>
> currently im using the default config to store user list (in a
> directory)
> -----------------
>                     <mailet
> match="CommandForListserv=me@myhost.com" class="AvalonListservManager">
>                         <membersPath>
> file://../var/users/list-james/manila/</membersPath>
>                     </mailet>
>                     <mailet match="RecipientIs=me@myhost.com"
> class="AvalonListserv">
>                         <membersonly> false </membersonly>
>                         <attachmentsallowed> true </attachmentsallowed>
>                         <replytolist> true </replytolist>
>                         <membersPath>
> file://../var/users/list-james/manila/</membersPath>
>                         <subjectprefix>manila</subjectprefix>
>                     </mailet>
> ------------------
> and lastly, does anyone already implemented a web-based user
> administration? :) thanx!
>
> regards,
> Stephen
>
> Monday, November 26, 2001, 4:31:00 AM, you wrote:
>
> DA> Yes, this is the case, consider the mailing list server that
> ships with
> DA> james as a proof of concept, rather than a fully fledged
> listserve system.
>
> DA> There will be improvements with time, and alternative
> mechanisms, perhaps
> DA> you'd like to extend or replace the default offering and offer your
> DA> enhancenments for inclusion in the codebase... :-)
>
> DA> d.
>
> DA> -----Original Message-----
> DA> From: Michelle [mailto:michelle@greenleaf-family.com]
> DA> Sent: 26 November 2001 12:14
> DA> To: James Users List
> DA> Subject: Re: James as a List Server
>
>
> DA> Thanks much for this.  It's very helpful.
>
> DA> One last question --- does each mailing list need to be defined in the
> DA> configuration file (for the mailet list serving definitions)?  So for
> DA> example, if my lists are created dynamically, I would need to
> somehow update
> DA> the configuration file and restart JAMES?
>
> DA> Again, thanks.
>
> DA> ----- Original Message -----
> DA> From: "Danny Angus" <da...@thought.co.uk>
> DA> To: "James Users List" <ja...@jakarta.apache.org>
> DA> Sent: Thursday, November 22, 2001 5:05 AM
> DA> Subject: RE: James as a List Server
>
>
> >> the mailing list stuff that ships with James is a little
> basic, there are
> >> better implementations in development AFAIK.
> >>
> >> However the things you need to check are 1/ that you have a list-users
> >> repository set up in the User Storage block
> >>
> >> this example is for db storage:
> >>
> >>       <repository name="list-james"
> >>
> >> class="org.apache.james.userrepository.ListUsersJdbcRepository"
> >>                   destinationURL="db://maildb/lists/list-james">
> >>           <sqlFile>file://conf/sqlResources.xml</sqlFile>
> >>       </repository>
> >>
> >>
> >> and 2/ that you have some kind of listserv mailets configured in a
> >> processor, this is my testing one from the root processor
> (every bona-fide
> >> mail gets here)
> >>
> >> the first mailet detects mail having the the user portion of the
> >> list-address appended with -on or -off (in this example
> >> james-on@killerbees.co.uk, james-off@killerbees.co.uk)
> >> the commands will subscribe and unsubscribe you, there is no
> facility for
> >> moderating membership.
> >>
> >>          <mailet match="CommandForListserv=james@killerbees.co.uk"
> >>                   class="AvalonListservManager">
> >>             <repositoryName>list-james</repositoryName>
> >>           </mailet>
> >>
> >> this next mailet appears below the previous in the conf and is the one
> DA> which
> >> deals with the distribution of the mail
> >> the params should speak for themselves,
> >>
> >>           <mailet match="RecipientIs=james@killerbees.co.uk"
> >> class="AvalonListserv">
> >>             <membersonly> false </membersonly>
> >>             <attachmentsallowed> true </attachmentsallowed>
> >>             <replytolist> true </replytolist>
> >>             <repositoryName>list-james</repositoryName>
> >>             <subjectprefix>JamesList</subjectprefix>
> >>           </mailet>
> >>
> >>
> >>
> >>
> >>
> >>
> >> d.
> >>
> >>
> >>
> >> > -----Original Message-----
> >> > From: Michelle [mailto:michelle@greenleaf-family.com]
> >> > Sent: Wednesday, November 21, 2001 5:09 PM
> >> > To: james-user@jakarta.apache.org
> >> > Subject: James as a List Server
> >> >
> >> >
> >> > I am a wee bit fuzzy on configuring James as a list server.  I've
> >> > been through the documentation and the mail list but I cannot
> >> > find anything but a few small references that do not paint a
> >> > complete picture.
> >> >
> >> > Are there any configuration and usage instructions around, or
> >> > even an email in the mailing list that I missed?    I appreciate
> >> > the help.
> >> >
> >> > - Michelle
> >> >
> >>
> >>
> >> --
> >> To unsubscribe, e-mail:
> DA> <ma...@jakarta.apache.org>
> >> For additional commands, e-mail:
> DA> <ma...@jakarta.apache.org>
> >>
> >>
>
>
> DA> --
> DA> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
DA> For additional commands, e-mail:
<ma...@jakarta.apache.org>


DA> --
DA> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
DA> For additional commands, e-mail:
<ma...@jakarta.apache.org>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>