Hi Marcus, It would be great if you can provide the modified schema you have for MS SQL. Also where is the one that is provided by OTRS?
I have convinced them to use Apache but not MySQL so that seems to be a good option right now. Thanks for the help. Dan King Software Developer Canadian Resident Matching Service 613.237.0075 ext. 241 (Toll free) 877.CARMS.42 171 Nepean Street, Suite 300 Ottawa, ON, CAN K2P 0B4 www.carms.ca ------------------------------------------------------------------------------------ This e-mail message, including any attachments, is for the sole use of the intended recipients and may contain confidential and or privileged information. If you are not the intended recipient or this information has been forwarded in error, please contact the sender by reply e-mail and destroy copies of the original message. Ce message (incluant toute pièce jointe) s'adresse uniquement au(x) destinataire(s) prévu(s) ou à une personne autorisée à le recevoir en son (leur) nom. Il pourrait contenir des renseignements confidentiels ou protégés. Si vous l'avez reçu par erreur, nous vous prions d'en informer l'auteur dans les meilleurs délais, de ne pas divulguer son contenu et de le supprimer de votre système. Merci. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marcus Dennis Sent: June 27, 2007 12:00 PM To: User questions and discussions about OTRS.org Subject: RE: [otrs] Re: Windows Installation If using Windows I would highly recommend using the environment provided as a base in the Windows installer. Once this is installed you can disable undesired services and/or selectively uninstall components. Is there a particular reason you need to use IIS? I am under the impression that getting IIS to support CGI is something of a pain. There are four options I can see: 1) Configure apache to run on another port, and simply link to the OTRS install on apache (http://hostname:newportnum/otrs/index.pl) - Trivial to implement 2) Configure apache to run on another port, and proxy requests to IIS for /otrs to apache. 3) Configure IIS to run on another port, and proxy requests for non-otrs paths to IIS from apache. 4) Configure IIS to invoke perl for CGI. I can provide hints on how to configure apache for each of the first three options, but can provide no insight on configuring IIS for the last three. As for MS SQL, there is a schema provided you can use to create the OTRS database in SQL Server, although minor changes may be needed. If necessary I can provide the modified schema files we are using. You will need to install a database backend package for the database; we chose to use DBD::ODBC. You can install this from the Perl Package Manager; look for ppm.bat in the perl installation. You can then configure the database to use an ODBC DSN created for use with an SQL Server database. Note also that 2.1.7 provides a major stability improvement over 2.1.6; we used the 2.1.7 source package to install the upgrade on top of the 2.1.6 binary install package. Note the schema alterations needed in the readme (VARCHAR(MAX)->TEXT). -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Beasley Sent: Wednesday, June 27, 2007 3:07 AM To: otrs@otrs.org Subject: [otrs] Re: Windows Installation Dan King schrieb: > Hi, > > > > I am trying to install OTRS on my Windows XP Desktop. I want to use IIS > and MS SQL Server though. I started off by unpacking the install file. > It gives me all the files that are used to install otrs and all it's > dependences but since it also installs apache and mysql I can't use it. > > > > The I attempted to install Perl. First I looked at the PerlInstaller.bat > script and noticed I would have to uncomment a few lines out so it asks > me for the directory to install Perl and such. I tried running the > PerlInstaller.bat script. but returned an error. It happens after > copying the files, editing a bunch of text files, and cleaning out the > backups. It then prints to the console > > > > Relocating...Undefined subroutine &main::run called at PerlInstaller.bat > line 163, <$reloc> line 1. > > > > Line 163 looks as follows: > > > > run("[EMAIL PROTECTED]", "-r", $f); > > > > I'm not sure what is wrong with this line and why it says this. My guess > is that the subroutine run is not define anywhere in the > PerlInstaller.bat file. > > > > Anyone with suggestions would be great help. > > Dan King > Software Developer > Canadian Resident Matching Service > 613.237.0075 ext. 241 > (Toll free) 877.CARMS.42 > 171 Nepean Street, Suite 300 > Ottawa, ON, CAN K2P 0B4 > www.carms.ca <http://www.carms.ca> > > ------------------------------------------------------------------------------------ > > This e-mail message, including any attachments, is for the sole use of > the intended recipients and may contain confidential and or privileged > information. If you are not the intended recipient or this information > has been forwarded in error, please contact the sender by reply e-mail > and destroy copies of the original message. Ce message (incluant toute > pièce jointe) s'adresse uniquement au(x) destinataire(s) prévu(s) ou à > une personne autorisée à le recevoir en son (leur) nom. Il pourrait > contenir des renseignements confidentiels ou protégés. Si vous l'avez > reçu par erreur, nous vous prions d'en informer l'auteur dans les > meilleurs délais, de ne pas divulguer son contenu et de le supprimer de > votre système. Merci. > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > 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 > Support or consulting for your OTRS system? > => http://www.otrs.com/ Use a linux maschine. alternitavely use a vmware appliance. based on LAMP http://www.vmware.com/vmtn/appliances/directory/591 --Shawn _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/ _______________________________________________ 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 Support or consulting for your OTRS system? _______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
