PROGRESS, Thank you.
mail:/etc # zypper info python311-Django Loading repository data... Reading installed packages...
Information for package python311-Django:
Repository : Main Repository (OSS) Name : python311-Django Version : 4.2.5-1.1 Arch : noarch Vendor : openSUSE Installed Size : 29.3 MiB Installed : Yes (automatically) Status : up-to-date Source package : python-Django-4.2.5-1.1.src Upstream URL : https://www.djangoproject.com Summary : A high-level Python Web framework Description : Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.
(venv) mailman@mail:~> pip install --force-reinstall psycopg2-binary Collecting psycopg2-binary Obtaining dependency information for psycopg2-binary from https://files.pythonhosted.org/packages/ce/85/62825cabc6aad53104b7b6d12eb2ad... Downloading psycopg2_binary-2.9.9-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (4.4 kB) Downloading psycopg2_binary-2.9.9-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.0 MB) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.0/3.0 MB 6.9 MB/s eta 0:00:00 Installing collected packages: psycopg2-binary Attempting uninstall: psycopg2-binary Found existing installation: psycopg2-binary 2.8.6 Uninstalling psycopg2-binary-2.8.6: Successfully uninstalled psycopg2-binary-2.8.6 Successfully installed psycopg2-binary-2.9.9 (venv) mailman@mail:~> pip install --force-reinstall psycopg2 Collecting psycopg2 Downloading psycopg2-2.9.9.tar.gz (384 kB) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 384.9/384.9 kB 2.2 MB/s eta 0:00:00 Preparing metadata (setup.py) ... done Building wheels for collected packages: psycopg2 Building wheel for psycopg2 (setup.py) ... done Created wheel for psycopg2: filename=psycopg2-2.9.9-cp311-cp311-linux_x86_64.whl size=505693 sha256=f0288149e9e27a5b88cc041b9385bc1f1c3a8e95958d0edf5de6d47ef3d6aadb Stored in directory: /opt/mailman/.cache/pip/wheels/ab/34/b9/78ebef1b3220b4840ee482461e738566c3c9165d2b5c914f51 Successfully built psycopg2 Installing collected packages: psycopg2 Attempting uninstall: psycopg2 Found existing installation: psycopg2 2.8.6 Uninstalling psycopg2-2.8.6: Successfully uninstalled psycopg2-2.8.6 Successfully installed psycopg2-2.9.9 (venv) mailman@mail:~> python -c 'import psycopg2' (venv) mailman@mail:~> mailman info GNU Mailman 3.3.8 (Tom Sawyer) Python 3.11.5 (main, Aug 31 2023, 07:57:41) [GCC] config file: /etc/mailman3/mailman.cfg db url: postgresql://mailman:XXXXX@localhost/mailman devmode: DISABLED REST root url: http://localhost:8001/3.1/ REST credentials: restadmin:restpass (venv) mailman@mail:~>
I went the through the rest of the install got the login screen and after logging in I get this:
Forbidden (403) CSRF verification failed. Request aborted.
Looking at the PostgreSQL db, the user table has certainly been emptied the only user is mailman. The UID, address and mailing list tables seem to contain many records. I am not sure how much to restore of the original DB? Short of doing a diff on two backup file do you have any insight?
Thanks Paul.