Status

RESOLVED FIXED
7 years ago
4 years ago

People

(Reporter: peterbe, Assigned: mpressman)

Tracking

Details

Attachments

(1 attachment)

(Reporter)

Description

7 years ago
As I'm working on a re-write of the PTO in Django, I need to write a script to migrate the existing database into the new app. For this I need a dump of the old one. Also, with a bug dump I'll be able to test that the new export works under "load". 

At some point we'll need to shut down the old one and migrate to my new app but that's something for later.

Comment 1

7 years ago
mpressman, I asked Peter to file this bug, since I think some aspects might need to be sanitized, although, not in a way that would break Peter's import script. I'm not really sure what the policy is for that stuff.

Comment 2

7 years ago
btw. I think this lives on the tm-b02 database cluster.
(Reporter)

Comment 3

7 years ago
:jabba can you help me get this going?
(Assignee)

Comment 4

7 years ago
Peter, the intranet_pto database on the tm-b02 cluster only contains one table called pto. Does that sound correct? If so, where would you like for me to put the dump?
(Assignee)

Updated

7 years ago
Assignee: server-ops-database → mpressman
(Reporter)

Comment 5

7 years ago
(In reply to comment #4)
> Peter, the intranet_pto database on the tm-b02 cluster only contains one
> table called pto. Does that sound correct? If so, where would you like for
> me to put the dump?

That is correct. Only one table. 

Well, I have my key on the elmo server which is bm-l10n-dashboard01
Any other ideas for where to put it?
(Assignee)

Comment 6

7 years ago
I've scrubbed the person field which contains the email addresses, but there is a field for detail which explains the reason for pto, should this be hashed out as well? In the meantime, I'll find a way to get access to bm-l10n-dashboard01
(Reporter)

Comment 7

7 years ago
(In reply to comment #6)
> I've scrubbed the person field which contains the email addresses, but there
> is a field for detail which explains the reason for pto, should this be
> hashed out as well? In the meantime, I'll find a way to get access to
> bm-l10n-dashboard01

When you scrub out the email address, can you at least hash it so that I can distinguish between users. I'm aware of the security precaution but eventually we need to run this migration properly when moving from the old app to the new app. 

Shall I share my public key so that I can scp it from some other VM?
(Assignee)

Comment 8

7 years ago
I was unable to gain access, so I have emailed you the dump as it is pretty small. The hash of the users will be the same for each unique user
(Assignee)

Updated

7 years ago
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
(Reporter)

Comment 9

7 years ago
Created attachment 550407 [details]
It worked!

Screenshot of a very unfinished List widget. Shows that all entries successfully imported into the new structure.
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.