For the record I am not using posgreSQL. I have a lot of other things in MySQL and I don't want to maintain 2 databases. I am following the virtual documentation. However, from the other thread I had to make a lot of adjustments for Ubuntu. If there are 2 configurations I don't know how that happened or where the other one is.
In settings.py:
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'mailmanweb', 'USER': 'mailman', # TODO: Replace this with the password. 'PASSWORD': 'pppppppp', 'HOST': 'localhost', 'PORT': '3306', # For MySQL/MariaDB, in addition to changing the 'ENGINE' setting, # uncomment the following to enable utf8 4-byte encodings. 'OPTIONS': {'charset': 'utf8mb4'}, } }
In mailman.cfg:
[database] class: mailman.database.mysql.MySQLDatabase url: mysql+pymysql://mailman:pppppppp@localhost/mailman?charset=utf8mb4&use_unicode=1