Hi Bing, The mails are stored in MESSAGE table and the users in JAMES_USER table. Both are linked via MEMBERSHIP table.
(in postgresql schema you defined in database.properties) Did you created your account before the first time and changed conf after that (for example enabling virtualhosting, or whatever) ? Since M1, we made some improvement on the user delete (for example, with M1, user mails are still present). This may be an issue that should be solved in M2. For now, if we can't find the cause, I don't see for now any other option than restart from a fresh database schema... Tks, Eric > Hi Eric, > > Yes I have checked the smtp log and got Successfully spooled... > message everytime. > > I'd like to know where the inboxes are physically located in my > postgresql database so I can take a peek. > > I have also deleted the account and recreated the same account, to no > avail. But a fresh new account worked. > > So... > > Bing > > > > > -------------------------------------------------- > From: "Eric Charles" <[email protected]> > Sent: Thursday, November 04, 2010 6:02 PM > To: "James Users List" <[email protected]> > Subject: Re: missing incoming mails > >> Hi Ran, >> >> That's strange. >> >> Did you change something in james conf before seeing that ? >> Are the smtp connection arriving to james when you send to that user >> (you would need to use netstat or wireshark equivalents) ? >> Are the mails in the database and only the fetch (pop/imap) does not >> work ? >> Can you double check the logs ? Sometimes, it's a single line that tells >> something... >> >> Tks, >> >> Eric >> >> >> On 4/11/2010 10:04, RanBing wrote: >>> Hi, >>> >>> James3 m2 trunk, with postgresql db repositories. >>> >>> All of the sudden, one of my accounts cannot receive any mails. The >>> logs looked fine. Other accounts worked OK. How shall I debug? >>> >>> Thanks >>> >>> Bing >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
