(cost=0.00..57162.37 rows=469537
width=0) (actual time=0.056..1019.980 rows=469683 loops=1)
Total runtime: 1574.676 ms
And that's just my home server, a XEN vm within a normal PC.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
on the previous value (which is normal output).
If I'm right, that's a bug and should be reported to Fedora.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc
commands are used. I'll try to find out if those
indices are of value, and include that in my sql cleanup patch ASAP.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http
On Dienstag 24 März 2009 Jonathan Feally wrote:
Testing the lists. I haven't gotten anything since 3/19.
Me too. Seems all are on vacation ;-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP
dbmail try to insert a value that exists already?
dbmail-util -by should only cache missing physmessages. The code
should be fixed there. If that needs a SELECT prior to INSERT or
whatever is in the coders hand ;-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
for
your reply.
Back to the original search: There is no subjectfield value in those 3
messages, so no subject gets inserted. And that makes dbmail-util never
successful in its cleanup. Maybe a subject should be inserted for
messages that don't have it?
mfg zmi
--
// Michael Monnerie
zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net
is pushing for, or database calls as you are.
Yes, and I'd like to help here, for that part that I can help with.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http
,
and now that my server allows them maybe I get everything/some mails,
but so far none from dbmail-dev.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net
the value comparison in dbmail, but
leaving it to the database makes perfect sense.
Good, please do that in the messageparts code also, as I guess that will
be the same behaviour then. :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
to save a big amount of storage space compared to cyrus
and dbmail-2.2 (the latter needing much more disk space than cyrus).
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s
. Maybe we can make it lightning fast until then
:-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A
, I would guess kmail is the problem then.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E
command, and see on our production system an
increase of backup time Mo-Fr, and on Sa we do dbmail-util -dp and
CLUSTER afterwards, that speeds up things dramatically. I'd like to know
how 2.3 behaves after a lot of input/deleted messages.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http
On Donnerstag 26 Februar 2009 Paul J Stevens wrote:
Michael Monnerie wrote:
On Dienstag 24 Februar 2009 Michael Monnerie wrote:
As we can drop dbmail_headervalue_3 index anyway, drop that 255
char field also, and store only the full headervalue. Use that
nice compressing technique Niki
On Dienstag 24 Februar 2009 Michael Monnerie wrote:
As we can drop dbmail_headervalue_3 index anyway, drop that 255 char
field also, and store only the full headervalue. Use that nice
compressing technique Niki implemented already, but without hash.
That might be more overhead than searching
On Dienstag 24 Februar 2009 Paul J Stevens wrote:
We need a good mimeparser, but gmime is proving to be an moving
target :-(
I hope your work with the devs of gmime is in a good shape :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
to
more accurate spam processing :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E
folders?
2) why do it in C not SQL?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14
-
tries to read message - bumm).
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12
errors are generally a good sign for the difference of SPAM or HAM, so
it's really needed.
If needed, add some only internally used headers, but always return the
original mail to the outside world.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65
the
unwanted tokens?
Why does dbmail parse that text at all? It must store it as-is. Why is
there any decoding or stripping?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s
the database too much ;-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
,opensuse-security-annou...@opensuse.org,cert-
advis...@cert.org,@us-cert.gov],
header :contains [list-id] [gallery-
announce.lists.sourceforge.net,twiki-
announce.lists.sourceforge.net] ) {
fileinto lists/security;
stop;
}
mfg zmi
--
// Michael Monnerie, Ing.BSc
) OR (acl.user_id = 100 AND acl.lookup_flag = 1) OR
(usr.userid = 'anyone' AND acl.lookup_flag = 1))
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
as well.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
On Samstag 21 Februar 2009 Jorge Bastos wrote:
Does anyone has a bigger one?
I have about 10GB in a single account, with 141 mailboxes and 226493
e-mails (average 46kb per mail).
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
(mailbox_idnr) where owner_idnr = your_user_idnr;
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E
mailbox2dbmail today and my dates are correct.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14
dbmail_users SET last_login = '2009-02-17 09:07:47' WHERE
user_idnr = 152
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint
that IMAP is bad, use Exchange server? My
collegue, who installs lots of PCs, just recently told be exactly that.
And I had to clarify that it's not IMAP that's broken, it's just
Outlook. But that's (not?) what Windows users/admins see...
mfg zmi
--
// Michael Monnerie, Ing.BSc- http
user_idnr = 152
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
Did this message get lost? I don't know as I didn't get any answer. And
it could be valuable for performance storage used.
On Montag 09 Februar 2009 Michael Monnerie wrote:
On Freitag 06 Februar 2009 Paul J Stevens wrote:
Interesting idea. VARCHAR for mysql can be 0x (65535) bytes
wide
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
On Freitag 13 Februar 2009 Paul J Stevens wrote:
Please do file a bug.
In as the Boeing Bug, number 767.
BTW: you can't select dbmail 2.2.11 in mantis, it's missing.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
, and then they have to be
regenerated, which fails.
So the bug is after make clean you can't compile because the man pages
sources report a problem. The solution to come around this is to simply
extract the tar again, then you can compile without problems.
Can anybody confirm?
mfg zmi
--
// Michael Monnerie
asciidoc etc installed.
That would have saved me some packages to install :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
On Mittwoch 04 Februar 2009 Michael Monnerie wrote:
I removed some lines from dbmail.conf.txt and the rest compiles
OK, I can live without the manpage and test 2.2.11 now. Still, needs
a fix.
Did nobody else have that problem with 2.2.11?
mfg zmi
--
// Michael Monnerie, Ing.BSc
function
Still dbmail returns several messages:
* SEARCH 3635587 (and about 20 other numbers)
104860 OK SEARCH completed
And those messages for sure do not contain what I searched for.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
. Or at least, if the max
possible would be long enough for a headervalue. What's the max here
anyway? 4KB? 64KB? Couldn't we just cut the headervalue at 4KB? After
all, this is only used for searching, right?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660
it be good to create a table version with two
columns name version where you write schema=2.2.10 or whatever? So
the scripts that upgrade the schema could verify what version we are on
and what to do to upgrade (to any desired version)?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http
old and new versions to debug.
Because anyway, if it's not atomic and the script breaks, you'll have a
mess in case of problems. That can't be solved automatically, right?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
version 2.3.5
And on upgrade, version becomes version_hist.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
On Mittwoch 28 Januar 2009 Paul J Stevens wrote:
Of course you'll need the suse equiv for those packages.
Yes, and the rest are the dependencies that got installed. I just wanted
to give a hint on what packages were installed because I needed the
files you listed.
mfg zmi
--
// Michael
apache2-utils-2.2.10-2.5 Di 13 Jan 2009 15:46:25
postgresql-devel-8.3.5-1.12 Di 13 Jan 2009 15:45:35
postfix-postgresql-2.5.5-6.8 Di 13 Jan 2009 15:45:35
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel
php5-dom-5.2.6-49.13
php5-ctype-5.2.6-49.13
apache2-2.2.10-2.5
php5-5.2.6-49.13
apache2-prefork-2.2.10-2.5
sqlite2-2.8.17-133.42
libmm14-1.4.2-16.64
apache2-utils-2.2.10-2.5
postgresql-devel-8.3.5-1.12
postfix-postgresql-2.5.5-6.8
mfg zmi
--
// Michael Monnerie, Ing.BSc- http
, and also with
dbmail+postgresql 8.3 on the same host. Why a named schema, and what
the hell's that?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc
smtp.decimal.pt (smtp.decimal.pt [195.23.114.76])
by elnino.fastxs.net (Postfix) with ESMTP id 762D31BD81
for dbmail@dbmail.org; Thu, 30 Oct 2008 18:07:24 +0100 (CET)
Seems to have been sent from [213.214.98.20] now.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http
On Dienstag 20 Januar 2009 Michael Monnerie wrote:
Stupidly the search gets started on every single folder search.
That should have been Stupidly the search gets started on every single
folder change of course.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
. I think it was only done because of a
bug somewhere, or and index that could not be created?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg
inserted the text in a
better place, it was confusing I see.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5
,
count(v.id) AS frequency
from dbmail_headername h
join dbmail_headervalue v on h.id = v.headername_id
group by h.id;
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas
$newuser --password2 $newpwd
--authmech2 LOGIN \
--skipsize \
--syncinternaldates
With the --exclude part some messages were not transferred.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
, at least
I didn't have that huge performance impact, it was only a little slow on
folder change sometimes.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at
);
ERROR: index row requires 18720 bytes, maximum size is 8191
8k is the default page size of PostgreSQL. And I don't know for the
other RDBMs, so staying at 255 is just OK ;-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
. Stupidly the search gets started on every single folder search.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED
as well. Compression would be
good, as you can see a single user can occupy dbmail, making sharing
nearly impossible (this search takes 60-90s, using 100% CPU on a single
core).
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
p (cost=0.00..7.89 rows=1 width=8) (actual
time=5.254..5.257 rows=1 loops=2)
Index Cond: (p.id = m.physmessage_id)
Total runtime: 92600.940 ms
(15 Zeilen)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
create patches for Paul? Or
would it be better I test things with 2.3? Would Paul want to have that
done? Or is it too early and you still need to code the big thing and
there's no time to optimize anyway, and commands will still be changed
greatly?
mfg zmi
--
// Michael Monnerie, Ing.BSc
entries for the whole
database.
Noted. More for that wiki entry perhaps?
Yep, is in it.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
most performance.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net
|^MIME-|^Content-Type|^Disposition-|^From|
^Cc|^Reply-|^Subject|^To|^DomainKey).*' --skipsize \
--delete2 --expunge2 \
--syncinternaldates /dev/null
But do not remember if it works correctly (but I'd guess so). May be
good as a starting point.
mfg zmi
--
// Michael Monnerie, Ing.BSc
I just wrote the wiki article for those who are interested:
http://www.dbmail.org/dokuwiki/doku.php?id=performance
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http
=passwd;
alter table dbmail_users drop passwd;
alter table dbmail_users rename p2 to passwd;
commit;
fixed in the code, btw.
Don't need to. ALTER TABLE .. COLUMN .. works perfectly.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
deleted the users already:
dbmail-util -ay
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E
On Mittwoch 17 Dezember 2008 Paul J Stevens wrote:
Michael Monnerie wrote:
I'm trying to optimize the db using the CLUSTER command from
postgres, which physically resorts records on disk according to an
index. The goal is to physically place records together on disk
which you might read
. BUT then the encryption+key has to be on the server, so in case
of a hacker attack it's still easy for the hacker to get db contents +
encryption tool+keys. And then I ask: what do you want to reach?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
point I hand-deleted the messages with above statement, that took some
seconds. A great performance benefit.
agreed. Michael, plz file a bug report for this so I wont forget
about this.
OK, bug #746.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660
=query_num_deleted_records();
return DM_EGENERAL;
}
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14
, 8
,9, 10)
That should help performance a bit. I just deleted some accounts with
220.000+ messages and about 8+ GB size, that's why it takes long.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas
die Nachricht Wer jetzt nicht zugreift - ist
selber schuld ! zurückrufen.
---
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s
that's fixed in 2.2.11rc?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12
On Dienstag, 7. Oktober 2008 Paul J Stevens wrote:
* 698: [IMAP daemon] PostgreSQL 8.3.1 can't execute query
Does that mean I need this rc2 to work with PostgreSQL 8.3? I'm planning
an upgrade from 8.1 to 8.3, are there any other problems to expect?
mfg zmi
--
// Michael Monnerie
zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver
the
first mail.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
, and move your mail via IMAP client
to that server.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38
but: A vacuum full analyze on a DB
of 16GB lasts about 2,75h here, but that is for the full DB.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg
. Is it possible you can help me here? Do
have a clou?
Thanks in advance,
Stef Bon
PS I've already setup stunnel on the server dbmail1server, to make it
possible to connect via ssl.
---
--
// Michael Monnerie, Ing.BSc- http
know you, Paul, have other
things to do - so a query log would be nice that we can share here, and
let the community optimize it. I'm sure there are some DB gurus on this
list :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
, but willing to share that log
for stats.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E
don't do this manually
until they receive the your account near over quota message.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
login for that PID.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
you must manually delete them from the menu. anybody knowing
an automated way, i would like to hear that
sorry for only typing small, my vmware just killed the special keys.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31
via the client
over IMAP. Of course this is no fun, but at least works as a quick
hack.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
that correctly? I use UTF8 everywhere.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7
{ return MSG };
Content-Type: text/plain; charset=utf-8
Subject:
and then it is UTF-8 and every umlaut is good. Sometimes it's just too
simple :-)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key
On Montag, 19. Mai 2008 Paul J Stevens wrote:
that sounds a lot like a mysql-101 question.
I think the OP uses phpmyadmin and doesn't understand mysql, and seeks a
way to create the dbmail db using phpmyadmin.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
. Fast enough and fully automatic.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7
.
The postfix users mailing list is of great help also.
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED
I
prevent this?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
be an error
back to the sender (looks unprofessional).
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: curl -s http://zmi.at/zmi.asc | gpg --import
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net
from people who
forward *their* e-mail to another server which checks SPF. That's a bit
tricky and requires a bit time to understand, I've got headaches in the
first debug of a rejected SPF e-mail too...
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0676
101 - 200 of 443 matches
Mail list logo