fetchmail-friends
[Top] [All Lists]

Re: [fetchmail]MySQL Interaction?

2005-11-01 05:51:18
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 ...
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.....

[ ]' s






On 11/1/05, Tobias Meyer <tobias(_at_)apeiron(_dot_)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(_at_)apeiron(_dot_)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)

_______________________________________________
Fetchmail-friends mailing list
Fetchmail-friends(_at_)lists(_dot_)ccil(_dot_)org
http://lists.ccil.org/cgi-bin/mailman/listinfo/fetchmail-friends

<Prev in Thread] Current Thread [Next in Thread>