Re: [otrs] Fw: perl migration script help
Many thanks for your help Rory... silly I should have thought of trying that. Got it working using command line anyways, thanks again! From: Rory rcler...@gmail.com To: User questions and discussions about OTRS. otrs@otrs.org Date: 11/09/2009 18:59 Subject: Re: [otrs] Fw: perl migration script help Sent by: otrs-boun...@otrs.org MySQL thinks the DBUpdate-to-2.4.pl is an sql file and is trying to run it as such. Its not qsl rho so that's why you're getting the error in you SQL syntax response. You need to run the file from the command line. Try this, perl DBUpdate-to-2.4.pl You might need to use the full path to the perl.exe if its not in your path. Once that's run log back into your mysql and run the DBUpdate-to-2.4-post.mysql.sql the same as the first .sql script. Hopefully that will get the DB updated for you. Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/11 Emily Flynn emily.fl...@zurichbank.com Hiya, Thanks a million for your reply.. I'm still having a problem and I suspect it is to do with something else. Here is what I input into MySQL Query Browser, logged in as root to otrs: use otrs; source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl; and this is what I get no matter what I type in.. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl' at line 1 I have tried a couple of variations on the code but still no luck :( Emily From: Rory rcler...@gmail.com To: User questions and discussions about OTRS. otrs@otrs.org Date: 11/09/2009 14:45 Subject: Re: [otrs] Fw: perl migration script help Sent by: otrs-boun...@otrs.org Hi, Yes, $HOME_OTRS should be the full path to the OTRS directory. On my windows machine this is C:\Program Files\OTRS\OTRS You could either use quotation marks around the entire path e.g. source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.mysql.sql; The perl script should run just fine as you have to have a perl interpreter to run otrs in the first place. I'm not sure if it will work on Windows tho as I think the upgrade scripts were written for Linux based machines. Take it easy, Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/11 Emily Flynn emily.fl...@zurichbank.com Sorry, just bumping this... really need the 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. otrs@otrs.org To User questions and discussions about OTRS. otrs@otrs.org 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 emily.fl...@zurichbank.com 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
Re: [otrs] Fw: perl migration script help
Great news! Glad I could help :) Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/14 Emily Flynn emily.fl...@zurichbank.com Many thanks for your help Rory... silly I should have thought of trying that. Got it working using command line anyways, thanks again! From: Rory rcler...@gmail.com To: User questions and discussions about OTRS. otrs@otrs.org Date: 11/09/2009 18:59 Subject: Re: [otrs] Fw: perl migration script help Sent by: otrs-boun...@otrs.org -- MySQL thinks the DBUpdate-to-2.4.pl is an sql file and is trying to run it as such. Its not qsl rho so that's why you're getting the error in you SQL syntax response. You need to run the file from the command line. Try this, perl DBUpdate-to-2.4.pl You might need to use the full path to the perl.exe if its not in your path. Once that's run log back into your mysql and run the DBUpdate-to-2.4-post.mysql.sql the same as the first .sql script. Hopefully that will get the DB updated for you. Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/11 Emily Flynn emily.fl...@zurichbank.com Hiya, Thanks a million for your reply.. I'm still having a problem and I suspect it is to do with something else. Here is what I input into MySQL Query Browser, logged in as root to otrs: use otrs; source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl; and this is what I get no matter what I type in.. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl' at line 1 I have tried a couple of variations on the code but still no luck :( Emily From: Rory rcler...@gmail.com To: User questions and discussions about OTRS. otrs@otrs.org Date: 11/09/2009 14:45 Subject: Re: [otrs] Fw: perl migration script help Sent by: otrs-boun...@otrs.org Hi, Yes, $HOME_OTRS should be the full path to the OTRS directory. On my windows machine this is C:\Program Files\OTRS\OTRS You could either use quotation marks around the entire path e.g. source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.mysql.sql; The perl script should run just fine as you have to have a perl interpreter to run otrs in the first place. I'm not sure if it will work on Windows tho as I think the upgrade scripts were written for Linux based machines. Take it easy, Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/11 Emily Flynn emily.fl...@zurichbank.com Sorry, just bumping this... really need the 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. otrs@otrs.org To User questions and discussions about OTRS. otrs@otrs.org 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
[otrs] Fw: perl migration script help
Sorry, just bumping this... really need the 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. otrs@otrs.org To User questions and discussions about OTRS. otrs@otrs.org 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 emily.fl...@zurichbank.com 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=PublicFAQSubaction=PrintCategoryID=5ItemID=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/ image/gifimage/gifimage/gifimage/gifimage/gifimage/gifimage/gifimage/gifimage/gifimage/gifimage/gif- 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] Fw: perl migration script help
Hi, Yes, $HOME_OTRS should be the full path to the OTRS directory. On my windows machine this is C:\Program Files\OTRS\OTRS You could either use quotation marks around the entire path e.g. source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.mysql.sql; The perl script should run just fine as you have to have a perl interpreter to run otrs in the first place. I'm not sure if it will work on Windows tho as I think the upgrade scripts were written for Linux based machines. Take it easy, Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/11 Emily Flynn emily.fl...@zurichbank.com Sorry, just bumping this... really need the 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. otrs@otrs.org To User questions and discussions about OTRS. otrs@otrs.org 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 emily.fl...@zurichbank.com 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=PublicFAQSubaction=PrintCategoryID=5ItemID=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/ - 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 -
Re: [otrs] Fw: perl migration script help
Hiya, Thanks a million for your reply.. I'm still having a problem and I suspect it is to do with something else. Here is what I input into MySQL Query Browser, logged in as root to otrs: use otrs; source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl; and this is what I get no matter what I type in.. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl' at line 1 I have tried a couple of variations on the code but still no luck :( Emily From: Rory rcler...@gmail.com To: User questions and discussions about OTRS. otrs@otrs.org Date: 11/09/2009 14:45 Subject: Re: [otrs] Fw: perl migration script help Sent by: otrs-boun...@otrs.org Hi, Yes, $HOME_OTRS should be the full path to the OTRS directory. On my windows machine this is C:\Program Files\OTRS\OTRS You could either use quotation marks around the entire path e.g. source C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.mysql.sql; The perl script should run just fine as you have to have a perl interpreter to run otrs in the first place. I'm not sure if it will work on Windows tho as I think the upgrade scripts were written for Linux based machines. Take it easy, Rory Support my 365 Challenge in aid of the Irish Cancer Society www.365challenge.ie 2009/9/11 Emily Flynn emily.fl...@zurichbank.com Sorry, just bumping this... really need the 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. otrs@otrs.org To User questions and discussions about OTRS. otrs@otrs.org 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 emily.fl...@zurichbank.com 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=PublicFAQSubaction=PrintCategoryID=5ItemID=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