Errors when passwords contain unicode

[Paul Sutor]

Conditions:

- Holland 1.1.22
- Password containing "£" as 15th character
- Password in ~/.my.cnf, not in Holland config files
- mysqldump Ver 8.0.24 for Linux on x86_64 (MySQL Community Server - GPL)

Behavior observed:

# holland bk --dry-run
Holland 1.1.22 started with pid 8717
--- Starting dry run ---
Creating backup path /var/spool/holland/default/20210420_194301
Estimating size of mysqldump backup
Failed to connect to database
MySQL Error 'ascii' codec can't encode character u'\xa3' in position 15: ordinal not in range(128)
Backup failed after 0.01 seconds
Backup failed: Failed backup: default
--- Ending dry run ---

mysqldmup alone works fine.

Google says this particular error possibly has to do with Python's str() doing an implicit encode, and perhaps explicit encode/decodes are better.

[Steve (steven-soulen)]

Thanks for reporting this bug. I've created an issue in github to track this.

https://github.com/holland-backup/holland/issues/331

[Steve (steven-soulen)]

v1.2.6 has been released. This will support Unicode characters when pymsql is newer than 1.0, and use the old behavior with legacy version of pymsql.