Re: [Dbmail] dbmail init systemd

2016-07-15 Thread Gordan Bobic
On 2016-07-15 13:00, Reindl Harald wrote: Am 15.07.2016 um 13:55 schrieb Gordan Bobic: On 2016-07-15 12:33, Reindl Harald wrote: Am 15.07.2016 um 13:26 schrieb Gordan Bobic: On 2016-07-15 12:24, Reindl Harald wrote: Am 15.07.2016 um 13:12 schrieb Gordan Bobic: On 2016-07-15 12:01, Reindl

Re: [Dbmail] dbmail init systemd

2016-07-15 Thread Gordan Bobic
On 2016-07-15 12:33, Reindl Harald wrote: Am 15.07.2016 um 13:26 schrieb Gordan Bobic: On 2016-07-15 12:24, Reindl Harald wrote: Am 15.07.2016 um 13:12 schrieb Gordan Bobic: On 2016-07-15 12:01, Reindl Harald wrote: Am 15.07.2016 um 12:58 schrieb Gordan Bobic: On 2016-07-15 11:43, Admin

Re: [Dbmail] dbmail init systemd

2016-07-15 Thread Gordan Bobic
On 2016-07-15 12:24, Reindl Harald wrote: Am 15.07.2016 um 13:12 schrieb Gordan Bobic: On 2016-07-15 12:01, Reindl Harald wrote: Am 15.07.2016 um 12:58 schrieb Gordan Bobic: On 2016-07-15 11:43, Admin Beckspaced wrote: i see there's also a systemd folder in the 3.2.3 version: https

Re: [Dbmail] dbmail init systemd

2016-07-15 Thread Gordan Bobic
On 2016-07-15 12:01, Reindl Harald wrote: Am 15.07.2016 um 12:58 schrieb Gordan Bobic: On 2016-07-15 11:43, Admin Beckspaced wrote: i see there's also a systemd folder in the 3.2.3 version: https://github.com/pjstevns/dbmail/tree/master/systemd and some makefiles sorry ... i'm no linux

Re: [Dbmail] dbmail init systemd

2016-07-15 Thread Gordan Bobic
On 2016-07-15 11:43, Admin Beckspaced wrote: as a workaround i wrote a tiny shell script checking if dbmail-imapd is running and if not then start a process since upgrading to 3.2.3 no crash has been reported so far ... keeping fingers crossed ;) should be handeled by the init system these

Re: [Dbmail] IMAP TLS after upgrade from 3.1.17 to 3.2.3

2016-07-14 Thread Gordan Bobic
On 2016-07-14 12:59, Reindl Harald wrote: Am 14.07.2016 um 13:49 schrieb Admin Beckspaced: Am 12.07.2016 um 16:24 schrieb Admin Beckspaced: i just upgraded dbmail from 3.1.17 to most recent stable 3.2.3 with the old version 3.1.17 i could do an IMAP account setup in thunderbird with SSL/TLS

Re: [Dbmail] IMAP TLS after upgrade from 3.1.17 to 3.2.3

2016-07-14 Thread Gordan Bobic
On 2016-07-14 13:13, Reindl Harald wrote: Am 14.07.2016 um 13:57 schrieb Ken Drummond: On 14-07-16 6:29 PM, Reindl Harald wrote: Am 12.07.2016 um 16:24 schrieb Admin Beckspaced: i just upgraded dbmail from 3.1.17 to most recent stable 3.2.3 with the old version 3.1.17 i could do an IMAP

Re: [Dbmail] Loadbalanced MySQL Cluster, can deadlock occur ?

2016-02-14 Thread Gordan Bobic
Deadlocks can occur even with a _single_ server and no clustering, unless you are running with transaction isolation level set to "serializable", which comes with a massive performance penalty (it will give you write concurrency of 1, i.e. as bad as MyISAM). On 14/02/16 12:36, Matt . wrote:

Re: [Dbmail] Database restore

2015-02-05 Thread Gordan Bobic
Apart from making sure you are using the long INSERT format, you will almost certainly find that bumping up the size of the InnoDB logs will help, and disabling InnoDB flushing at trx commit and doublewrite will help massively to reduce the import time. Obviously, re-enable the flush at trx

Re: [Dbmail] Database restore

2015-02-05 Thread Gordan Bobic
On 2015-02-05 14:36, Casper Langemeijer wrote: On 05-02-15 15:11, Reindl Harald wrote: Am 05.02.2015 um 15:00 schrieb Curtis Maurand: Thanks, I'll give that a shot while i look at replicatuon which I've never been able to make work there is nothing difficult and is configured within 5

Re: [Dbmail] Database restore

2015-02-05 Thread Gordan Bobic
On 2015-02-05 13:59, Andrea Brancatelli wrote: Don't mistreat mysqldump, if used correctly it's powerfull. It's reasonably powerful, but for datasets larger than a few GB the process is slow to back up, and unworkably slow to restore. Especially if you have binary-logging enabled you can

[Dbmail] Full Text Search

2015-01-14 Thread Gordan Bobic
Hi, I am due to be upgrading my mail server soon. I am currently using dbmail (old 2.2.x). The question I am currently trying to answer is whether in the past few years dbmail has gained the advantage of being able to use full text search capabilities of the modern RDBMSes. Back when I

Re: [Dbmail] dbmail3: hughe performance problem full + explain

2012-02-02 Thread Gordan Bobic
On 02/02/2012 06:33 PM, Paul J Stevens wrote: On 02/02/2012 02:32 PM, Reindl Harald wrote: SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts k LEFT JOIN dbmail_partlists l ON k.id=l.part_id LEFT JOIN dbmail_physmessage p ON l.physmessage_id=p.id LEFT JOIN dbmail_header h ON

Re: [Dbmail] Change of mysql backend comes with increase in CPU

2011-11-02 Thread Gordan Bobic
How does your CPU time get measured? Does it include iowait time? If so, it could just be the period during which the caches are getting warmed up. Gordan On Wed, 2 Nov 2011 20:59:54 +1300, Simon grem...@gmail.com wrote: Hi There, We are running dbmail 2.2.17 on a debian squeeze VM. It has

Re: [Dbmail] MySQL config for dbmail

2011-10-31 Thread Gordan Bobic
On 10/31/2011 09:34 PM, Simon wrote: Hi There, This may be slightly OT… but I'm wondering if someone would be able to give me a few pointers new dbmail mysql VM please? Currently it has 2 VCPUs (Xeon E5645 @ 2.4GHz) and 1GB RAM (note: this is only in testing, no mail flow to it or no client

Re: [Dbmail] Backups with 100GB mail

2011-10-13 Thread Gordan Bobic
On Thu, 13 Oct 2011 21:11:26 +1300, Simon grem...@gmail.com wrote: Hi There, I know this has been discussed on the list off and on and i have searched and reviewed the list for these.. but i would just like to get peoples opinion of the best strategy to move forward with… We have DBmail 2.2.17

Re: [Dbmail] POP and IMAP over SSL/TLS.

2011-03-10 Thread Gordan Bobic
On 03/10/2011 07:47 PM, Rafał Radecki wrote: Hi All. I am configuring a mail server with postfix and dbmail with postgresql. As I see in dbmail.conf POP listens on TCP 110 and IMAP on TCP 143, there are no certificates or keys to add. Is there a way to use POP/IMAP securely (SSL/TLS) in

Re: [Dbmail] Multi-Master Replication

2011-01-13 Thread Gordan Bobic
Larry H. wrote: I have two dbmail 2.2.17 servers using MySQL in a multi-master setup. I only have pop3, imap and lmtp running on the primary master and all incoming mail is received on the primary master. Basically the second master is a hot standby for failover. Every few days the replication

Re: [Dbmail] Multi-Master Replication

2011-01-13 Thread Gordan Bobic
Larry H. wrote: I haven't gone as far as doing a full dump and restore just yet. That's probably a good place to start. You absolutely have to make sure beyond any doubt that the data is in sync. That means preventing all the writes to the master DB while you are dumping. One trick you

Re: [Dbmail] Multi-Master Replication

2011-01-13 Thread Gordan Bobic
rsync pass with the master DB off. The reason to do it 2-pass is to minimize the downtime in the 2nd pass since most of the data won't need to be changed again. Gordan Gordan Bobic wrote: Larry H. wrote: I haven't gone as far as doing a full dump and restore just yet. That's probably

Re: [Dbmail] Multi-Master Replication

2011-01-13 Thread Gordan Bobic
On 01/13/2011 06:39 PM, Paul J Stevens wrote: On 01/13/2011 06:34 PM, Larry H. wrote: So just to clarify I would be rsyncing the contents of the dbmail database folder (/var/lib/mysql/dbmail) to the slave. Then stopping the master and rsyncing the innodb log files in (/var/lib/mysql) to the

Re: [Dbmail] Multi-Master Replication

2011-01-13 Thread Gordan Bobic
On 01/13/2011 09:51 PM, Paul J Stevens wrote: On 01/13/2011 09:07 PM, Gordan Bobic wrote: You'll find the master will grind to a halt anyway while you're doing this, as soon as the write-ahead log fills up. With small-ish databases it's not a big deal, but if the size is in the 100GB+ range

Re: [Dbmail] Which spam filtering package do you think is best?

2010-12-30 Thread Gordan Bobic
zamri wrote: Can I collect opinions here about favorite/least favorite spam filtering packages, for use in a dbmail environment? What have you had luck with? What works best? What's your opinion? Which should a happy dbmail (postfix) user, now getting too much spam, use for

Re: [Dbmail] Which spam filtering package do you think is best?

2010-12-30 Thread Gordan Bobic
Tomas Kuliavas wrote: Can I collect opinions here about favorite/least favorite spam filtering packages, for use in a dbmail environment? What have you had luck with? What works best? What's your opinion? Which should a happy dbmail (postfix) user, now getting too much

Re: [Dbmail] Which spam filtering package do you think is best?

2010-12-30 Thread Gordan Bobic
On 12/30/2010 05:54 PM, Tomas Kuliavas wrote: Can I collect opinions here about favorite/least favorite spam filtering packages, for use in a dbmail environment? What have you had luck with? What works best? What's your opinion? Which should a happy dbmail (postfix) user,

Re: [Dbmail] Which spam filtering package do you think is best?

2010-12-30 Thread Gordan Bobic
On 12/30/2010 08:56 PM, edac...@gmail.com wrote: Hi It's broken because it demonstrably fails, by it's very design, to work reliably in a very real and valid scenario. very real - for spammers and misconfigured setups. gmail is a misconfigured setup and/or a major spam source? News to me.

Re: [Dbmail] Which spam filtering package do you think is best?

2010-12-22 Thread Gordan Bobic
Lou Picciano wrote: Can I collect opinions here about favorite/least favorite spam filtering packages, for use in a dbmail environment? What have you had luck with? What works best? What's your opinion? Which should a happy dbmail (postfix) user, now getting too much spam, use for

Re: [Dbmail] Which spam filtering package do you think is best?

2010-12-22 Thread Gordan Bobic
Larry H. wrote: I use Mailscanner to manage spamassassin and clamav. You can configure spamassassin to use RBLs and/or a bayesian filter. What possible reason could there be for using MailScanner and SpamAssassin if you are only going to filter based on ClamAV and RBLs? Both are hookable

[Dbmail] LDAP Authentication over SSL

2010-10-15 Thread Gordan Bobic
I'm trying to get this to work using OpenLDAP 2.4 (RHEL6), and according to this: http://www.dbmail.org/dokuwiki/doku.php/stunnel It should work based on what is in /etc/openldap/ldap.conf without having to fall back on stunnel if I omit the URL and HOSTNAME parameters in dbmail.conf's [LDAP]

Re: [Dbmail] Repeated Folder Names

2009-06-30 Thread Gordan Bobic
Marc Dirix wrote: I think 2.2.10 does not seem to suffer from it. As I tried to downgrade earlier I got into problems with strtoul. So 2.2.10 works but 2.2.11 doesn't? Gordan ___ DBmail mailing list DBmail@dbmail.org

Re: [Dbmail] Repeated Folder Names

2009-06-30 Thread Gordan Bobic
Marc Dirix wrote: I think 2.2.10 does not seem to suffer from it. As I tried to downgrade earlier I got into problems with strtoul. I just rolled back to 2.2.9 and the problem disappeared. Yet another upgrade exclusion in my yum.conf. Thanks to those of you who pointed out that the bug was

[Dbmail] Repeated Folder Names

2009-06-29 Thread Gordan Bobic
Hi, I'm seeing an odd issue with the IMAP folders. If I have multiple sub-folders, When I check folders on a higher level, I see the higher level folder multiple times, once per subfolder. For example, if I have I the following folders: Mail/foo Mail/bar Mail/baz I'll see the Mail folder

Re: [Dbmail] Repeated Folder Names

2009-06-29 Thread Gordan Bobic
15:15:58 +0200, Paul J Stevens p...@nfg.nl wrote: Gordan Bobic wrote: Is this a DBmail misconfiguration? Or corruption in my mail database? Is there anything that can be done about this? this is a known dbmail bug in 2.2, fixed already in 2.3. But since no of my dbmail-2.2 users complain

Re: [Dbmail] Repeated Folder Names

2009-06-29 Thread Gordan Bobic
On Mon, 29 Jun 2009 15:15:58 +0200, Paul J Stevens p...@nfg.nl wrote: Gordan Bobic wrote: Is this a DBmail misconfiguration? Or corruption in my mail database? Is there anything that can be done about this? this is a known dbmail bug in 2.2, fixed already in 2.3. But since no of my

Re: [Dbmail] dbmail performance test

2009-05-27 Thread Gordan Bobic
On 27/05/2009 23:01, Andreja Babic wrote: I am using roundcube webmail as front end for dbmail imap server and after login it takes ages to open huge mailbox. I would appreciate if you know and tell me if there is any trick to increase speed of fetch on dbmail. Have you enabled Roundcube's

Re: [Dbmail] LDAP Schema

2009-05-22 Thread Gordan Bobic
09:31:36 +0200, Paul Stevens p...@nfg.nl wrote: Gordan Bobic wrote: USER_OBJECTCLASS = top,account,dbmailUser Other than the fact that I can't seem to add the object class to an existing user to a class violation somewhere. :-/ then you are most likely missing a required attribute

[Dbmail] Migration to LDAP with Postfix

2009-05-22 Thread Gordan Bobic
I'm currently using DBMail in standalone mode, and my Postfix domain and recipient maps are as follows: main.cf: mydestination = $myhostname, localhost.localdomain, localhost, mysql:/etc/postfix/sql-domains.cf local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf proxy:unix:passwd.byname

Re: [Dbmail] Migration to LDAP with Postfix

2009-05-22 Thread Gordan Bobic
ldapmodify and perform CRUD operations on domains and users. Gordan Bobic wrote: I'm currently using DBMail in standalone mode, and my Postfix domain and recipient maps are as follows: main.cf: mydestination = $myhostname, localhost.localdomain, localhost, mysql:/etc/postfix/sql

[Dbmail] LDAP Schema

2009-05-21 Thread Gordan Bobic
Hi, Can anyone confirm if this is the most up to date LDAP schema that should be used with 2.2.11? http://svn.ic-s.nl/websvn/filedetails.php?repname=DBMailpath=%2Ftrunk%2Fdbmail%2Fdbmail.schemarev=1828sc=0 Thanks. Gordan ___ DBmail mailing list

Re: [Dbmail] LDAP Schema

2009-05-21 Thread Gordan Bobic
Feally wrote: See - http://git.dbmail.eu/cgit/cgit.cgi/paul/dbmail/tree/dbmail.schema?h=dbmail_2_2 We no longer use svn. I'm not sure as to how correct this schema is, but it should be better than what that old svn version shows. -Jon Gordan Bobic wrote: Hi, Can anyone confirm

Re: [Dbmail] LDAP Schema

2009-05-21 Thread Gordan Bobic
Jonathan Feally wrote: [...] You should have also read README.ldap from the tarball. Indeed I did, but the documentation isn't exactly extensive. :( Gordan ___ DBmail mailing list DBmail@dbmail.org

Re: [Dbmail] LDAP Schema

2009-05-21 Thread Gordan Bobic
Aaron Stone wrote: Please read the DBMail config file's [LDAP] section. It is designed to interact with essentially arbitrary schemas, you simply tell it what the field names are it'll use them. You are encouraged to use your existing schema as much as possible. There's no need to convert

Re: [Dbmail] replication

2008-06-12 Thread Gordan Bobic
James Greig wrote: Hi, I've probably asked this before however can someone remind me why mysql master-master (innodb) replication is not recommend with dbmail? It's not recommended with anything. By the very nature of it, there is a potential very nasty race condition inherent in

Re: [Dbmail] replication

2008-06-12 Thread Gordan Bobic
could use it with pop3 and lmtp without a problem. On Thu, 2008-06-12 at 18:56 +0100, Gordan Bobic wrote: James Greig wrote: Hi, I've probably asked this before however can someone remind me why mysql master-master (innodb) replication is not recommend with dbmail? It's not recommended

Re: [Dbmail] replication

2008-06-12 Thread Gordan Bobic
Paul J Stevens wrote: I've probably asked this before however can someone remind me why mysql master-master (innodb) replication is not recommend with dbmail? It's not recommended with anything. By the very nature of it, there is a potential very nasty race condition inherent in multi-master

Re: [Dbmail] replication

2008-06-12 Thread Gordan Bobic
James Greig wrote: Some good points raised on the subject. I thought it might spark a few posts. Just so people are aware, i've currently setup two remote postfix/dbmail machines Server 1 (postfix + dbmail + mysql) server 2 (postfix + dbmail + mysql) Both in master-master replicating and