[rt-users] db migration from mysql to postgres

[Matthias Peplow]

Hi,

thanks for the quick response,

after 

 sbin/rt-setup-database --action create,schema,acl --prompt-for-dba-password

the import went flawlessly,

Matthias
Am 12.01.2014 um 21:24 schrieb Alex Vandiver <alexmv at bestpractical.com>:

> On Sun, 2014-01-12 at 20:42 +0100, Matthias Peplow wrote:
>> I found out the following:
>> 
>> 1. rt-serializer and rt-import are not installed automatically, had to
>> copy them from my build directory manually to the RTs sbin directory
> 
> Already fixed in 4.2.2rc1.
> 
>> 2. the import fails, as it is expecting the .dat files not in
>> /my/backup/directory but in /my/backup/directory//my/backup/directory
>> 
>> adding a symbolic link works as a workarround but this seems to be a
>> bug. Not using the —directory switch works as well.
> 
> Looks like a bug, yes.  File it on issues.bestpractical.com?
> 
>> 3. the import fails right at the beginning with
>> 
>> DBD::Pg::st execute failed: ERROR:  relation "users" does not exist
>> LINE 1: SELECT  * FROM Users WHERE LOWER(Name) = LOWER($1)
> 
> http://docs.bestpractical.com/rt-importer#CLONED_DATA
> 
> - Alex
>