caught it:

Environment="LANG=C" in the systemd-unit

recently changed on testing machines because wrong date headers
of smokeping in case of a german locale on the machine:
https://bugzilla.redhat.com/show_bug.cgi?id=1080949

the idea was to prevent something similar again and also
short ago i added LANG=C to /etc/crontab because some
cron-scripts not worked as expected by get "Mär" instead
of "Mar" for the current month

Environment="LANG=en_EN.UTF-8"
seems to do a betetr job

Am 29.03.2014 13:16, schrieb Reindl Harald:
> i am out of ideas what triggers the messages below on my homeserver
> 
> any subject with special cahrs like "Schlösser" or "Rückmeldung" is not
> inserted and triggers that error while i (thanks god) can't reproduce
> that on our production servers ('\xF6sser' should have been 'Schlösser'
> one time LMTP and the second line is IMAP-append to sent-folder)
> 
> my homeserver and production are using the same source tarball version of the
> following components and the only difference is Fedora 19 vs. 20 - strange
> 
> * Linux 3.13.7
> * dbmail-3.1.13
> * mariadb-server-5.5.36
> * libzdb-3.0
> * gmime-2.6.20
> * libevent-2.0.21
> 
> Mar 29 13:04:21 srv-rhsoft dbmail/lmtpd[29833]: Error:[message] 
> _header_value_get_id(+1615): SQLException:
> Incorrect string value: '\xF6sser' for column 'sortfield' at row 1
> Mar 29 13:04:21 srv-rhsoft dbmail/imap4d[29817]: Error:[message] 
> _header_value_get_id(+1615): SQLException:
> Incorrect string value: '\xF6sser' for column 'sortfield' at row 1
> ____________________________________
> 
> CREATE TABLE `dbmail_headervalue` (
>   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
>   `hash` varchar(255) NOT NULL,
>   `headervalue` text NOT NULL,
>   `sortfield` varchar(255) DEFAULT NULL,
>   `datefield` datetime DEFAULT NULL,
>   PRIMARY KEY (`id`),
>   KEY `hash` (`hash`),
>   KEY `headervalue` (`headervalue`(255)),
>   KEY `sortfield` (`sortfield`),
>   KEY `datefield` (`datefield`),
>   KEY `hash_headervalue` (`hash`,`headervalue`(255))
> ) ENGINE=InnoDB AUTO_INCREMENT=82254 DEFAULT CHARSET=utf8 
> ROW_FORMAT=COMPRESSED

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to