Proven Configurations for OTRS, IIS and Strawberry Perl ?

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

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

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

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

I get the same results with the original (I'm running 3.0 Beta 2) script
version (TZ set enabled).
I'm not that familiar with the unit test. Could you please explain the
following with regard to tests 1-4?
Unit test uses a baseline time of '2005-10-20T10:00:00Z'
my $SystemTime = $TimeObject->TimeStamp2SystemTime(
String => '2005-10-20T10:00:00Z',
);
TimeStamp2SystemTime() returns 1129802400, which is correct, Thu, 20 Oct
2005 10:00:00 UTC.
However, the script seems to expect 1129795200, which is Thu, 20 Oct 2005
08:00:00 UTC.
Results 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 14:55:03
Perl: 5.12.2
OS: MSWin32
Vendor: unknown
Database: mssql
TestOk: 46
TestNotOk: 20
=====================================================================
On Tue, Sep 14, 2010 at 12:49 PM, Michiel Beijen
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
--------------------------------------------------------------------- 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

Michiel:
When running with ActiveState under IIS, have you ever experienced time zone
"drift"?
I'm continuing to have incidents where PerlEx will lose track of the time
zone (see the log snippet below for evidence). Note how the time shifts
back then forth:
[Tue Sep 28 10:49:19
2010][Notice][Kernel::System::AuthSession::DB::RemoveSessionID] Removed
SessionID 100aa750a028fb004d26421b88bcd5af3f.
[Tue Sep 28 10:49:19
2010][Notice][Kernel::System::AuthSession::DB::RemoveSessionID] Removed
SessionID 10b75be74d3e8d4133dbe07f78c4957655.
. . .
[Tue Sep 28 08:02:58 2010][Notice][Kernel::System::User::GetUserData]
. . .
[Tue Sep 28 13:58:38
2010][Notice][Kernel::System::AuthSession::DB::CheckSessionID] SessionID:
'10f656307616f5b470ff3985a0c6652b56' is invalid!!!
I have been discussing the issue with ActiveState but am not getting much
helpful advice (with respect to actually solving the problem, but lots of
useful C runtime trivia).
http://bugs.activestate.com/show_bug.cgi?id=87871
My next step is to go down to a single processor server. I had already
tried pegging the worker process to single CPU. Apparently something is
changing the effective timezone.
Hugh
On Mon, Sep 13, 2010 at 3:51 PM, Michiel Beijen
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
participants (2)
-
Hugh Kelley
-
Michiel Beijen