Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-08 Thread Simon Buchanan
Actually your reply here made me re-think. We are using Percona 5.1, so upgrading to 5.5 then 5.6 - so downtime of 5mins. Then using  pt-online-schema-change to perform the ALTER the structure without blocking reads or writes. Works a treat! On 8 March 2016 at 10:21:45 PM, Andrea Brancatelli

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-08 Thread Simon Buchanan
Don’t forget this is mysql 5.1... On 8 March 2016 at 10:21:45 PM, Andrea Brancatelli (abrancate...@schema31.it) wrote: As a side node that will require longer time and more space than the ALTER TABLE Engine=InnoDB ROW_FORMAT_COMPRESSED, as you will have to read the table to write the dump,

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-07 Thread Simon Buchanan
base sizes where no enough space is left in other words: you should have upgraded years ago, can't remember when it was here, in the meantime switched to mariadb 5.5 and last year upgraded to mariadb 10 Ursprüngliche Nachricht ---- Von: Simon Buchanan <grem...@gmail.com>

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-06 Thread Simon Buchanan
A - BO - FI - PA ITALY Tel: +39. 06.98.358.472 Cell: +39 331.2488468 Fax: +39. 055.71.880.466 Società del Gruppo SC31 ITALIA   Il 2016-03-03 22:08 Simon Buchanan ha scritto:   On 3 March 2016 at 11:36:59 PM, Andrea Brancatelli (abrancate...@schema31.it) wrote:   Yes you can proceed easily with

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-03 Thread Simon Buchanan
of space to do the optimise, plus the tables are write locked whist this happens (is this correct?). Thats going to take a while on a 650GB table :) with live data on it. Does Alter table write lock as well? PS: also - what do i alter…  Simon

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-02 Thread Simon Buchanan
On 3 March 2016 at 9:42:03 AM, Reindl Harald (h.rei...@thelounge.net) wrote: Am 02.03.2016 um 21:30 schrieb Simon Buchanan:  > Is there any way to claw back this space?  first consider migartion to a more recent dbmail because  single-instance-storage will deduplicate mime-parts and so

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-02 Thread Simon Buchanan
arracuda and do an ALTER TABLE  Engine=InnoDB ROW_FORMAT=COMPRESSED? Thanks Simon On 3 March 2016 at 9:30:50 AM, Simon Buchanan (grem...@gmail.com) wrote: Hi All, We are running dbmail 2.2.18 for some legacy clients, the database is a debian default 5.1.73. We have around 260 mailboxes on this se

Re: [Dbmail] curmail_size vs innodb disk usage

2015-03-19 Thread Simon
the database size (even dump'ed) is 400GB. Surely dbmail does not have that much overhead in its database? Thanks! Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] curmail_size vs innodb disk usage

2015-03-19 Thread Simon
On Fri, Mar 20, 2015 at 9:31 AM, Reindl Harald h.rei...@thelounge.net wrote: Am 19.03.2015 um 21:16 schrieb Simon: What im trying to understand is why is the SUM of curmail_size is approx 110GB, yet the database size (even dump'ed) is 400GB. Surely dbmail does not have that much overhead

[Dbmail] curmail_size vs innodb disk usage

2015-03-18 Thread Simon
500GB and the mysql data space is just about full. Is this something that dbmail is not reporting correctly curmail_size or is this just innodb (e.g. does not reclaim the space). If the later, I would really appreciate some pointers to deal with reclaiming the space...? Many thanks, Simon

Re: [Dbmail] Memory usage with dbmail-2.2.18?

2012-09-12 Thread Simon
On 12/09/2012, at 7:26 PM, Paul J Stevens p...@nfg.nl wrote: On 09/12/2012 02:10 AM, Simon wrote: Hi There, We are using dbmail-2.2.18 on freshly minted debian squeeze for about 400+ mailboxes. The VM (esxi 5.0) it is running on has dual core Xeon E5645 @ 2.4GHz with 1GB RAM. I

[Dbmail] Memory usage with dbmail-2.2.18?

2012-09-11 Thread Simon
MAXCHILDREN = 200 MINSPARECHILDREN = 10 MAXSPARECHILDREN = 100 The issue we have with this new install is that it runs into SWAP and just (very) slowly fills the swap up.. its load average is 0.01-0.05. Any ideas here, or are my settings above to much? need more RAM? Simon

[Dbmail] Force all POP users to delete from server?

2012-09-11 Thread Simon
Hi There, I might be asking the question in the wrong way.. but is there any way to force pop users to delete messages from the server? e.g. no mater what they have as keep a copy message on server dbmail still deletes it? Thanks! Simon ___ DBmail

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-08-26 Thread Simon
On 25/08/2012, at 2:37 AM, Harald Leithner harald.leith...@itronic.at wrote: Hi Simon, I have similar problems in Mail.app 6.0 but I'm not sure if we have the sample problems ;-) I added my own account to mail.app (bad Idea adding a 5Gb mailbox) after downloading my mails (I'm still

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-08-22 Thread Simon
On 23/08/2012, at 2:55 AM, Paul J Stevens p...@nfg.nl wrote: On 08/22/2012 05:11 AM, Simon wrote: Sorry to keep asking.. but i really want to keep using dbmail (!!!), but cant with this client if there is not even an answer when it will be compatible with apple mail? I understand

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-08-22 Thread Simon
On 22/08/2012, at 9:57 PM, Harald Leithner harald.leith...@itronic.at wrote: Hi Simon, I'm running dbmail 3 commit 22b964b, I tested it with one of our Imac using Mail.app Version 5.2 (1278) and have no problem... so could you give me a version number of Mail.app? Version 6.0 (1485

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-08-21 Thread Simon
to dbmail3 for our core mail server platform.. many of our clients are mac users and use Mac Mail - asking them to change their mail program is not viable... so therefore we have to change our platform Thanks! Simon On 17/08/2012, at 5:38 PM, Simon grem...@gmail.com wrote: Hey Paul, Just

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-08-16 Thread Simon
Hey Paul, Just wondering if you got anywhere with this? We are happy to assist where ever we can... its only dbmail 3.0, 2.2.x is absolutely fine :) Thanks! Simon On Wed, Aug 1, 2012 at 11:05 PM, Paul J Stevens p...@nfg.nl wrote: On 07/05/2012 10:37 PM, Simon wrote: Hi There, We

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-07-09 Thread Simon
On 6/07/2012, at 9:54 AM, Simon wrote: On 6/07/2012, at 9:35 AM, Daniel Urstöger wrote: Hi Simon, I can feel your pain. One of my customers runs roughly 25-30 Apple clients (Macs, iPhones, iPads, etc.) against dbmail 2.x and I havent seen any problem like the two you described

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-07-05 Thread Simon
On 6/07/2012, at 8:40 AM, Reindl Harald wrote: Am 05.07.2012 22:37, schrieb Simon: Hi There, We are running dbmail 3.0.2 on debian squeeze for a client who all use Max OSX and Apple Mail for their client... there is a weird issue(s): 1). When sending email, the email does not show up

Re: [Dbmail] Drafts sent items with apple mail and dbmail 3.0.2

2012-07-05 Thread Simon
On 6/07/2012, at 9:35 AM, Daniel Urstöger wrote: Hi Simon, I can feel your pain. One of my customers runs roughly 25-30 Apple clients (Macs, iPhones, iPads, etc.) against dbmail 2.x and I havent seen any problem like the two you described. Yes - our main customer dbmail cluster (1500

Re: [Dbmail] DBMail insert email via SQL?

2012-06-22 Thread Simon
On 22/06/2012, at 10:19 PM, Reindl Harald wrote: Am 22.06.2012 07:47, schrieb Simon: Hi There, We have a CRM package that emails on behalf of our users, who are using DBMail (3.x) and IMAP for their email. I know its SQL so i know its techincally possible, but is there a correct way

[Dbmail] DBMail insert email via SQL?

2012-06-21 Thread Simon
Hi There, We have a CRM package that emails on behalf of our users, who are using DBMail (3.x) and IMAP for their email. I know its SQL so i know its techincally possible, but is there a correct way todo this? if so, pointers would be really appreciated thanks! Thanks! Simon

[Dbmail] 2_2-3_0.mysql run again?

2012-03-26 Thread Simon
Hi There, I was testing the 2_2-3_0.mysql script on our dbmail-2.2.17 database (115GB - running under a cloned VM of our live database), but the SSH connection died before it completed... can i just simply run the script again or should i just re-clone a new VM? Thanks Simon

Re: [Dbmail] dbmail3?

2012-01-29 Thread Simon
in batches at times when fewer clients are connected. dbmail-util is used for that -M:: migrate legacy 2.2.x messageblks to mimeparts table. -m limit:: limit number of physmessages migrated. Default 1 per run. Cool - so once all working, we can do things bit by bit. Nice. Simon

Re: [Dbmail] dbmail3?

2012-01-25 Thread Simon
On 26/01/2012, at 4:18 PM, Reindl Harald wrote: hi i hope all is well with paul! DBMail 3.0.0 final release candidate 2011-08-15 is there a plan for the final version? Yes - i would like to know this as well :) ___ DBmail mailing list

[Dbmail] Log IP address without TRACE_SYSLOG = 4?

2011-11-03 Thread Simon
Hi There, Is there anyway to log the IP address of the pop and imap connections without increasing TRACE_SYSLOG up to 4? DBmail 2.2.17 on debian squeeze BTW. Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin

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

2011-11-02 Thread Simon
Hi There,We are running dbmail 2.2.17 on a debian squeeze VM. It has two VCPUs and 1GB of RAM. Up until today it was connected to our old mailstore mysql VM (debian lenny, mysql 5.1, 2 GB RAM). Over the past couple of weeks we have been syncing mail (using imapsync - don't ask.) to our new

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

2011-11-02 Thread Simon
.. and it has settled down to normal now :) Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

[Dbmail] MySQL config for dbmail

2011-10-31 Thread Simon
to assist with mysql config to best utilise the resources of the new VM? Current my.conf is http://www.nzlocal.com/simon/dbmail_my_conf.txt Many Thanks!!! Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman

[Dbmail] Backups with 100GB mail

2011-10-13 Thread Simon
platform for our clients. Any feedback is very welcome! Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

[Dbmail] 2.2.17 3? (need to migrate to new mysql server, should i upgrade?)

2011-09-06 Thread Simon
Hi There, We need to migrate our 80+GB of mail over to a new mysql server (old and new servers are 5.1 on 64bit debian squeeze). We are doing this with imapsync. Is it worth upgrading to dbmail 3 at the same time? Its still rc, but that might change soon? Simon

Re: [Dbmail] dbmail-util questions

2011-09-05 Thread Simon
? * stop live/vm server * rsync of new mysql-datadir to the live-server * start services/mysql on the liveserver All good with the last 3... BTW: Thank you for your replies. Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl

[Dbmail] imapsync with dbmail

2011-09-05 Thread Simon
LOGIN --sep1 '/' \ --host2 HOST2 --user2 USER1 --authuser2 USER1 --password2 PASS1 --authmech2 LOGIN This seems to work with a basic IMAP mailbox with a couple of messages in it and some folders etc… but is there anything that might muck up with larger mailboxes/messages? Thanks Simon

[Dbmail] dbmail-util questions

2011-08-29 Thread Simon
birds!). Is this a normal process? Is there any changes or a different way of doing this so that the mail will continue to flow thru? Thanks Simon dbmail-util -ay output: # cat dbmail-util.log Repairing DBMAIL messageblocks integrity... Ok. Found [0] unconnected messageblks. Repairing DBMAIL

Re: [Dbmail] dbmail-util questions

2011-08-29 Thread Simon
for the quick reply... i had thought it might be something like this. 2GB RAM on the MySQL box with the following: http://www.nzlocal.com/simon/mysqlconf.txt Simon___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman

Re: [Dbmail] dbmail and debian squeeze

2011-06-30 Thread Simon
On Wed, Jun 29, 2011 at 11:50 AM, Schattenfell p...@michael-neubert.de wrote: Hello Simon, I recommend you to use DBMail 2.2.17 or the new DBMail 3.0 RC2. I also tested 2.2.11 with Debian but there were some really annoying bugs relating IMAP daemon in this old release (IMAP daemons

[Dbmail] dbmail and debian squeeze

2011-06-23 Thread Simon
dbmail-2.2.17.tar.gz? Many thanks! Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

[Dbmail] DBmail ical (OT a bit)

2011-03-16 Thread Simon
in a direction that works? Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

[Dbmail] IMAP dies after a couple of mins

2010-11-21 Thread Simon
to server A works with no issues. Any ideas on how to go about solving this one? Many thanks, Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] IMAP dies after a couple of mins

2010-11-21 Thread Simon
Solved! MAXCHILDREN was set to low (default setting) On Mon, Nov 22, 2010 at 3:20 PM, Simon grem...@gmail.com wrote: Hi There, We added a new server (B below) to our mail config... So now we have: A) DBMail 2.2.11 on debian etch (also running mysql 5.0.32) B) DBMail 2.2.15 on debian lenny

[Dbmail] 2 DB mail servers to one mysql server

2010-11-17 Thread Simon
see any issues here? Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] IMAP quick resync?

2009-09-17 Thread Simon Gray
George Vieira wrote: Hey Shane, I'm looking for a way to rsync mail to a second server for mail migration.. I've worked out how to have multiple servers serving the same domain so you could have users in different locations and either mail server acting as a MX to the other for failover

Re: [Dbmail] MySQL tweaks?

2009-09-15 Thread Simon Gray
Michael Monnerie wrote: Note: Everybody who care about their data, you should leave this setting on it's default 1: innodb_flush_log_at_trx_commit=1 Also, this will only affect writes - rather than reads. S ___ DBmail mailing list

Re: [Dbmail] MySQL tweaks?

2009-09-15 Thread Simon Gray
Jonathan Feally wrote: Simon Gray wrote: Michael Monnerie wrote: Note: Everybody who care about their data, you should leave this setting on it's default 1: innodb_flush_log_at_trx_commit=1 Also, this will only affect writes - rather than reads. If you

Re: [Dbmail] MySQL tweaks?

2009-09-14 Thread Simon Gray
Ken D'Ambrosio wrote: Hey, all. I've got a bajillion e-mails in my e-mail. (I'm using dbmail for archiving.) I don't care about disk space -- I've got it to throw away. But searches take close to 5+ minutes. Any clues on indexing, etc., that might be appropriate? -Ken How much

[Dbmail] Calculate mailbox size?

2009-08-05 Thread Simon
Hi There, We have a external client management app that we would like to be able to calculate the size of a dbmail mailbox with a SQL query. Can anyone give me some pointers here to get this right please? Thanks Simon ___ DBmail mailing list DBmail

Re: [Dbmail] External forwards piped out to a command

2009-03-12 Thread Simon
On Thu, Mar 12, 2009 at 10:01 PM, Paul J Stevens p...@nfg.nl wrote: Simon wrote: An assistance would be greatly apprectiated! Show me the code. Thanks Paul.. The code for /usr/local/autoresponder/autoresponder.php? I have removed all the PHP that we currently have in the scipt to make sure

Re: [Dbmail] Postfix DBMail 2.2 (lost connections)

2009-03-11 Thread Simon
On Thu, Mar 12, 2009 at 7:29 AM, Paul J Stevens p...@nfg.nl wrote: Simon wrote: Hi There, After our forced upgrade of the os and dbmail from stage/dbmail_2.0 to etch/dbmail_2.2 we are seeing this sometimes in the mail filter log: Mar 11 17:32:21 mail-in1 postfix/qmgr[31948]: BAE4B482F9

Re: [Dbmail] Forced upgrade from 2.0 to 2.2

2009-03-11 Thread Simon
On Thu, Mar 12, 2009 at 7:27 AM, Paul J Stevens p...@nfg.nl wrote: Aleksander Kamenik wrote: Simon wrote: I have read various things, but it would be good to get the correct thing todo here please? First check your database settings. Default collation was latin/swedish for mysql I think

Re: [Dbmail] Postfix DBMail 2.2 (lost connections)

2009-03-11 Thread Simon
cause the issue? Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] Postfix DBMail 2.2 (lost connections)

2009-03-11 Thread Simon
On Thu, Mar 12, 2009 at 8:53 AM, Simon grem...@gmail.com wrote: On Thu, Mar 12, 2009 at 8:45 AM, Paul J Stevens p...@nfg.nl wrote: Looking at the logs I see: Mar 12 08:11:40 mail-store1 dbmail/lmtpd[3544]: Info:[delivery] pipe.c,send_mail(+144): opening pipe to [/usr/local/autoresponder

[Dbmail] External forwards piped out to a command

2009-03-11 Thread Simon
thru. Note that the /usr/local/autoresponder/autoresponder.php is owned by the dbmail user and is executable. An assistance would be greatly apprectiated! Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman

[Dbmail] Forced upgrade from 2.0 to 2.2

2009-03-10 Thread Simon
the migrate_from_2.0_to_2.2.mysql file, configuring dbmail for our environment and starting it? Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] Forced upgrade from 2.0 to 2.2

2009-03-10 Thread Simon
On Wed, Mar 11, 2009 at 12:44 PM, Simon grem...@gmail.com wrote: Hi There, Our dbmail 2.0 running on debian sarge was damaged last night. We are currently building a new VM with debian etch and dbmail 2.2. The innodb mysql database from the old server is just being recovered onto the new

Re: [Dbmail] Forced upgrade from 2.0 to 2.2

2009-03-10 Thread Simon
-by as well correct? Correct. Thanks Aaron, The VM has 2 x E5310 Xeon Cores @ 1.6GHz... and the ibdata1 file is approx 40GB.. so that upgrade script might take a while huh? Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman

Re: [Dbmail] Forced upgrade from 2.0 to 2.2

2009-03-10 Thread Simon
) that would be great to know. Any ideas rough approx time? 30mins, 30hours, 30 days? THanks Simon PS: WIll do on the reports. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] Forced upgrade from 2.0 to 2.2

2009-03-10 Thread Simon
occured. Please check log. I have read various things, but it would be good to get the correct thing todo here please? Thanks Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

[Dbmail] Postfix DBMail 2.2 (lost connections)

2009-03-10 Thread Simon
? Any pointers? Thanks, Simon ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] adding database rows and customize insert querys

2008-12-19 Thread Simon Gray
Cody Stewart wrote: I am trying to add some rows to the database for additional information to be stored and encrypting the body of the message. Can someone point me to the file that has the actual mysql insert query's. Why? Is this for archiving purposes? or do you plan on just storing the

Re: [Dbmail] dbmail on a VPS

2008-12-08 Thread Simon Gray
of ram handling 15-20gig dbmail db within mysql - handling about 30 imap users just fine. Yet, I have another box with 6gig of ram (raid 5 etc..) with 70gb dbmail db for about 60 heavy imap users and its struggling. Depends on the usage patterns of your users. HTH Simon

Re: [Dbmail] imapd error

2008-11-10 Thread Simon Gray
Ok, nothing to worry about. The \Recent flag on messages will be incorrect, but no information is lost. The culprit: Nov 6 14:38:58 mail4-core-2 dbmail/imap4d[15280]: Debug:[sql] dbmysql.c,db_query(+287): query [UPDATE dbmail_messages SET recent_flag = 0 WHERE message_idnr IN

[Dbmail] mail deletion flag after reading?

2008-10-06 Thread Simon Lange
in the util? it is a problem in pop3?! or maybe some co-problem between pop3 and imap daemon?! Simon ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

AW: [Dbmail] mail deletion flag after reading?

2008-10-06 Thread Simon Lange
they dont keep mails on the server at all?! Simon PS: i will create a situation i can log. otherwise there is too much garbage when lvl5 is running on a production server. ;) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Montag

Re: [Dbmail] Losing end of messages?

2008-08-19 Thread Simon Gray
=| /tmp/somefile HTH Simon ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] incomplete IMAP attachments with thunderbird 2.0.0.16 (20080708)

2008-07-29 Thread Simon Lange
Aleksander Kamenik schrieb: Simon Lange wrote: can anyone confirm this being a dbmail-issue?! Did this occur with thunderbird 2.0.0.14? 2.0.0.16 was very recently released. And do attachments of any size cause the problem, would even a 1 kilobyte sized attachment be downloaded only partly

Re: [Dbmail] incomplete IMAP attachments with thunderbird 2.0.0.16 (20080708)

2008-07-29 Thread Simon Lange
Will test it... will report here. Jesse Norell schrieb: Did this occur with thunderbird 2.0.0.14? 2.0.0.16 was very recently released. Have you read my initial post? I wrote Thunderbird 2.0.0.16 (20080708) ;) I'll interject and paraphrase the question, Thunderbird 2.0.0.16

AW: [Dbmail] need a link

2008-07-26 Thread Simon Lange
or error-messages? if so, which one? gosh, 7weeks and 5 years as linux administrator?! what have you done in these 5 years?! ;) SCNR Simon Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von David B. Gesendet: Sonntag, 27. Juli 2008 01:50 An: DBMail mailinglist Betreff: RE: [Dbmail

Re: [Dbmail] replication

2008-06-17 Thread Simon Gray
Paul J Stevens wrote: But there is another reason in the imap requirements: UID values must be strictly ascending within a mailbox. Rather than making the UID just an autoincrement, why not make it a function with time? Therefore as long as the servers are time sync'd (easy with ntp) you

Re: [Dbmail] replication

2008-06-17 Thread Simon Gray
Paul J Stevens wrote: Simon Gray wrote: Worth a thought or completely silly? Worth a thought *and* not-quite-silly but it still wont do. In fact I did an implementation of this once. There will still be ample opportunity for one server to store a UID that is below the MAX(uid). *Any

AW: [Dbmail] dbmail @ ohloh

2008-05-28 Thread Simon Lange
Okay, but you may take a site which does not force registration. ;) Otherwise you wont get a result which reflects the real usage. Simon __ UseTorrent - der sicherste, schnellste und umweltfreundlichste BitTorrent

Re: [Dbmail] DBMAIL grinds to a craw in production

2008-05-16 Thread Simon Gray
I'm not 100% sure, but I think these are MyISAM only. I think the roughly equivalent InnoDB setting is: innodb_buffer_pool = 1024M It is myisam only, use buffer_pool instead. Another thing that is worth doing is bypassing OS caching for table access because MySQL does it's own caching, and

Re: [Dbmail-dev] db.c/db_getmailbox_count - unions not using indexes correctly

2008-05-01 Thread Simon Gray
John Fawcett wrote: Simon I doubt that splitting the queries will change whether an index is used. The potential index on mailbox_idnr is not a good one when there are many rows corresponding to mailbox_idnr. Did you try to explain the separated queries? The behaviour should be the same

Re: [Dbmail-dev] db.c/db_getmailbox_count - unions not using indexes correctly

2008-04-29 Thread Simon Gray
mailboxes - Its just that I can see this becoming an issue in the future. Simon ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev

[Dbmail-dev] db.c/db_getmailbox_count - unions not using indexes correctly

2008-04-28 Thread Simon Gray
(2,1); } mb-exists = exists; mb-unseen = exists - seen; mb-recent = recent; What do you think? Simon ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev

AW: [Dbmail] Dummy pop3-server

2008-04-16 Thread Simon Lange
Good Idea, but i would prefer perl. No need for installing another interpreter if perl is already aboard. You may have a perl version? Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Marc Dirix Gesendet: Mittwoch, 16. April 2008 13:41

[Dbmail] Upgrading from 2.0.10-1 on Sarge to 2.2.10-1 on Etch

2008-04-04 Thread Simon
? My dbmail_messageblks table is currently 9.8GB and is mysqldump'ed each night, so i am going to use the nightly backup as a test for the new server. Thanks Simon ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo

AW: [Dbmail] Feature request: dbmail forwarding with SRS

2008-03-28 Thread Simon Lange
THUMB UP!!! Would be great. Although you can doit with your mta (e.g. exim). But a native dbmail implementation would be awesome! Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Michael Monnerie Gesendet: Freitag, 28. März 2008 19:38

AW: AW: [Dbmail] DBMail 2.2.10 second release candidate

2008-03-27 Thread Simon Lange
Okay, that wiped out any doubts. :) thanks. I just wanted to be sure about this. ;) Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Donnerstag, 27. März 2008 09:14 An: DBMail mailinglist Betreff: Re: AW

AW: [Dbmail] DBMail 2.2.10 second release candidate

2008-03-26 Thread Simon Lange
of 2.2.10. is there a plan to distribute a alter mysql script too? Im asking because what happens when in a future release you add/change features and has only the new scheme in mind forgetting the existing schemes? Inconsistency by accident? Know what I mean? So? Regards Simon -Ursprüngliche

AW: [Dbmail] symbian mail

2008-03-18 Thread Simon Lange
Had the same issue with my N95 8GB. Sometimes I see them all. Sometimes I see ONLY one Message although I KNOW that there are more. Simon Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Casper Langemeijer Gesendet: Dienstag, 18. März 2008 09:52 An: DBMail mailinglist

AW: AW: [Dbmail] DBMail version 2.2.10 release candidate

2008-03-10 Thread Simon Lange
(alias) lower(deliver_to)] Just some lines of dbmail-util... same for all binaries of dbmail. Dbmail-conf settings for tracelevel are completely ignored. Began with the patch. And now arrived in the rc1. Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [Dbmail] 2.3.2. users heads up

2008-03-10 Thread Simon Gray
Paul J Stevens wrote: Jorge Bastos wrote: I changed mine to 50M, wich will mean an attach of 50M, per message, correct?. No. That means a maximum of 50M per attachment, not per message. Are you storing the data straight in to a blob? or is it still base64 encoded? Is it is still

AW: AW: AW: [Dbmail] DBMail version 2.2.10 release candidate

2008-03-10 Thread Simon Lange
? ;) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Montag, 10. März 2008 12:00 An: DBMail mailinglist Betreff: Re: AW: AW: [Dbmail] DBMail version 2.2.10 release candidate Simon tracelevel has been deprecated since before 2.2.0

AW: [Dbmail] DBMail version 2.2.10 release candidate

2008-03-09 Thread Simon Lange
. ;) Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Freitag, 7. März 2008 14:11 An: DBMail mailinglist; DBMAIL Developers Mailinglist Betreff: [Dbmail] DBMail version 2.2.10 release candidate -BEGIN

AW: [Dbmail] (patch) Another case of duplicate keys (via dbmail-smtp)

2008-03-05 Thread Simon Lange
it be better to make dbmail more tolerant for human-errors for such a case? Just adding the field id to that unique key would solve the issue at once. What do you think? Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Peter Rabbitson

AW: AW: [Dbmail] (patch) Another case of duplicate keys (via dbmail-smtp)

2008-03-05 Thread Simon Lange
processings. And - personal: don’t like php very much. I prefer html4/ssi and cgi a lot more. ;) yeah im a oldschool dog. Regards Simon PS: yes, it’s a real old debate. ;) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet

AW: [Dbmail] (patch) Another case of duplicate keys (via dbmail-smtp)

2008-03-05 Thread Simon Lange
without patches, it compiles successful. Some new requirements?! Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Mittwoch, 5. März 2008 13:06 An: DBMail mailinglist Betreff: Re: [Dbmail] (patch) Another case

AW: [Dbmail] HMM got lmtp dupicate entries HOW and WHY?

2008-03-04 Thread Simon Lange
noticed when running dbmail util after 2.2.6rc1 - 2.2.9 was that dbmail killed 730 unconnected physmessages well, I wondered a bit about this but since im in the same stable tree with 2.2.9 I did not suspect dbmail doin something wrong... up to now no complains by customers. Simon

AW: [Dbmail] HMM got lmtp dupicate entries HOW and WHY?

2008-03-04 Thread Simon Lange
2008 11:47:49 +0100 x-UID: b92ee197-54d9-4dc8-a2b2-26975fa9f53a From: Constantin Film PresseService [EMAIL PROTECTED] To: Simon Lange [EMAIL PROTECTED] Date: 4 Mar 2008 11:47:49 +0100 Subject: DIE WELLE feiert Premiere in Berlin Message-Id: [EMAIL PROTECTED] X-DNSBL: 0 X-AntiSpam: Checked

[Dbmail] HMM got lmtp dupicate entries HOW and WHY?

2008-03-03 Thread Simon Lange
Mar 3 14:08:02 primary dbmail/lmtpd[21419]: Message:[serverchild] serverchild.c,PerformChildTask(+346): incoming connection from [127.0.0.1 (localhost)] by pid [21419] Mar 03 14:08:02 primary dbmail-lmtpd[21419]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate entry '[EMAIL PROTECTED]' for key

AW: [Dbmail] HMM got lmtp dupicate entries HOW and WHY?

2008-03-03 Thread Simon Lange
instance of dbmail running (imapd,pop3d,lmtpd,timsieved) and lmtp is exclusive storing mails (no dbmail-smtp running or using). Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Montag, 3. März 2008 15:42

AW: AW: [Dbmail] HMM got lmtp dupicate entries HOW and WHY?

2008-03-03 Thread Simon Lange
Log of lmtpd? Or any other processes as well? Im asking since lvl5 produces HUGE amounts of log ;) Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Montag, 3. März 2008 16:00 An: DBMail mailinglist Betreff

AW: AW: AW: [Dbmail] HMM got lmtp dupicate entries HOW and WHY?

2008-03-03 Thread Simon Lange
and sieve support. glib 1.2.10-595 glib2 2.8.1-3 gmime 2.1.16-5 regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Montag, 3. März 2008 17:10 An: DBMail mailinglist Betreff: Re: AW: AW: [Dbmail] HMM got lmtp

Re: [Dbmail-dev] multifoo architecture

2008-01-25 Thread Simon Gray
Paul J Stevens wrote: Simon Gray wrote: Do you have any plans for the db connection pooling as yet? Sure do. The plan is as follows: I'm well underway with making dbmail fully event-driven using libevent. This will enable dbmail daemons to handle a lot of clients simultaneously

AW: [Dbmail] Umlaut in password not working?

2008-01-25 Thread Simon Lange
Well a-z and 0-9 should be all he needs. löl is not a secure password anyway. Just tell him that special chars (which are öäüß) are not allowed in a password as they are not allowed in the localpart. Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im

AW: [Dbmail] Umlaut in password not working?

2008-01-25 Thread Simon Lange
chars in passwords. My 2 cents Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Daniel Urstöger Gesendet: Freitag, 25. Januar 2008 13:49 An: DBMail mailinglist Betreff: Re: [Dbmail] Umlaut in password not working? Hello, well, I just tried

Re: [Dbmail] amd64 packages

2008-01-25 Thread Simon Gray
Casper Langemeijer wrote: Hi Paul, I added deb http://debian.nfgd.net/debian stable main to my sources.list apt-get update says: Failed to fetch http://debian.nfgd.net/debian/dists/stable/main/binary-amd64/Packages.gz 404 Not Found There is no binary-amd64 in dists/stable/main I found

[Dbmail-dev] Re: [Dbmail] New idea for 2.3x, shared quotas [moved to dev list]

2008-01-24 Thread Simon Gray
Paul J Stevens wrote: The single-instance storage is pretty much done now. The next big milestone will be some form of database connection pooling so we can scale out the number of concurrent connected clients without draining the database backend. Paul, Do you have any plans for the db

AW: [Dbmail] Sieve Error

2007-12-29 Thread Simon Lange
Not the message itself was the topic of my posting - it was the ERROR! So some help would be usefull. Ignoring a informational message is not what I want. I want to eliminate the ERROR itself. You may want to reread my original post? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED]

  1   2   3   >