You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by Michael Motet <mi...@motet.dk> on 2004/09/22 12:13:56 UTC
Create db tables when launching James.
Hi,
I am trying to setup some extra tables in the database.
I want to make a list of "allowed mail senders" (these are not necessary
users on the James mail server).
first thing is, that I want to make the table creation from the
sqlRessources.xml.
But it seems that I need to add some code to the JDBCMailRepository.java
- please correct me if I am wrong !?
so I want to create following table:
SenderList
senderID
senderName
senderMail
I then intend to make a mailet, that will validate sender with the list
in the database.
can anyone give a hint on how the code should be modified ? or if there
are other places/way of doing this ?
Thanks,
-Michael
------------------------------------------------------
This mail was sent through Jay.net: http://www.jay.net
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: Create db tables when launching James.
Posted by Vincenzo Gianferrari Pini <vi...@praxis.it>.
See http://portale.praxis.it/pub/james/readme.htm#_Toc39401031.
The code is in http://portale.praxis.it/pub/james/james-praxis.zip.
Vincenzo
Michael Motet wrote:
>Hi,
>
>I am trying to setup some extra tables in the database.
>
>I want to make a list of "allowed mail senders" (these are not necessary
>users on the James mail server).
>
>first thing is, that I want to make the table creation from the
>sqlRessources.xml.
>But it seems that I need to add some code to the JDBCMailRepository.java
>- please correct me if I am wrong !?
>
>so I want to create following table:
>
>SenderList
> senderID
> senderName
> senderMail
>
>I then intend to make a mailet, that will validate sender with the list
>in the database.
>
>can anyone give a hint on how the code should be modified ? or if there
>are other places/way of doing this ?
>
>
>Thanks,
>
>-Michael
>
>------------------------------------------------------
>This mail was sent through Jay.net: http://www.jay.net
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>For additional commands, e-mail: server-dev-help@james.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: inbox message order
Posted by Davide Frigerio <da...@wise-lab.it>.
Thanks, this is a problem if you are working in a webmail. Tipically
webmail doesn't maintain POP3 session so it's dangerous to call delete
of message that can change is id. There's no way to configure James to
mantain message id across session, I think that the best way is to set
id as message ordering arriaval.
Thanks
Davide Frigerio.
Noel J. Bergman wrote:
>>I'm seeing message with RETR 2 POP3 command, after new
>>messages have been recieved the RETR 2 command returns
>>a different messege , is this correct?
>>
>>
>
>POP3 only guarantees that the number will be constant for the duration of a
>single POP3 session.
>
> ---- Noel
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>For additional commands, e-mail: server-user-help@james.apache.org
>
>
>
>
--
========================
Davide Frigerio
Wise-Lab S.r.l.
http://www.wise-lab.it
http://www.wisemodel.com
========================
RE: inbox message order
Posted by "Noel J. Bergman" <no...@devtech.com>.
> I'm seeing message with RETR 2 POP3 command, after new
> messages have been recieved the RETR 2 command returns
> a different messege , is this correct?
POP3 only guarantees that the number will be constant for the duration of a
single POP3 session.
---- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
inbox message order
Posted by Davide Frigerio <da...@wise-lab.it>.
What about James inbox message order?
I noticed this problem in my James installation. I'm seeing message with
RETR 2 POP3 command, after new messages have been recieved the RETR 2
command returns a different messege , is this correct?
Thanks,
Davide Frigerio.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
inbox message order
Posted by Davide Frigerio <da...@wise-lab.it>.
What about James inbox message order?
I noticed this problem in my James installation. I'm seeing message with
RETR 2 POP3 command, after new messages have been recieved the RETR 2
command returns a different messege , is this correct?
Thanks,
Davide Frigerio.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
RE: Create db tables when launching James.
Posted by "Noel J. Bergman" <no...@devtech.com>.
> I am trying to setup some extra tables in the database.
At a very quick glance, it sounds as if you're on the right track. Just
look at how we handle our own tables.
--- Noel
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org