I've changed postgresql to version 8.4 and it works now. Thank You for the tip ;)
2011/3/16 Jan Marc Hoffmann <[email protected]> > 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 > [email protected]http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > !DSPAM:4d80a1ea75082062322751! > > > !DSPAM:4d80a30275084452212443! > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > >
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
