
It might be better to say that OTRS setup on Windows with MSSQL / IIS isn’t difficult – “easy” would be too generous. There are some extra steps that you must perform to get it up and running but it isn’t too bad.
However, seeing what it is that you want to do, what about this configuration:
Windows XP
OTRS | MySQL & IIS6
The reasons I would opt for MySQL in this case: cost, easier integration as a backup solution, consistency with live environment.
If you went with MSSQL on the Windows box, then you would have to deal with restoring MySQL database into MSSQL and who needs that hassle?
Once you have your Windows OTRS working, your failure-over process should be a snap. Granted, I am not a MySQL person; but I would expect that your process could be to take automatic backups of your live database and save them to a file share or some other location not on the live server. Could take the backup every 15 minutes, hour, whatever is best for your needs. If a failure occurs, simply take the backup and restore it to the Windows MySQL instance and you’ll be all set. It’s all about the database – once it’s all setup, you shouldn’t have to deal with modifying anything on the web server side when restoring a backup.
Nathan Campbell
Dallas Symphony Orchestra
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Lev Davidovich
Sent: Friday, September 18, 2009 3:27 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Install OTRS 2.2.5 on Windows XP machine
Thank you Nathan - I appreciate your input - sometimes a late intervention can be the most decisive one! ;-)
You have raised an issue that I must admit I had not considered until now.. Thinking about it, the only possible reason would be because our live version runs on Apache (on a Linux platform). However, all we really want to do is have a backup of our tickets on the Windows (or, as I have now realised, a Mac OS) machine and if that can be achieved with IIS rather than Apache I would certainly look into it.
In your opinion, how easy would it be to set up OTRS on a Windows machine which would then be able to import the database dumped from our live version 2..2.5 running on Apache/Linux?
Many thanks again
_____
From: Nathan Campbell
Thanks Michael. I am inclined to go down the VMWare route that both you and Rory and others suggest but I am not having much luck convincing the decision makers here!
The consensus seems to be that it is OK as a long term project but that in the short term what we need is a quick database dump followed by import into a copy of OTRS running on Windows.
Just to be clear about what you are saying -
are you saying it is no longer possible to download versions of OTRS earlier than 2.3 x and install them on Windows? Or is it only AUTOMATIC installers that it is no longer possible to download?
Where can I find an automatic installer for version 2.3 x?
I could still download version 2.2.5 from ftp://ftp.otrs.org/pub/otrs/ and ftp://ftp.otrs.org/pub/otrs/%C2%A0and install it manually (using the instructions that Afshar Mohebbi has posted ) - is that correct?
Thank you ________________________________ From: Michiel Beijen
To: User questions and discussions about OTRS. Sent: Wednesday, 9 September, 2009 10:36:46 Subject: Re: [otrs] Install OTRS 2.2.5 on Windows XP machine Hi Lev,
Due to licensing issues there are no longer old Windows installers earlier than 2.3..x available for download.
Afshar Mohebbi has posted instructions for setting up OTRS on Windows; http://afsharm.blogspot.com/2009/03/installing-otrs-active-perl-on-windows.h... (but this is with Microsoft SQL Server, you should just install MySQL instead)
I guess it would be good to also have instructions for manual installation on Windows...
Depending on your situation you could also install VMWare on your XP workstation with linux, just as on your server. Then you would have a real test environment; which you can also use to test out upgrades or so. VMWare Server is available at no charge. VMWare workstation costs a little more but has lots of good features. Myself, I use VMWare server ;-)
Regards,
Michiel.
On Wed, Sep 9, 2009 at 11:18 AM, Lev Davidovich
wrote: Hi I want to install OTRS 2.2.5 on a Windows XP test machine as that is the version we have on the live server.
The automatic installer on the following page
is only for the latest version.
Is there an automatic installer I can find for installing 2.2 on Windows?
Rory was kind enough to point out the following page with downloads of earlier versions
ftp://ftp.otrs.org/pub/otrs/
but downloading 2..2.5 from here would require a manual install on Windows.
I can't seem to find instructions to manually install version 2.2 on Windows.
I have, however, found instructions to manually install version 1.3 on Windows on the following page.
http://doc.otrs.org/1.3/en/html/install-win32.html
Is there a page with similar instructions for version 2.2 or will the instructions for 1.3 be able to do the job for me?
Thanks for your help
Lev
--------------------------------------------------------------------- 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/