On 28/07/11 03:34, lee Chalupa wrote:
I can't find the emails in the database....
I'm using James 3.0. I've sent two emails from one user to another user both
users are setup

Did you add a domain before adding the users?
You must add users in the form [email protected] (example: [email protected])

as a James user.  I am expecting to see the content of the sent email in the
database.  Is this correct?

Yes, it should be there

There should be two rows in the James_Mail table right? But I don't see the
detail anywhere in the database.
But the email transmissions were successful.  So what's going on?  Where is
the body of the email being stored?


The SMTP transmission didn't show an error, but the mail processing may have put the mail in unknown user repository for example. I would check the domain and user creation, and look at what the log says (in james-server.log).

Thanks for your help.

Lee

On Wed, Jul 27, 2011 at 1:58 AM, Eric Charles<[email protected]>  wrote:

On 27/07/11 03:07, lee Chalupa wrote:

Thank you.  I'm now able to send and receive emails.


Cool!


  One more question.  I wanted all the data in the db.  Looks like the
application
is not storing the body of the email in the database.  I've checked the
xml
configuration
files. Can you give me some idea where to look for the problem?


With James 2.3, there was an option to have mail metadata in db, and mail
body on file.

With James 3.0, all is in the database.
You can view an outdated database schema on http://james.apache.org/**
server/3/dev-database-schema.**html<http://james.apache.org/server/3/dev-database-schema.html>
.
The mails content is in (JAMES_)MESSAGE.(MESSAGE_)**CONTENT column.


  When will a change be reflected in the application?  Do I just have to
restart the application or
do I need to recreate the database from scratch?


Sorry, not sure to understand the question.
When James is running, there is nothing to do around the database.
You can of course stop/start, and the persisted data will be used.

  Thanks again.

Lee

On Mon, Jul 25, 2011 at 3:29 AM, Eric Charles<[email protected]>   wrote:

  Hi Lee,


On 24/07/11 21:52, lee Chalupa wrote:

  Hello:

I have version 3.m3 of the james server running.  I've worked through
the
instructions
on the james website.  Seems to be working ok.


  Good news :)


  I have configured the application to put all of the data into a MySql

database.

Now I get to the part where I want to add some users.  In the past, I
would
use telnet on port 4555
to do this.  I can't seem to find that part of the application now.  I
think
I saw an email in google that
noted that it has been dropped in favor of JMX.  Can someone verify this
for
me?


  Yes, telnet is no more available.
You have to use a JMX client or use the james-cli.sh script.


  If I add users and domains via JMX, how will these objects get
persisted?



  Yes, in the JAMES_USER table.


  As you can probably tell, I'm lost.


I'm also confused about the virtualUserTable feature and using the User
table in the database.
Are these different names for the same thing?


  VirutalUserTable has been renamed to RecipientRewriteTable to better
reflect what it really des.


  Can I just add users to the User table? I would have to convert the

password
to the value the database
field is expecting.


  The password are hashed before being stored.
Via the JMX client, you simply have to use the plain password you want
for
the user.


  Any help would be appreciated.


Thanks

Lee



--
Eric Charles
http://about.echarles.net

------------------------------****----------------------------**
--**---------
To unsubscribe, e-mail: server-user-unsubscribe@james.****apache.org<
server-user-**[email protected]<[email protected]>

For additional commands, e-mail: [email protected].****org<
server-user-help@james.**apache.org<[email protected]>>





--
Eric Charles
http://about.echarles.net

------------------------------**------------------------------**---------
To unsubscribe, e-mail: 
server-user-unsubscribe@james.**apache.org<[email protected]>
For additional commands, e-mail: 
[email protected].**org<[email protected]>





--
Eric Charles
http://about.echarles.net

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

Reply via email to