This is an automated email from the ASF dual-hosted git repository. ash pushed a commit to branch v2-0-test in repository https://gitbox.apache.org/repos/asf/airflow.git
commit ac43056777af2e5206fa50ebcb0cf56ad86eea42 Author: Ash Berlin-Taylor <[email protected]> AuthorDate: Fri Mar 12 11:37:00 2021 +0000 Note that the DB must be using UTF-8 (#14742) Without it non-ASCII characters in serialized dag will cause an error. (cherry picked from commit b40beb3036b8221053fdb7ab537a45afccf0bd8e) --- docs/apache-airflow/howto/set-up-database.rst | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/docs/apache-airflow/howto/set-up-database.rst b/docs/apache-airflow/howto/set-up-database.rst index 153ca80..58e8123 100644 --- a/docs/apache-airflow/howto/set-up-database.rst +++ b/docs/apache-airflow/howto/set-up-database.rst @@ -116,6 +116,11 @@ In the example below, a database ``airflow_db`` and user with username ``airflo CREATE USER 'airflow_user' IDENTIFIED BY 'airflow_pass'; GRANT ALL PRIVILEGES ON airflow_db.* TO 'airflow_user'; + +.. note:: + + The database must use a UTF-8 character set + We rely on more strict ANSI SQL settings for MySQL in order to have sane defaults. Make sure to have specified ``explicit_defaults_for_timestamp=1`` option under ``[mysqld]`` section in your ``my.cnf`` file. You can also activate these options with the ``--explicit-defaults-for-timestamp`` switch passed to ``mysqld`` executable @@ -150,6 +155,10 @@ In the example below, a database ``airflow_db`` and user with username ``airflo CREATE USER airflow_user WITH PASSWORD 'airflow_pass'; GRANT ALL PRIVILEGES ON DATABASE airflow_db TO airflow_user; +.. note:: + + The database must use a UTF-8 character set + You may need to update your Postgres ``pg_hba.conf`` to add the ``airflow`` user to the database access control list; and to reload the database configuration to load your change. See
