[fetchmail]MySQL Interaction?

Tue, 01 Nov 2005 14:17:08 +0100

Maginot Junior wrote:

>Sorry for not replying to the list, I just clicked on the reply in gmail...
>okay, this is how its working here:
>
>I have a domains and server configured with it that is my mail server.
>If you send a message to it Postfix receive it and store at
>/var/server/postfix/domain.com/user/Maildir/new not the usual mail
>system default /var/spool/mail ...
>  
>
Not relevant, fetchmail will not use those files.

>Okay. The message is on the server in the folder especified above. Now
>I want using thunderbird on my desktop that doesnt have static ip to
>connect to the POP3 or IMAP port on my server and retrieve the
>messages that are on the folder.
>The user "user" in this case, arent a user of the system, it is a user
>add on my mysql postfix table where postfix searchs for the users and
>their maildir location.
>What I need is something to fetch the mail from that folder searching
>all the information in mysql (maybe something else) because the
>password for that user and his maildir location is on a mysql table.
>For what I remember the user have to authentica on the pop server so
>it can get his messages and to prove that is truely him....
>
>The question is how I do this using Fetchmail, mayber some other app
>... mysql-pam? sasl2 ? I dont know.....
>
>  
>
If I understand you correctly, you will not need fetchmail at all.
What you need is a pop3 server. ( which will need all the information 
you mentioned above - but the fetchmail list is the wrong place to ask 
for help about that)
There is quite a few of them around - most propably also one that can 
interact with your mysql-postfix setup.

Fetchmail is for users who have one or more pop3 server accounts and 
want to collect the emails from there in another mailbox.
I, for example have a linux box at home that polls all my email 
accounts, scans for virusses and spam, and then places the mail in a 
mailbox on that server.
That mailbox I then access through imap or a web interface. I do so 
because I often work from different computers, and want to access my 
email from all of them.
If you only have one computer, you will live quite happily with just 
thunderbird.

>
>On 11/1/05, Tobias Meyer <tobias@apeiron.de> wrote:
>  
>
>>Please always reply to the list. That way others can participate in the
>>discussion.
>>
>>Back to the topic:
>>I'm not sure what exactly you want to do....
>>Fetchmail is for fetching mail from server A (pop3, imap) and delivering
>>it to server B.
>>I assume you are on (or near) server B.
>>
>>Of course that assumes that you have the username and password (or some
>>other way of authentication) for the mail account on server A.
>>Server B usually does not need authentication to deliver email TO some user.
>>
>>If I assume that you want fetchmail to get the mails from server B for
>>ALL your local users (stored in mysql some way or another), I regret to
>>tell you that there is no configuration option known to me to do so. ( I
>>would further assume, that the password is stored as MD5 or SHA1 hash in
>>your database, whereas fetchmail obviuosly needs a plaintext password -
>>what password is it supposed to use? ).
>>
>>Maybe you can describe a little better what you want to do?
>>
>>Cheers,
>>Tobias
>>
>>
>>Maginot Junior wrote:
>>
>>    
>>
>>>But when I make a POP3 or IMAP connections it doesnt searchs for the
>>>requesting user to authenticate??
>>>
>>>
>>>On 11/1/05, Tobias Meyer <tobias@apeiron.de> wrote:
>>>
>>>
>>>      
>>>
>>>>Maginot Junior wrote:
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>>>Hi everyone... Im new in the list so Helo!
>>>>>
>>>>>I was searching for some pop3 (imap?) fetcher and found by
>>>>>recommendation fetchmail the problem is that after reading inthe site
>>>>>what it is capable to do I didnt found anything about interaction with
>>>>>mysql.
>>>>>
>>>>>Im using Postfix+PopBeforeSMTP and wanted to use Fetchmail as my POP3
>>>>>fetcher... but Im using mysql to take care of the accounts and putting
>>>>>the files in /var/server/postifx/.../.../...
>>>>>
>>>>>So the questions is: FetchMail supports MySQL? Where I found some how-to?
>>>>>
>>>>>Thanks in advance
>>>>>[ ]'s
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>          
>>>>>
>>>>Fetchmail delivers to postfix, so it does not need to know anything
>>>>about where postfix get's its users from.
>>>>If you can send email to your postfix users, fetchmail will be able to
>>>>do so as well.
>>>>Fetchmail will not ever directly modify any of your mail servers files -
>>>>that is always a task for your MDA (postfix in your case)
>>>>
>>>>Hth,
>>>>Tobias
>>>>
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>--
>>>Maginot Júnior
>>>Florianópolis/SC - BR
>>>LPIC-1 Certified since 28/10/05
>>>Linux Professional Institute Certified - https://www.lpi.org/en/verify.html
>>>id: LPI000095352 ver: juswaj4mct
>>>http://linux.maginot.com.br (under development)
>>>
>>>
>>>      
>>>
>>    
>>
>
>
>--
>Maginot Júnior
>Florianópolis SC BR
>LPIC-1 Certified since 28/10/05
>Linux Professional Institute Certified - https://www.lpi.org/en/verify.html
>id: LPI000095352 ver: juswaj4mct
>http://linux.maginot.com.br (under development)
>  
>