[SOLVED] copy OTRS from production to test

[massimobianchi]

Dear all,
i want to copy production OTRS to test.

I have a test environtment, but it has gone far from production, so I'm willing to refresh it.

I am puuting down some steps, any advice on missing actions ?

Environtment: OTRS 3.1.0 / ITSM 3.1.6 on Centos 6.3 / Mysql / Apache (LAMP)

Preparatory steps
On test:
- take note os users for binding to ldap or other db sources
- stop sendmail or any other outgoing email handler
- stop cron for otrs
- take a backup of Config.pm
- take a full backup
- clean otrs test

Execution:
on test
- take backup on production
- restore database and configuration
DO NOT START HTTPD or OTRS

Post Activities:
on test
- disable any POP3 configured account (truncate table mail at db level)
- change user for connecting to AD (taking values from saved ones)
- change OTRS ID (how to with httpd down ????)
- disable event handling (to prevent email sending to real customers) (how to with httpd down ???)
- start sendmail or any other outgoing email handler
- start cron for otrs
START HTTPD and OTRS


any hint/help is appreciated

[crythias]

change OTRS ID (how to with httpd down ????)

You can put the values in Config.pm or modify (I know, I know) ZZZAAuto.pm manually
$Self->{SystemID} = 10;
$Self->{'SendmailModule::Host'} = 'mail.example.com';

I don't know why (necessarily) you will want to re-enable send on test, but certainly if you disable *how* you send, you can feel confident that it won't send even if it tries to.

[massimobianchi]

Thanks for the hints.

Regarding email, i will re-enable it because I want to test the full handling of the tickets, and the email exchange is the ground of otrs logic.

I will leave this thread opened for a while, hoping to get some other suggestion.

[massimobianchi]

some additions:

re-creating scratch database for reloading: "CREATE DATABASE `otrs` DEFAULT CHARACTER SET utf8"
avoiding download of POP3 configured account: "truncate table otrs.mail_account;"