[rt-users] Fwd: Try to migrating from MySQL to Postgres

[Juanjo]

---------- Forwarded message ----------
From: Juanjo <juanjillo at gmail.com>
Date: 2012/6/27
Subject: Re: [rt-users] Try to migrating from MySQL to Postgres
To: Anders Hansen-Øvre <Anders.Hansen-Ovre at contra.no>


Ok, tahnks. I think is working. Almost the script is running well.

I have some errors like that:
Use of uninitialized value $mymaxid in concatenation (.) or string at
./RTmysqltoPg line 35.




2012/6/26 Anders Hansen-Øvre <Anders.Hansen-Ovre at contra.no>

>  I used the following after some key issues.****
>
> ** **
>
> Using Pg to request password for local connections****
>
> ** **
>
> /opt/rt4/sbin/rt-setup-database --dba postgres --prompt-for-password
> --action drop****
>
> /opt/rt4/sbin/rt-setup-database --dba postgres --prompt-for-password
> --action create****
>
> /opt/rt4/sbin/rt-setup-database --dba postgres --prompt-for-password
> --action schema --datadir /opt/rt4/etc/schema.Pg****
>
> /opt/rt4/sbin/rt-setup-database --dba postgres --prompt-for-password
> --action acl --datadir /opt/rt4/etc/acl.Pg****
>
> ** **
>
> Change Pg back to default auth for postgres from local****
>
> ** **
>
> Then run ./RTmysqltoPg****
>
> ** **
>
> ---****
>
> Anders****
>
> ** **
>
> *Fra:* rt-users-bounces at lists.bestpractical.com [mailto:
> rt-users-bounces at lists.bestpractical.com] *På vegne av* Juanjo
> *Sendt:* 26. juni 2012 09:54
> *Til:* rt-users at lists.bestpractical.com
> *Emne:* [rt-users] Try to migrating from MySQL to Postgres****
>
> ** **
>
> Hi.
>
> I try to make a migration in my dev server from MySQL to Postgres.
>
> Now im trying to use the scrip from Dario given in this thread
> http://www.gossamer-threads.com/lists/rt/users/103305
>
> I get this error:
>
> [root at rt ~]# ./RTmysqltoPg
> Migrating ACL...
> maxid=83
> Asked ACL for 2000 starting from 0, got 73
> DBD::Pg::st execute failed: ERROR:  duplicate key violates unique
> «acl_pkey» at ./RTmysqltoPg line 130.
> Use of uninitialized value $values[6] in join or string at ./RTmysqltoPg
> line 130.
> Use of uninitialized value $values[8] in join or string at ./RTmysqltoPg
> line 130.
>
>  2,0,SuperUser,1,0,Group,,1,,RT::System at ./RTmysqltoPg line 130.
>
>
>
> in the ACL table there aren´t duplicates key for ID.
> The new database is empty, only generated by # make initialize-database
>
> Any help?
>
> I attach the script.
>
> Thanks.
> Kindest Regards.
>
> --
> Un saludo.
> Juanjo Corral****
>



-- 
Un saludo.
Juanjo Corral



-- 
Un saludo.
Juanjo Corral
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120627/eea4cf1a/attachment.htm>