-
15. Re: how to test POP3 in Outlook
I am using MySQL 5. I am out of the office right now but there's an option that I've checked in outlook something like delete after some days. Will this have an effect?
Yes, will have an affect. May be whats causing it, but depends how many days, and if sent recently, and dissappearing, then maybe time's are diff. on each box?
I will try to check it out on Monday. But I've been thinking about Jason's suggestion to remove security. I remember when I installed it it requires SSL when sending but there is no security when receiving POP3. I will try to reinstall it and remove the security.
if it requires SSL when sending, then you wouldnt have been able to authenticate as you did, when you showed/posted the telnet output.
Unless sending to you@domain.com, then it would be in allowed domain list, i think.
I have observed when I try the send/receive option in Outlook I can see the ff quick messages - Authenticating ... and then Disconnecting. I am not very familiar with this stuff so basically I don't know how to test it. I don't even know how to see the logs in Outlook.
I am using cheesey a$$ outlook express, but does job excellent, I think you can right click a "folder", and see where ot is storing it's data, it is something like "c:\doc* and set*\you\apllication data..."
you can then turn enhanced debug, within outlook express, for SMTP, then you can check the logs, they will be in that folder as refrenced by "folder"->properties
I would, definitely reinstall, it took me more than 25 times of reinstalling before i got it worked out, if you like, post screen shots of each screen and your settings, preferably in jpg or some compressed format, but if you cant do this, at the end of install it asks you if you want to create an install script, say yes, then post that file, it contains I believe all the settings associated with the install
I am using Outlook bec. most people use it but if I have the time I will try Mozilla. But I assume this shouldn't be a problem. Anyway, I appreciate all your help. Thanks and have a good weekend.
doh, that brings up a good point, I always test our mail server with outlook, must remember the "test cases", i.e. need to try diff. clients
probly not a problem, though andrew may think of a jira issue, related to outlook and m4, your not sending large files or attachments? didnt look like it from telnet, though outlook may have caused server to deleted them
you have a good weekend also! and good luck! -
16. Re: how to test POP3 in Outlook
Hi Jason,
I re-installed it and it seems to be working now. I have two different clients, one is Outlook Express and the other Mac OS Mail and it works. IMHO, I really (still) don't know what I'm doing. However, there is still the same observation, the MessageData gets deleted when the mail is fetched, but the other tables storeitemmetadata, paged_mail_store, paged_mail_store_pages still does not get deleted. My wild guess it must be the Jdbc driver cause I'm using MySQL 5, but I still have to check this out. Also, as you confirmed there is a problem when sending attachments but I do not have a through test with that. Just sending once mail with attachment and I cannot retrieve it. Also my remote mail does not work anymore but I guess I'll have to reinstall it again. Is there a source code somewhere where I can check out the SQL statements, which maybe I can test individually? We have some projects that makes use of blobs (but not intensive though) and so far I have not encountered problems. I've also noticed it creates blobs and not long blobs. Normally we use long blobs, but I guess you're using pages so I think it would not matter. Some problems we have encountered before was when blobs don't get completely flushed out and you get missing bytes. However, I'm not yet very familiar with hibernate so I can't guarantee anything - I guess you're using it for persistence right? Anyways, thanks a lot for your's and Andrews time in helping me out. If I find anything unusual (I'm sure) I'll post it. I have some other questions but I'll post it in another thread. Thanks!
Regards,
Elmo -
17. Re: how to test POP3 in Outlook
currently, JBCS does not clean up after itself, when a message is deleted, it is only removed from messagedata table, it is recommended, for now, to have a cron job, that cleans the other tables, there is code(sql) in forums that does this, or if you like, I can post what I am doing...
nice, so it sounds like it is working fine for you now, messagedata, should have message headers in it, if, and only if, the message has not been deleted by the mail client.
so nothing wrong with your driver, it is "natural" for this to happen.
I suck at hibernnate, and trying to learn(not trying very hard), so cant help with blobs vs. long blobs, one of the other guys, may be able to help!
Glad you got it working!