Run bugzilla over readonly database

[Mehuge]

Is it possible to run bugzilla over a readonly database?

Use Case: A mirror server connected to a mirror database (a slave, which only allows readonly access). In the event of a live server failure, depending on the nature of the failure, we might want to allow readonly access to the mirror server (for information lookup) without going full-hog switch over to mirror (of the downtime on the the live server is expected to be short).

When I try, bugzilla complains that the DB is readonly and can't insert records on logincookies.

[Thorsten Schöning]

Guten Tag Mehuge,

Post by Mehuge
When I try, bugzilla complains that the DB is readonly and can't insert records on logincookies.

Give it a try without authentication and securing access to your
read-only mirror using authentication of your web server, if
needed at all. Bugzilla doesn't rely on writes for querying bugs, it
even provides support for a read-only shadow database itself already:

https://bugzilla.readthedocs.io/en/5.0/administering/parameters.html#shadow-database

But you can't use any operations that store any kind of data in the
database and authentication is one of those because of sessions,
timestamp of last login etc.

Mit freundlichen Grüßen,

Thorsten Schöning
--
Thorsten Schöning E-Mail: ***@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[Mehuge]

Post by Thorsten Schöning
Guten Tag Mehuge,

Post by Mehuge
When I try, bugzilla complains that the DB is readonly and can't insert records on logincookies.

Give it a try without authentication and securing access to your
read-only mirror using authentication of your web server, if
needed at all. Bugzilla doesn't rely on writes for querying bugs, it
https://bugzilla.readthedocs.io/en/5.0/administering/parameters.html#shadow-database
But you can't use any operations that store any kind of data in the
database and authentication is one of those because of sessions,
timestamp of last login etc.
Mit freundlichen Grüßen,
Thorsten Schöning

Unfortunately that doesn't really work because many bugs are not visible to non-logged in users due to group permissions.