Hi all.
I've installed dbmail (2.2.17) with postfix (2.3.3) and postgresql (9.0.3).
I am sending messages with SMTP to postfix, postfix then uses lmtp to
forward them to dbmail-lmtp.
Below is the effect of sending of one message:
- dbmail_users:
user_idnr | userid | passwd | client_idnr | maxmail_size | curmail_size |
maxsieve_size | cursieve_size | encryption_type | last_login
-----------+--------+--------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------
6 | test | test | 0 | 0 | 3004
| 0 | 0 | | 2011 12:07:45
- dbmail_mailboxes:
mailbox_idnr | owner_idnr | name | seen_flag | answered_flag | deleted_flag
| flagged_flag | recent_flag | draft_flag | no_inferiors | no_select |
permissi
on
--------------+------------+-------+-----------+---------------+--------------+--------------+-------------+------------+--------------+-----------+---------
---
7 | 6 | INBOX | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0
|
2
8 | 6 | Trash | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0
|
2
11 | 6 | Sent | 1 | 1 |
1 | 1 | 1 | 1 | 0 | 0
|
2
- dbmail_messages in INBOX:
message_idnr | mailbox_idnr | physmessage_id | seen_flag | answered_flag |
deleted_flag | flagged_flag | recent_flag | draft_flag |
unique_id
| status
--------------+--------------+----------------+-----------+---------------+--------------+--------------+-------------+------------+-------------------------
---------+--------
25 | 7 | 10 | 1 | 0
| 0 | 0 | 0 | 0 |
51fe391c745ab2d012520e31
440dacd8 | 0
27 | 7 | 11 | 1 | 0
| 0 | 0 | 0 | 0 |
81da749ff59888c73d1483a6
f65af992 |
- dbmail_phys_messages for second message:
id | messagesize | rfcsize | internal_date
----+-------------+---------+---------------------
11 | 483 | 498 | 2011-03-16 11:07:25
- dbmail_messageblks for this message:
messageblk_idnr | physmessage_id
|
messageblk
| blocksize |
is_header
-----------------+----------------+--------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------+-----------+-----------
21 | 11 |
\x52656365697665643a2066726f6d2063656e7435612e746573742e6c6f63616c202863656e743561205b3132372e302e302e315d290a09627920636
56e7435612e746573742e6c6f63616c2028506f73746669782920776974682045534d5450206964203133324431434536453709666f72203c7465737440782e6c6f63616c3e3b0a095765642c2031
36204d617220323031312031323a30373a3235202b303130302028434554290a4d6573736167652d49443a203c34443830393945432e3530363030303940782e6c6f63616c3e0a446174653a20576
5642c203136204d617220323031312031323a30373a3234202b303130300a46726f6d3a2054455354203c7465737440782e6c6f63616c3e0a557365722d4167656e743a205468756e646572626972
6420322e302e302e323420285831312f3230313031323133290a546f3a207465737440782e6c6f63616c0a5375626a6563743a20320a52657475726e2d506174683a207465737440782e6c6f63616
c0a4d494d452d56657273696f6e3a20312e300a436f6e74656e742d547970653a20746578742f706c61696e3b20636861727365743d5554462d383b20666f726d61743d666c6f7765640a436f6e74
656e742d5472616e736665722d456e636f64696e673a20376269740a0a | 481
| 1
22 | 11 |
\x320a
| 2
| 0
The output is exaclty sa given above.
When I connect through IMAP client to the INBOX is see the subject of the
message ("2") but I do not see the body (should also be "2"). When I try to
read the source of the message as I always did in case of filesysten stored
e-mails after pressing Crtl+U I get:
x52656365697665643a2066726f6d2063656e7435612e746573742e6c6f63616c202863656e743561205b3132372e302e302e315d290a0962792063656e7435612e746573742e6c6f63616c2028506f73746669782920776974682045534d5450206964203133324431434536453709666f72203c7465737440782e6c6f63616c3e3b0a095765642c203136204d617220323031312031323a30373a3235202b303130302028434554290a4d6573736167652d49443a203c34443830393945432e3530363030303940782e6c6f63616c3e0a446174653a205765642c203136204d617220323031312031323a30373a3234202b303130300a46726f6d3a2054455354203c7465737440782e6c6f63616c3e0a557365722d4167656e743a205468756e6465726269726420322e302e302e323420285831312f3230313031323133290a546f3a207465737440782e6c6f63616c0a5375626a6563743a20320a52657475726e2d506174683a207465737440782e6c6f63616c0a4d494d452d56657273696f6e3a20312e300a436f6e74656e742d547970653a20746578742f706c61696e3b20636861727365743d5554462d383b20666f726d61743d666c6f7765640a436f6e74656e742d5472616e736665722d456e636f64696e673a20376269740a0ax320a
Any ideas what can be done to resolve the problem?
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
