Hi Rafal, one problem might be your postgresql version. One of the new features of dbmail 3.0 was postgresql 9 support. So you might run into problems using a dbmail version lower than 3.0 with postgresql 9. You could either try dbmail 3.0 or postgres 8.x.
greetings
Jan Marc
On 16.03.2011 12:41, Rafa? Radecki wrote:
> 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?
>
>
> !DSPAM:4d80a1ea75082062322751!
>
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
>
> !DSPAM:4d80a1ea75082062322751!
signature.asc
Description: OpenPGP digital signature
!DSPAM:4d80a30275084452212443!
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
