Paul J Stevens | 1 Nov 08:29 2004
Picon

Re: sig11 in search - trying to track

We need better debugging facilities. I've been wondering if perhaps using a backtrace dump as part of the 
signal handler would be feasible. Is execinfo.h portable? Can we use it for this purpose? If so, this would 
help in at least locating the source of segfaults more easily.

Mikhail Ramendik wrote:
> Hello,
> 
> An IMAP search in one, ond only one, folder always fails - with a "got
> signal 11" in the log. This seems to mean a segfault during some
> processing.
> 
> I am trying to track it down now. Apparently I doo need to try and fix
> one more bug...
> 
> Yours, Mikhail Ramendik
> 
> 
> 
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

--

-- 
   ________________________________________________________________
   Paul Stevens                                  mailto:paul <at> nfg.nl
   NET FACILITIES GROUP                     PGP: finger paul <at> nfg.nl
   The Netherlands________________________________http://www.nfg.nl
(Continue reading)

Doug Stanley | 1 Nov 15:16 2004

Re: Auto Replies

Actually, the autoreplies implementation is broken. It's been said
many many times on this list NOT to use the dbmail implementation.
Most people who NEED it make their own implementation. I mysql
whipped up a short python script and added a new table for handling
them. If you want to go that route, I'm sure theres plenty of people
on this list that could give you examples of what they did.

Doug

Simon Lange wrote:
> anyone?!
> 
> this is essential... its not covered by any existing howto readme - any 
> documentation.
> since its existing in dbmail and sum use it it would be very helpfull if 
> sumone answers and gives a hint.
> 
> however, best would be to include into the documentation of dbmail... ;)
> 
> anyone?!
> 
> Simon
> 
> Simon Lange wrote:
> 
>> Hi,
>>
>> i have insert an auto reply row into the dbmail_auto_replies table.
>> dbmail-lmtpd does state that its working so far.
>> BUT
(Continue reading)

Simon Lange | 1 Nov 16:27 2004

Re: Auto Replies

its not been said many times. all i found was that many times ppl asked 
how it works or havin problems with it. also the "documentation" does 
not sayin that its workin nor that its not workin. just no words about 
auto reply. but the mysql scripts do install the auto_replies table so 
admins may think that its a working part of dbmail... ;)

however, its working here too but the fact that sort.c never finds an 
address (parsed from from or reply-to field). so the - for me important 
- question  is:
where must be the form or reply-to field. in the original mail TO the 
address which has autoreplies enabled?
or in the body field of the database table?
must the form or reply-to have sum special kind of syntax?!
is it caseSenSitive?

im asking since dbmail just gets the mailbody from database but fails 
then to parse/recognize an address where it can send to, and stops.

so any help would be great...

Simon

Doug Stanley wrote:

> Actually, the autoreplies implementation is broken. It's been said
> many many times on this list NOT to use the dbmail implementation.
> Most people who NEED it make their own implementation. I mysql
> whipped up a short python script and added a new table for handling
> them. If you want to go that route, I'm sure theres plenty of people
> on this list that could give you examples of what they did.
(Continue reading)

Micah | 1 Nov 21:51 2004

Re: Auto Replies

I suggest not using the DBMail implimentation, as Doug pointed out, it's 
broken, and you will have less of a headache cooking up your own script. IF 
you do want to try and get it working, keep in mind there's no mail loop 
protection to my knowledge. Also, more specifically to your questions:

I believe you attach an auto-reply to a user, not an address. All addresses 
corresponding to this user will then be affected. That's what it seems like 
without digging in the code. 

It is not case sensitive. Or at least shouldn't be considering how the 
database works, and how email addresses are handled. 

If you patch the code to fix the mail loop issue, and get this working, post 
the patch as I'm sure many others would love to use it. 

-Micah

On Monday 01 November 2004 07:27 am, Simon Lange wrote:
> its not been said many times. all i found was that many times ppl asked
> how it works or havin problems with it. also the "documentation" does
> not sayin that its workin nor that its not workin. just no words about
> auto reply. but the mysql scripts do install the auto_replies table so
> admins may think that its a working part of dbmail... ;)
>
> however, its working here too but the fact that sort.c never finds an
> address (parsed from from or reply-to field). so the - for me important
> - question  is:
> where must be the form or reply-to field. in the original mail TO the
> address which has autoreplies enabled?
> or in the body field of the database table?
(Continue reading)

Jacques Beaudoin | 2 Nov 08:36 2004
Picon

Receiving mails to 2 postfix-dbmail servers

Hi all

Im using dbmail-1.2.11 with postfix on my production server.

I would like to have all mails received on my production server
to be sent to a new test server also running dbmail-1.2.11 and postfix.

Is that possible ?

Bien à vous

Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île
Montréal, Québec, Canada
Micah | 2 Nov 17:53 2004

Re: Receiving mails to 2 postfix-dbmail servers

There's at least a couple ways to accomplish this, probably more:

1) Set up the production dbmail server to connect to a database server on the 
test server. This will keep all the mail on the test server. Has anyone 
tested two dbmail setups working with the same database yet? This in theory 
should work fine. 

2) If it's MySQL, you can use database replication to replicate a the 
production database on the test server. In my experience this would only work 
if you inserted all mail on the production server and only received mail on 
the test server. Otherwise key violations could be possible. Once again, in 
theory this would work. 

3) You could use your MTA on the production server to forward all mail to an 
MTA on the test server. 

That's all the idea I have right now, I'm going to go vote. Hope that helps. 
-Micah 

On Monday 01 November 2004 11:36 pm, Jacques Beaudoin wrote:
> Hi all
>
> Im using dbmail-1.2.11 with postfix on my production server.
>
> I would like to have all mails received on my production server
> to be sent to a new test server also running dbmail-1.2.11 and postfix.
>
> Is that possible ?
>
> Bien à vous
(Continue reading)

Jesse Norell | 2 Nov 18:10 2004
Picon

RE: Receiving mails to 2 postfix-dbmail servers


Hello,

  From postfix's ADDRESS_REWRITING_README:

   always_bcc (default: empty)
          Optional address that receives a "blind carbon copy" of each
          message that is received by the Postfix mail system.

          NOTE: if mail to the BCC address bounces it will be returned
          to the sender.

---- Original Message ----
From: Jacques Beaudoin <dbmail <at> dbmail.org>
To: dbmail <at> dbmail.org
Subject: [Dbmail] Receiving mails to 2 postfix-dbmail servers 
Sent: Tue,  2 Nov 2004 02:36:18 -0500

> Hi all
> 
> Im using dbmail-1.2.11 with postfix on my production server.
> 
> I would like to have all mails received on my production server
> to be sent to a new test server also running dbmail-1.2.11 and postfix.
> 
> Is that possible ?
> 
> Bien  vous
> 
> Jacques Beaudoin
(Continue reading)

dbmail | 3 Nov 14:04 2004
Picon

dbmail 2.0

I have tested dbmail.(MTA postfix) on Suse 9.1 (for test on vmware)

If using myisam tables check should be added like
SELECT  * 
FROM dbmail_messages
LEFT  JOIN dbmail_physmessage ON dbmail_messages.physmessage_id = 
dbmail_physmessage.id
WHERE dbmail_physmessage.id IS  NULL 
if there any records, imap will fail to deliver, or will cache everything 
into memory! tested on 600mb mailbox and imap eat all memory!!
It cannot happen on innodb tables, but a check would be usefull if somebody 
using myisam.

Imapd does cache the last message into memory and do not relase until next 
message delivery or logout, for example 6 Mb message by fetching goes up to 
14Mb memory and then back to 10Mb memory usage but I think it should free up 
it.(staying on a message in a client, but message is downloaded and viewed, 
it use still 10 mb).
The email messages will go bigger and bigger so I have made a test database 
of 6 Mb mails.

The message in the database is splitted into half Mb parts, so it should 
relase the delivered message part of the message, and do not hold in the 
memory.
(I think the memory use is caused by the mysqlclient part because normaly it 
will not relase memory sended true it, but possibly I'm wrong. I programming 
in delphi, and when I made mass insert of big blobs to a mysql database with 
ODBC and ADOTable and not limited the MaxRecords to 1 , all inserted rows 
remained in memory and have eaten all memory. ).

(Continue reading)

dbmail | 3 Nov 14:39 2004
Picon

dbmail 2.0 NCHILDREN

The NCHILDREN will result one more processes 
for example: NCHILDREN=2
root      4836  0.0  0.4  2364  796 ?        S    12:22   0:00 dbmail-imapd
nobody    4837  0.0  0.4  2364  820 ?        S    12:22   0:00 dbmail-imapd
nobody    4838  0.0  0.7  2496 1340 ?        S    12:22   0:00 dbmail-imapd
nobody    4839  0.0  0.6  2496 1280 ?        S    12:22   0:00 dbmail-imapd
there are 3+1 processes it should be 2+1 I think.
dbmail | 3 Nov 22:13 2004
Picon

Auto reply does not works..

Auto Reply does not work by me:

log:
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: dbmysql.c,db_query: executing 
query [
SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 8]
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: db.c,db_get_reply_body: found 
reply_b
ody [test reply^M test^M ]
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: GetConfigValue(): searching value 
for
 config item [SENDMAIL]
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: GetConfigValue(): found value 
[/usr/s
bin/sendmail]
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: send_reply(): found sendmail 
command
to be [/usr/sbin/sendmail]
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: send_reply(): no address to send 
to
Nov  3 21:49:14 linux dbmail/lmtpd[11392]: insert_messages(): we need to 
deliver
 [0] messages to external addresses

the header:
Received: from udoq (udoq [192.168.18.1])
	by linux.site (Postfix) with SMTP id E72385885
	for <vissza <at> test.hu>; Wed,  3 Nov 2004 21:57:56 +0100 (CET)
Message-ID: <001601c4c1e9$621328a0$6400a8c0 <at> udoq>
From: "dbmail" <dbmail <at> udo.hu>
(Continue reading)


Gmane