Re: [otrs] Moving OTRS to new server, very slow
Hi, On Wed, Oct 8, 2014 at 11:45 AM, Michael Diederich < michael.dieder...@gmail.com> wrote: > Hi, > > I'm moving my old OTRS installation to a fresh server. In a later step, I > want to upgrade to a newer version. > > New VM: Fresh Debian stable 64bit, dedicated mysql-server 5.6, OTRS 2.4.12 > Old VM: Old Debian stable 32bit, small localhost mysql, OTRS 2.4.12 > > I moved the old localhost mysql to the decicated mysql-server. Still no change - the old otrs is fast and the new otrs is terribly slow. old server: Apache/2.2.9 # apache2ctl -M Loaded Modules: ... cgi_module (shared) ... perl_module (shared) .. Syntax OK #/etc/apache2/conf.d/otrs2 ScriptAlias /otrs/ "/opt/otrs/bin/cgi-bin/" Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/" AllowOverride None Options +ExecCGI -Includes Order allow,deny Allow from all AllowOverride None Order allow,deny Allow from all new server: Apache/2.2.22 # apache2ctl -M Loaded Modules: ... cgid_module (shared) ... perl_module (shared) ... Syntax OK #/etc/apache2/conf.d/otrs2 ScriptAlias /otrs/ "/home/otrs-2.4.12/bin/cgi-bin/"Alias /otrs-web/ "/home/otrs-2.4.12/var/httpd/htdocs/" Perlrequire /home/otrs-2.4.12/scripts/apache2-perl-startup.pl PerlModule Apache2::Reload PerlInitHandler Apache2::Reload #PerlModule Apache2::RequestRec #test no differences ErrorDocument 403 /otrs/index.pl SetHandler perl-script PerlResponseHandler ModPerl::Registry Options +ExecCGI PerlOptions +ParseHeaders PerlOptions +SetupEnv Order allow,deny Allow from all PerlOptions -ParseHeaders AllowOverride None Options +ExecCGI -Includes Order allow,deny Allow from all AddOutputFilterByType DEFLATE text/html text/javascript text/css text/xml application/json text/json AllowOverride None Order allow,deny Allow from all AddOutputFilterByType DEFLATE text/html text/javascript text/css text/xml application/json text/json ... #/home/otrs-2.4.12/scripts/apache2-perl-startup.pl changed the following: # set otrs lib path! use lib "/home/otrs-2.4.12/"; use lib "/home/otrs-2.4.12/Kernel/cpan-lib"; # enable this if you use mysql use DBD::mysql (); use Kernel::System::DB::mysql; Anyone any idea? :( - 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
Re: [otrs] Moving OTRS to new server, very slow
No clue why, but for the future DenverCoder9:
I installed the Apache2 DBD perl module:
perl -MCPAN -e 'install Apache::DBI'
and changed the apache2-perl-startup.pl
use CGI (); CGI->compile(':all');
#use CGI ();
#CGI->compile(':cgi');
use CGI::Carp ();
use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs;host=loadbalancer', 'otrs',
'');
use DBI ();
and now it is as fast as the old system. I already migrated the old
database to the new dedicated mysqlserver but this was not part of the
problem (or of the solution).
Michael
-
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
Re: [otrs] : Auto send Statistics by mail weekly
That's just what I was looking for. Thanks very much! *Marcel Sánchez Toledano* 2014-10-08 16:54 GMT+02:00 Sander Goudswaard < s.goudswa...@westerscheldetunnel.nl>: > Example: go to $OTRS_HOME/var/cron and add your own text file, e.g. > marcel_stats > > > > Use these contents (e.g. for quarterly reports): > > > > 1 0 1 1,4,7,10 * /opt/otrs/bin/otrs.GenerateStats.pl -n 10101 -r > your@email.adddress -s otrs@from_address -m 'OTRS Quarterly Report' > > -f Print > > > > The –n number is the report ID which you can find through the interface. > > > > Sander > > > > - > 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] Authentication failed for customers - Windows 2012 R2 AD LDAP
Hello I have an Active Directory installed on Windows Server 2012 R2. The OTRS can view all users, however, when I try to authenticate, displays error like username or password is incorrect. Does anyone have any tips on how to solve? Thanks Raul Libório http://rauhmaru.blogspot.com/ openSUSE Member | Linux User #581 - 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
Re: [otrs] Authentication failed for customers - Windows 2012 R2 AD LDAP
Fix Config.pm (If you would like more assistance, you may want to post this question in the forum, rather than posting information in this mailing list for all eternity.) On Thu, Oct 9, 2014 at 5:11 PM, Raul Libório wrote: > Hello > > I have an Active Directory installed on Windows Server 2012 R2. The OTRS > can view all users, however, when I try to authenticate, displays error > like username or password is incorrect. > Does anyone have any tips on how to solve? > > Thanks > > Raul Libório > http://rauhmaru.blogspot.com/ > openSUSE Member | Linux User #581 > > - > 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
Re: [otrs] Authentication failed for customers - Windows 2012 R2 AD LDAP
Ok bro. Thanks. Raul Libório http://rauhmaru.blogspot.com/ openSUSE Member | Linux User #581 On Fri, Oct 10, 2014 at 12:31 AM, Gerald Young wrote: > Fix Config.pm (If you would like more assistance, you may want to post > this question in the forum, rather than posting information in this mailing > list for all eternity.) > > On Thu, Oct 9, 2014 at 5:11 PM, Raul Libório wrote: > >> Hello >> >> I have an Active Directory installed on Windows Server 2012 R2. The OTRS >> can view all users, however, when I try to authenticate, displays error >> like username or password is incorrect. >> Does anyone have any tips on how to solve? >> >> Thanks >> >> Raul Libório >> http://rauhmaru.blogspot.com/ >> openSUSE Member | Linux User #581 >> >> - >> 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
