Re: [otrs] perl migration script help
Hiya, Sorry I'm doing this on an XP box just to test the upgrade process... prod box is on Windows Server 2003. I am using MySQL Query Browser to run these scripts, I log into it using root, and then I can browse to the actual SQL script to run that and that is ok... But as far as the Perl script goes, I don't know what to do with that as MySQL Query Browser won't run Perl... and I have no Perl experience so am really not sure how to go about it! On a side... below where you write source $HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql; do you mean me to paste that directly into the browser or do I amend $HOME_OTRS to the actual path, and if so, what it the best way to write this, i.e, the 'program files' bit? Apologies for my silly questions and thanks. Emily m...@timocom.com Sent by: otrs-boun...@otrs.org 09/09/2009 17:55 Please respond to "User questions and discussions about OTRS." To "User questions and discussions about OTRS." cc Subject Re: [otrs] perl migration script help Hey, just login into your mysql as 'root' and then do the following. use otrs; source $HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql; source $HOME_OTRS/scripts/DBUpdate-to-2.4.pl; Here you´ll get some error´s just ignore them and go on with the following command. source $HOME_OTRS/scripts/DBUpdate-to-2.4-post.mysql.sql; Then you can quit from mysql and restart the services. Now just login into your OTRS System with an administrators account, go to the Admin panel and click on the sysconfig. Have fun ;) Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: m...@timocom.com www.TimoCom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 Emily Flynn ---09.09.2009 18:48:07---Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to From: Emily Flynn To: otrs@otrs.org Date: 09.09.2009 18:48 Subject: [otrs] perl migration script help Sent by: otrs-boun...@otrs.org Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to do for running the perl migration script http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Print&CategoryID=5&ItemID=351 I have MySQL Tools installed and so have used MySQL Admin to backup and restore, and MySQL Query Browser to run the first upgrade script ( DBUpdate-to-2.4.mysql.sql ). I am not sure how to run the Perl migration script, can someone please give me a couple of pointers? Thanks in advance Emily- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ <><><><><><><><><><><>- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] perl migration script help
Hi, On 09.09.2009, at 18:46, Emily Flynn wrote: Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to do for running the perl migration script http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Print&CategoryID=5&ItemID=351 I have MySQL Tools installed and so have used MySQL Admin to backup and restore, and MySQL Query Browser to run the first upgrade script (DBUpdate-to-2.4.mysql.sql ). I am not sure how to run the Perl migration script, can someone please give me a couple of pointers? Windows? -- Shawn Beasley sh...@otrs.org Computers make work that one would not have without them go faster! - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] perl migration script help
Hey, just login into your mysql as 'root' and then do the following. use otrs; source $HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql; source $HOME_OTRS/scripts/DBUpdate-to-2.4.pl; Here you´ll get some error´s just ignore them and go on with the following command. source $HOME_OTRS/scripts/DBUpdate-to-2.4-post.mysql.sql; Then you can quit from mysql and restart the services. Now just login into your OTRS System with an administrators account, go to the Admin panel and click on the sysconfig. Have fun ;) Mit freundlichen Grüßen / Kind regards Markus Moj IT Infrastructure & Services TimoCom Soft- und Hardware GmbH In der Steele 2 D-40599 Düsseldorf Tel: +49 211 88 26 80 14 Fax: +49 211 88 26 70 14 eMail: m...@timocom.com www.TimoCom.com Geschäftsführer: Jens Thiermann, Gunther Matzaitis Amtsgericht Düsseldorf, HRB 34489 From: Emily Flynn To: otrs@otrs.org Date: 09.09.2009 18:48 Subject: [otrs] perl migration script help Sent by:otrs-boun...@otrs.org Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to do for running the perl migration script http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Print&CategoryID=5&ItemID=351 I have MySQL Tools installed and so have used MySQL Admin to backup and restore, and MySQL Query Browser to run the first upgrade script ( DBUpdate-to-2.4.mysql.sql ). I am not sure how to run the Perl migration script, can someone please give me a couple of pointers? Thanks in advance Emily- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ <><>- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
[otrs] perl migration script help
Hello! I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what to do for running the perl migration script http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Print&CategoryID=5&ItemID=351 I have MySQL Tools installed and so have used MySQL Admin to backup and restore, and MySQL Query Browser to run the first upgrade script ( DBUpdate-to-2.4.mysql.sql ). I am not sure how to run the Perl migration script, can someone please give me a couple of pointers? Thanks in advance Emily- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/