It finally dawn on me, after some sleep last night, and a good, hot cup of coffee this morning, that your favorite database admin app would probably be Dabo; since, that's kind of your baby. My hat's off to you, and Ed, for all you have done in developing Dabo.
Anyway, I found an article yesterday that explained how to identify a roaming user using their email address. Each email address is unique with a domain name that resolves to a unique IP address, so this could be used to identify an incoming email by have Postfix examine the "From" header as trusted for relaying. The author did not recommend this solution, because it's not secure, but I could use this method temporarily for a couple of iPhones, until I had the time to implement something more secure, like sasl. Here is what I've done to implement the temporary fix: I create a "/etc/postfix/sender_access" file with the following content: [email protected] OK [email protected] OK Then I made the .db file as follows: postmap hash:/etc/postfix/sender_access This created the "/etc/postfix/sender_access.db" file. Next, I entered the following into my main.cf file: smtpd_recipient_restrictions = check_sender_access hash:/etc/postfix/sender_access Then I restarted postfix: service postfix restart postfix reload I then created an email going to my gmail account, and sent it using my outgoing SMTP server, (eg mail.smvfp.com). The progress bar started, but then stopped, after only moving about 10% of the way. The iPhone continued in this state for some time, after which it reported the email could not be sent and was being placed in the outbox. Any points on why this is not working for me? My gmail account relays fine, but moving my wife's email over to it might be a problem. She currently has over 1,500 email in her INBOX, with lots of picture and video attachments. Over 700 of her INBOX emails have never been read. She claim the unread email is junk/spam, but she refuses to throw them away, (eg delete them). I don't press her on the issue; because, throwing anything away for her is very distrubing. Gmail allows a generous amount of space, but I'm not sure gmail is ready for my wife, Peggy. LOL BTW, does anyone know if it's possible to connect a desktop email client like Thunderbire to a gmail account? http://www.informit.com/articles/article.aspx?p=24672&seqNum=4 Regards, LelandJ On 02/03/2010 07:02 PM, Paul McNett wrote: > On 2/3/10 4:07 PM, Leland Jackson wrote: > >> that hold the email users. It kind of hard working with the dbmail >> database, because there a lots of table and the creator of the system >> has normalzed everything to the extreme, (eg an email is spread over >> many tables all normalized), so to see the entire email you need to join >> many tables together parent/child keys. >> > Sounds like a perfect opportunity for an admin app... > > Paul > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
