similar to: SQL insert?

I'm a newbie at Dovecot. For a company groupware I need a kind of a history function for mails to see which user sent which mail to whom / got which mail from whom. So I have to get the message ID of in- and outgoing mails (and write related data to a mysql database). My first idea was to monitor the log file with a daemon and search for strings like "deliver(x at y.z): 2010-11-15

Hi all, I compiled Dovecot 1.2.16 (on Debian 5/lenny) and followed the quick configuration guide (wiki.dovecot.org/QuickConfiguration). I just need plaintext authentication. After starting Dovecot I get "Last died with error" and in var/log/mail.err: Nov 23 15:06:55 debian dovecot: auth(default): Fatal: Support not compiled in for passdb driver 'pam' Nov 23 15:06:55 debian

I've recently been able to compile the CVS code in Solaris 9, but I'm now getting a few errors. First, I receive this error during the autogen process: src/plugins/Makefile.am:5: required directory src/plugins/convert does not exist configure.in:1717: required file `src/plugins/convert/Makefile.in' not found I can workaround that by removing the reference to

Hi all. Recently I was looking for an IMAP-server with Oracle support and unfortunatelly I couldn't find one. It was a surprise for me but there is no such functionality at all. So I've chosen an IMAP-server with most flexible and convinient architecture that was Dovecot-1.2.9 and written a driver for Oracle RDBMS support. I used Oracle Pro*C so a Pro*C preprocessor is needed to

Hello, I'm trying to access a mysql database in a plugin. -What special compiler flags do I need? I discovered that when I don't explicitly link lib-sql/libsql.a in, then I get an undefind symbol error about sql_init when loading the plugin. Shouldn't the imap process itself have sql support linked in, rather than each plugin? -It appears that I need to call sql_drivers_init() and

One of the things my employer uses dovecot for is as mail download server for an 'e-mail purification service' (AV/ anti-spam) for smartphones. The service itself presently runs on a rented server somewhere in the UK and the corresponding 'web service' front-end and user account/ mail account database resides on a server in Germany. The UK dovecot server uses the PostgreSQL server

I can not use quota/dict when i configure it come outs this error. If the configuration gos wrong it just do not happen anything, but if the filds and name are ok, happen this.. > May 14 17:03:40 auth: Debug: Loading modules from directory: > /usr/lib/dovecot/auth > May 14 17:03:40 auth: Debug: master in: USER 1 sfrique at nti.uff.br > service=lda > May 14 17:03:40 auth:

Hi, yesterday lib-sql got driver-sqlpool with some changes in Makefile.am, but these changes in makefile works only for --with-sql=yes. When --with-sql=plugin is used build fails with: libtool --tag=CC --mode=link gcc -std=gnu99 -O2 -g -pipe -Wall -Wp,- D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 - m64 -mtune=generic -Wall -W -Wmissing-prototypes

Hello, I'm trying to build another antispam plugin, but some things are a bit unclear. In backend_handle_mail I put store the signature returned from signature_extract into my antispam_transaction_context. In backend_commit it appears that the signature is empty. (It wasn't in backend_handle_mail). Somehow between backend_handle_mail en backend_commit it has been cleared... When I use

Here's a list of things I've been thinking about implementing for Dovecot v2.2. Probably not all of them will make it, but I'm at least interested in working on these if I have time. Previously I've mostly been working on things that different companies were paying me to work on. This is the first time I have my own company, but the prioritization still works pretty much the same

Hi, we are trying to track down the problem that prevents two mysql password databases from working. Instead of connecting to each database, it looks like dovecot tries to connect *twice* to the second specified. Do do this we just inserted some i_warning()s in the code. We noticed that passdb_sql_init (auth/passdb-sql.c) is called twice, once per configuration file, with the correct argument

There's a minor compilation bug in dovecot 1.0 beta3 -- if there are no sql_drivers, then the generated Makefile in src/lib-sql exits improperly. A simple patch is appended below. Regards, John -- John DiMarco <jdd at cs.toronto.edu> Office: SF3302B IT Director Phone: 416-978-5300 Department of Computer Science,

I forgot to take out the portion that would read in the voicemail boxes from the text file. If you want to leave it in then you could have some voicemail boxes defined in the text voicemail.conf. I do not, so I have removed it. Below is the new patch: *** app_voicemail.c 2004-06-23 07:55:54.000000000 -0600 --- app_voicemail.c.new 2004-06-23 07:55:47.000000000 -0600 *************** *** 49,61 ****

Hello all, I am just getting going on building my system, but I thought I'd send you all a patch that I wrote so the command: show voicemail users issued from the CLI works properly when there is a postgres backend for the voicemail. The current version of the app does not display the voicemail boxes found in a database. It is called in the load_config function. I haven't done

Hello, I want to create a plugin to dovecot 2.0.1, to call a on the deliver action. My plugin work even if I include other libs like mysql or wathever I tried to use the "sql-api.h" (lib-sql), but at runtime, I have : "undefined symbol: sql_init", "Fatal: Couldn't load required plugins" Is it possible to use lib-sql api or mysql libs in a plugin ? I've

Hi, With the latest hg version I see panics with dict process whenever a message is received via lmtp. This didn't happen with the original beta4 release. Mar 27 11:45:51 ubuntu-test dovecot: dict: mysql: Connected to localhost (mails) Mar 27 11:45:51 ubuntu-test postfix/lmtp[5261]: 0F22B27F0D: to=<test at ubuntu-test.localdomain>, orig_to=<test at ubuntu-test.localdomain>,

Today I finally caught up with my mail. I've now read all the mails from the Dovecot list from this year and all my private mails from last few years (totaling around 500 unread mails). If you think there's still something I should have replied to, please re-send it because I've either missed it or just skipped it for some reason. (Except there are still a couple of mails from this

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I'm using a postgres dict for ACL, when when use deleteacl or setacl I get a "not connected" error and (v2.2) Panic: file driver-pgsql.c: line 84 (driver_pgsql_set_state): assertion failed: (state == SQL_DB_STATE_BUSY || db->cur_result == NULL) and a rawdump eventually. You can trigger the error with the "dict"

I some add information about bug... Dovecot 2.2.19 version on server FreeBSD 10.2 Release. Config quota (dict + mysql) Database create Postfixadmin 2.3.7 Old version Dovecot 2.2.13 use method UPDATE in MySQL base + dict example mysql.log ----------------- Connect postfix at localhost on postfix 134 Query SELECT bytes FROM quota2 WHERE username = 'user at mydomain.lan'