On 11/8/25 11:27, dap1--- via Mailman-users wrote:
Yes, everything is from the virtual environment and there were no errors reported anywhere during the process.
<venv> $ ls -l /opt/mailman/var/etc total 4 -rw-rw---- 1 mailman mailman 501 Oct 19 11:07 mailman.cfg
The sqlite line bothered me from the beginning. Shouldn't it be mysql?
I'm still concerned that mailman info reports the config at
/opt/mailman/var/etc/mailman.cfg instead of /etc/mailman3/mailman.cfg.
The database is sqlite because thats what's defined in /opt/mailman/var/etc/mailman.cfg. Did you create /etc/mailman3/mailman.cfg? what does
diff /etc/mailman3/mailman.cfg /opt/mailman/var/etc/mailman.cfg
give? You are not seeing the list in mysql because Mailman core is using the sqlite db at /opt/mailman/var/data/mailman.db
<venv> $ ls -l /opt/mailman/var/data total 300 -rw-rw---- 1 mailman mailman 274432 Nov 1 14:40 mailman.db -rw-rw---- 1 mailman mailman 343 Nov 1 14:39 postfix_domains -rw-r----- 1 mailman mailman 12288 Nov 1 14:39 postfix_domains.db -rw-rw---- 1 mailman mailman 1003 Nov 1 14:39 postfix_lmtp -rw-r----- 1 mailman mailman 12288 Nov 1 14:39 postfix_lmtp.db
The postfix files are good, but the mailman.db is spurious because the mailman.cfg that the mailman command is using most likely doesn't define a [database] section and gets the default from https://gitlab.com/mailman/mailman/-/blob/master/src/mailman/config/schema.c...
The [database] you have defined in mailman.cfg as
[database] class: mailman.database.mysql.MySQLDatabase url: mysql+pymysql://mailman:pppppppp@localhost/mailman?charset=utf8mb4&use_unicode=1
is presumably defined in /etc/mailman3/mailman.cfg which isn't being used.
What is the content of /opt/mailman/venv/bin/mailman? Do you have the environment variable MAILMAN_CONFIG_FILE set?
I did this import command:
<venv> $ mailman import21 lllllllllllll@ddddddddd.net /tmp/config.pck
Which works but imports to the list defined in the sqlite database at /opt/mailman/var/data/mailman.db.
This was the hyperkitty command:
<venv> $ mailman-web hyperkitty_import -l lllllllllllll@ddddddddd.net /tmp/lllllllllllll.mbox
<venv> $ mailman-web diffsettings|grep DATABASES DATABASES = {'default': {'ENGINE': 'django.db.backends.mysql', 'NAME': 'mailmanweb', 'USER': 'mailma n', 'PASSWORD': 'ppppppppp', 'HOST': 'localhost', 'PORT': '3306', 'OPTIONS': {'charset': 'utf8mb4'}, 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'CONN_HEALTH_CHECKS': False, 'TIME_ ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIGRATE': True, 'MIRROR': None, 'NAME': N one}}}
This looks correct.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan