Suggeested change to the venv installation instructions
Well, I'm now on my third installation of mailman3. I ran into a problem I had forgotten about but once I figured it out, *then* I remembered running into it last time.
Configuration: Ubuntu 24.04 ib a vos,
It's this. I'm a mysql person, not a postgres person, but I installed postgres for this installation just so I could follow the instructions directly. Whenever I tried to start the mailman service, I got the error that mailman didn't have permission to do whatever needed to be done. The error was:
psycopg2.errors.InsufficientPrivilege: permission denied for schema public
After a little searching, I found out that mailman needs to be made the OWNER of the database, not just granted all privileges. After adding the commands:
ALTER DATABASE mailman OWNER TO mailman; ALTER DATABASE mailmanweb OWNER TO mailman;
I suggest adding those two lines to the instructions for "Setup Database" at https://docs.mailman3.org/en/latest/install/virtualenv.html
billo
On 11/28/24 4:14 PM, Bill Oliver via Mailman-users wrote:
After a little searching, I found out that mailman needs to be made the OWNER of the database, not just granted all privileges. After adding the commands:
ALTER DATABASE mailman OWNER TO mailman; ALTER DATABASE mailmanweb OWNER TO mailman;
I suggest adding those two lines to the instructions for "Setup Database" at https://docs.mailman3.org/en/latest/install/virtualenv.html
There's already an MR in progress for this, although the approach there is different. See https://gitlab.com/mailman/mailman-suite-doc/-/merge_requests/160
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (2)
-
Bill Oliver
-
Mark Sapiro