- dovecot - dovecot.org

Re: [Dovecot] quota dict with mysql 4.0
by Andre Hübner 25 Mar '10

25 Mar '10

(sorry, i only read the digest version of list and always create i new thread by "fake-Re") Hello, >> Perhaps you can implement some updating procedure that >> would only involve a percentage of your users at one time. no way, i want to fix this! but i need help because i have no idea of c-programming. i can read the code a little bit, but never lerned it. solution is to edit dovecot-1.2.11/src/lib-dict/dict-sql.c i can avoid using ON DUPLICATE KEY UPDATE by changing line 91 to: orig: dict->has_on_duplicate_key = strcmp(driver->name, "mysql") == 0; changed: dict->has_on_duplicate_key = strcmp(driver->name, "mysqlXXX") == 0; this works only 50%. if a user has no entry in quotatable, dovecot is updating his quota with 2 queries: INSERT INTO quota (bytes,username) VALUES ('2456','myuser') INSERT INTO quota (messages,username) VALUES ('2','myuser') The first query works, the second throws an error because username-field is uniqe. Duplicate entry 'myuser' for key 1 So i have to find a way to make this query in one step: INSERT INTO quota (bytes,messages, username) VALUES ('2456','2','myuser') or turn the second insert into an update update quota SET messages='2' where username='myuser' But iam afraid this is too much for my c-skills. I need help of an C-Crack or timo as developer. if timo could create a switch for mysql 4.0 would surely be the best. Thanks, Andre

1 0

Re: [Dovecot] quota dict with mysql 4.0
by Andre Hübner 25 Mar '10

25 Mar '10

Hello, >> I am somewhat surprised that the older software is not compatible with >> the newer version of MySQL. Usually, it is the other way around. Have >> you checked to see if newer versions of the incompatible software >> exist? I would be willing to wager that they have been updated to >> accommodate the newer MySQL versions. Syntax changed a litte bit and also there are some new protected words which are used by older software in sql without backticks etc. I agree updating would be the better way but we talking about a big number of servers and customers still using it. this is not changed over night.... I looked into dovecot-1.2.11/src/lib-dict/dict-sql.c, there seems to be a check for "ON DUPLICATE KEY UPDATE" on line 588. I recompiled dovecot on mysql 4.0 machine and tried again but there was no change. SQL is successful when dataset in quotatable is existing. in this case dovecot triggers an update of the data. But if no line for user is existing in quotatable and an insert is needed there is still the error: sql dict: commit failed: 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 'ON DUPLICATE KEY UPDATE bytes='12525'' at line why is the mysql 4.0-recompiled dovecot thinking my mysql is able to do "ON DUPLICATE KEY UPDATE"? How to avoid this? Thanks, Andre

2 1

[Dovecot] What is the difference between the plugin zlib and imap-zlib ?
by Alex Baule 24 Mar '10

24 Mar '10

What is the difference between the plugin zlib and imap-zlib ? in dovecot 1.2.X the zlib plugin works with imap....imap-zlib is a complement to zlib ?

2 1

[Dovecot] Question howto wiki.dovecot.org about quotas using dict
by Ricardo Barbosa 24 Mar '10

24 Mar '10

Hi, I am configuring a server with postfix and dovecot with virtual domains and using quota. To implement quota followed the documentation of the link http://wiki.dovecot.org/Quota/Dict, did not understand what you mean the field "where_field = path" would be the path on the filesystem of your mailbox? I would have to create the table that he says in the documentation or can I force a value with concat and using the AS (ie select '/var/vmail/domain/user' as path from table) ? Regards. __________________________________________________ Faça ligações para outros computadores com o novo Yahoo! Messenger http://br.beta.messenger.yahoo.com/

2 3

[Dovecot] Is it possible to prevent users from ever deleting anything?
by Snaky Love 24 Mar '10

24 Mar '10

Hi, dear dovecot-users, is it possible to make dovecot ignore the DELETE command for some accounts? Basically what I want to achieve is: users shall not be able to delete their emails - but they still should be able write emails. This is meant for a setup where different users are sending and receiving emails for a "support" account. I looked into IMAP virtual folders and ACL but I did not see a way of totally disabling the possibility to delete emails and share the whole account. I realize there may be race conditions with a setup like this and a web based ticket system might be a better solution, but it is only a very small team and we can always talk to each others to resolve conflicts - so using only one mail account for support seems practical and could keep the overhead small - but we do not want to delete anything from it (accidentaly). Of course, at one point in future somebody has to delete some mails from this accounts to get rid of old stuff - so I would like to implement a super-user that is able to do that kind of mailbox maintanance. How would I use ACL to setup such a scenario? Is it even possible? Or did I misunderstand IMAP shared folders completely??? Thank you very much for your attention! Have a nice day, Snaky

4 3

[Dovecot] Writing "sieve" script
by Jerry 24 Mar '10

24 Mar '10

This is probably not the best place to ask this question; however, I figured I had to start somewhere. I want to write a sieve script that can sort incoming mail into specific locations. EXAMPLE: require ["fileinto"]; if header :contains "X-Virus-Status" "Infected" {fileinto "SPAM"; stop;} elsif header :contains "X-SpamCop-Disposition" "Blocked" {fileinto "SPAM"; stop;} elsif address :contains "To" "user1(a)domain.com" {fileinto "INBOX.user1";} elsif address :contains "To" "user2(a)domain.com" {fileinto "INBOX.user2";} elsif address :contains "To" "user3(a)domain.com" {fileinto "INBOX.user3";} # The rest goes into INBOX # The default is "implicit keep", we do it here explicitly else {keep;} This works fine unless user1, user2 and or user3 are all included in the same e-mail address. It is rare; however, it does happen. In that case, a separate message for each recipient would be delivered to the first matching mailbox. The other recipients would not receive any traffic at all. I am new at writing sieve scripts, and have not come up with any way of preventing this from happening. If anyone has a suggestion, I would love to hear it. Even the examples I found by Googling were not really informative. -- Jerry Dovecot.user(a)seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________ "Glory is fleeting, but obscurity is forever." - Napoleon Bonaparte

2 1

Re: [Dovecot] POPS and IMAPS with dovecot
by Wilberth Pérez 23 Mar '10

23 Mar '10

Hi: the problem was due to some links from openssl, but now I have the following message: Mar 23 10:55:17 mailer dovecot: [ID 583,609 mail.warning] imap-login: Waiting for SSL parameter file ssl-parameters.dat ¿what is the meaning of that? -------------------------------------------------------- LCC Wilberth de Jesús Pérez Segura CCSA- Administración de Servicios y Seguridad de las TI Correo: wilberth.perez(a)uady.mx Universidad Autónoma de Yucatán Secretaría General Coordinación Administrativa de Tecnologías de Información RIUADY C-59 x Av. Itzáes (999)923-74-28 Ext. 1117 Mérida, Yucatán, México 2010 -------------------------------------------------------- El 23/03/2010 10:16 a.m., Mira Das escribió: > I think you should give the proper IP addesses > > Try this as it works for me > > protocol imap { > listen = 192.168.1.201:143 > ssl_listen = 192.168.1.201:993 > imap_max_line_length = 65536 > mail_plugins = imap_quota quota trash > .......... > } > > protocol pop3 { > listen = 192.168.1.201*:110 > ssl_listen = 192.168.1.201*:995 > pop3_no_flag_updates = no > pop3_uidl_format = %08Xu%08Xv > pop3_client_workarounds = outlook-no-nuls oe-ns-eoh > ............. > } > > > > Mira Das > EcoSuite Corporation > mira(a)ecosuite.com > 561-945-4466 > > -----Original Message----- > Received On: Tue, 23 Mar 2010 at 12:12 PM EDT > From: =?ISO-8859-1?Q?Wilberth_P=E9rez?= <wilberth.perez(a)uady.mx> > Subject: [Dovecot] POPS and IMAPS with dovecot > To: dovecot(a)dovecot.org > > > > Hi everyone: > > when I try to run dovecot after modifying the dovecot.conf file I have > the following error messages: > > > Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.info] Dovecot v1.2.10 > starting up > Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.info] Generating > Diffie-Hellman parameters for the first time. This may take a while.. > Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.error] ssl-build-param: > ld.so.1: ssl-build-param: fatal: libssl.so.0.9.8: open failed: No such > file or directory > Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.error] dovecot: child > 8103 (ssl-build-param) killed with signal 9 > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: > Temporary failure in creating login processes, slowing down for now > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] imap-login: > ld.so.1: imap-login: fatal: libssl.so.0.9.8: open failed: No such file > or directory > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] pop3-login: > ld.so.1: pop3-login: fatal: libssl.so.0.9.8: open failed: No such file > or directory > Mar 23 09:56:53 mailer last message repeated 2 timesMar 23 09:56:53 > mailer dovecot: [ID 583609 mail.error] dovecot: child 8110 (login) > killed with signal 9 > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child > 8109 (login) killed with signal 9Mar 23 09:56:53 mailer dovecot: [ID > 583609 mail.error] dovecot: child 8108 (login) killed with signal 9 > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child > 8107 (login) killed with signal 9Mar 23 09:56:53 mailer dovecot: [ID > 583609 mail.error] dovecot: child 8106 (login) killed with signal 9 > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] imap-login: > ld.so.1: imap-login: fatal: libssl.so.0.9.8: open failed: No such file > or directoryMar 23 09:56:53 mailer last message repeated 1 time > Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child > 8111 (login) killed with signal 9 > > Any idea what this wrong? > > > My dovecot.conf have enable the following: > > protocol imap { > listen = *:143 > ssl_listen = *:993 > mail_plugins = quota imap_quota > mail_plugin_dir = /usr/local/lib/dovecot/imap > } > > protocol pop3 { > listen = *:110 > ssl_listen = *:995 > mail_plugins = quota > } > > # SSL/TLS support: yes, no, required. <doc/wiki/SSL.txt> > ssl = yes > > ssl_cert_file = /etc/certs/mailer/mailer-crt.pem > ssl_key_file = /etc/certs/mailer/mailer-key.pem > ssl_ca_file = /etc/certs/mailer/CA-crt.pem > > > compilation of dovecot was as follows: > > CPPFLAGS='-I/opt/mysql/include/mysql -I/usr/local/ssl/include' > LDFLAGS='-L/opt/mysql/lib/mysql -L/usr/local/ssl/lib' ./configure > --with-sql --with-mysql --with-ssl --with-ssldir=/usr/local/ssl/ > > > -- > -------------------------------------------------------- > LCC Wilberth de Jesús Pérez Segura CCSA- Administración de Servicios y > Seguridad de las TI > Correo: wilberth.perez(a)uady.mx > Universidad Autónoma de Yucatán > Secretaría General > Coordinación Administrativa de Tecnologías de Información > RIUADY > C-59 x Av. Itzáes (999)923-74-28 Ext. 1117 > Mérida, Yucatán, México 2010 > -------------------------------------------------------- >

1 0

[Dovecot] POPS and IMAPS with dovecot
by Wilberth Pérez 23 Mar '10

23 Mar '10

Hi everyone: when I try to run dovecot after modifying the dovecot.conf file I have the following error messages: Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.info] Dovecot v1.2.10 starting up Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.info] Generating Diffie-Hellman parameters for the first time. This may take a while.. Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.error] ssl-build-param: ld.so.1: ssl-build-param: fatal: libssl.so.0.9.8: open failed: No such file or directory Mar 23 09:56:52 mailer dovecot: [ID 583609 mail.error] dovecot: child 8103 (ssl-build-param) killed with signal 9 Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: Temporary failure in creating login processes, slowing down for now Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] imap-login: ld.so.1: imap-login: fatal: libssl.so.0.9.8: open failed: No such file or directory Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] pop3-login: ld.so.1: pop3-login: fatal: libssl.so.0.9.8: open failed: No such file or directory Mar 23 09:56:53 mailer last message repeated 2 timesMar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child 8110 (login) killed with signal 9 Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child 8109 (login) killed with signal 9Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child 8108 (login) killed with signal 9 Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child 8107 (login) killed with signal 9Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child 8106 (login) killed with signal 9 Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] imap-login: ld.so.1: imap-login: fatal: libssl.so.0.9.8: open failed: No such file or directoryMar 23 09:56:53 mailer last message repeated 1 time Mar 23 09:56:53 mailer dovecot: [ID 583609 mail.error] dovecot: child 8111 (login) killed with signal 9 Any idea what this wrong? My dovecot.conf have enable the following: protocol imap { listen = *:143 ssl_listen = *:993 mail_plugins = quota imap_quota mail_plugin_dir = /usr/local/lib/dovecot/imap } protocol pop3 { listen = *:110 ssl_listen = *:995 mail_plugins = quota } # SSL/TLS support: yes, no, required. <doc/wiki/SSL.txt> ssl = yes ssl_cert_file = /etc/certs/mailer/mailer-crt.pem ssl_key_file = /etc/certs/mailer/mailer-key.pem ssl_ca_file = /etc/certs/mailer/CA-crt.pem compilation of dovecot was as follows: CPPFLAGS='-I/opt/mysql/include/mysql -I/usr/local/ssl/include' LDFLAGS='-L/opt/mysql/lib/mysql -L/usr/local/ssl/lib' ./configure --with-sql --with-mysql --with-ssl --with-ssldir=/usr/local/ssl/ -- -------------------------------------------------------- LCC Wilberth de Jesús Pérez Segura CCSA- Administración de Servicios y Seguridad de las TI Correo: wilberth.perez(a)uady.mx Universidad Autónoma de Yucatán Secretaría General Coordinación Administrativa de Tecnologías de Información RIUADY C-59 x Av. Itzáes (999)923-74-28 Ext. 1117 Mérida, Yucatán, México 2010 --------------------------------------------------------

1 0

[Dovecot] Removing Duplicates
by Sabahattin Gucukoglu 23 Mar '10

23 Mar '10

Hi all, I am starting fresh with a local repository of mails, which almost certainly have duplicates in them. I am going to use maildirs, and ensure all mails are input with CRLFs. The question is: does anybody know how I can find and remove duplicates, either while injecting mail with IMAP, or afterward? I can use tools to find duplicate Message-IDs, but don't know of a way to remove duplicates in mailboxes that are already imported as opposed to incoming mail. Perhaps there is a way to use the IMAP protocol for this? Cheers, Sabahattin

4 4

[Dovecot] Debian Unstable Packages
by Sabahattin Gucukoglu 23 Mar '10

23 Mar '10

Hi all, Speaking of Debian, what relative position are the Debian Unstable (Sid) packages in to the latest "Bleeding edge" builds of RCS-based releases from the Wiki? If using Unstable is it recommended to stay or use the newer ones? I'd say it was production, yes, but I'm forgiving of problems in the latest releases, so long as they aren't meant to be beta (i.e., known breakages). Cheers, Sabahattin

2 1