No DBA password when installing Mailman3 with remote database server
Dear Mailman3 list,
I try to install the Mailman3 software 3.3.3-1 on a Debian 11 system with a remote Postgres database server. During the installation process dpkg is asking for the DBA password that our DBA team would not provide to me. So what can I do?
Best regards, Markus
-- Markus Ludwig Grandpré Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre, Tel: ++49 7531 88 4342
On 10/31/22 07:04, Markus Ludwig Grandpré wrote:
Dear Mailman3 list,
I try to install the Mailman3 software 3.3.3-1 on a Debian 11 system with a remote Postgres database server. During the installation process dpkg is asking for the DBA password that our DBA team would not provide to me. So what can I do?
This is really a question for Debian, but apparently dpkg wants to
create databases for Mailman and Mailman Web. You will need to get your
DBA team to create these databases (probably named mailman
and
mailmanweb
) and a Mailman user (probably list
) with all access to
these databases and probably manually configure the [database]
section
of mailman.cfg and DATABASES
on Django's settings
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
but apparently dpkg wants to create databases for Mailman and Mailman Web.
During the installation process dpkg creates not only a database and a database user with approriate permissions, but also many tables.
Dpkg allows to skip database configuration. Is there routine or skript to create database, database user and all required tables after the installation process has finished?
Best regards, Markus
On 31.10.22 18:52, Mark Sapiro wrote:
On 10/31/22 07:04, Markus Ludwig Grandpré wrote:
Dear Mailman3 list,
I try to install the Mailman3 software 3.3.3-1 on a Debian 11 system with a remote Postgres database server. During the installation process dpkg is asking for the DBA password that our DBA team would not provide to me. So what can I do?
This is really a question for Debian, but apparently dpkg wants to create databases for Mailman and Mailman Web. You will need to get your DBA team to create these databases (probably named
mailman
andmailmanweb
) and a Mailman user (probablylist
) with all access to these databases and probably manually configure the[database]
section of mailman.cfg andDATABASES
on Django's settings
-- Markus Ludwig Grandpré Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre, Tel: ++49 7531 88 4342
Il 31/10/22 20:43, Markus Ludwig Grandpré ha scritto:
Dpkg allows to skip database configuration. Is there routine or skript to create database, database user and all required tables after the installation process has finished?
Hi Markus Ludwig Grandpré,
For mailman3 sudo dpkg-reconfigure mailman3
For mailman3-web sudo dpkg-reconfigure mailman3-web
Best regards
-- blackout69
blackout69 writes:
For mailman3 sudo dpkg-reconfigure mailman3
For mailman3-web sudo dpkg-reconfigure mailman3-web
I guess those will work too as long as the users and databases have been created. But they'll still fail at the first step without that (and they might fail anyway if checking for the existence of those users and databases involves logging in to the database as the admin user).
Markus Ludwig Grandpré writes:
Dpkg allows to skip database configuration. Is there routine or skript to create database, database user and all required tables after the installation process has finished?
Not the whole thing. The users and databases must be created by a database administrator.
After that, any "mailman" command will initialize the core's tables, and the "mailman-web migrate" command creates the Django tables for both Postorius and HyperKitty if mailman-web is installed, or you use the Django "manage.py migrate" command separately in both HyperKitty and Postorius if Debian uses the older installation without mailman-web. After the migrate command, you should use mailman-web or manage.py to issue the collectstatic, compress, and compilemessages commands for HyperKitty and Postorius.
participants (4)
-
blackout69
-
Mark Sapiro
-
Markus Ludwig Grandpré
-
Stephen J. Turnbull