Bugzilla Data & Database

Hello,

I have been trying to find an answer to this question for about a week now =
online. My organization and I are aware that the database and the data for =
Bugzilla is stored on mysql and in that mysql directory (/var/lib/mysql). H=
owever, they want to have the data stored elsewhere. Our system administrat=
or created a designated space on our linux device and they would like to tr=
y and have the data stored in that particular area (not on mysql) and have =
mysql just point to that storage area. The closest thing I was able to find=
 online was moving the mysql directory to that area and reconfiguring the m=
y.cnf file. However, with our systems permissions, moving the mysql directo=
ry is not possible. The reason for this new storage area is so that it cont=
inuously gets backed up and is off the main area. Additionally, it would al=
low others in our department who do not have access to linux systems to be =
able to access the bugzilla site, again due to permissions and servers from=
 the system administrator. If anyone would be able to assist with this, tha=
t would be great. I am pretty new at this type of thing.
0
Leo
11/16/2020 2:40:09 PM
mozilla.support.bugzilla 10162 articles. 0 followers. Post Follow

1 Replies
9 Views

Similar Articles

[PageSpeed] 20

Guten Tag Leo James,
am Montag, 16. November 2020 um 15:40 schrieben Sie:

> [...]Our system administrator created a designated
> space on our linux device and they would like to try and have the
> data stored in that particular area (not on mysql) and have mysql
> just point to that storage area. The closest thing I was able to
> find online was moving the mysql directory to that area and
> reconfiguring the my.cnf file. However, with our systems
> permissions, moving the mysql directory is not possible.

Doesn't make much sense to me that you have an admin capable of
creating some additional "space" on your Linux, but not being able to
change permissions to move some directories there as well. That's
simply the easiest way forward: If you want to move that directory,
change the permissions to be able to do so and afterwards change the
permissions back or alike. This is admin 1:1 your sysadmin should be
capable of.

> The reason
> for this new storage area is so that it continuously gets backed up
> and is off the main area.

Keep in mind that Bugzilla might store data worth of being backed up
in it's own "data"-directory as well. Things heavily depend on how
you configured it, especially regarding where to store attachments.

https://bugzilla.readthedocs.io/en/5.0/administering/parameters.html#attach=
ments

> Additionally, it would allow others in our
> department who do not have access to linux systems to be able to
> access the bugzilla site,

Bugzilla is a web app, the only thing users need is a browser, so
Linux is NOT a requirement for them. Moving directories around for
MySQL doesn't change anything about who is able to access Bugzilla
how. In theory it doesn't even change anything about how Bugzilla is
hosted.

You are mixing VERY different things up here.

> again due to permissions and servers from the system administrat
> or. If anyone would be able to assist with this, that would be
> great. I am pretty new at this type of thing.

Your question is MySQL-specific, not Bugzilla, so it might make more
sense to use one of their mailing lists. In the end, everythign
depends on what exactly the storage is you intend to use for MySQL,
why you have permission problems etc. While you don't necessarily need
to move the existing MySQL-directories, but e.g. instead copy them and
change the config, you e.g. simply need to have permissions to change
the config or replace the current MySQL-dirs with some symlink or
alike.

Without permissions your options are very limited and OTOH there's a
reason why you lack permissions. This means someone doesn't want you
to change things as you would like, so at least you need to ask
whoever denies you access why your access is denied and change that.

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning       E-Mail: Thorsten.Schoening@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=E4ftsf=FChrer: Andreas Muchow

0
windows
11/16/2020 3:04:12 PM
Reply: