Page History

At the start of the month, send an email to oc@geant.org asking him to get an extract of the OTRS data and dump it onto them to export the OTRS database - they have instructions for this. Currently they put it on test-msr.geant.net in the /tmp/ directory, it would be better if we get them to export it to test-dwarehouse01.geant.net in the /msr directory.

(Alternative to the above, ask Emma to do this.)

Unzip the file using gunzip into the same directory.

...

This will split the very large DatabaseBackup.sql into seperate .sql files in the /msr/datafiles directory. The script takes about 3 minutes to complete.

This next bit may not work properly as it may run out of disk space when trying to dump the tables to otrs.sql; in which case you will need to delete the expanded DatabaseBackup.sql file and export the tables manually:

sudo mysqldump-as-root otrs dynamic_field_value ticket ticket_history ticket_state ticket_type > otrs.sql

Now run the script /msr/dataload.sh

...

ticket_history

ticket_state

ticket_type

Winscp the Log into test-msr.geant.net and scp the file from test-dwarehouse01.geant.net:/msr/otrs.sql file onto your laptop/:

scp test-dwarehouse01.geant.net:/msr/otrs.sql /tmp/

Load the sql into the otrs database using the reportsUser user:

mysql -ureportsUser -p otrs < /tmp/otrs.sql

Using MYSQL Workbench, import the otrs.sql file into the otrs database on test-msr.geant.net.

The queues used generate the results are below:

Business Development

Eduroam

Eduroam::Eduroam_SMEs

Educonf

Educonf::Educonf_SME

GTS

GTS::GTS SA2
Implementation
Maintenance

Operations Centre
Operations Centre::Internal
Operations Centre::Resolved
Pending

Security::CERT
Service Assurance::Customer Orders