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.cfg?ref_type=heads#L308-L318
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 [email protected] /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 [email protected]
/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 <[email protected]> The highway is for gamblers,
San Francisco Bay Area, California better use your sense - B. Dylan
_______________________________________________
Mailman-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at:
https://lists.mailman3.org/archives/list/[email protected]/message/KMIKI33GERKE7PW3I3O4T5HCU2KRFOP7/
This message sent to [email protected]
