Footer from templates not working - DB issue?
Hi,
I am running Mailman3 on Debian 11 with Apache and MariaDB. Single installation.
When I edit a footer from the WebUI templates, it doesn't show in the messages.
Could it be an issue with the related DB? If so - what do I need to change?
Many thanks in advance for any leads! Chris
On 9/21/22 05:10, chris@mehl.one wrote:
Hi,
I am running Mailman3 on Debian 11 with Apache and MariaDB. Single installation.
When I edit a footer from the WebUI templates, it doesn't show in the messages.
How is Mailman installed? If from the Debian packages, this may be a Debian issue, and you should contact Debian for assistance.
Could it be an issue with the related DB? If so - what do I need to change?
I can't say without more info. Is the default footer added to messages?
What do you get from the db query
SELECT * from template WHERE name = 'list:member:regular:footer';
Assuming that returns a row with context of the list id, what is the uri and can you retrieve it?
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Dear All, I have a similar issue. Also on Debian 11. Also installed as Debian PKG. It's version GNU Mailman 3.3.3 (Tom Sawyer) I am using sqlite3. When I do the SQL-query I get an URI which is in multiple reasons wrong http://localhost/mailman3/postorius/api/templates/list/....../list:member:re... OK - the hostname could be changed but the path is not existing at all. There is no file "list:member:regular:footer" on the complete filesystem.
Kind regards Hans
On 9/25/22 05:26, mailman--- via Mailman-users wrote:
Dear All, I have a similar issue. Also on Debian 11. Also installed as Debian PKG. It's version GNU Mailman 3.3.3 (Tom Sawyer) I am using sqlite3. When I do the SQL-query I get an URI which is in multiple reasons wrong http://localhost/mailman3/postorius/api/templates/list/....../list:member:re...
The initial part of that URL is set from the Django setting
POSTORIUS_TEMPLATE_BASE_URL. If that is set to
http://localhost/mailman3/, it should probably be just
http://localhost/.
OK - the hostname could be changed but the path is not existing at all. There is no file "list:member:regular:footer" on the complete filesystem.
It's not a file. It refers to an entry in the postorius_emailtemplate table in the database which is retrieved via the Postorius API.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Hi Mark,
many thanks for this hint.
I updated table "template" and replaced "localhost" with the real name and it worked.
// Hans
--
On 25.09.22 19:28, Mark Sapiro wrote:
On 9/25/22 05:26, mailman--- via Mailman-users wrote:
Dear All, I have a similar issue. Also on Debian 11. Also installed as Debian PKG. It's version GNU Mailman 3.3.3 (Tom Sawyer) I am using sqlite3. When I do the SQL-query I get an URI which is in multiple reasons wrong http://localhost/mailman3/postorius/api/templates/list/....../list:member:re...
The initial part of that URL is set from the Django setting
POSTORIUS_TEMPLATE_BASE_URL. If that is set tohttp://localhost/mailman3/, it should probably be justhttp://localhost/.OK - the hostname could be changed but the path is not existing at all. There is no file "list:member:regular:footer" on the complete filesystem.
It's not a file. It refers to an entry in the postorius_emailtemplate table in the database which is retrieved via the Postorius API.
On 9/26/22 14:00, Hans Mayer via Mailman-users wrote:
Hi Mark,
many thanks for this hint.
I updated table "template" and replaced "localhost" with the real name and it worked.
You should also replace localhost in the setting for
POSTORIUS_TEMPLATE_BASE_URL so that additional entries will be created
properly.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (4)
-
chris＠mehl.one -
Hans Mayer -
mailman＠ma.yer.at
-
Mark Sapiro