OTRS 3.0.5 / Win Server 2003 R2 / MSSQL

Hilfe zu OTRS Problemen aller Art
Post Reply
DrRamazzotti
OTRS newbie
Posts: 3
Joined: 15 Sep 2010, 10:20
OTRS Version?: 3.0.0 beta 2

OTRS 3.0.5 / Win Server 2003 R2 / MSSQL

Post by DrRamazzotti » 01 Feb 2011, 16:04

Hallo zusammen.

OTRS im internen Netz. Sporadisch tritt der Fehler auf, dass eine Seite nicht erreichbar ist (gleiches Phänomen wie in http://forums.otrs.org/viewtopic.php?f=31&t=7332)

Dies wird im Apache-Error-Log geloggt:

Code: Select all

Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
[Tue Feb 01 14:40:59 2011] [notice] Apache/2.2.17 (Win32) mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.12.2 configured -- resuming normal operations
[Tue Feb 01 14:40:59 2011] [notice] Server built: Oct 18 2010 01:58:12
[Tue Feb 01 14:40:59 2011] [notice] Parent: Created child process 2420
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
[Tue Feb 01 14:41:07 2011] [notice] Child 2420: Child process is running
[Tue Feb 01 14:41:07 2011] [notice] Child 2420: Acquired the start mutex.
[Tue Feb 01 14:41:07 2011] [notice] Child 2420: Starting 64 worker threads.
[Tue Feb 01 14:41:07 2011] [notice] Child 2420: Starting thread to listen on port 80.
ModPerl::Util::exit: (120000) exit was called at C:/PROGRA~1/OTRS/OTRS/Kernel/cpan-lib/CGI/Carp.pm line 561[Tue Feb 01 14:41:42 2011] [notice] Parent: child process exited with status 25 -- Restarting.
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
[Tue Feb 01 14:41:47 2011] [notice] Apache/2.2.17 (Win32) mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.12.2 configured -- resuming normal operations
[Tue Feb 01 14:41:47 2011] [notice] Server built: Oct 18 2010 01:58:12
[Tue Feb 01 14:41:47 2011] [notice] Parent: Created child process 4056
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
[Tue Feb 01 14:41:56 2011] [notice] Child 4056: Child process is running
[Tue Feb 01 14:41:56 2011] [notice] Child 4056: Acquired the start mutex.
[Tue Feb 01 14:41:56 2011] [notice] Child 4056: Starting 64 worker threads.
[Tue Feb 01 14:41:56 2011] [notice] Child 4056: Starting thread to listen on port 80.
ModPerl::Util::exit: (120000) exit was called at C:/PROGRA~1/OTRS/OTRS/Kernel/cpan-lib/CGI/Carp.pm line 561[Tue Feb 01 14:42:08 2011] [notice] Parent: child process exited with status 25 -- Restarting.
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
[Tue Feb 01 14:42:14 2011] [notice] Apache/2.2.17 (Win32) mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.12.2 configured -- resuming normal operations
[Tue Feb 01 14:42:14 2011] [notice] Server built: Oct 18 2010 01:58:12
[Tue Feb 01 14:42:14 2011] [notice] Parent: Created child process 3248
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
[Tue Feb 01 14:42:22 2011] [notice] Child 3248: Child process is running
[Tue Feb 01 14:42:22 2011] [notice] Child 3248: Acquired the start mutex.
[Tue Feb 01 14:42:22 2011] [notice] Child 3248: Starting 64 worker threads.
[Tue Feb 01 14:42:22 2011] [notice] Child 3248: Starting thread to listen on port 80.
Habt ihr irgendwelche Ideen?

Danke und Gruss

Bernhard

tpsupport
OTRS expert
Posts: 60
Joined: 02 Feb 2011, 14:45
OTRS Version?: 6.0.12

Re: OTRS 3.0.5 / Win Server 2003 R2 / MSSQL

Post by tpsupport » 02 Feb 2011, 14:57

Hallo!

Wie haben exakt die gleichen Fehlermeldungen schon seit 3.0.2. Unser OTRS läuft auf einem Windows Server 2008 R2 mit mysql DB sowie apache 2.2 webserver und alles lokal auf einer Machine.
Für Hilfestellungen wären wir sehr dankbar. Es gibt bereits von uns einen Bug report, den ein OTRS Consultant eröffnet hat. Bisher existiert keine bekannte Lösung.

http://bugs.otrs.org/show_bug.cgi?id=6399


Grüße
OTRS 6 - Ubuntu 16.04 x64, Azure Database for MySQL server 5.7, Perl 5.22.1, Apache/2.4.18

DrRamazzotti
OTRS newbie
Posts: 3
Joined: 15 Sep 2010, 10:20
OTRS Version?: 3.0.0 beta 2

Re: OTRS 3.0.5 / Win Server 2003 R2 / MSSQL

Post by DrRamazzotti » 23 Feb 2011, 11:48

Hi, was ich bisher rausfinden konnte liegt es irgendwie am Apache unter Windows...
Irgendwie scheint der Worker-Thread "vollzulaufen" beendet sich und dann wird wieder ein neuer Worker gestartet...

Wir haben uns jetzt so beholfen, dass wir das Hosting von Hosting von dem Windows-Server / IIS runtergenommen haben und auf eine Debian 5 Maschine gelegt haben.
Datenbank lag ja schon immer auf einen Server und ist unter MSSQL geblieben. Die Anbindung war zwar auch nicht trivial, läuft jetzt aber scheinbar problemlos..

Leider keine anderen NEws für Dich...

LG Bernhard

Mike_B
Moderator
Posts: 266
Joined: 12 Jan 2010, 18:16
OTRS Version?: CVS HEAD

Re: OTRS 3.0.5 / Win Server 2003 R2 / MSSQL

Post by Mike_B » 03 Oct 2012, 16:24

Hi all,

I've created a new version of the Windows Installer which bundles a different
Apache (ApacheLounge's version) with a different mod_perl; for me it no longer
restarts but I would like to get some feedback from actual users.

Please test it and leave feedback in this bug report:

https://www.dropbox.com/s/3zwhmjc6tx2td ... -beta3.exe
http://bugs.otrs.org/show_bug.cgi?id=6399
huntingbears.nl - @michielbeijen on Twitter

pyth0n
OTRS newbie
Posts: 24
Joined: 02 Aug 2012, 11:46
OTRS Version?: 3.1.x

Re: OTRS 3.0.5 / Win Server 2003 R2 / MSSQL

Post by pyth0n » 19 Oct 2012, 13:22

Hi mike_B,

i´ve updated my faulty OTRS System after you´ve replied to this thread. Thanks for your effort to write a new package to solve this problem !

My previous System was:
OTRS 3.1.9 - Apache/2.2.22 (Win32) mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.12.3 on a Windows Server 2008 R2 x64 with MS SQL 2008 Express

My current System is:
OTRS 3.1.11 - Apache/2.2.23 (Win32) mod_apreq2-20090110/2.8.0 mod_perl/2.0.7 Perl/v5.16.0. Server OS and DB are the same.

First i´ve installed your .exe on a seperate VM with the OS and DB same as obove. To successfully start apache i had to install Visual c++ 2008 + Visual c++ 2010 in two versions (x86 AND x64).
Your package have been installed successfully! :)

After this step i wanted to update my real system. I´ve copied Apache Modules, .h-Files, dlls etc. from the Apache and the Strawberryperl-Directory to my directory on the real system.
Little config customizations i made here:
\OTRS\Apache\conf\httpd.conf
# load mod_perl

Code: Select all

LoadFile 'D:/OTRS/StrawberryPerl/perl/bin/perl516.dll'
LoadModule perl_module modules/mod_perl.so
LoadModule apreq_module modules/mod_apreq2.so
I changed the 2 in perl512.dll to a 6.

The problem already exists.Why otrs runs on windows so crappy ?! :(

Code: Select all

[Fri Oct 19 12:53:07 2012] [notice] Apache/2.2.23 (Win32) mod_apreq2-20090110/2.8.0 mod_perl/2.0.7 Perl/v5.16.0 configured -- resuming normal operations
[Fri Oct 19 12:53:07 2012] [notice] Server built: Aug 24 2012 11:30:00
[Fri Oct 19 12:53:07 2012] [notice] Parent: Created child process 1496
[Fri Oct 19 12:53:08 2012] AdminEmail.pm: defined(@array) is deprecated at D:/OTRS/OTRS//Kernel/Modules/AdminEmail.pm line 221.
[Fri Oct 19 12:53:08 2012] AdminEmail.pm: 	(Maybe you should just omit the defined()?)
[Fri Oct 19 12:53:08 2012] AdminEmail.pm: defined(@array) is deprecated at D:/OTRS/OTRS//Kernel/Modules/AdminEmail.pm line 232.
[Fri Oct 19 12:53:08 2012] AdminEmail.pm: 	(Maybe you should just omit the defined()?)
[Fri Oct 19 12:53:08 2012] AdminEmail.pm: defined(@array) is deprecated at D:/OTRS/OTRS//Kernel/Modules/AdminEmail.pm line 244.
[Fri Oct 19 12:53:08 2012] AdminEmail.pm: 	(Maybe you should just omit the defined()?)
[Fri Oct 19 12:53:10 2012] AdminEmail.pm: defined(@array) is deprecated at D:/OTRS/OTRS//Kernel/Modules/AdminEmail.pm line 221.
[Fri Oct 19 12:53:10 2012] AdminEmail.pm: 	(Maybe you should just omit the defined()?)
[Fri Oct 19 12:53:10 2012] AdminEmail.pm: defined(@array) is deprecated at D:/OTRS/OTRS//Kernel/Modules/AdminEmail.pm line 232.
[Fri Oct 19 12:53:10 2012] AdminEmail.pm: 	(Maybe you should just omit the defined()?)
[Fri Oct 19 12:53:10 2012] AdminEmail.pm: defined(@array) is deprecated at D:/OTRS/OTRS//Kernel/Modules/AdminEmail.pm line 244.
[Fri Oct 19 12:53:10 2012] AdminEmail.pm: 	(Maybe you should just omit the defined()?)
[Fri Oct 19 12:53:10 2012] [notice] Child 1496: Child process is running
[Fri Oct 19 12:53:10 2012] [notice] Child 1496: Acquired the start mutex.
[Fri Oct 19 12:53:10 2012] [notice] Child 1496: Starting 64 worker threads.
[Fri Oct 19 12:53:10 2012] [notice] Child 1496: Starting thread to listen on port 80.
Scalars leaked: -1
Scalars leaked: 1
[Fri Oct 19 13:16:30 2012] [notice] Parent: child process exited with status 255 -- Restarting.
[Fri Oct 19 13:16:32 2012] [notice] Apache/2.2.23 (Win32) mod_apreq2-20090110/2.8.0 mod_perl/2.0.7 Perl/v5.16.0 configured -- resuming normal operations
[Fri Oct 19 13:16:32 2012] [notice] Server built: Aug 24 2012 11:30:00
[Fri Oct 19 13:16:32 2012] [notice] Parent: Created child process 1808
I really hope that otrs on windows as well as running on linux.

Have a nice weekend, I have sacrificed my whole work day for this problem and it still does not work....

Post Reply