A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=862 ====================================================================== Reported By: smb Assigned To: ====================================================================== Project: DBMail Issue ID: 862 Category: bug tracker Reproducibility: always Severity: feature Priority: normal Status: new target: ====================================================================== Date Submitted: 09-Oct-10 16:41 CEST Last Modified: 10-Oct-10 09:16 CEST ====================================================================== Summary: get empty email Description: install dbmail with postgresql backend. mail server can send email correctly but when try get mail emails are empty(no subject,sender & description) ======================================================================
---------------------------------------------------------------------- (0003118) smb (reporter) - 09-Oct-10 16:59 http://www.dbmail.org/mantis/view.php?id=862#c3118 ---------------------------------------------------------------------- and when select "Show Original Message" in outlook express outlook or "view source" in thunder bird MUA i see just: "x52656365697665643a2066726f6d206d61696c2d7779302d663137342e676f6f676c652e636f6d20286c6f616462616c616e6365722e6f73746e6179617a642e6972205b38352e3138352e3135392e3130315d290a0962792064626d61696c302e6f7374616e79617a642e69722028506f73746669782920776974682045534d545020696420303938453134353032300a09666f72203c6d7974657374406d61696c746573742e6972616e6273642e6f72673e3b205361742c202039204f637420323031302031373a35323a3338202b30333330202849525354290a52656365697665643a206279207779623238207769746820534d5450206964203238736f313837393739387779622e31390a09666f72203c6d7974657374406d61696c746573742e6972616e6273642e6f72673e3b205361742c203039204f637420323031302030373a35303a3231202d303730302028504454290a444b494d2d5369676e61747572653a20763d313b20613d7273612d7368613235363b20633d72656c617865642f72656c617865643b2020202020202020643d676d61696c2e636f6d3b0a09733d67616d6d613b202020202020200a09683d646f6d61696e6b65792d7369676e61747572653a72656365697665643a6d696d652d76657273696f6e3a72656365697665643a66726f6d3a 6461746520202020202020200a093a6d6573736167652d69643a7375626a6563743a746f3a636f6e74656e742d747970653b202020202020200a0962683d5774476246466873302f73584f4e374836546e64577367755833626c506c676f394f3335544841666d6c413d3b202020202020200a09623d4e2b4b7130387a72716c773366556c646d70316b76513478473741574c51546c2b796159435a7970707669304b4e4a56694677616679652b5835327476686556703020202020202020200a0967585a68766769375a38385152375374634a6c6a7343797968656d5643775131565477436b71647667654c6c3972684833576d51305465456f6d70555a5267785748426620202020202020200a0938636776437438796c5a626b30572b5a66524836775a306a7861654853434c58374d6849383d0a446f6d61696e4b65792d5369676e61747572653a20613d7273612d736861313b20633d6e6f6677733b2020202020202020643d676d61696c2e636f6d3b20733d67616d6d613b202020202020200a09683d6d696d652d76657273696f6e3a66726f6d3a646174653a6d6573736167652d69643a7375626a6563743a746f3a636f6e74656e742d747970653b202020202020200a09623d416a596a326570415948772f414d52472f6b542b7464537738696f7651776d784a4 8774c2f696e7548616a6749575152415258645543646b4b3059686779712f626e20202020202020200a094a585a5a2f7541622b5647376a336352392f6d4a3247526f347552485348717230392b73546b4a2b6268376e4d4668694b5749793147517179315143523845447968733320202020202020200a0935476e7a345450374b7755334b7a2f51446931335136664570337a67476e635168335a37553d0a52656365697665643a2062792031302e3231362e35392e31207769746820534d54500a0969642072316d72333531383439387765632e36372e313238363633353832303239303b205361742c203039204f637420323031302030373a35303a3230202d303730302028504454290a52656365697665643a2062792031302e3231362e3137382e3132207769746820485454503b205361742c2039204f637420323031302030373a35303a3030202d303730302028504454290a46726f6d3a2022532e4d6f6873656e2042616861646f726e696122203c62616861646f726e696140676d61696c2e636f6d3e0a446174653a205361742c2039204f637420323031302031383a32303a3030202b303333300a4d6573736167652d49443a203c41414e4c6b54693d6768756775506657633846436a59656a7a47365747646e7a555a524f57756463733d657233406d6169 6c2e676d61696c2e636f6d3e0a5375626a6563743a206b6b0a546f3a206d7974657374406d61696c746573742e6972616e6273642e6f72670a52657475726e2d506174683a2062616861646f726e696140676d61696c2e636f6d0a4d494d452d56657273696f6e3a20312e300a436f6e74656e742d547970653a206d756c7469706172742f616c7465726e61746976653b20626f756e646172793d303030653063653064393763303631363838303439323330336664660a0ax2d2d303030653063653064393763303631363838303439323330336664660a436f6e74656e742d547970653a20746578742f706c61696e3b20636861727365743d49534f2d383835392d310a0a6b6b6b0a0a2d2d303030653063653064393763303631363838303439323330336664660a436f6e74656e742d547970653a20746578742f68746d6c3b20636861727365743d49534f2d383835392d310a0a6b6b6b3c62723e0a0a2d2d303030653063653064393763303631363838303439323330336664662d2d0a" ---------------------------------------------------------------------- (0003119) paul (administrator) - 09-Oct-10 23:35 http://www.dbmail.org/mantis/view.php?id=862#c3119 ---------------------------------------------------------------------- dbmail-2.2 does *not* support postgresql-9 out-of-the box. You must change the bytea storage type in postgresql.conf: bytea_output = escape if you want to use postgresql-9 dbmail-2.3(git-master) does support the new storage format. ---------------------------------------------------------------------- (0003120) smb (reporter) - 10-Oct-10 09:16 http://www.dbmail.org/mantis/view.php?id=862#c3120 ---------------------------------------------------------------------- i did above config and problem resolved but when trace log of dbmail i see this error: "Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT userid FROM dbmail_usermap WHERE 1 = 2] : [FATAL: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. ]" Issue History Date Modified Username Field Change ====================================================================== 09-Oct-10 16:41 smb New Issue 09-Oct-10 16:59 smb Note Added: 0003118 09-Oct-10 23:35 paul Note Added: 0003119 09-Oct-10 23:35 paul Severity major => feature 09-Oct-10 23:35 paul Reproducibility have not tried => always 10-Oct-10 09:16 smb Note Added: 0003120 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev