[Pkg-mailman-hackers] Bug#891937: Bug#891937: mailman3-suite: Hyperkitty tries to connect postgres on system using sqlite
Jonas Meurer
jonas at freesources.org
Thu Mar 15 22:15:52 UTC 2018
Hi Markus,
I did quite some testing of the mailman3 packages in the last days,
using all possible database backends. So far, I failed to reproduce the
bug you discovered.
After testing different settings, I'm pretty confident that indeed the
database settings from '/etc/mailman3/mailman3-suite.py' are used in a
clean mailman3-suite installation.
Please send the output of the following commands:
$ ls -al /etc/mailman3/mailman-suite.py
$ ls -al /usr/share/mailman3-suite/settings*
We renamed the 'mailman3-suite' package to 'mailman3-web' recently, to
avoid further confusion about the purpose of the package. Similarly, we
renamed 'mailman3-core' to 'mailman3'. You should find all these
packages in Debian Unstable by now.
Would you mind to purge all your mailman3 packages, do a fresh
installation and see, whether you're still able to reproduce the bug
with the latest packages from Debian Unstable?
Cheers,
jonas
Am 05.03.2018 um 02:12 schrieb Markus Gschwendt:
> cat /etc/mailman3/mailman3-suite.py
>
> # This file is imported by the Mailman Suite. It is used to override
> # the default settings from /usr/share/mailman3-suite/settings.py.
>
> # SECURITY WARNING: keep the secret key used in production secret!
> SECRET_KEY = '5S/5OIURrBJcaoB3xFK+lorJ+Rnb1GdTN3jVx9RGwKJZkjDz'
>
> ADMINS = (
> ('Mailman Suite Admin', 'root at localhost'),
> )
>
> # Hosts/domain names that are valid for this site; required if DEBUG is
> False
> # See https://docs.djangoproject.com/en/1.8/ref/settings/#allowed-hosts
> # Set to '*' per default in the Deian package to allow all hostnames.
> Mailman3
> # is meant to run behind a webserver reverse proxy anyway.
> ALLOWED_HOSTS = [
> #"localhost", # Archiving API from Mailman, keep it.
> # "lists.your-domain.org",
> # Add here all production URLs you may have.
> '*'
> ]
>
> # Mailman API credentials
> MAILMAN_REST_API_URL = 'http://localhost:8001'
> MAILMAN_REST_API_USER = 'restadmin'
> MAILMAN_REST_API_PASS = 'xxxxx'
> MAILMAN_ARCHIVER_KEY = 'xxxxx'
> MAILMAN_ARCHIVER_FROM = ('127.0.0.1', '::1')
>
> # Application definition
>
> INSTALLED_APPS = (
> 'hyperkitty',
> 'postorius',
> 'django_mailman3',
> # Uncomment the next line to enable the admin:
> 'django.contrib.admin',
> # Uncomment the next line to enable admin documentation:
> # 'django.contrib.admindocs',
> 'django.contrib.auth',
> 'django.contrib.contenttypes',
> 'django.contrib.sessions',
> 'django.contrib.sites',
> 'django.contrib.messages',
> 'django.contrib.staticfiles',
> 'rest_framework',
> 'django_gravatar',
> 'paintstore',
> 'compressor',
> 'haystack',
> 'django_extensions',
> 'django_q',
> 'allauth',
> 'allauth.account',
> 'allauth.socialaccount',
> #'django_mailman3.lib.auth.fedora',
> #'allauth.socialaccount.providers.openid',
> #'allauth.socialaccount.providers.github',
> #'allauth.socialaccount.providers.gitlab',
> #'allauth.socialaccount.providers.google',
> #'allauth.socialaccount.providers.facebook',
> #'allauth.socialaccount.providers.twitter',
> #'allauth.socialaccount.providers.stackexchange',
> )
>
>
> # Database
> # https://docs.djangoproject.com/en/1.8/ref/settings/#databases
>
> DATABASES = {
> 'default': {
> # Use 'sqlite3', 'postgresql_psycopg2', 'mysql', 'sqlite3' or
> 'oracle'.
> 'ENGINE': 'django.db.backends.sqlite3',
> #'ENGINE': 'django.db.backends.postgresql_psycopg2',
> #'ENGINE': 'django.db.backends.mysql',
> # DB name or path to database file if using sqlite3.
> 'NAME': '/var/lib/mailman3/web/mailman3suite.db.db',
> # The following settings are not used with sqlite3:
> 'USER': '',
> 'PASSWORD': '',
> # HOST: empty for localhost through domain sockets or
> '127.0.0.1' for
> # localhost through TCP.
> 'HOST': '',
> # PORT: set to empty string for default.
> 'PORT': '',
> # OPTIONS: Extra parameters to use when connecting to the
> database.
> 'OPTIONS': {
> # Set sql_mode to 'STRICT_TRANS_TABLES' for MySQL. See
> # https://docs.djangoproject.com/en/1.11/ref/
> # databases/#setting-sql-mode
> #'init_command': "SET sql_mode='STRICT_TRANS_TABLES'",
> },
> }
> }
>
>
> # If you're behind a proxy, use the X-Forwarded-Host header
> # See https://docs.djangoproject.com/en/1.8/ref/settings/#use-x-forward
> ed-host
> USE_X_FORWARDED_HOST = True
>
> # And if your proxy does your SSL encoding for you, set
> SECURE_PROXY_SSL_HEADER
> # https://docs.djangoproject.com/en/1.8/ref/settings/#secure-proxy-ssl-
> header
> SECURE_PROXY_SSL_HEADER = ('HTTP_X_FORWARDED_PROTO', 'https')
> SECURE_PROXY_SSL_HEADER = ('HTTP_X_FORWARDED_SCHEME', 'https')
>
> # Other security settings
> # SECURE_SSL_REDIRECT = True
> # If you set SECURE_SSL_REDIRECT to True, make sure the
> SECURE_REDIRECT_EXEMPT
> # contains at least this line:
> # SECURE_REDIRECT_EXEMPT = [
> # "archives/api/mailman/.*", # Request from Mailman.
> # ]
> # SESSION_COOKIE_SECURE = True
> # SECURE_CONTENT_TYPE_NOSNIFF = True
> # SECURE_BROWSER_XSS_FILTER = True
> # CSRF_COOKIE_SECURE = True
> # CSRF_COOKIE_HTTPONLY = True
> # X_FRAME_OPTIONS = 'DENY'
>
>
> # Internationalization
> # https://docs.djangoproject.com/en/1.8/topics/i18n/
>
> LANGUAGE_CODE = 'en-us'
>
> TIME_ZONE = 'UTC'
>
> USE_I18N = True
> USE_L10N = True
> USE_TZ = True
>
>
> # Set default domain for email addresses.
> EMAILNAME = 'xxxxx.xx'
>
> # If you enable internal authentication, this is the address that the
> emails
> # will appear to be coming from. Make sure you set a valid domain name,
> # otherwise the emails may get rejected.
> # https://docs.djangoproject.com/en/1.8/ref/settings/#default-from-emai
> l
> # DEFAULT_FROM_EMAIL = "mailing-lists at you-domain.org"
> DEFAULT_FROM_EMAIL = 'postorius@{}'.format(EMAILNAME)
>
> # If you enable email reporting for error messages, this is where those
> emails
> # will appear to be coming from. Make sure you set a valid domain name,
> # otherwise the emails may get rejected.
> # https://docs.djangoproject.com/en/1.8/ref/settings/#std:setting-SERVE
> R_EMAIL
> # SERVER_EMAIL = 'root at your-domain.org'
> SERVER_EMAIL = 'root@{}'.format(EMAILNAME)
>
>
> # Django Allauth
> ACCOUNT_DEFAULT_HTTP_PROTOCOL = "https"
>
>
> #
> # Social auth
> #
> SOCIALACCOUNT_PROVIDERS = {
> #'openid': {
> # 'SERVERS': [
> # dict(id='yahoo',
> # name='Yahoo',
> # openid_url='http://me.yahoo.com'),
> # ],
> #},
> #'google': {
> # 'SCOPE': ['profile', 'email'],
> # 'AUTH_PARAMS': {'access_type': 'online'},
> #},
> #'facebook': {
> # 'METHOD': 'oauth2',
> # 'SCOPE': ['email'],
> # 'FIELDS': [
> # 'email',
> # 'name',
> # 'first_name',
> # 'last_name',
> # 'locale',
> # 'timezone',
> # ],
> # 'VERSION': 'v2.4',
> #},
> }
>
> _______________________________________________
> Pkg-mailman-hackers mailing list
> Pkg-mailman-hackers at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mailman-hackers
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 866 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mailman-hackers/attachments/20180315/6d9083d0/attachment-0001.sig>
More information about the Pkg-mailman-hackers
mailing list