Hi There,
I'm new to OTRS and started yesterday to setup my system.
My setup is as follow:
- OTRS is installed on a Windows 2008 r2 (x64) running on a hyperV server.
- MSSQL2005 is installed on our central DB server in the company.
I did a fresh install in the windows server and installed OTRS 2.4.5 on it.
After installation i created the DB called OTRS on my SQL Server with the three
scripts supplied with the OTRS installation for MSSQL.
I adjusted the config of OTRS and removed the MySQL entries and put in the
following DB entries:
# MSSQL database settings
$Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL
Server};Server=SQLSERVER,1433;database=OTRS;uid=OTRS;pwd=PASSWORD;";
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseUserTable} = 'users';
OTRS is working but the interface is quite slow.
Under Support Assessment I saw the following critical messages:
Check Comment State
Check existing framework tables.
69 Tables Critical
Webserver
Check Comment State
Check if the system uses Apache::DBI.
Apache::DBI should be used to get a better performance (pre establish
database connections). Critical
Check if the system uses Apache::Reload/Apache2::Reload.
You should use Apache::Reload or Apache2::Reload to increase your
performance. Critical
Check used mod_perl version.
You should use mod_perl to increase your performance. Critical
I already check some things but do not come any further.
For the "Check existing framework tables." I have no idea what to check...
anyone?
For the "Check if the system uses Apache::DBI." I created a System DSN on the
windows server to the SQL Server.
And in the apache2-perl-startup.pl<http://apache2-perl-startup.pl> script i
added the following rule:
Apache::DBI->connect_on_init('DBI:ODBC:OTRS', 'OTRS', 'password');
But this didn't improve the situation.
If i do a SQL Benchmark "1 *Normal" i have the following result at the moment:
Result: SQL
Key Value Time Comment
Insert Time: 10000 37 s :-( Should not take more than 5s on an
average system.
Update Time: 10000 39 s :-( Should not take more than 9s on an
average system.
Select Time: 10000 37 s :-( Should not take more than 6s on an
average system.
Delete Time: 10000 35 s :-( Should not take more than 5s on an
average system.
Multiplier: * 1
For the "Apache::reload" i have checked the httpd.conf of apache and found the
rule:
Include 'C:/PROGRA~2/OTRS/OTRS/scripts/apache2-httpd-new.include.conf'
In this script I found the Apache2::Reload so assume because the include it's
loaded but why do i get this critcal warning?
---
# load all otrs modules
Perlrequire C:/PROGRA~2/OTRS/OTRS/scripts/apache2-perl-startup.pl
# Apache::Reload - Reload Perl Modules when Changed on Disk
PerlModule Apache2::Reload
PerlInitHandler Apache2::Reload
PerlModule Apache2::RequestRec
# set mod_perl2 options
<Location /otrs>
# ErrorDocument 403 /otrs/customer.pl
ErrorDocument 403 /otrs/index.pl
SetHandler perl-script
PerlResponseHandler ModPerl::Registry
Options +ExecCGI
PerlOptions +ParseHeaders
PerlOptions +SetupEnv
Order allow,deny
Allow from all
</Location>
---
For "mod_perl" I found in httpd.conf the following:
# load mod_perl
LoadFile 'C:/PROGRA~2/OTRS/StrawberryPerl/perl/bin/perl510.dll'
So also this looks okay i think...
Anybody any idea how i can solve these issues? and how to speed up my config...
Thanks in advance!
Best regards,
Dave
________________________________
Telio Nederland B.V. | Veemkade 540 | 1019 HE Amsterdam | Netherlands
Tel: 0320 750400 | E-Mail: [email protected] | Website: www.tel.io
--------------------------------------------------------------------------------
This electronic message contains information from Telio Nederland BV which may
be privileged or confidential. The information is intended to be for the use of
the individual(s) or entity named above. If you are not the intended recipient
be aware that any disclosure, copying, distribution or use of the contents of
this information is prohibited. If you have received this electronic message in
error, please notify us by telephone or email (to the numbers or address above)
immediately.
Diese Email enthaelt Informationen der Telio Nederland BV. Diese sind
moeglicherweise vertraulich und ausschliesslich fuer den Adressaten bestimmt.
Jeglicher Zugriff auf diese Email durch andere Personen als den Adressaten ist
untersagt. Sollten Sie nicht der fuer diese Email bestimmte Adressat sein, ist
Ihnen jede Veroeffentlichung, Vervielfaeltigung oder Weitergabe wie auch das
Ergreifen oder Unterlassen von Massnahmen im Vertrauen auf erlangte Information
untersagt. Sollten Sie diese elektronische Nachricht irrtuemlicherweise
erhalten haben, so informieren Sie uns bitte unverzueglich telefonisch oder per
Email (Kontaktdaten obenstehend).
---------------------------------------------------------------------
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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
