Hello Everyone, I am planing to implement OTRS. I have following technology stacks: OS: Windows Database: MS SQL Directory: Active directory Please suggest me whether this selection is ok and if anybody has experience of using this stack plz share with me, How was the performance? and plz if u could tell me what is best choice. Thanks & Regards Arpit Gupta ESM Sub Focus Area, TEG Open Source Platform Tata Consultancy Services Ph:- +91-22-67782544 Mailto: arpit2.g@tcs.com Website: http://www.tcs.com ____________________________________________ Experience certainty. IT Services Business Solutions Outsourcing ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
Hello, I use Windows 2003 server SP2 and the OTRS windows installer otrs-2.4.5-win-installer-2.1.1 When upgrading from 2.43 last weekend I had quite some trouble. First issue was that my zzzauto.pm was no longer compatible. When I put it in the correct folder otrs stopped working. So I replaced it with the zzzauto.pm that was delivered with 2.45 and manually had to copy all settings from my own zzzauto.pm file. Second issue is that I cannot get the apache::DBI working: use Apache::DBI (); Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'some-pass'); use DBI (); # enable this if you use mysql use DBD::mysql (); use Kernel::System::DB::mysql; But when I check it in the support assessment it is not enabled. Third issue is the mod_perl that cannot start (apache does not start when enabling it) # load mod_perl LoadFile 'C:/OTRS/StrawberryPerl/perl/bin/perl510.dll' #LoadModule perl_module modules/mod_perl.so And most likely reason is that mod_perl.so is not available in the installation. Is there a new way of enabling these instances that I don't know of? Met vriendelijke groet / Best regards, Danny van Dorp Webmaster and ICT Officer Applications SNV Netherlands Development Organisation Dr. Kuyperstraat 5 2514 BA The Hague Tel: +31 (0)70 344 02 57 Fax: +31 (0)70 385 55 31 Email ICT: ICTHelpdesk@snvworld.org Email personal and MSN: dvandorp@snvworld.org DISCLAIMER This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of SNV. SNV accepts no liability for any damage caused by any virus transmitted by this email.
Hi Danny, I guess in fact this is more a system setup-type question, so the best place for this will be the otrs@ list, and not the developers-list. But anyway: * Apache::DBI will only work if you have mod_perl running... it's inside an <IfModule mod_perl.c> block in the apache config file. * mod_perl with StrawberryPerl does not work; this is a known issue, see http://bugs.otrs.org/show_bug.cgi?id=4270 I hope this helps... -- ((enjoy)) - Michiel Beijen R&D OTRS AG Norsk-Data-Str 1. 61352 Bad Homburg Deutschland T: +31 (0) 6457 42418 F: +49 (0) 9421 56818-18 I: http://www.otrs.com/ Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial register: 10751, Tax ID: 003 240 97505 Chairman of the Board: Burchard Steinbild, Managing Board: André Mindermann (CEO), Martin Edenhofer CU@ IIR Service Desk Forum in Mainz (Germany) and get to know more about OTRS at booth no. 12 from Nov 24-25, 2009! http://bit.ly/1rbdkT Dorp, Danny van wrote:
Hello,
I use Windows 2003 server SP2 and the OTRS windows installer otrs-2.4.5-win-installer-2.1.1
When upgrading from 2.43 last weekend I had quite some trouble. First issue was that my zzzauto.pm was no longer compatible. When I put it in the correct folder otrs stopped working. So I replaced it with the zzzauto.pm that was delivered with 2.45 and manually had to copy all settings from my own zzzauto.pm file.
Second issue is that I cannot get the apache::DBI working:
use Apache::DBI (); Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'some-pass'); use DBI ();
# enable this if you use mysql use DBD::mysql (); use Kernel::System::DB::mysql;
But when I check it in the support assessment it is not enabled.
Third issue is the mod_perl that cannot start (apache does not start when enabling it)
# load mod_perl LoadFile 'C:/OTRS/StrawberryPerl/perl/bin/perl510.dll' #LoadModule perl_module modules/mod_perl.so
And most likely reason is that mod_perl.so is not available in the installation.
Is there a new way of enabling these instances that I don't know of?
Met vriendelijke groet / Best regards,
Danny van Dorp
Webmaster and ICT Officer Applications SNV Netherlands Development Organisation Dr. Kuyperstraat 5 2514 BA The Hague Tel: +31 (0)70 344 02 57 Fax: +31 (0)70 385 55 31 Email ICT: ICTHelpdesk@snvworld.org Email personal and MSN: dvandorp@snvworld.org
DISCLAIMER
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of SNV. SNV accepts no liability for any damage caused by any virus transmitted by this email.
------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Dear Arpit, We use windows 2003 server with MYSQL database and Active directory for agents and customer login. We have 2000 customers and around 50 agents over multiple disciplines (communication, logistics, application management and helpdesk) I think the performance is great, even without the apache::dbi and mod_perl support that is missing from 2.45 at this moment in our configuration. We use a file location on disk for attachements instead of storing them in the database which improved performance. This configuration is set up with the windows installer provided by OTRS and it helped us to improve our customer support tremendously. We are, as a development organisation, located in remote locations all over the world and OTRS being light is still a very good tool also for local ict officers to be able to use it, even over VSAT bandwidth. Met vriendelijke groet / Best regards, Danny van Dorp Webmaster and ICT Officer Applications SNV Netherlands Development Organisation Dr. Kuyperstraat 5 2514 BA The Hague Tel: +31 (0)70 344 02 57 Fax: +31 (0)70 385 55 31 Email ICT: ICTHelpdesk@snvworld.org Email personal and MSN: dvandorp@snvworld.org -----Original Message----- From: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] On Behalf Of Arpit2 G Sent: Wednesday, December 02, 2009 7:18 To: dev@otrs.org Subject: [dev] Help Needed regarding Technology Stack of OTRS Hello Everyone, I am planing to implement OTRS. I have following technology stacks: OS: Windows Database: MS SQL Directory: Active directory Please suggest me whether this selection is ok and if anybody has experience of using this stack plz share with me, How was the performance? and plz if u could tell me what is best choice. Thanks & Regards Arpit Gupta ESM Sub Focus Area, TEG Open Source Platform Tata Consultancy Services Ph:- +91-22-67782544 Mailto: arpit2.g@tcs.com Website: http://www.tcs.com ____________________________________________ Experience certainty. IT Services Business Solutions Outsourcing ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --------------------------------------------------------------------- OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ DISCLAIMER This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of SNV. SNV accepts no liability for any damage caused by any virus transmitted by this email.
participants (3)
-
Arpit2 G -
Dorp, Danny van -
Michiel Beijen