I used to use dbmail for my service. I thought it would be a no-brainer to
set up with some sort of control panel app since, hey, it's SQL. However,
I had t stop using it because it doesn't look like it's maintained any
longer. There hasn't been an update since early last year. I was also
having trouble with database size vs the actual dump size. After much
time, I decided that the command-line invited too many errors. IMAP
searches always timed out. All the solutions I saw used dovecot and
dovecot's message store. I had to switch. such a shame. It was a good
idea, but I'm not sure SQL is the right technology for the store. hadoopor
mongo or some such might actually work better. I know I had an extensive
set of save queries. It was just too much to manage. I'm a purist, but
I"m getting too old be working the command-line.
--Curtis Maurand
On Fri, Oct 5, 2018 at 3:32 PM Reindl Harald (mobile) <
h.rei...@thelounge.net> wrote:
> MariaDB 10.2.18 but that issue exists virtually forever and predates
> MariaDB
>
> I don't get what is that hard to handle database input properly and no you
> can't reject non rfc conform messages on postfix side as long the server is
> not for personal use
>
> when dbmail-util is not able to cleanup stuff which cannot be handled it
> is a major bug and I am tired of turn on debug logging to get the fucking
> physical ID for delete the record (and so the whole) message by hand after
> all that years
>
> Am 5. Oktober 2018 21:09:28 MESZ schrieb Maxim <max_c...@e-foto.ru>:
> >
> >which DBMS do you use?
> >
> >05.10.18 14:52, Reindl Harald пишет:
> >> that there is a invalid char in a header is one thing, but that
> >dbmail
> >> produces non-recovery errors in that case sucks
> >>
> >> <147609553.1537264268556.JavaMail.ýkids2@oekids-server>
> >> "<75106708.5820290.1537266387...@mail.yahoo.com>")]
> >>
> >> Oct 05 13:36:09 mail.thelounge. dbmail-util[200378]: [0x562cfcc0a600]
> >> Error:[message] dbmail_message_cache_envelope(+1844): SQLException:
> >> Incorrect string value: '\xFDkids2...' for column 'envelope' at row 1
> >>
> >> Am 05.10.18 um 11:51 schrieb Reindl Harald:
> >>> this sucks for years
> >>>
> >>> * why does this happen at all
> >>> * why no output of database-id instead a dot
> >>> * why no dbmail-util switch "kill messages you can't handle"
> >>> * why spit lines with breaks into maillog confusing mailgraph
> >>> ------------------------------
> >>>
> >>> Ok. Found [3] missing envelope values.
> >>> ...
> >>> Maintenance done. Errors were found and fixed.
> >>> We suggest running dbmail-util again to confirm that all errors were
> >>> repaired.
> >>> Ok. Found [3] missing envelope values.
> >>> ...
> >>> Maintenance done. Errors were found and fixed.
> >>> We suggest running dbmail-util again to confirm that all errors were
> >>> repaired.
> >>> Ok. Found [3] missing envelope values.
> >>> ...
> >>> Maintenance done. Errors were found and fixed.
> >>> We suggest running dbmail-util again to confirm that all errors were
> >>> repaired.
> >>>
> >>> ------------------------------
> >>>
> >>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message]
> >>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string
> >>> value: '\xFDkids2...' for column 'envelope' at row 1
> >>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message]
> >>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue,
> >02
> >>> Oct 2018 19:07:51 +0000"
> >"=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
> >>> =?UTF-8?Q?ktobe
> >>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message]
> >>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string
> >>> value: '\xFDkids2...' for column 'envelope' at row 1
> >>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message]
> >>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue,
> >18
> >>> Sep 2018 10:26:26 +0000" {159}
> >>> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
> >>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message]
> >>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string
> >>> value: '\xFDkids2...' for column 'envelope' at row 1
> >>> Oct 5 11:45:54 mail dbmail/maintenance[190011]: Error:[message]
> >>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue,
> >11
> >>> Sep 2018 12:49:54 +0000" "[SPAM]
> >>> =?UTF-8?Q?Fw:_Einladung_zum_Jour_Fixe_am?= =?UTF-8?Q
> >>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message]
> >>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string
> >>> value: '\xFDkids2...' for column 'envelope' at row 1
> >>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message]
> >>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue,
> >02
> >>> Oct 2018 19:07:51 +0000"
> >"=?UTF-8?Q?Fw:_Einladung_Jour_Fixe_am_2._O?=
> >>> =?UTF-8?Q?ktobe
> >>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message]
> >>> dbmail_message_cache_envelope(+1844): SQLException: Incorrect string
> >>> value: '\xFDkids2...' for column 'envelope' at row 1
> >>> Oct 5 11:45:55 mail dbmail/maintenance[190013]: Error:[message]
> >>> dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue,
> >18
> >>> Sep 2018 10:26:26 +0000" {159}
> >>> =?UTF-8?Q?Fw:_Einladung_zum_Vortrag_"Focusing_und_kre
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://lists.nfg.nl/mailman/listinfo/dbmail
>
--
--Curtis
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
