Re: [otrs] Proven Configurations for OTRS, IIS and Strawberry Perl ?

Hi Hugh,

# $ENV{TZ} = 'Europe/Berlin';

This is really for setting an offset to UTC; otherwise if your test machine would be on Pacific or so and another on Moscow time, the tests would be generating different results. With this line, all unit tests are running in CET no matter what your actual time zone is, so we actually have results that we can test and compare. Can you please put the line back and post the results? -- Mike On Tue, Sep 14, 2010 at 1:04 PM, Hugh Kelley wrote:

In order to make time zones work consistently as UTC under PerlEx I've had to set the TZ System environment variable.

Therefore, I just commented out the following (perhaps this is causing the failures)

# set time zone to get correct references # $ENV{TZ} = 'Europe/Berlin';

The results are below:

+-------------------------------------------------------------------+ c:/otrs/otrs-3.0.0/scripts/test/Time.t: +-------------------------------------------------------------------+  not ok 1 - TimeStamp2SystemTime() (is '1129802400' should be '1129795200')  not ok 2 - TimeStamp2SystemTime() (is '1129802400' should be '1129795200')  not ok 3 - TimeStamp2SystemTime() (is '1129802400' should be '1129795200')  not ok 4 - TimeStamp2SystemTime() (is '1129802400' should be '1129795200')  ok 5 - SystemTime2Date() (is '2005-10-20 10:00:00')  ok 6 - Date2SystemTime() (is '1129802400')  ok 7 - WorkingHours - Thu-Fri (is '13')  ok 8 - WorkingHours - Thu-Mon (is '26')  ok 9 - WorkingHours - Thu-Thu (is '65')  ok 10 - WorkingHours - Thu-Thu-Thu (is '130')  ok 11 - WorkingHours - Fri-Fri-Mon (is '89')  ok 12 - WorkingHours - The-The-Fr (is '52')  ok 13 - WorkingHours - Sun-Mon (is '2')  ok 14 - WorkingHours - Son-The (is '18')  ok 15 - WorkingHours - Son-Son (is '65')  ok 16 - WorkingHours - Mon-Mon (is '4.48333333333333')  ok 17 - WorkingHours - Thu-Wed (is '2.41666666666667')  ok 18 - WorkingHours - Thu-Wed (is '13.9')  ok 19 - WorkingHours - Mon-Mon (is '2')  ok 20 - WorkingHours - Mon-Mon (is '0')  ok 21 - DestinationTime() - Test 1 (is '2006-11-13 12:00:00')  ok 22 - DestinationTime() - Test 2 (is '2006-11-13 14:15:00')  ok 23 - DestinationTime() - Test 3 (is '2006-11-14 08:15:00')  ok 24 - DestinationTime() - Test 4 (is '2007-01-02 19:00:00')  ok 25 - DestinationTime() - Test 5 (is '2007-01-02 08:15:00')  ok 26 - DestinationTime() - Test 6 (is '2007-01-02 19:00:00')  ok 27 - DestinationTime() - Test 7 (is '2006-12-07 08:54:00')  ok 28 - DestinationTime() - Test 8 (is '2007-01-17 08:30:00')  ok 29 - DestinationTime() - Test 9 (is '2007-03-15 09:00:00')  ok 30 - DestinationTime() - Test 10 (is '2007-03-12 13:56:01')  ok 31 - DestinationTime() - Test 11 (is '2007-03-15 20:21:27')  not ok 32 - TimeStamp2SystemTime() - Test summertime -> wintertime (prepare without +60 min) (is '1192817543' should be '1192810343')  not ok 33 - DestinationTime() - Test summertime -> wintertime (prepare without +60 min) (is '1193049743' should be '1193042543')  ok 34 - DestinationTime() - Test summertime -> wintertime (prepare without +60 min) (is '2007-10-22 10:42:23')  not ok 35 - TimeStamp2SystemTime() - Test summertime -> wintertime (+60 min) (is '1193422343' should be '1193415143')  not ok 36 - DestinationTime() - Test summertime -> wintertime (+60 min) (is '1193654543' should be '1193650943')  ok 37 - DestinationTime() - Test summertime -> wintertime (+60 min) (is '2007-10-29 10:42:23')  not ok 38 - TimeStamp2SystemTime() - Test summertime -> wintertime (prepare without +60 min) (is '1192817543' should be '1192810343')  not ok 39 - DestinationTime() - Test summertime -> wintertime (prepare without +60 min) (is '1193136143' should be '1193128943')  ok 40 - DestinationTime() - Test summertime -> wintertime (prepare without +60 min) (is '2007-10-23 10:42:23')  not ok 41 - TimeStamp2SystemTime() - Test summertime -> wintertime (+60 min) (is '1193422343' should be '1193415143')  not ok 42 - DestinationTime() - Test summertime -> wintertime (+60 min) (is '1193740943' should be '1193737343')  ok 43 - DestinationTime() - Test summertime -> wintertime (+60 min) (is '2007-10-30 10:42:23')  not ok 44 - TimeStamp2SystemTime() - Test wintertime -> summertime (prepare without -60 min) (is '1174068743' should be '1174065143')  not ok 45 - DestinationTime() - Test wintertime -> summertime (prepare without -60 min) (is '1174300943' should be '1174297343')  ok 46 - DestinationTime() - Test wintertime -> summertime (prepare without -60 min) (is '2007-03-19 10:42:23')  not ok 47 - TimeStamp2SystemTime() - Test wintertime -> summertime (-60 min) (is '1174673543' should be '1174669943')  not ok 48 - DestinationTime() - Test wintertime -> summertime (-60 min) (is '1174905743' should be '1174898543')  ok 49 - DestinationTime() - Test wintertime -> summertime (-60 min) (is '2007-03-26 10:42:23')  not ok 50 - TimeStamp2SystemTime() - Test wintertime -> summertime (prepare without -60 min) (is '1174068743' should be '1174065143')  not ok 51 - DestinationTime() - Test wintertime -> summertime (prepare without -60 min) (is '1174387343' should be '1174383743')  ok 52 - DestinationTime() - Test wintertime -> summertime (prepare without -60 min) (is '2007-03-20 10:42:23')  not ok 53 - TimeStamp2SystemTime() - Test wintertime -> summertime (-60 min) (is '1174673543' should be '1174669943')  not ok 54 - DestinationTime() - Test wintertime -> summertime (-60 min) (is '1174992143' should be '1174984943')  ok 55 - DestinationTime() - Test wintertime -> summertime (-60 min) (is '2007-03-27 10:42:23')  ok 56 - Vacation - 2005-01-01 (is 'New Year's Day')  ok 57 - Vacation - 2005-01-01 (is 'New Year's Day')  ok 58 - Vacation - 2005-12-31 (is 'New Year's Eve')  ok 59 - Vacation - 2005-02-14 (is 'no vacation day')  ok 60 - Vacation - 2005-01-01 (Calendar1) (is 'New Year's Day')  ok 61 - Vacation - 2005-01-01 (Calendar1) (is 'New Year's Day')  ok 62 - Vacation - 2005-01-01 (Calendar1) (is 'no vacation day')  ok 63 - Vacation - 2005-01-01 (Calendar1) (is 'no vacation day')  ok 64 - Vacation - 2004-01-01 (Calendar1) (is 'no vacation day')  ok 65 - Vacation - 2004-01-01 (Calendar1) (is 'no vacation day')  ok 66 - Vacation - 2005-02-14 (Calendar1) (is 'no vacation day') =====================================================================  Product:   OTRS 3.0.0 beta2  Test Time: 0 s  Time:      2010-09-14 10:59:57  Host:      xyz  Perl:      5.12.2  OS:        MSWin32  Vendor:    unknown  Database:  mssql  TestOk:    46  TestNotOk: 20 =====================================================================

On Mon, Sep 13, 2010 at 7:51 PM, Michiel Beijen wrote:

...

Hi Hugh,

We actually use ActiveState PerlEx when deploying on IIS because there's no good accelerator for IIS that comes with StrawberryPerl. You can deploy StrawberryPerl in CGI mode but that's pretty slow.

We do have unit tests for time bundled in OTRS, and I would be interested to see how they would then work for you on your deployment. You can run them so:

perl bin/UnitTest.pl -n Time

BTW you probably first need to update scripts/test/Time.t to this version: http://source.otrs.org/viewvc.cgi/otrs/scripts/test/Time.t?view=log&pathrev=...  older versions assume your test system timezone is set to CET, but actually, not every OTRS user lives in Germany...

Michiel Beijen Senior Consultant

OTRS BV Schipholweg 103 2316 XC  Leiden The Netherlands

T: +31 71 8200 255 F: +31 71 8200 254 I:  http://www.otrs.com

OTRS brings true mobility to the Help Desk: The OTRS iPhone App free download http://www.otrs.com/en/products/iphone-app/

On Mon, Sep 6, 2010 at 5:11 PM, Hugh Kelley wrote:

...

Does anyone have advice on the best way to deploy OTRS under IIS 7.x with Strawberry Perl?  I'm unfamiliar with Fast CGI, but that seems to be a possible approach.

I have been using ActivePerl's PerlEx up to this point but between the differences in CPAN offerings and a recent timezone but I found, I think it's work the trouble for me to learn the more about Strawberry Perl.

Hugh

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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