RE: [Dbmail] How to compile php with dbmail-imapd support

2005-07-21 Thread Simon Gray
Hi, How to compile my php with imap support while i am using dbmail-imapd ? www.php.net/imap --shah Simon

RE: [Dbmail] FreeBSD keep-alive script ?

2005-09-13 Thread Simon Gray
This should work similarly under freebsd. The only real difference would be the dbmail startup script. Instead of /etc/init.d/dbmail, it'll be /usr/local/etc/rc.d/dbmail.sh snip I use a simple keep-alive script triggered from cron :-(... like thiz: #!/bin/sh

RE: [Dbmail] MySQL Connections

2005-09-13 Thread Simon Gray
eat up your mysql max_connections. There is a section on this in Jeremy Zawodny's high performance mysql -- http://highperformancemysql.com/ -- worth a read. HTH, S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Sent: 12 September 2005 08:14

RE: [Dbmail] dbmail-2.0.7 released

2005-09-13 Thread Simon Lange
in the MySQL (InnoDB) and Postgresql create_table files. How to apply this to the existing tables? that is what id like to know too. sum kind of upgrade.sql would ne nice. thanx Simon

RE: [Dbmail] Bind ip

2005-09-16 Thread Simon Gray
A dirty way might be to run 2 instances of dbmail with separate configs each on it's own ip? S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Glait Sent: 16 September 2005 14:50 To: dbmail@dbmail.org Subject: [Dbmail] Bind ip Hi ! I want BINDIP to

RE: [Dbmail] dbmail mysql ..

2005-10-26 Thread Simon Gray
I have a problem with mysql db ... InnoDB: Page may be an index page where index id is 1481853025 1498166642 InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 41223. InnoDB: You may have to recover from a backup. InnoDB: It is also possible that your operating InnoDB:

RE: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-26 Thread Simon Gray
Table dbmail_messageblks has almost 24Gb size (we have about 45000 emails each day!). So when OPTIMIZE TABLE dbmail_messageblks starts Mysql sets locking on this table and write operations delays while optimize process runnig. It has a very long time to parse 25Gb of data (MySQL creates

RE: [Dbmail] Execute Script when Mail is Received ...

2005-10-31 Thread Simon Gray
Morning Everyone, Hi! The reason for me asking is because not all people may have this option and I am working on a webmail interface application for dbmail that I would like to have message filtering as an option to people that use it, but to be able to do this some sort of script will have to

RE: [Dbmail] Execute Script when Mail is Received ...

2005-11-01 Thread Simon Gray
because I want filter options to be controlled by the user from the webmail interface ... You webmail interface can control this if you build it. All you need to do is find the user, apply any logic/filtering and deliver. Remember all you're doing is database access, could quite easily knock up a

RE: [Dbmail] Question (pop/imap over ssl)

2005-12-06 Thread Simon Gray
The only challenge in setting up stunnel is in obtaining a (self-signed?) certificate. And that very same challenge will not go away if and when dbmail acquired STARTTLS capabilities. Perhaps I am missing something: the tunnel is only active server side and joe-user need only click use ssl in

RE: [Dbmail] swiftMail 0.6.0 Alpha Released for DBMail

2005-12-12 Thread Simon Lange
looks nice on first view. thanx for ur work BUT security sensitive information in a XML FILE?!?! why not php?! its more secure and makes a htaccess obsolete, especially if htaccess cannot be used. best regards Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [Dbmail] swiftmail 0.6.0 Update

2005-12-12 Thread Simon Lange
syntax errors in the table creation if i use ur query from the INSTALL text. also: a fieldname from ?! and why ` instead of ' ?! Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erik Kristensen Sent: Monday, December 12, 2005 12:34 PM

RE: [Dbmail] Question

2005-12-14 Thread Simon Gray
Hi Jorge, I wonder, if i want to send a news letter, this is an example is just send an email telling that the server will be in mainteinence in day X at hour Y, how can i send an email to all dbmail users? Does it has anything to do with the user everyone that is in dbmail-users? How can

RE: [Dbmail] 2 MTA 1 DB

2005-12-14 Thread Simon Lange
We have 1 dbmail database on a cluster of 6 databaseservers. (mysql) srv1 does run lmtp exim pop3 and imap srv2 and the whole rest only lmtp and exim all servers are primary mta. works like a charm... Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

RE: [Dbmail] User - Alias Map and restrictions

2005-12-16 Thread Simon Lange
i recommend using exilist and exim for mailinglist management. yes, u need a mailing list with closed groups. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nataraj S Narayan Sent: Friday, December 16, 2005 1:53 PM To: dbmail@dbmail.org

RE: [Dbmail] Question (newsletter - Virtual - Virtusertable - ACLs)

2005-12-16 Thread Simon Gray
Uhm, my response was an answer not a question :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of M. J. [Mike] OBrien Sent: 14 December 2005 19:33 To: DBMail mailinglist Subject: [Dbmail] Question (newsletter - Virtual - Virtusertable - ACLs) Simon Gray

RE: [Dbmail] announce: dbmail-2.0.8

2006-01-26 Thread Simon Lange
to change their database-modell?! best regards Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens Sent: Thursday, January 26, 2006 2:10 PM To: DBMail mailinglist Subject: Re: [Dbmail] announce: dbmail-2.0.8 There are *no* changes

AW: [Dbmail] problem with LVS and MySQL cluster

2006-06-07 Thread Simon Lange
!!!). e.g. 3 servers: a b c a load balancing is done via dns round robin. If you want safe on fail, you may code a little wrapper/proxy. Not hard to do. Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Matthew Story Gesendet

AW: [Dbmail] Exim4 Configuration Issues

2006-06-07 Thread Simon Lange
What about using lmtp? We are using exim4 dbmail-lmtpd and it works like a charme... transport_dbmail: driver = smtp protocol = lmtp hosts = 127.0.0.1 allow_localhost return_path_add Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag

AW: [Dbmail] Mailquota like Unix Filesystem on the Roadmap

2006-08-02 Thread Simon Lange
it and use it. Another way is to use squirrelmail and using their imap-quota system. Works nice including warnings... :) Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Martin Hierling Gesendet: Mittwoch, 2. August 2006 17:53 An: DBMail

AW: [Dbmail] Vacation

2006-08-03 Thread Simon Lange
Dunno, but maybe their dbmail server throws a segfault if a mail arrives. :-) SCNR _ Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Jorge Bastos Gesendet: Donnerstag, 3. August 2006 15:22 An: DBMail mailinglist Betreff: [Dbmail] Vacation Is dbmail team in

AW: [Dbmail] Mailquota like Unix Filesystem on the Roadmap

2006-08-04 Thread Simon Lange
YOu will laugh but i already did post it into wiki many moons ago. ;) You may fetch it from: http://www.thecenter.at/index.php?name=UpDownloadreq=viewdownloaddetailsli d=773 In the wiki you find it under code donations... ;) Best regards Simon PS: its really a fast but good working program

AW: [Dbmail] DBMail and Sendmail

2006-08-04 Thread Simon Lange
)?). However, no offense just thanks for your contribution. :D Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Marc Dirix Gesendet: Freitag, 4. August 2006 13:30 An: DBMail mailinglist Betreff: Re: [Dbmail] DBMail and Sendmail

AW: AW: [Dbmail] Mailbox full + sieve - got a perlscript for it! use it if u want

2007-11-21 Thread Simon Lange
contact the mailbox-owner (via phone, letter, ...) Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Aaron Stone Gesendet: Mittwoch, 21. November 2007 19:36 An: DBMail mailinglist Betreff: Re: AW: [Dbmail] Mailbox full + sieve - got

AW: [Dbmail] Mailbox full + sieve - got a perlscript for it! use it if u want

2007-11-21 Thread Simon Lange
); } } } snap You may want to download it since I don’t know how the mailinglist will treat this mail. ;) http://www.simonlange.de/dbmail-quotacheck.tgz best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Aaron Stone

AW: [Dbmail] Mailbox full + sieve

2007-11-25 Thread Simon Lange
cron. ;) Simon Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Casper Langemeijer Gesendet: Sonntag, 25. November 2007 15:16 An: DBMail mailinglist Betreff: Re: [Dbmail] Mailbox full + sieve Hey Guys, I see everyone is very much going to enjoy this feature. I will too

AW: [Dbmail] dbmail quota cron job script

2007-11-29 Thread Simon Lange
don’t find it just give me a note. Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Administrator Beckspaced.com Gesendet: Donnerstag, 29. November 2007 13:00 An: dbmail@dbmail.org Betreff: Re: [Dbmail] dbmail quota cron job script

AW: [Dbmail] db server -- 64 bit, or 32 bit?

2007-11-29 Thread Simon Lange
database server or you have lots of data to be crunched you don’t want to hassle with 32bit boundaries if you have real 64bit power. ;) Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Aaron Stone Gesendet: Freitag, 30. November 2007 01:00 An: DBMail

AW: Re: AW: [Dbmail] Mailbox full + sieve - got a perlscript for it!useitif u want

2007-12-06 Thread Simon Lange
Nice to hear. So i save some time and spent it on some nightclubs. Wish me luck in relaxing my neurons. :) Cheers Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Aaron Stone Gesendet: Donnerstag, 6. Dezember 2007 23:18 An: DBMail

AW: AW: [Dbmail] Mailbox full + sieve - got a perlscript for it! use it if u want

2007-12-07 Thread Simon Lange
Great job aaron! Guess many ppl will love it. Best Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Aaron Stone Gesendet: Freitag, 7. Dezember 2007 09:50 An: DBMail mailinglist Betreff: Re: AW: [Dbmail] Mailbox full + sieve - got

[Dbmail] sieve not running anymore

2007-12-10 Thread Simon Lange
. Anyone?! Simon PS: as u can see its generated via smartsieve ___ Simon Lange IT Berater und Journalist http://www.simonlange.de image001.jpgBEGIN:VCARD VERSION:2.1 X-MS-SIGNATURE:YES N:Lange;Simon FN:Simon Lange TITLE:Consultant TEL;WORK;VOICE:+49

AW: [Dbmail] sieve not running anymore

2007-12-10 Thread Simon Lange
the alias. But its not the way I like it. ;) a defined reply plus errorcode would be more gentle. ;) Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Aaron Stone Gesendet: Dienstag, 11. Dezember 2007 06:51 An: DBMail mailinglist Betreff

AW: [Dbmail] DBMail 2.2.8 released

2007-12-12 Thread Simon Lange
Quotascript missing. In the cvs its in the contrib folder but in the 2.2.8 release its missing? Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Mittwoch, 12. Dezember 2007 14:06 An: DBMail mailinglist

AW: AW: [Dbmail] DBMail 2.2.8 released

2007-12-12 Thread Simon Lange
You may not using cvs but u r using A cvs. ;) The archive I did download didn’t contain the script. But im willing to take a third look. ;) Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Mittwoch

AW: AW: [Dbmail] DBMail 2.2.8 released

2007-12-12 Thread Simon Lange
Yep ur right. its in. did look for a folder. ;) Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens Gesendet: Mittwoch, 12. Dezember 2007 14:25 An: DBMail mailinglist Betreff: Re: AW: [Dbmail] DBMail 2.2.8 released Check

AW: [Dbmail] Re: DBMail 2.3.0 released

2007-12-17 Thread Simon Lange
Usually impossible, except that you try to hit this impossibility manual. -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Jorge Bastos Gesendet: Montag, 17. Dezember 2007 20:48 An: 'DBMail mailinglist' Betreff: RE: [Dbmail] Re: DBMail 2.3.0

AW: [Dbmail] Re: DBMail 2.3.0 released

2007-12-17 Thread Simon Lange
the optimized attachementstorage only affects those mails where ONE mail with ONE message-id has been sent to more than one recipient. Regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Jorge Bastos Gesendet: Montag, 17. Dezember 2007 21

[Dbmail] Sieve Error

2007-12-21 Thread Simon Lange
! See urself: snip require [fileinto,reject]; if anyof (address :contains [From] digitalpayment) { reject text: Küsst meinen pelzigen Hintern! Aber Eure Mails werden NICHT angenommen! . ; } /snap So I guess this error comes when the From field is formatted as snip Simon

AW: [Dbmail] enormous DB Traffic using imapsync

2007-12-21 Thread Simon Lange
that. Right? Best regards Simon -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Marc Dirix Gesendet: Freitag, 21. Dezember 2007 15:42 An: Patrick de Ruiter Cc: 'DBMail mailinglist' Betreff: Re: [Dbmail] enormous DB Traffic using imapsync Hmm, Looks like

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]

AW: [Dbmail] Sieve Error

2007-12-29 Thread Simon Lange
Still no answers to the error itself. Anyone? Is this a bug or do I oversee a mistake somewhere? Simon Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Simon Lange Gesendet: Freitag, 21. Dezember 2007 14:55 An: 'DBMail mailinglist' Betreff: [Dbmail] Sieve Error Sometimes

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] 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

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

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] 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: 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] 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: [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: 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] 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: [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

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

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] 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] 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] 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

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

[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] 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

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] 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] 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

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] 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] 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-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-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] 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-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-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>

[Dbmail-dev] Quota Bounce Message - Is there a way to customise?

2006-07-12 Thread Simon
Hi There, Is there a way to customise the bounce back if a quota is full, or is this a thing for postfix? Thanks Simon

[Dbmail-dev] Fwd: Quota Bounce Message - Is there a way to customise?

2006-07-13 Thread Simon
: Simon [EMAIL PROTECTED] Date: Jul 12, 2006 2:19 PM Subject: Quota Bounce Message - Is there a way to customise? To: DBMail mailinglist dbmail@dbmail.org, dbmail-dev@dbmail.org Hi There, Is there a way to customise the bounce back if a quota is full, or is this a thing for postfix? Thanks Simon

Re: [Dbmail-dev] Fwd: Quota Bounce Message - Is there a way to customise?

2006-07-14 Thread Simon
Thanks Paul, Is DBmail supposed to pass some sort of information back to postfix regarding the quota being reached?In this case im using postfixamavisdbmail. Thanks Simon On 7/13/06, Paul J Stevens [EMAIL PROTECTED] wrote: Simon, this is a postfix issue. Simon wrote: A quick update here

Re: [Dbmail-dev] [EMAIL PROTECTED]: [DBMail 0000057]: direct mailforwarding with [EMAIL PROTECTED]

2004-08-12 Thread Simon Cocking
.x branch still beta quality? There's no obvious way to know if 4.0.10 is production quality when 4.0.1 wasn't... I would _definately_ like to see Linux-style versioning adopted for dbmail. Simon. -- Simon Cocking [EMAIL PROTECTED] Network Operations -- MailGuard Pty. Limited Melbourne 68-72

Re: [Dbmail-dev] [EMAIL PROTECTED]: [DBMail 0000057]: direct mailforwarding with [EMAIL PROTECTED]

2004-08-12 Thread Simon Cocking
release schedule would be hugely beneficial. -- Simon Cocking [EMAIL PROTECTED] Network Operations -- MailGuard Pty. Limited Melbourne 68-72 York St South Melbourne VIC 3205 P +61 3 9694 SydneyLevel 39, 2 Park Street Sydney NSW 2000 P +61 2 9004 7889 Message protected by MailGuard: e

[Dbmail-dev] SnapperMail 2.0 compatibility / RFC adherence

2004-08-30 Thread Simon Cocking
SnapperMail is extremely particular about the RFCs.. Cheers, Simon. -- Simon Cocking [EMAIL PROTECTED] Network Operations MailGuard Pty. Limited Email anti-virus, anti-spam and content filtering Melbourne 68-72 York St South Melbourne VIC 3205 P +61 3 9694 SydneyLevel 39, 2 Park Street Sydney

Re: [Dbmail-dev] SnapperMail 2.0 compatibility / RFC adherence

2004-08-31 Thread Simon Cocking
in that code; I was confident I could remove the offending whitespace, but not that I wouldn't break something else in the process. However, I'll apply your patch, do some testing and let you know how it performs. Thanks, Simon. -- Simon Cocking [EMAIL PROTECTED] Network Operations MailGuard Pty

[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

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

[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

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

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

<    1   2   3