[otrs] Moving OTRS to new server, very slow

2014-10-08 Thread Michael Diederich
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

The old server is quite fast, the new is very slow:

Response::Agent: 64s taken
(URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich)
Response::Agent: 63s taken (URL:Action=AdminLog:mdiederich)
Response::Agent: 64s taken
(URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich)
Response::Agent: 64s taken (URL:Action=AdminLog:mdiederich)
Response::Agent: 64s taken
(URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich)
Response::Agent: 63s taken (URL:Action=AdminLog:mdiederich)
Response::Agent: 64s taken
(URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich)
Response::Agent: 64s taken (URL:Action=AdminLog:mdiederich)
Response::Agent: 64s taken
(URL:Action=AdminSysConfig&Subaction=Edit&SysConfigSubGroup=Core&SysConfigGroup=Framework&:mdiederich)
Response::Agent: 63s taken (URL:Action=AdminLog:mdiederich)
Response::Agent: 66s taken
(URL:Action=AdminSysConfig&Subaction=Update:mdiederich)
Response::Agent: 64s taken
(URL:Action=AdminSysConfig&Subaction=Edit&SysConfigSubGroup=Core::PerformanceLog&SysConfigGroup=Framework&:mdiederich)

# apache2ctl -M
Loaded Modules:
 core_module (static)

 perl_module (shared)

I use the  apache2-httpd-new.include.conf and modified the
otrs-2.4.12/scripts/apache2-perl-startup.pl:

use DBD::mysql ();
use Kernel::System::DB::mysql;

I checked the DNS records, I checked the AdminLog and now I have no other
ideas.

CheckMXRecord is disabled

Thanks for any help.

-- 
Viele Grüße,

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

2014-10-08 Thread Sander Goudswaard
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