similar to: Authentication with encrypted passwords

Hi, I am wondering if it's possible to authenticate users that come from specific IP differently then other users. I will be authenticating them by postgresql so something like this would be very useful: password_query = SELECT password from get_user('%username','%host') Is that possible? Can it be done any other way? Thanks, Sebastjan

Hi, i'm using postgres for authorization. When I switched from a4 to a5 authorization stoped working. Query in conf file for postgres looks like this: password_query = select password from auth('%u','%r'); But in logs, the transformed query looks like this: Performing query: select password from auth('test','%r'); Looks like you don't transform that

Hi, I'm trying to decide if I could use you mail server in our enviroment which has about 10k users and mailboxes size about ~1GB. So I made a few tests and it all worked quite fast, except that select command on large mailboxes. The first time I select a mailbox which has 10k messages it takes about 4s to process. I am deliberately trying this on a Celeron 850Mhz, 512 MB memory and some

Is there a way to list all keywords a mailbox uses? I fetch flags for all messages and then gorup them, but this is a very nasty solution. What's the situation with full text search? Will it ever be implemented? Is it already? Text search on my 0.99.14 is quite slow. Don't understand why no IMAP server wants to implement this feature. Does Dovecot support plugins? Thank you, Sebastjan

Hi, I have a few questions regarding copy and save_finish methods. How can I get a filename or processing mail from the parameters you get in that methods? How could I use the logger you use for dovecot inside my plugin? Thanks, Sebastjan -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi, is there a quick way to disable keyword feature in dovecot? Thanks, Sebastjan

Hi, I'm trying to add a code in dovecot that will notify my services when a message is updated/added/moved/copied. I checked dovecot code a bit and mail-storage.c seems to be a nice place for tracking but I'm not sure if I can track all changes there. Does anyone have any experience with this topic or ideas? Thanks, Sebastjan -------------- next part -------------- An HTML

Hi, when I try to copy/move messages with keywords, IMAP process dies: dovecot: Jul 24 23:49:47 Info: imap-login: Login: user=<seba>, method=PLAIN, rip=192.168.0.192 <http://192.168.0.192>, lip=192.168.0.188<http://192.168.0.188> dovecot: Jul 24 23:49:47 Info: IMAP(seba): Effective uid=1000, gid=100 dovecot: Jul 24 23:49:47 Info: IMAP(seba): maildir: data=/home/seba/Maildir

Hi, is it possible to configure dovecot so that users from a specific IP (let's say 127.0.0.1) don't have to send password? They would be authenticated no matter if passwords match or not. Thanks, Sebastjan

Hi, while implementing thread support in our mail application I found a bug which kills IMAP(alpha5, SUSE 10) process... These are the commands: x OK Logged in. x select INBOX * FLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk Junk $Forwarded Spam) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk Junk $Forwarded Spam \*)] Flags permitted. * 2280 EXISTS * 1 RECENT *

I'm trying to setup dovecot to use my postfixadmin user accounts on an ubuntu server. dovecot versions: dovecot-common 1.0.beta3-3ubuntu5.3 dovecot-imapd 1.0.beta3-3ubuntu5.3 I have gotten the account up and I can see dovecot query for the password for the user, but I get login failed. In my mail.log I only see this: dovecot: imap-login: Aborted login: user=<user at

I have trying to find how to set the dovecot-sql.conf for using SHA256/512.? I am going to start clean with the stronger format, not migrate from the old MD5.? It seems all I need is: driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password default_pass_scheme = SHAxxx-CRYPT # following should all be on one line. password_query =

Hi List Anybody could tell me how to set per-user quota with dovecot-lda? Thank in advance.

1. Auth debug turned on, - nothing 2. cryptpwd is the name of my "password" column, have to specify that if you want to run password_query as it relies on a field "password" to work. 3. I have access to the "clear passwords" but none of my google searches worked for converting them to SHA512_CRYPT On Tue, May 3, 2016 at 1:02 PM, Steffen Kaiser < skdovecot at

Steffen, If you can point me in the direction as to how to convert a column of clear text passwords to SHA512-CRYPT I will be happy to follow it and close this query, I only came here because I had spent almost two weeks trying to make the dovecot wiki work and thought someone would point out the mistakes I had made. But otherwise, I will move on, and not waste anyone's time anymore.

Thank you, Due to changes I had to make to let password_query work, I think your "quick" version should be like this my setup: UPDATE mailbox set password = ENCRYPT(clearpwd, CONCAT('$6$',sha(RAND()))) WHERE password IS NULL OR password=' '; ------------ You have a good day now, en mag jou m?re ook so wees, Carl A Jeptha On 2016-05-03 18:10, Gedalya wrote: > The

Just tried to run it on the "Live" database, the simulation found all the rows, but when I ran the query I got this error (still trying to see what mus be changed): |#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.sha(RAND()))) WHERE password IS NULL OR password=''' at line

I am switching from a fedora/postfix/mysql/couriermail/squirrelmail to Centos/.../dovecot/roundcubemail and adding postfixadmin to the mix. My tutorial before was an earlier version (on F14) of: http://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-centos-6.2-x86_64 Now I am using

Currently using 2.0.12, configured the auth-sql.conf to look like this for password lookups (doing smtp auth with postfix, so I am not actually running pop or imap, just auth): passdb { driver = sql connect = host=server.net dbname=passwd user=sqluser password='password' default_pass_scheme = CRYPT password_query = SELECT CONCAT(username,'@domain.net') as user, pw as

Good afternoon, I am trying to setup dovecot to authenticate using the userdata from wordpress. It's being a bit mor difficult than I thought. This is the relevant part of the dovecot-sql.conf default_pass_scheme = CRYPT password_query = SELECT user_pass AS password FROM wp_users WHERE user_email='%u'; user_query = SELECT 501 as uid, 501 as gid,'maildir:storage=51200' as