Re: [Dbmail] problems (with empty physmessages)

2007-07-25 Thread Michael Monnerie
On Mittwoch, 25. Juli 2007 Michael Monnerie wrote: > In dbmail-2.2.6 or so The rc1 I meant of course. # dbmail-util -V This is DBMail version 2.2.6-rc1 mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914

Re: [Dbmail] problems (with empty physmessages)

2007-07-25 Thread Michael Monnerie
age WHERE id = OLD.physmessage_id AND id NOT IN (SELECT physmessage_id from dbmail_messages); The rule is active, still I see again 31.349 physmessages hanging around. What could be the problem? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/84

Re: [Dbmail] MySQL server requirements

2007-07-20 Thread Michael Monnerie
efer LSI. http://www.tomshardware.com/2006/12/13/pci-express-sata-raid-controllers-for-smb-servers/page10.html http://www.tomshardware.com/2005/10/31/sata_spells_trouble_for_scsi_raid/page14.html http://www.tomshardware.com/2006/01/02/safer_6_for_raid_controllers/page11.html mfg zmi -- // Michael

Re: [Dbmail] dbmail LBL cluster report

2007-07-20 Thread Michael Monnerie
wo or more PostgreSQL servers would be active, it would be load balancing. I want to do an active-standby configuration to another server in another city, to have HA, so your concept interests me a lot. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at //

Re: [Dbmail] MySQL server requirements

2007-07-19 Thread Michael Monnerie
real hardware RAID controller and a bunch of quick disks should have no problems at all. I'd recommend the Areca SATA RAID controllers, with Western Digital 10k Raptor drives, they really rock. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel

Re: [Dbmail] dbmail LBL cluster report

2007-07-19 Thread Michael Monnerie
On Donnerstag, 19. Juli 2007 Alexander Benaguev wrote: > if anybody interesting, I'll post howto to wiki. I'm interested, but not sure if this can really work stable. How can it be without database support? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-managem

Re: [Dbmail] users and alias forwards together

2007-07-19 Thread Michael Monnerie
[EMAIL PROTECTED]   # Create a > local alias - "store" > dbmail-users -x [EMAIL PROTECTED] -t [EMAIL PROTECTED]   # Create > the external alias - "forward" Ah yes, aliasing the e-mail address to the real user, I really should have had this idea myself. :-( Thanks for tha

[Dbmail] users and alias forwards together

2007-07-18 Thread Michael Monnerie
k other questions, it saves some time *g* 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: EA39 8918 EDFF

Re: [Dbmail] Help on scoreboard

2007-07-13 Thread Michael Monnerie
On Freitag, 13. Juli 2007 Charles Marcus wrote: > a scoreboard... like they have in the big stadiums Yes, on the left side the number of bytes that came in, right the # of bytes that went out. I bet on "out" being the winner. SCNR2 *g* mfg zmi -- // Michael Monn

Re: [Dbmail] deleted users mails

2007-07-13 Thread Michael Monnerie
on and Paul about this issue. > Thanks Michael! You're welcome. 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" /

Re: [Dbmail] deleted users mails

2007-07-12 Thread Michael Monnerie
messages_with_mailbox AS ON DELETE TO dbmail_messages DO DELETE FROM dbmail_physmessage WHERE id = OLD.physmessage_id AND id NOT IN (SELECT physmessage_id from dbmail_messages); mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666

Re: [Dbmail] unused physmessages are not deleted when a user is deleted

2007-07-09 Thread Michael Monnerie
DELETE FROM dbmail_physmessage WHERE id = OLD.physmessage_id AND id NOT IN (SELECT physmessage_id from dbmail_messages); The PostgreSQL documentation says that rules can be optimized and thus much cheaper than triggers, so it could be good to use rules when possible. What do you think about

Re: [Dbmail] unused physmessages are not deleted when a user is deleted

2007-07-08 Thread Michael Monnerie
ge_gc" line 2 at SQL statement SQL-Anweisung »DELETE FROM ONLY "public"."dbmail_messages" WHERE "mailbox_idnr" = $1« SQL-Anweisung »DELETE FROM ONLY "public"."dbmail_mailboxes" WHERE "owner_idnr" = $1« It's not clear to me wh

Re: [Dbmail] unused physmessages are not deleted when a user is deleted

2007-07-07 Thread Michael Monnerie
FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages); DELETE 0 Should I file it as a bug report? It's more like a feature. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ide

[Dbmail] dbmail IMAP not saying "quota full"

2007-07-07 Thread Michael Monnerie
reached"? I don't know if that's possible, just a recommendation. 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" // F

Re: [Dbmail] unused physmessages are not deleted when a user is deleted

2007-07-06 Thread Michael Monnerie
On Samstag, 23. Juni 2007 Michael Monnerie wrote: > DELETE FROM dbmail_physmessage WHERE id NOT IN >      (SELECT physmessage_id FROM dbmail_messages); > > it took 808609.896 ms to run, still quite long, but much faster than > the previous statement :-). The VACUUM ANALYZE afterw

[Dbmail] sievecmd - what does it do exactly?

2007-07-05 Thread Michael Monnerie
all others (or is it possible to let 2 scripts active?) dbmail-sievecmd checks uploaded scripts, could we do this easily ourself? Otherwise we'll skip this, as the vacation script is fairly easy, doesn't need checking I guess. mfg zmi -- // Michael Monnerie, Ing.BSc- htt

Re: [Dbmail] Feature #616

2007-06-29 Thread Michael Monnerie
On Freitag, 29. Juni 2007 Jorge Bastos wrote: > DecimalHi Aaron, Jorge, why do your e-mails always start with "Decimal"? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key:

Re: [Dbmail] Spamfilter for postfix lmtp.

2007-06-29 Thread Michael Monnerie
on another (virtual) machine than dbmail. We found there are lots of advantages in splitting services to VMs, like performance tuning or moving to other hardware, as well as security. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at //

Re: [Dbmail] new mails only with button send/receive

2007-06-27 Thread Michael Monnerie
On Mittwoch, 27. Juni 2007 Uwe Kiewel wrote: > Is this behavior related to the imap server or to the client? This is the IDLE functionality, see thread "imap IDLE support" started on 17.6.2007 from Paul J Stevens. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-

Re: [Dbmail] sieve script error message

2007-06-26 Thread Michael Monnerie
On Dienstag, 26. Juni 2007 Paul J Stevens wrote: > Maybe a simple user attribute on the dbmail_users table That's what I thought of, but Aaron said thats not possible ATM. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846

Re: [Dbmail] sieve script error message

2007-06-26 Thread Michael Monnerie
provide customers with filter rules, so they should never receive an error anyway, and if, so they can report to us. Powerusers who write their own scripts get a warning if they make bullshit, so no problem there too. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at

Re: [Dbmail] Bug in dbmail-sievecmd?

2007-06-26 Thread Michael Monnerie
it didn't work out. We just finished our web interface for user administration. Users can select start/enddate, subject and text of a vacation, and we generate the script and upload it. A clear definition of how we could find out if the command was OK or not is definitely important :-) mf

Re: [Dbmail] Bug in dbmail-sievecmd?

2007-06-26 Thread Michael Monnerie
On Dienstag, 26. Juni 2007 Michael Monnerie wrote: > Shouldn't that activate script "testscript"? > Script "testscript" doesn't even exist... BTW, it did't even upload defaultscript. Should there be an error message? mfg zmi -- // Michael Monnerie, Ing.

[Dbmail] Bug in dbmail-sievecmd?

2007-06-26 Thread Michael Monnerie
cript "testscript"? Script "testscript" doesn't even exist... 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 --imp

Re: [Dbmail] sieve script error message

2007-06-26 Thread Michael Monnerie
by default off our system, but power users should be able to enable it. 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" /

Re: [Dbmail] compressing header info

2007-06-23 Thread Michael Monnerie
fterwards shrinked a lot of things down. 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: EA39 8918 EDF

Re: [Dbmail] compressing header info

2007-06-21 Thread Michael Monnerie
I have to ask again, because the number of physmessages and messages differs greatly on our server: On Mittwoch, 20. Juni 2007 Michael Monnerie wrote: > > No. It's a known bug there are some checks missing from the > > maintenance code. > > OK, should I > select * from

Re: [Dbmail] slow queries

2007-06-21 Thread Michael Monnerie
he 2.2.x series anyway. > Yes, that is the current situation where headervalues have a direct > relation with a physmessage. Like we discussed in the 'compressing > header info' thread, that will be changed during the 2.3 cycle. I'm loving it. *g* mfg zmi -- // Michael

Re: [Dbmail] slow queries

2007-06-19 Thread Michael Monnerie
;message-id' before having to look at the headervalues. This is especially true when you look at the number of rows: select count(*) from dbmail_headername; 2430 dbmail=> select count(*) from dbmail_headervalue; 4979350 Any chance this could be changed? Or are there many lookups that se

Re: [Dbmail] compressing header info

2007-06-19 Thread Michael Monnerie
TECTED], [EMAIL PROTECTED] So the whole text is word-by-word extended with @domain... *g* 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 --

Re: Fw: [Dbmail] imap IDLE support

2007-06-19 Thread Michael Monnerie
the caching, that might be better. In PostgreSQL, there's no in-memory table anyway, right? 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 |

[Dbmail] slow queries

2007-06-19 Thread Michael Monnerie
5:09 db.zmi.at postgres[6513]: [3-4] status IN (0,1) AND headername ILIKE 'MESSAGE-ID' AND headervalue ILIKE '%<[EMAIL PROTECTED]>%' Jun 19 12:15:09 db.zmi.at postgres[6513]: [3-5] ORDER BY message_idnr Where is such a SELECT coming from? Must be dbmail, but who cause

Re: [Dbmail] compressing header info

2007-06-19 Thread Michael Monnerie
21 +0200 (CEST) I did a quick look, they are stored in one entry, so probably this field should be varchar(3) or something. Anybody got the correct RFC for reference? And a select length(headervalue) from dbmail_headervalue order by length(headervalue) desc; shows there are a lot of long

Re: [Dbmail] Suppressing duplicates mails

2007-06-19 Thread Michael Monnerie
27;m wondering if these really have the same content though. 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: EA

Re: [Dbmail] Suppressing duplicates mails

2007-06-19 Thread Michael Monnerie
eive them anymore anyway. 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: EA39 8918 EDFF 0A68

[Dbmail] compressing header info

2007-06-18 Thread Michael Monnerie
m. When you're already working on compressing the contents, maybe there's an idea for this also? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http:/

Re: [Dbmail] Suppressing duplicates mails

2007-06-18 Thread Michael Monnerie
ssages (for automated e-mails). 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: EA39 8918 EDFF 0A68 ACFB 11B

Re: [Dbmail] Suppressing duplicates mails

2007-06-18 Thread Michael Monnerie
just dropped a duplicate message right on the floor. 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: EA39 8

Re: [Dbmail] converting dbmail from SQL_ASCII to UTF-8

2007-06-18 Thread Michael Monnerie
could we apply it? Did anybody do 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: EA39 8918 EDFF 0A68

[Dbmail] converting dbmail from SQL_ASCII to UTF-8

2007-06-17 Thread Michael Monnerie
mport. Anybody got some script? 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: EA39 8918 EDFF 0A68 ACFB

[Dbmail] On the status of IDN domains

2007-06-11 Thread Michael Monnerie
Does DBmail support IDN domains? Would I enter the e-mail address as [EMAIL PROTECTED] or in punicode form? I guess punicode would not work because postfix takes the values as-is, right? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666

Re: [Dbmail] dbmail_aliases

2007-06-11 Thread Michael Monnerie
rantee it works... But that's nice SQL foo, I didn't even dare to try 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 --impor

[Dbmail] 30 minutes delay

2007-06-10 Thread Michael Monnerie
eived: from power2u.goelsen.net (mail.goelsen.net [195.202.170.130]) by elnino.fastxs.net (Postfix) with ESMTP id 4FC9D1BDD3 for ; Sun, 10 Jun 2007 23:37:51 +0200 (CEST) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/

[Dbmail] status of eGroupWare integration

2007-06-10 Thread Michael Monnerie
configure the sender. I believe that would be nice for many users of eGW/dbmail 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 --impor

Re: [Dbmail] dbmail_aliases

2007-06-10 Thread Michael Monnerie
love to have the DB rock solid, after all, it's a bit important. ;-) And is we're developing a complete web interface for it, having dependencies guaranteed by the DB is much better than logic in external programs. Developers make errors, after all. mfg zmi -- // Michael Monnerie, Ing.BS

Re: [Dbmail] Current state of aliases

2007-06-09 Thread Michael Monnerie
rr). mine 2. 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: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F

Re: [Dbmail] Current state of aliases

2007-06-09 Thread Michael Monnerie
i.at [EMAIL PROTECTED] Then e-mail to all sub-domains of zmi.at would go to that address? 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/z

Re: [Dbmail] DBmail webmail app

2007-06-08 Thread Michael Monnerie
your e-mail locally. That way, it's only one extra lookup on DCC. 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" // Fi

Re: [Dbmail] DBmail webmail app

2007-06-08 Thread Michael Monnerie
DCC and so on before, maybe they've got their own ideas already. 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" // F

Re: [Dbmail] DBmail webmail app

2007-06-07 Thread Michael Monnerie
or so before giving them to the users, just to recheck them for spam checksums later. It sounds strange now, but when spam rates grow, things have to be done. Another option would be to reject e-mails containing inline pictures that are highly probable spam, and only allow attached pictures. mfg

Re: [Dbmail] Current state of aliases

2007-06-04 Thread Michael Monnerie
On Montag, 4. Juni 2007 Aaron Stone wrote: > This used to be the only form of catch-all. The username@ catch-all, > and the sub-domain catch-all (@.sub.domain) were both added more > recently (version 2.2.2, iirc). Great, I really love you(r product) ;-) mfg zmi -- // Michael Monnerie

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Michael Monnerie
could be good advertising :-) > Rebuiling of headers can be done quickly with message_part=0 This can still be done, if headerparts is a sub of message_part=0 mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.yo

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Michael Monnerie
On Montag, 4. Juni 2007 Tom Allison wrote: > So if I add one line at the end of a word doc, this will be > considered to be the same file unless the file format includes > something unique within the first 8MB of the file? No, as the size is also used for the primary key. mfg zmi -- /

[Dbmail] Current state of aliases

2007-06-03 Thread Michael Monnerie
le, right? Maybe there's a way to do this with the help of postfix? 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"

Re: [Dbmail] DBmail webmail app

2007-06-03 Thread Michael Monnerie
nt. Some old Pentium based e-mail servers with 128MB RAM will probably die on such a mail, but a current multi-core multi-gigabyte RAID based clustered and whatever else mail server will take it without a problem. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-mana

Re: [Dbmail] DBmail webmail app

2007-06-03 Thread Michael Monnerie
about copying bytes. No real processing power required for that. If you'd tell me that *mail clients* have problem with big files, I agree. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // P

Re: [Dbmail] DBmail webmail app

2007-06-03 Thread Michael Monnerie
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: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6

Re: [Dbmail] DBmail webmail app

2007-06-03 Thread Michael Monnerie
w of a size that can't be handled? At least 100MB/mail is no problem here. 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&quo

Re: [Dbmail] dbmail-util extension, was: Just a question

2007-06-01 Thread Michael Monnerie
n did a vacation where users can define start/end dates, that's pretty nice and people love it already. 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/

Re: [Dbmail] dbmail-util extension, was: Just a question

2007-06-01 Thread Michael Monnerie
n (select a.alias from dbmail_aliases as a left join dbmail_users as b on (a.deliver_to = b.user_idnr) where char_length(a.deliver_to) = 4 and a.alias=b.userid); mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas.

Re: [Dbmail] Here we go again

2007-06-01 Thread Michael Monnerie
s? Then I could test, still have some imapsync to do during the next days. 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" /

Re: [Dbmail] DBmail webmail app

2007-06-01 Thread Michael Monnerie
the system, but then again, computers are made for this :-) mfg mzi -- // 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:

Re: [Dbmail] Umlaut in Vacatio text (was: Vacation auto-responder)

2007-06-01 Thread Michael Monnerie
. That's why I changed my db to latin1 then. Is utf8 better now? Then I'd like to switch again... mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.a

Re: [Dbmail] DBmail webmail app

2007-06-01 Thread Michael Monnerie
rformance is increased a lot (using the cache more efficient), and by searching for references to it you can do nice statistics (which files are used how often...). I'd love to make stats "we saved 16GB storage just for this .ppt". mfg zmi -- // Michael Monnerie, Ing.BSc-

Re: [Dbmail] DBmail webmail app

2007-06-01 Thread Michael Monnerie
ho actually uses PGP (except me ;-)? End users often believe that if they make a signature where they write "this is top secret", that the computer automatically decides to take care of that. We've even had bio-pharma companies storing "top secret" documents on FTP.

[Dbmail] Re: Vacation in dbmail

2007-06-01 Thread Michael Monnerie
te it, look with dbmail-sievecmd -l, this looks like: - script1 + vacation Where a "+" shows the active script. BTW, I'd suggest an improvement: dbmail-sievecmd -d should not require the name of the script, as there can be only one script active anyway. mfg zmi -- // Michael

Re: [Dbmail] Just a question

2007-06-01 Thread Michael Monnerie
t. 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: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserv

Re: [Dbmail] DBmail webmail app

2007-06-01 Thread Michael Monnerie
r A has the same checksum of "funny pic" from user B, and the DB makes a link for user B to "high secret attachment" of user A. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. /

Re: [Dbmail] Problems with Sieve

2007-06-01 Thread Michael Monnerie
g e-mail... 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: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 0

Re: [Dbmail] Umlaut in Vacatio text (was: Vacation auto-responder)

2007-06-01 Thread Michael Monnerie
On Donnerstag, 31. Mai 2007 Michael Monnerie wrote: > I use a sieve script like this: One problem with that: We have a webmail app to select which text to send. If I enter German Umlaut there (ö ä ü ß etc.), I don't have this in the mail. What should I do there? mfg zmi -- // Michael

Re: [Dbmail] Vacation auto-responder

2007-05-31 Thread Michael Monnerie
"my bloody text" ; Tested it, it works. 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" // Fingerp

Re: [Dbmail] Here we go again

2007-05-31 Thread Michael Monnerie
On Donnerstag, 31. Mai 2007 Andrea Brancatelli wrote: > I'm not using any guy. That's good, as that could be forbidden in your country ;-) SCNR mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.

Re: [Dbmail] How to copy passwords from Cyrus to dbmail

2007-05-31 Thread Michael Monnerie
On Dienstag, 29. Mai 2007 Michael Monnerie wrote: > I wrote a script to extract all users/pwds from cyrus and insert them > into dbmail. The encryption_type was set to "crypt", but still users > don't seem to be able to login. What does work? Found it, it was the implem

Re: [Dbmail] imapsync.

2007-05-29 Thread Michael Monnerie
#x27;/' --syncinternaldates \ --regextrans2 's/^user.//' --delete2 --expunge2 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&

Re: [Dbmail] dbmail-util

2007-05-29 Thread Michael Monnerie
On Dienstag, 29. Mai 2007 Michael Monnerie wrote: > Am I right that there's no way to re-compute the "curmail_size" for a > user or all users? That should be a dbmail-util switch. I'd need it > after using imapsync with a single user, and now I separate the >

[Dbmail] dbmail-util

2007-05-29 Thread Michael Monnerie
calculated. 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: EA39 8918 EDFF 0A68 ACFB 11B7 BA

[Dbmail] How to copy passwords from Cyrus to dbmail

2007-05-29 Thread Michael Monnerie
Did anybody do this? I wrote a script to extract all users/pwds from cyrus and insert them into dbmail. The encryption_type was set to "crypt", but still users don't seem to be able to login. What does work? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-manag

Re: [Dbmail] seperate lmtp and pop3

2007-05-29 Thread Michael Monnerie
ing the > database load. We're in the implementation phase of a much-extended dbmail. Once things calm down a bit, I'd like to share our db schema back, it would be nice to have it in dbmail per default. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-managemen

Re: [Dbmail] seperate lmtp and pop3

2007-05-29 Thread Michael Monnerie
can for sure be on a separate host. 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: EA39 8918 EDFF 0A68

Re: [Dbmail] supervisor password

2007-05-29 Thread Michael Monnerie
dmin.foo > pass supervisorpassword You can set ACLs to allow a user to read other mailboxes, but that's IMAP only I believe. There's a wiki page http://dbmail.org/dokuwiki/doku.php?id=shared-mbox mfg zmi -- // Michael Monnerie, Ing.BSc- h

Re: [Dbmail] monitoring message movement between mailboxes

2007-05-09 Thread Michael Monnerie
products will have in the future. On windows, there are integrated platforms that work together, while on Linux we sometimes suffer from the "one tool for one thing" idea. Nobody runs a mail server without SPAM checks nowadays, so why not integrate them

Re: [Dbmail] monitoring message movement between mailboxes

2007-05-02 Thread Michael Monnerie
e of the message could be saved. It should contain points (like from SpamAssassin) and the timestamp from when it was checked: // for postgres: points NUMERIC(5,2) checktime TIMESTAMP DEFAULT current_timestamp NOT NULL Now you can easily search for messages to recheck (which were checked within the

Re: [Dbmail] monitoring message movement between mailboxes

2007-04-30 Thread Michael Monnerie
On Freitag, 27. April 2007 12:24 Aleksander wrote: > Michael Monnerie wrote: > You should now use the patch provided by Paul. Yes, ASA there's the postgreSQL version. He only wrote about mysql/sqlite by now. > You can have different names for the spam folder, but then there'

Re: [Dbmail] monitoring message movement between mailboxes

2007-04-26 Thread Michael Monnerie
signatures arrive, or whatever. Can we find out whether a message from today was marked as SPAM, but then altered by the client to HAM status? Such messages shouldn't be marked as SPAM afterwards again, of course. mfg zmi -- // Michael Monnerie, Ing.BSc- http

Re: [Dbmail] Sieve scripts: current year and month

2007-04-26 Thread Michael Monnerie
ore good thing to associate with each > client. I use that field to assign domains by now :-) If you're interested, I could provide the schema, postfix select statements etc., because I would prefer this being standard dbmail stuff, rather than patching it during the next years 8-) mfg

Re: [Dbmail] smtp before pop3/imap

2007-04-26 Thread Michael Monnerie
ally improve security. 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: EA39 8918 EDFF 0A68 A

Re: [Dbmail] monitoring message movement between mailboxes

2007-04-26 Thread Michael Monnerie
e some developer feedback on it. 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: EA39 8918 EDFF 0A68 ACFB 1

Re: [Dbmail] Store and forwards

2007-04-26 Thread Michael Monnerie
kes it easier to check if we accept e-mail for a domain: virtual_mailbox_domains = pgsql:/etc/postfix/domains.sql and domains.sql is: query = SELECT domain FROM zmi_domains WHERE domain='%s' mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 9

Re: [Dbmail] Sieve scripts: current year and month

2007-04-26 Thread Michael Monnerie
e nice. Everybody wants their SPAM filtered a bit different... 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" // Finger

Re: [Dbmail] max messageblk size changeable?

2007-03-16 Thread Michael Monnerie
If that > benefit is contingent upon some feature we haven't implemented, > you're doing the right thing by waiting. I don't like cyradm, that's enough :-) We're currently developing our own admin code, maybe we will open that code then. It will be ISP capable s

Re: [Dbmail] max messageblk size changeable?

2007-03-15 Thread Michael Monnerie
50x512KB to store in messageblks. And to find and retrieve 50 blocks can't be that hard, especially when there's an index. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key:

[Dbmail] max messageblk size changeable?

2007-03-15 Thread Michael Monnerie
d it be better, performancewise, to increase the messageblks, or do I not have to care about that? I'd better not change the default, because with every upgrade I'd have to change it. But I need to prevent a performance problem. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-manag

Re: [Dbmail] DBMail Installations

2007-03-13 Thread Michael Monnerie
On Freitag, 9. März 2007 16:48 Eelco van Beek wrote: > We're supporting a platform of about 35.000 mailboxes for one of our >   clients And which hardware for this? mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/

Re: [Dbmail] msoutlook 2003

2007-03-07 Thread Michael Monnerie
big problem for people sending info e-mail to their customers. 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/zmi4.asc | gpg --import" // Fingerprint

Re: [Dbmail] shibbolising dbmail possible?

2007-03-01 Thread Michael Monnerie
g a customer just yesterday with a (Linux) Apache Server with a rootkit, I think trusting in anything is unsecure anyway :-) mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key:&

Re: [Dbmail] shibbolising dbmail possible?

2007-03-01 Thread Michael Monnerie
Or is that the idea behind that app? 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/zmi4.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 A

Re: [Dbmail] imapsync issues from cyrus to dbmail

2007-02-22 Thread Michael Monnerie
On Montag, 18. Dezember 2006 09:50 Paul J Stevens wrote: > Michael Monnerie wrote: > > Yes, it did then. Maybe that would be worth a Wiki entry? Should I? > > Can I? I think more (accurate) documentation would be nice. > > Please do. http://www.dbmail.org/dokuwiki/doku.php?i

Re: [Dbmail] Per user read status

2007-02-22 Thread Michael Monnerie
or "per folder" setting, so that you can have the normal behaviour per default, but define that for a certain user/folder it should be different. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0676/846 914 666 .network.yo

[Dbmail] imapsync and dbmail

2007-02-13 Thread Michael Monnerie
index > > for a message that doesn't exist > > That's a strange message for an append command since > appending a message doesn't need any searching or matching. > The message "Search completed..." comes from destination server, > server two. I don't

<    1   2   3   4   5   >