Hi,
How to compile my php with imap support while i am using dbmail-imapd ?
www.php.net/imap
--shah
Simon
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
!!!).
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
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
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
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
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
)?).
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
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
);
}
}
}
snap
You may want to download it since I dont 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
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
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
database server or you have lots of data to be
crunched you dont 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
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
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
.
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
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
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
You may not using cvs but u r using A cvs. ;)
The archive I did download didnt 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
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
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
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
!
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
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
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]
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
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
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
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
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
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
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
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
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
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
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
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
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
. ;)
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
(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
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
? ;)
-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
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
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
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
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
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
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
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
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
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
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
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
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
=| /tmp/somefile
HTH
Simon
___
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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>
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
: 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
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
.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
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
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
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
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
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
(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
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
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
201 - 298 of 298 matches
Mail list logo