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 as a James user. I am expecting to see the content of the sent email in the database. Is this correct? 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?
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]> > >
