[Dbmail] separate anounce and security list

2006-07-26 Thread Casper Langemeijer
Hi All! Thanks for a great product! I'm going to use dbmail in a production environment in the near future and I like to be kept updated about security issues and new releases. I subscribed to this mailinglist, but what I really like is a very low-volume mailinglist only for security and new re

[Dbmail] sieve fileinto command

2006-08-14 Thread Casper Langemeijer
Hi guys, I built & installed 2.1.7 and have the following problem: When I activate the following sievescript require ["fileinto"]; if allof (header :contains "subject" "{spam?}") { fileinto "spam"; } My mails containing {spam?} are being put in my folder "spam" but marked deleted (an

Re: [Dbmail] sieve fileinto command

2006-08-14 Thread Casper Langemeijer
ust what i need (i think) > >This is done for every user right? >But if the user gets the email by POP3 (that is 99% of the users)? he will >never see the "spam" folder... how to resolve it in this situation? > >Jorge > >- Original Message - >From: "C

Re: [Dbmail] sieve fileinto command

2006-08-15 Thread Casper Langemeijer
I just installed SVN Trunk and... no probs... I'm sorry to have wasted your time! Op 14/8/2006 schreef "Casper Langemeijer" <[EMAIL PROTECTED]>: > >Hi guys, > >I built & installed 2.1.7 and have the following problem: > >When I activate the following

Re: [Dbmail] Webmail

2006-08-20 Thread Casper Langemeijer
I've used Squirrelmail but found it too slow, I've used Roundcube but it ate alot of CPU on my desktop and killed Internet Explorer after 10mins. Currently I use IlohaMail and I find it allright. So far its the fastest client I've used. It has quite a few bugs, but I fixed alot myself and added a

[Dbmail] purge with dbmail-utils

2006-08-28 Thread Casper Langemeijer
I'm not getting it... if I do: # dbmail-util -dp dbmail-util says: Opening connection to database... Opening connection to authentication... Ok. Connected. Counting messages with DELETE status... Ok. [0] messages have DELETE status. Counting deleted messages that need the DELETE status set...

Re: [Dbmail] purge with dbmail-utils

2006-08-29 Thread Casper Langemeijer
Hehehe... I'm sorry, my example was wrong, I've always included the -y switch. The notice is a good thing anyway :-) Even with the -y switch, it is still not working like I expected it to work. I just noticed that to fully delete an email you: - delete a message in outlook - press the purge but

Re: [Dbmail] purge with dbmail-utils

2006-08-30 Thread Casper Langemeijer
> > >so, at least me, in my example, i run a cron script once a day at night, 3 >ou 4 AM i don't know with: > >#!/bin/bash >/usr/local/sbin/dbmail-util -d -y >/usr/local/sbin/dbmail-util -p -y > > >and that's it > >Give it a try and tell me someth

Re: [Dbmail] purge with dbmail-utils

2006-08-30 Thread Casper Langemeijer
quot;bypass trash" >in squirrelmail > >then you have to do the -dy and next -py > >maybe Paul will explain this better than i > > >- Original Message - >From: "Casper Langemeijer" <[EMAIL PROTECTED]> >To: "DBMail mailinglist" >Se

Re: [Dbmail] purge with dbmail-utils

2006-08-30 Thread Casper Langemeijer
On 30/8/2006 "Jorge Bastos" wrote: >Yes but in the dbmail-util you're not right, at least in my point. > [.] >dbmail-util -dpy (delete then purge, but it doesn't folow this order) >it is going to purge and then delete > [.] >it's better to do separated That is just a matter of opinion. S

Re: [Dbmail] New ideas

2006-12-01 Thread Casper Langemeijer
I know this probably not within the scope of the original idea, but is libdbmail also going to have an API to the message base? A while back there was alot of talk about people writing apps that directly read and write the dbmail database. Could libdbmail be an interface to it? I really don't

[Dbmail] small feature request: allow_imap, allow_pop

2007-03-20 Thread Casper Langemeijer
Hi Paul, Aaron and others. I want to put a request for a small, but very nice feature down. I'd like to allow IMAP to some users, but not all of them. This because people using IMAP tend to use more resources than POP users. How about an `allow_imap` and `allow_pop` field in the `dbmail_users

Re: [Dbmail] small feature request: allow_imap, allow_pop

2007-03-22 Thread Casper Langemeijer
Nice! Sorry to have bothered you! Marc Dirix wrote: This is already possible with usermap. Please review README.usermap in the source tree. Marc Op 20-mrt-2007, om 9:43 heeft Casper Langemeijer het volgende geschreven: Hi Paul, Aaron and others. I want to put a request for a small, but

Re: [Dbmail] 'subjectfield' encoding bug

2007-08-07 Thread Casper Langemeijer
On Tue, 2007-08-07 at 15:29 +0400, umask wrote: > > > > For example we sent message with subject (next line): > > > > Fwd: =?windows-1251?b?zu/z4evo6u7i4O3gIO/w7uPw4Ozs4CBIaWdoTG9hZCAt?= > > > > 2007 > > > > In SQL select field 'subjectfield' we seen (next line): > > > > ?>?°???° ?

Re: [Dbmail] Mailbox full + sieve

2007-11-25 Thread Casper Langemeijer
Hey Guys, I see everyone is very much going to enjoy this feature. I will too, but I'd like you devvers to consider if it really should be part of dbmail itself. I use a commandline PHP script for this, others might use a Perl script. There are a lot of thing to configure about a script mentione

Re: [Dbmail] dbmail quota cron job script

2007-11-26 Thread Casper Langemeijer
Hi Becki, I don't get your script. If you already have a mysql connection to get the mailbox names, why don't you just query the mailboxsize and max size from mysql? Grtz, Casper On Mon, 2007-11-26 at 07:00 +0700, Administrator Beckspaced.com wrote: > hello, > > my name is becki and i'm using

Re: [Dbmail] dbmail quota cron job script

2007-11-29 Thread Casper Langemeijer
> smartest ... and was coded in a very short time. > > but after all it does its job successfully since a few years. > > by the way ... what query should i use to get the mail box size from the > database? sorry for asking just being terribly lazy ;-) > > all the best &a

Re: [Dbmail] DBMail 2.2.8 released

2007-12-21 Thread Casper Langemeijer
Hi Paul, I'm using an amd64 server with debian running dbmail. So far I've been using the debian testing repository, but I've noticed 2.2.8 has been out a while now and it isn't in debian testing (or experimental even) Is there going to be a amd64 debian package in the debian.nfgd.net repository

Re: [Dbmail] Multiple hosts - where to run sieve?

2007-12-21 Thread Casper Langemeijer
Hi Uwe, I'm curious: Why do you designate A,B and C a function? In my opinion setting them all up in the same configuration would be way easier maintenance wise and gives you something very nice in return: redundancy. Also, machines can be used to their full potential and planning is much easier

[Dbmail] usermap table

2008-01-21 Thread Casper Langemeijer
Hi All, A while back I asked how to restrict imap to be used only by certain users, Marc Dirix replied and told me to read README.usermap, and use the usermap table. I read the readme file and wiki entry, but find it very confusing. My goal is to deny imap by default, but enable it for specific u

Re: [Dbmail] usermap table

2008-01-22 Thread Casper Langemeijer
Hi Paul, Thanks for making this a lot more clear to me. To make the wiki-entry complete, (I'll put it in later) how is the score() pseudo function working? I'm assuming ANY is always lower than a specific login, 0.0.0.0 is lower than a specific ip, port 0 is lower than a specific port. In that o

[Dbmail] amd64 packages

2008-01-25 Thread Casper Langemeijer
n Fri, 2007-12-21 at 18:56 +0100, Paul J Stevens wrote: > I havent had it uploaded to debian.org. But it's in the stable repo on > nfgd.net. > > > > Casper Langemeijer wrote: > > Hi Paul, > > > > I'm using an amd64 server with debian running dbmail.

Re: [Dbmail] amd64 packages

2008-01-26 Thread Casper Langemeijer
Grtz, Casper On Fri, 2008-01-25 at 17:37 +, Simon Gray wrote: > 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 >

Re: [Dbmail] usermap table

2008-01-26 Thread Casper Langemeijer
Hi Paul, > >> > >> From this you can deduce that setting up the policy you want, you > >> shouldn't use sock_deny, but rather map ANY user to a non-existent > userid. > >> > >> login sock_allowsock_deny userid > >> ---

Re: [Dbmail] Can dbmail cope with 1.000 e-mails/s ?

2008-01-28 Thread Casper Langemeijer
On Mon, 2008-01-28 at 09:38 +0100, Paul J Stevens wrote: > That smells like POP3 access. Like Marc's suggestion, perhaps we should > offer a pop3-storage only mode (no headercaching, no envelope caching, > etc). But that would not be possible on a per-user basis, only on a > per-dbmail-instance b

Re: [Dbmail] mail encryption

2008-01-30 Thread Casper Langemeijer
Hi Sim, I think your management is coercing you to do something a lot op the techies on this mailinglist wouldn't want to implement, simply because from the technical point of view it has no added value. (except the perceived value by your management) If your management is this paranoia about con

[Dbmail] symbian mail

2008-03-18 Thread Casper Langemeijer
Hi All, My users report me that retrieving their email with their Symbian S60 phones (Among them Nokia E51 and Nokia E90) is not working properly. They only get one single mail per mail folder. This problem occurs in version 2.2.9, but not in 2.1 (svn Revision: 2065) I understand that is might

[Dbmail] Feature request: more caching

2008-04-24 Thread Casper Langemeijer
Hi Paul and others! I've been very busy making a webmail interface directly into the dbmail database backend, and that has given me some time to gather some thoughts on the table layout. For a typical email client there are to things that need to be optimized, which currently are quite slow: On

Re: [Dbmail] Feature request: more caching

2008-04-24 Thread Casper Langemeijer
Hi Paul, Thanks for your quick reply. On Thu, 2008-04-24 at 14:59 +0200, Paul J Stevens wrote: > > One is the messagecount (read messages and total) that are displayed for > > a dbmail_mailbox. Counting them everytime is quite a strain on the database. > > That's why in 2.3+ the dbmail_mailbox

[Dbmail] future 2.2 release

2008-10-06 Thread Casper Langemeijer
Hi Paul, Do you have plans to release 2.2.11? Currently I'm on 2.2.10. I've seen the rc1, but I need bug #725 fixed. Grtz, Casper ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] future 2.2 release

2008-10-06 Thread Casper Langemeijer
tware you write. The reason I'm asking this is just to know If I should do a git build or wait for the release. Grtz, Casper On Mon, 2008-10-06 at 10:11 +0200, Uwe Kiewel wrote: > Hi, > > Casper Langemeijer schrieb: > > Hi Paul, > > > > Do you have plans to re

Re: [Dbmail] Problem with outlook and pop3

2008-11-06 Thread Casper Langemeijer
Hi Giulio, I've seen microsoft clients give the username/password prompt when it was unable to connect. Check the amount of allowed pop3 or imap processes. Search for MAXCHILDREN in your dbmail.conf file. If you are using MySQL, check the max_connections setting in your my.cnf file too. Once I'v

[Dbmail] auto replies / vacation messages

2009-07-23 Thread Casper Langemeijer
Hi All, What is the correct way to implement out of office replies for dbmail 2.2? I see people on this list using sieve (vacation), but I've used an entry in dbmail_auto_replies, and I think (but am not sure) that I've seen that one work before. Anyway: It seems broken in the dbmail debian pack

Re: [Dbmail] Debian Lenny packages

2009-08-11 Thread Casper Langemeijer
Hi Paul, Are you aware that you are only building i386 packages, and you have an empty amd64 repo? http://debian.nfgd.net/debian/dists/lenny/main/binary-amd64/Packages is empty http://debian.nfgd.net/debian/dists/lenny/main/binary-i386/Packages is correct The directory http://debian.nfgd.net/deb

[Dbmail] dbmail-util physmessage integrity

2009-09-27 Thread Casper Langemeijer
Hi All, Recently I found the following behaviour in my cron logs, Repairing DBMAIL physmessage integrity... Ok. Found [156629] unconnected physmessages Sep 26 18:40:51 mail01 dbmail-util[13321]: Error:[sql] dbmysql.c,db_query(+290): [The total number of locks exceeds the lock table size] [DELETE

[Dbmail] Speeding up the upgrade process from 2.2 to 3.1

2014-09-15 Thread Casper Langemeijer
Hey All, I'm testing the upgrade path for my mailserver from 2.2.11 to the 3.1.17 on a staging server and I'm a little confused. I run 2_2-3_0.mysql over my 160GB production email database. http://git.dbmail.eu/paul/dbmail/tree/sql/mysql/2_2-3_0.mysql I'd like someone to confirm that 3_0_2-3

Re: [Dbmail] Speeding up the upgrade process from 2.2 to 3.1

2014-09-17 Thread Casper Langemeijer
On 15-09-14 13:55, Reindl Harald wrote: Am 15.09.2014 um 13:40 schrieb Casper Langemeijer: I noticed dbmail_messageblks data is never written into the dbmail_mimeparts, table. My guess is that the current dbmail code can still handle dbmail_messageblks, and conversion is not required that

Re: [Dbmail] dbmail on openSUSE 13.2 with mariaDB version 10.0.13

2014-11-27 Thread Casper Langemeijer
i heard people tend to switch to mariaDB? any thoughts on that topic would be more than welcome ;-) We switched production databases (2000 db's 40G-10K, totaling 650G) for our internally developed software to MariaDB and have found a few small issues we didn't expect. Most of them stem from a

Re: [Dbmail] Security alert: disable CRAM-MD5 if you don't use it

2014-12-20 Thread Casper Langemeijer
On 19-12-14 22:55, Paul J Stevens wrote: You should disable CRAM-MD5 in dbmail.conf if you store password encrypted. ehh.. how? by setting 'capability'? ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmai

Re: [Dbmail] Security alert: disable CRAM-MD5 if you don't use it

2014-12-20 Thread Casper Langemeijer
I imagined the capability string only was the advertised capabilities, so I checked the source. Nowhere in the dbmail source I see that CRAM-MD5 is actually disabled, but I could be missing the location. Could dbmail still authenticate a malicious client? ___

Re: [Dbmail] Segmentation faults in DBMail 3.2

2015-01-11 Thread Casper Langemeijer
On 11-01-15 19:21, Paul J Stevens wrote: Ok, Managed to reproduce the problem, and fixed it. Try the lastest snapshot to test this - really small fix http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_2 or wait for the next release. A quick: git branch -a --contains ba60583b leads me to

Re: [Dbmail] Database restore

2015-02-05 Thread Casper Langemeijer
On 05-02-15 15:11, Reindl Harald wrote: Am 05.02.2015 um 15:00 schrieb Curtis Maurand: Thanks, I'll give that a shot while i look at replicatuon which I've never been able to make work there is nothing difficult and is configured within 5 minutes I disagree, the learning curve is not 5 minute

Re: [Dbmail] curmail_size vs innodb disk usage

2015-03-19 Thread Casper Langemeijer
On 19-03-15 04:21, Simon wrote: If the later, I would really appreciate some pointers to deal with reclaiming the space...? As others suggested, optimize table (or the mysqloptimize command line utility) can help you 'reclaim' space. But you shouldn't use it unless you really need to becau

Re: [Dbmail] curmail_size vs innodb disk usage

2015-03-20 Thread Casper Langemeijer
On 19-03-15 21:16, Simon wrote: What im trying to understand is why is the SUM of curmail_size is approx 110GB, yet the database size (even dump'ed) is 400GB. Surely dbmail does not have that much overhead in its database? As Reindl stated, why still use dbmail 2.2 without the single-instance

Re: [Dbmail] Database access in version 3

2015-04-09 Thread Casper Langemeijer
On 08-04-15 11:15, Ralph Ballier wrote: I still use the version 2.2.18 because I have seen on the previous computer only MySQL 4 and not MySQL 5. A switch to the new version of MySQL is too risky to me. I know I'm not answering you question, but this needs to be said: You have your priorities

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-20 Thread Casper Langemeijer
I'm not sure this is related, and I probably should investigate further before posting this here, but in my setup, dbmail seems to break DKIM signatures. I've seen that mails from booking.com and facebook.com have broken DKIM signatures according to google's gmail, when forwarded by my mailserver.

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-21 Thread Casper Langemeijer
signature is calculated on the body and these headers. Therefore any modifications to these headers are an alteration of the message and cause DKIM to fail. I can imagine this could possibly break PGP/MIME, if it checks the integrity in a similar way. On Fri, Apr 20, 2018 at 6:14 PM Casper Lange

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-23 Thread Casper Langemeijer
ound message and what you get > > back from dbmail is harmful except the headers aded by lmtpd itself on > > top (which was also wrong, Return-Path before the patch i requested > > where on bottom while every hop touching a mail is supposed to add his > > headers on top and

Re: [Dbmail] will dbmail continue to be developed?

2019-02-21 Thread Casper Langemeijer
Hi All, The questions about the future of dbmail keeps popping up. As well as question on this mailinglist, I've tried to reach out to Paul a several times last year. I'm not getting any response, even though I've put in alot of hours in on making dbmail work with gmime3: https://github.com/pjstev

Re: [Dbmail] mailing lists are moving and github organisation.

2019-02-24 Thread Casper Langemeijer
Excellent! https://github.com/langemeijer Op zo 24 feb. 2019 15:40 schreef Paul J Stevens : > > Hi all, > > > I'm migrating all my hosting services to another data-center. This means > that the mailinglist is also moving to a new host. > > As some of you noticed the website was already moved. >