[rt-users] db migration from mysql to postgres

[Alex Vandiver]

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