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 Rod TuK <ro...@hotmail.com> on 2001/05/03 16:33:49 UTC
Database setup
hi,
I successfully setup the DB (mySql) for Users and I am trying to do the
same for message and spool. Can someone tell me the Table definition for the
table "Message"? I am interested on the column type also for
"message_name","remote_host", etc.
Also, can someone point me to the correct direction for setting up lists? I
understand it is pointed as default to list-james directory, but how should
we setup files under it?
Thanks
Rod~
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: James and Jetspeed
Posted by sbelt <sb...@velos.com>.
yes, i have successfully setup this combination. Look in the James mail
archive - I posted a hint where I found that James was looking at the from:
address and put the emails into the spam folder. The
jetspeedresources.properties mail settings need to match James'
allowed-domains settings. Again, please see my email in the James archive
for what the settings were.
Steve B.
----- Original Message -----
From: "scott" <sc...@internetvillages.net>
To: <ja...@jakarta.apache.org>
Sent: Wednesday, May 09, 2001 3:21 AM
Subject: Re: James and Jetspeed
> Hi
>
> Any combined experience of Jetspeed and James mail here?
>
> I already successful setup the James mail and running. local pop and smtp
is
> working.
>
> As for Jetspeed. I would like to add a new user. But the the user didnot
> receive any ket confirmation mail sent out by the Jetspeed. Any
> configuration at Jetspeed I need to set?
>
> Thanks
>
> -Scott
> ----- Original Message -----
> From: Oki DZ <ok...@bdg.pindad.com>
> To: <ja...@jakarta.apache.org>
> Sent: Tuesday, May 08, 2001 8:52 AM
> Subject: Re: Database setup
>
>
> > Rod TuK wrote:
> > >
> > > hi,
> > > I successfully setup the DB (mySql) for Users and I am trying to do
> the
> > > same for message and spool. Can someone tell me the Table definition
for
> the
> > > table "Message"? I am interested on the column type also for
> > > "message_name","remote_host", etc.
> >
> > It's in the docs directory, anyway:
> >
> > CREATE TABLE Message (
> > message_name varchar (200) NOT NULL PRIMARY KEY,
> > repository_name varchar (200) NOT NULL ,
> > message_state varchar (30) NOT NULL ,
> > error_message varchar (200) NULL ,
> > sender varchar (100) NOT NULL ,
> > recipients text NOT NULL ,
> > remote_host varchar (100) NOT NULL ,
> > remote_addr varchar (20) NOT NULL ,
> > message_body longblob NOT NULL ,
> > last_updated datetime NOT NULL
> > );
> >
> > BTW, in the repository_name, users' mailboxes are identified as
> > "inbox/username". I think it would be better if the ident is
> > username/inbox. So that if IMAP were implemented on James, users'
> > repositories could be identified as username/inbox, username/mybox,
> > username/james-list, etc. I believe that the database server will search
> > the records much faster (mail clients are identified by usernames first
> > and then on what mailboxes they have; being the usernames located in the
> > beginning of the strings, the search should be faster).
> >
> > Oki
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: james-user-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: James and Jetspeed
Posted by scott <sc...@internetvillages.net>.
Hi
Any combined experience of Jetspeed and James mail here?
I already successful setup the James mail and running. local pop and smtp is
working.
As for Jetspeed. I would like to add a new user. But the the user didnot
receive any ket confirmation mail sent out by the Jetspeed. Any
configuration at Jetspeed I need to set?
Thanks
-Scott
----- Original Message -----
From: Oki DZ <ok...@bdg.pindad.com>
To: <ja...@jakarta.apache.org>
Sent: Tuesday, May 08, 2001 8:52 AM
Subject: Re: Database setup
> Rod TuK wrote:
> >
> > hi,
> > I successfully setup the DB (mySql) for Users and I am trying to do
the
> > same for message and spool. Can someone tell me the Table definition for
the
> > table "Message"? I am interested on the column type also for
> > "message_name","remote_host", etc.
>
> It's in the docs directory, anyway:
>
> CREATE TABLE Message (
> message_name varchar (200) NOT NULL PRIMARY KEY,
> repository_name varchar (200) NOT NULL ,
> message_state varchar (30) NOT NULL ,
> error_message varchar (200) NULL ,
> sender varchar (100) NOT NULL ,
> recipients text NOT NULL ,
> remote_host varchar (100) NOT NULL ,
> remote_addr varchar (20) NOT NULL ,
> message_body longblob NOT NULL ,
> last_updated datetime NOT NULL
> );
>
> BTW, in the repository_name, users' mailboxes are identified as
> "inbox/username". I think it would be better if the ident is
> username/inbox. So that if IMAP were implemented on James, users'
> repositories could be identified as username/inbox, username/mybox,
> username/james-list, etc. I believe that the database server will search
> the records much faster (mail clients are identified by usernames first
> and then on what mailboxes they have; being the usernames located in the
> beginning of the strings, the search should be faster).
>
> Oki
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: Database setup
Posted by Oki DZ <ok...@bdg.pindad.com>.
Rod TuK wrote:
>
> hi,
> I successfully setup the DB (mySql) for Users and I am trying to do the
> same for message and spool. Can someone tell me the Table definition for the
> table "Message"? I am interested on the column type also for
> "message_name","remote_host", etc.
It's in the docs directory, anyway:
CREATE TABLE Message (
message_name varchar (200) NOT NULL PRIMARY KEY,
repository_name varchar (200) NOT NULL ,
message_state varchar (30) NOT NULL ,
error_message varchar (200) NULL ,
sender varchar (100) NOT NULL ,
recipients text NOT NULL ,
remote_host varchar (100) NOT NULL ,
remote_addr varchar (20) NOT NULL ,
message_body longblob NOT NULL ,
last_updated datetime NOT NULL
);
BTW, in the repository_name, users' mailboxes are identified as
"inbox/username". I think it would be better if the ident is
username/inbox. So that if IMAP were implemented on James, users'
repositories could be identified as username/inbox, username/mybox,
username/james-list, etc. I believe that the database server will search
the records much faster (mail clients are identified by usernames first
and then on what mailboxes they have; being the usernames located in the
beginning of the strings, the search should be faster).
Oki
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org