similar to: SQL mail storage

First of all, you can probably go online before you convert all passwords. You can modify your query in dovecot-sql.conf.ext to something like the following: SELECT IF(crypt_pass IS NULL OR crypt_pass='', CONCAT('{PLAIN}',plain_pass), crypt_pass) as password FROM mailuser .. This is assuming that: * for incoming users, you have a plain_pass column containing just the plaintext

You do need to complete the query. Don't just replace your query with the one I wrote. You have to have a WHERE clause, and you might need to return other fields. Keep the password query you had before, just replace the 'password' column with "IF( ... ) as password" The query as you have it now simply returns all the passwords for all the users, because you don't have a

This looks good, except it is truncated, it should be something like 95chars long, Is your hash column set to 128 or up around there or larger? Quoting Carl A Jeptha <cajeptha at gmail.com>: > Sorry for double reply, but this what a password looks like in the > "hashed" password column: > {SHA512-CRYPT}$6$wEn1UFuiMzl9OSjd$Vh/PZ95WDID1GwI2 > > ------------

Hello guys, Firstly I would like to state that I am fairly new to Dovecot. I have played around with it in the past here and there but mainly with debian packages. I have compiled this version of Dovecot from source, so please go easy with me. Ok now down to my questions: I am having trouble getting Dovecot to 'ignore' the Trash folder when summing up the used quota for a user.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, 2 Mar 2015, Oliver Welter wrote: > Am 02.03.2015 um 06:03 schrieb Dan LaSota: >> I have dovecot version 2.2.10 >> dovecot -n output below >> >> I am seeing connection errors being written to my dovecot error log: >> Mar 1 19:51:15 mail dovecot: auth-worker(2224): Error: mysql(localhost): >> Connect

I'm using a Postfix, Dovecot, MySQL setup with virtual domains. I have mail being delivered through Dovecot LDA working 100%. I'm trying to use sieve to handle vacation messages but dovecot is not reading the .dovecot.sieve file in the users maildir. I have a hunch it has to do with my dovecot-sql query but have had no success with what I found in the forums from Googling. Any help would

Am 02.03.2015 um 19:30 schrieb Dan LaSota: >>> Just some quick ideas >>> * check if the mysql socket file has rw permissions for the dovecot user > > # ls -l /var/lib/mysql/mysql.sock > srwxrwxrwx. 1 mysql mysql 0 Mar 1 19:33 /var/lib/mysql/mysql.sock that's not the problem > I have tried with > connect = host=localhost dbname=servermail

Hello, I have a small server running dovecot 1.2 (still not balsy enough to switch to 2.0 - virtual sql accounts, managesieve etc.). There are no local users - only ones defined in the SQL database, and everything else (including quota) is defined in SQL db too. Dovecot is used as IMAP daemon, and dovecot-lda is responsible for delivery (in order to make use of sieve and managesieve). I know

Excuse me for being stupid and confused. I'm trying to convert my dovecot install from passwd-file to mysql. I have a single table called "users" that has 3 fields, user_name, domain_name and password. The data came from passwd/shadow files so it uses the same password encryption as the shadow files do. The directory where the email is stored is calculated elsewhere and not

Hi, i tried to setup replication since some days but I'am stuck now. My conf: # 2.2.10: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-431.3.1.el6.x86_64 x86_64 CentOS release 6.5 (Final) dsync_remote_cmd = ssh -l%{login} %{host} /usr/bin/doveadm dsync-server -u%u -l%{lock_timeout} -n%{namespace} log_path = /var/log/dovecot mail_gid = 5000 mail_home = /var/vmail/%d/%n mail_location =

> On 28/08/2019 21:01 R.N.S. via dovecot <dovecot at dovecot.org> wrote: > > > > Am 28.08.2019 um 19:46 schrieb Jakobus Sch?rz via dovecot <dovecot at dovecot.org>: > > > > I think, i had the same problem as you. > > > > When dovecot runs lmtp, no user is logged in, so there is no user from > > which you can get groups. So i think, my

I think, i had the same problem as you. When dovecot runs lmtp, no user is logged in, so there is no user from which you can get groups. So i think, my solution is (not really sure, if this is right, it's a long time ago, i played around) this transport in exim for local delivery dovecot_delivery:????????????? ? debug_print = "T: dovecot_delivery_pipe for $local_part@$domain translates

Hello I installed dovecot 2.0.9 (and dovecot-mysql!) on my Ubuntu 12.04 LTS root-server to work together with Postfix 2.9.1-4 After some struggle, I got Postfix's auth working, using dovecot for smtp-authentification with mysql. But dovecot himself is not working properly. When I connect, after giving plaintext password I read the error in the client (I connect for debug reasons with a

On 29.8.2019 12.18, R.N.S. via dovecot wrote: > >> Am 28.08.2019 um 20:02 schrieb Aki Tuomi via dovecot <dovecot at dovecot.org>: >> >> >>> On 28/08/2019 21:01 R.N.S. via dovecot <dovecot at dovecot.org> wrote: >>> >>> >>>> Am 28.08.2019 um 19:46 schrieb Jakobus Sch?rz via dovecot <dovecot at dovecot.org>:

> On 28/08/2019 21:07 R.N.S. via dovecot <dovecot at dovecot.org> wrote: > > > > Am 28.08.2019 um 20:02 schrieb Aki Tuomi via dovecot <dovecot at dovecot.org>: > > > > > >> On 28/08/2019 21:01 R.N.S. via dovecot <dovecot at dovecot.org> wrote: > >> > >> > >>> Am 28.08.2019 um 19:46 schrieb Jakobus Sch?rz via

I've been working on setting up a Dovecot server with a maildir mailboxes stored over NFS. Initially, everything was working great, and then I started seeing this error as previously discussed on the list in my maillog: (mail_index_expunge): assertion failed: (!t->view->external) Timo, in another thread, suggested to remove line 247 in mail-index-transaction.c in the test52

I have been using cyrus for the past 6 years, but it is a pain to config. So ... I just installed dovecot 1.0.15 on a new debian 4r7 box. In cyrus we were using usernames as "user.domain.tld". In dovecot I realize I can: auth_username_translation = .@ But this converts user.domain.tld to user at domain@tld which of course fails. Is there a regex or something I can apply to pull this

Hi, I am trying to write a RMySQL sql script inside R such that part of the SQL would be R list or vector. For example, I want to select * from Atable where ID would equal to a members of R list or vector of "1, 2, 3". Here the ID list was generated inside R and then try to feed to mysql to call to get additional data sets. Can someone on the list help? Thanks. -- Waverley @ Palo

Hello all. I'm have this problem: I'm want auth users by "uid" filed but this filed uniq only in one LDAP container. So im what to tell dovecot were to look some "uid" by "mail" filed of this user. Can im do this: pass_filter = (&(objectClass=mailUser)(mail=*@%d)(uid=%n)) Will this construction work? -- Best regards, Proskurin Kirill

Dear Users I am new to R. I'm trying to make a connection to Microsoft SQL Server via R. How can I find the correct syntax to make the connection? The Help pdf file has an example for mySql but there's isnt much on SQL Server. Please help. I am trying the following code library(RODBC) con<-odbcConnect(dbname,hostname) How do I specify the driver,userid,password etc? Many thanks for