[Pdns-users] Error after upgrade

[Sven Kieske]

On Di, 2020-11-24 at 20:07 -0800, Daniel Lo Nigro via Pdns-users wrote:
> 
> If PowerDNS relies on the character set being explicitly set to latin1 and
> breaks when other character sets (such as UTF-8) are set as the default
> collation on the server, it should explicitly set the character set used by
> the connection to the MySQL server by executing SET NAMES 'latin1' after
> connecting but before executing any 'real' queries. This seems like a bug
> in PowerDNS.

Hi,

it's at least explicitly mentioned in the docs to create your database with a latin1 character set:

https://docs.powerdns.com/authoritative/guides/basic-database.html

Engine=InnoDB CHARACTER SET 'latin1';

It's most of the time not a good idea to alter defaults if you do not now the internal working of
the software very well, as can be seen in this example.

It's up to debate if this is a bug of the software or if the documentation should be more urgent about setting up
the database schema. The current wording is:

"Example: configuring MySQL"

This contains some ambiguity (an example is, most of the time, not the only way to do something).
But the rest of the wording is imho relatively clear, that you should not configure the database with a different schema.

-- 
Mit freundlichen Grüßen / Regards

Sven Kieske
Systementwickler
 
 
Mittwald CM Service GmbH & Co. KG
Königsberger Straße 4-6
32339 Espelkamp
 
Tel.: 05772 / 293-900
Fax: 05772 / 293-333
 
https://www.mittwald.de
 
Geschäftsführer: Robert Meyer, Florian Jürgens
 
St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen
Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen

Informationen zur Datenverarbeitung im Rahmen unserer Geschäftstätigkeit 
gemäß Art. 13-14 DSGVO sind unter www.mittwald.de/ds abrufbar.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: This is a digitally signed message part
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20201125/24ffadf0/attachment.sig>