Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Ed W
On 22/04/2010 17:18, Phil Howard wrote: I have not been following this thread as closely as I probably should have; however, I was wondering what the OP's problem was with using MySQL? It would greatly simplify the job of constructing and maintaining databases. It is even possible to create tab

Re: [Dovecot] Expire plugin

2010-04-23 Thread Steffen Kaiser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 22 Apr 2010, Thomas M Goerger wrote: expires table when I look. Is there anywhere that expire can log to so I can see what might be happening? It doesn't look like it logs to the Did you checked that the plugin is loaded at all? Regards

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Ed W
P.S. The "idiot" who kept breaking the plain text format file in my original setup was da da ... me ... So given I think of myself as reasonably technical, I would claim that text format "databases" are way more fragile than you might expect (good luck getting a non technical user not

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-23 Thread Gábor Lénárt
On Wed, Apr 21, 2010 at 01:45:35PM -0400, Phil Howard wrote: > > Then I think MySQL will do the job. Both postfix and dovecot support MySQL, > > and you can use SASL to authenticate SMTP with Dovecot, so Dovecot would do > > all the auth work. Finally, you could use Postfix's VDA patch if you want

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-23 Thread Ed W
On 23/04/2010 10:30, Gábor Lénárt wrote: On Wed, Apr 21, 2010 at 01:45:35PM -0400, Phil Howard wrote: Then I think MySQL will do the job. Both postfix and dovecot support MySQL, and you can use SASL to authenticate SMTP with Dovecot, so Dovecot would do all the auth work. Finally, you could

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-23 Thread Phil Howard
On Fri, Apr 23, 2010 at 2:49 AM, Rainer Frey wrote: > On Thursday 22 April 2010 18:15:18 Phil Howard wrote: > [ ... all standard stuff that is well documented ... ] > > > 5. Passwords stored encrypted, such as MD5. And it should be a scheme > > that both Postfix and Dovecot can use so I don't h

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Phil Howard
On Fri, Apr 23, 2010 at 3:45 AM, Ed W wrote: You need to look at where you are going with this One way or another you > need a database - call it a banana if you prefer, but it's still a database > whether it's a flat file or a BDB file or whatever > One must be careful with the term "databa

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Phil Howard
On Fri, Apr 23, 2010 at 5:23 AM, Ed W wrote: > P.S. The "idiot" who kept breaking the plain text format file in my > original setup was da da ... me ... So given I think of myself as > reasonably technical, I would claim that text format "databases" are way > more fragile than you might exp

[Dovecot] order of variable modifiers

2010-04-23 Thread Phil Howard
I'd like to have a variable substitute take the domain name part, lower case it, MD5 it, and take a 2-character substring of that. Would that be like %2MLd ? The documentation on the H hash modifier described reversing with R, but expresses it at %3RHu which seems to me like it would be reversing

[Dovecot] have I been added to the mailing list

2010-04-23 Thread ttplayer
Hi, have I been added to the mailing list? Thank you.

Re: [Dovecot] Expire plugin

2010-04-23 Thread Thomas M Goerger
Yes, the plugin is loading. The libraries associated are being touched upon user login, so it looks like expire is running. Just that nothing is being added to the database upon a user putting something into the Trash. We do have our mail not in root of a user folder, but in mail/. So, I added m

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Jerry
On Fri, 23 Apr 2010 09:03:02 -0400 Phil articulated: > You rsync the files an SQL database (like MySQL) works from, and don't > expect corruption? That's only safe if the database is synced and > shut down. I don't want to be doing that. If I did run a database > engine, it would have to impor

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Ed W
On 23/04/2010 15:51, Jerry wrote: There are numerous ways to export/backup a live MySQL database. I have employed several of them myself. You might want to check out this URL for starters: http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html Your statement t

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Jerry
On Fri, 23 Apr 2010 16:07:20 +0100 Ed articulated: > Err to be fair, I was about to reply and say that it's IS achievable, > but on the flip side I would concede that it does require a bit of > thought to make this stuff work correctly. I think you are being a > bit harsh to suggest it's *that

Re: [Dovecot] Expire plugin

2010-04-23 Thread Thomas M Goerger
I do now see on the console: Apr 22 16:56:14 mars.tc.umn.edu imap(testg019): : net_connect_unix(/var/opt/dovecot/run/dovecot/dict-server) failed: Connection refused I owned this file to mysql:mysql now, and the error has gone away on subsequent logins, but I still don't see anything in the db.

[Dovecot] How can I make dovecot aware of user's email aliases?

2010-04-23 Thread Ian P. Christian
Sieve will not reply to mail it doesn't think was sent directly to a user. I use an SQL auth backend, and a user might login as us...@domain.com. What method can I use to inform dovecot that us...@domain.com is a forward to us...@domain.com, such that the vacation auto response will fire when us.

[Dovecot] Anyone successfully using expire plugin?

2010-04-23 Thread Thomas M Goerger
Anyone out there using expire? At this point, I'm not sure that it's even running. It was touching the plugin libraries yesterday, but doesn't appear to be doing so today. The plugin directory wasn't explictly set, so I've done so now, but it's still not touching these. Anyone have a cf file I

Re: [Dovecot] Anyone successfully using expire plugin?

2010-04-23 Thread Rainer Weikusat
Thomas M Goerger writes: > Anyone out there using expire? At this point, I'm not sure that it's even > running. It was touching the plugin libraries yesterday, but doesn't > appear to be doing so today. The plugin directory wasn't explictly set, > so I've done so now, but it's still not touchin

Re: [Dovecot] Expire plugin

2010-04-23 Thread Thomas M Goerger
Actually, this is where the problem is coming in. We'd switched the server from using IMAPS to IMAP, and I'd neglected to change the folder location. So, now using the mail/Trash folder, I'm again seeing the permission denied. We'd determined that the dict-server socket that was being used was a

[Dovecot] What causes dovecot to rebuild dovecot-uidlist?

2010-04-23 Thread Pat
Hello, In what situations will Dovecot 1.2.11 rebuild its uidlist? I am using the maildir storage format, and I am also modifying the uidlist manually (so it's possible I could jack* things up). I have found some related code in maildir-uidlist.c: maildir_uidlist_next. 1) Blank filename or UID 0