On 08/03/2010 07:38 PM, Lou Picciano wrote:
> Paul,
>
> Output of your proposed debugging routine; everything seems to work.
> Select inbox through the fetch command shown below...
No, it doesn't look right at all. Is that the result of a simple message
insertion like I showed? If so, please share your dbmail.conf and
postgresql schema.
I suspect there's a problem with the database encoding used. A dump and
reload may be required. Depends on your dbmail.conf encoding option and
whether it aligns with the database encoding used for your dbmail
database. You can use the \l command to check that encoding, collation
and ctype are all UTF8
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
dbmail | dbmail | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
>
> SIGNIFICANTLY, however, as I've reported: A mail client can login
> properly, and 'see' the header line in its inbox Remember, we've
> already received a bunch of email, on various virtualized domains, and
> have used your import utility for a few thousand more... I think we're
> beyond the basics.
Mmm, I consider your problem to be rather basic.
> Problem seems to be at the point of 'translating' dbmail messageblks
> (binary, bytea in PostgreSQL) into something an email client can read?
> Note the long binary string 'message body'... Help!
Yep. Like I said, smells like an encoding problem.
>
> (By way of documentation example, where are the full docs to these
> debugging commands? Where would one have found them?) Lou
Eh, nowhere. On the list maybe. Or the IMAP rfc.
> PS - For what it's worth, we have lots of output in errorlog, but have
> _never_ gotten anything written to logfile.
That's normal. The logfile only contains stdout/stderr for the daemons.
The errorlog contains the actual logging stream.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
