On Sun, Mar 15, 2026 at 12:51 PM Thomas Krichel <[email protected]> wrote:
> Washington Odhiambo writes > > > MM3 with Sqlite is not recommended for production. The virtualenv HOWTO > > even doesn't mention it. > > I know now, but I have it in production now. It was the default > in the Debian package. > > > So ideally, you should be using PostgreSQL or MariaDB. > > But I don't know how to convert. I know very little about RDMS, > have been avoiding them since my earliest childhood. ;-) > There are tools that can help you do it, if my Google-foo serves me right, but I suppose you have feared those since childhood as well. > > In a production setup, the MM3 core and Django config files should > ideally > > reside in /etc/mailman3/ > > mailman@tagol:~$ mailman info | grep -v creden > GNU Mailman 3.3.10 (Tom Sawyer) > Python 3.12.9 (main, Feb 5 2025, 01:31:18) [GCC 14.2.0] > config file: /etc/mailman3/mailman.cfg > db url: sqlite:////var/lib/mailman3/data/mailman.db > devmode: DISABLED > REST root url: http://localhost:8001/3.1/ > > > The output of the command 'mailman info' should show "config file: > > /etc/mailman3/mailman.cfg". with db_url pointing to an officially > supported > > RDBM. > > Well the list has been running off sqlite for years, > so I believe all the data is there and it is correct. > OK. > > That will tell you that MM3 is reading the expected config. > > I think it does. > > > Having said that, let's say your choice is sqlite as the DB, does your > list > > exist in the DB? > > I think so. > > > Run this command from the DB and show output: > > select id, list_id from mailinglist; > > mailman@tagol:~$ sqlite3 /var/lib/mailman3/data/mailman.db > SQLite version 3.46.1 2024-08-13 09:16:08 > Enter ".help" for usage hints. > sqlite> select id, list_id from mailinglist; > 1|bibnez.folks.email > sqlite> > > So it is in the database. Thank you so much for your help! > Great. The list is in the DB. Now, let's see if MM3 is using that DB: What is the output of the command 'mailman lists'? -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html] _______________________________________________ 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/XV5YL57DPVUMGA7YLPPMXZLSJR4ZRO26/ This message sent to [email protected]
