Run bugzilla over readonly database

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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.
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Run bugzilla over readonly database

Mehuge
On Thursday, 23 August 2018 13:36:02 UTC+1, Thorsten Schöning  wrote:

> Guten Tag Mehuge,
> am Donnerstag, 23. August 2018 um 14:10 schrieben Sie:
>
> > 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
>

Unfortunately that doesn't really work because many bugs are not visible to non-logged in users due to group permissions.
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.