Hi Mohammad,

You can find the generated database schema here:
https://svn.apache.org/repos/asf/james/server/trunk/src/site/resources/images/database/james-database-schema-derby.png
(will  be on M2 web site,  with more info)

The users is in the JAMESUSER table.
Depending on your virtualHosting config, JAMESUSER.NAME is the email address (or the user part that must be completed with a domain).

The user has MAILBOXes via the SUBSCRIPTION table.

The email are in MESSAGE (belonging to a MAILBOX via MEMBERSHIP). You have to look in the HEADER table to get all the detailled infos (from, to, cc, bcc,...).

Tks,

Eric


On 14/11/2010 12:16, Mohammad Naghavi wrote:
Hi every body,
I installed and worked with james 3 m1 with a mysql backend. now what I
wanted to ask is to get as much information about db structure as possible.
for example I sent an email from server to itself using telnet and
I received the mail correctly but now I find no where in db that sender and
receiver's email address are stored! or what I need to know is how to add a
user directly in database?

Thanks in advance,
MN
________________________________________
PHP&  ASP .Net 3.5 web developer
Java&  C# desktop developer
www.mohamnag.com



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to