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

Reply via email to