A new database will be setup, separate for the production otrs database (scheduled to be hosted on test db host db1077) from a consistent copy/backup of the original one.
This will be used to test the upgrade process before production "for real" upgrade.
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| mariadb: Set db1077 in read-write | operations/puppet | production | +1 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Stalled | None | T302086 Set scap minimum python version to 3.7 | |||
| Resolved | None | T247045 Migrate all of production metal and VMs to Buster or later | |||
| Resolved | Marostegui | T250666 Upgrade WMF database-and-backup-related hosts to buster | |||
| Resolved | Marostegui | T257540 Upgrade m2 to Buster and Mariadb 10.4 | |||
| Resolved | LSobanski | T122220 Enable optional two-factor authentication for OTRS | |||
| Restricted Task | |||||
| Resolved | akosiaris | T126759 Some URLs seem to get replaced with [##############2] when written in notes and responses. | |||
| Resolved | akosiaris | T187984 Update OTRS to the latest stable version (6.0.x) | |||
| Resolved | jcrespo | T257928 Create a parallel OTRS database with a frozen snapshot of the production one |
I was planning on doing this slowly with @akosiaris so at the same time he learned about streamlined db provisioning system, but I think serviceops may be quite busy at the time, so I will resolve this quickly on my own.
Mentioned in SAL (#wikimedia-operations) [2020-07-14T14:42:26Z] <jynus> stopping db1117:3322 (m2) replication temp. for otrs db cloning T257928
A clone of the otrs database has been setup on db1077. The question now, @akosiaris, is what needs access to it in order to add the required grants/accounts and firewall holes, if necessary.
You are awesome! Thanks!
Access wise, otrs1001.eqiad.wmnet (10.64.16.39) should suffice.
Np. More questions: do we setup it with a separate user/password (to avoid mistakes with the production db) or the same (for convenience).
Credentials have been setup and shared on client root dir, feel free to productionize as you see adequate:
root@otrs1001:/root$ cat otrs_test_credentials [client] host = db1077.eqiad.wmnet ...
Port should be open. However, while everything should work, I wasn't unable to test directly as mysql client is not installed on client host.
Change 616012 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Set db1077 in read-write
Change 616012 merged by Jcrespo:
[operations/puppet@production] mariadb: Set db1077 in read-write