From t.werner@traso.de Tue May 6 14:06:57 2014 From: Tilo Werner To: entwicklung@lists.traso.de Subject: [Entwicklung] Fwd: Cron php5 /var/www/xres_xpur/utility/calculateLogHistory.php Date: Tue, 06 May 2014 14:06:54 +0200 Message-ID: <5368D05E.4010702@traso.de> In-Reply-To: <20140505230001.E6EE718199@service01.xpur.xres.de> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3601754282020863440==" --===============3601754282020863440== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Dieser CronJob spamt auf allen service01 Servern der Kunden, bitte pr=C3=BCfe= n. -------- Original-Nachricht -------- Betreff: Cron php5 /var/www/xres_xpur/utility/calculateLogHistory.php Datum: Tue, 6 May 2014 01:00:01 +0200 (CEST) Von: root@service01.xpur.xres.de (Cron Daemon) An: root@service01.xpur.xres.de [2014-05-06T01:00:01+02:00] DEBUG =3D [3] display data and XML
=

SELECT hotelRequest, flightRequest, D=
ATE(createdAt), COUNT(*) as amount, SUM(IF(responseCode IN('200','206','712',=
'733','923'),1,0)) as successes, ROUND((SUM(IF(responseCode IN('200','206','7=
12','733','923'),1,0)) / SUM(1)), 2) as ratio, ROUND(AVG(runtime),2) as avgRu=
nTime FROM log_ba WHERE createdAt >=3D'2014-05-05' AND createdAt <=3D '=
2014-05-05 23:59:59' GROUP BY hotelRequest, flightRequest, DATE(createdAt)

SELECT hotelRequest, flightRequest, DATE(createdAt), COUNT(*) as amount, S=
UM(IF(responseCode IN('200','206','712','733','923'),1,0)) as successes, ROUN=
D((SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) / SUM(1)), 2) =
as ratio, ROUND(AVG(runtime),2) as avgRunTime FROM log_b WHERE createdAt >=
=3D'2014-05-05' AND createdAt <=3D '2014-05-05 23:59:59' GROUP BY hotelReq=
uest, flightRequest, DATE(createdAt)

--===============3601754282020863440==-- From s.rank-kunitz@traso.de Tue May 6 20:48:30 2014 From: Stefan Rank Kunitz To: entwicklung@lists.traso.de Subject: Re: [Entwicklung] Fwd: Cron php5 /var/www/xres_xpur/utility/calculateLogHistory.php Date: Tue, 06 May 2014 20:48:25 +0200 Message-ID: <53692E79.9000605@traso.de> In-Reply-To: <5368D05E.4010702@traso.de> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============9200057396656691022==" --===============9200057396656691022== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hallo Tilo, Danke f=C3=BCr die Meldung. Die Ausgaben dieses CRON k=C3=B6nnen problemlos n= ach /dev/null weitergeleitet werden. K=C3=B6nntest Du dies ggf. einrichten? VG SRK Am 06.05.2014 14:06, schrieb Tilo Werner: > Dieser CronJob spamt auf allen service01 Servern der Kunden, bitte pr=C3=BC= fen. > > > -------- Original-Nachricht -------- > Betreff: Cron php5 > /var/www/xres_xpur/utility/calculateLogHistory.php > Datum: Tue, 6 May 2014 01:00:01 +0200 (CEST) > Von: root@service01.xpur.xres.de (Cron Daemon) > An: root@service01.xpur.xres.de > > > > [2014-05-06T01:00:01+02:00] DEBUG =3D [3] display data and XML
=

SELECT hotelRequest, flightRequest, D=
ATE(createdAt), COUNT(*) as amount, SUM(IF(responseCode IN('200','206','712',=
'733','923'),1,0)) as successes, ROUND((SUM(IF(responseCode IN('200','206','7=
12','733','923'),1,0)) / SUM(1)), 2) as ratio, ROUND(AVG(runtime),2) as avgRu=
nTime FROM log_ba WHERE createdAt >=3D'2014-05-05' AND createdAt <=3D '=
2014-05-05 23:59:59' GROUP BY hotelRequest, flightRequest, DATE(createdAt)

class=3D"header 13993308018381" style=3D"background-color: #411931">Entry= ID: 13993308018381 Time: 01:00:01 Runtime: 0.10s

(click to select)

Mapper_Log_Abst= ract::getLastDays
Search SQL

SELECT hotelRequest, flightRequest, DATE(createdAt), COUNT(*) as amount, =
SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) as successes, ROU=
ND((SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) / SUM(1)), 2)=
 as ratio, ROUND(AVG(runtime),2) as avgRunTime FROM log_b WHERE createdAt >=
;=3D'2014-05-05' AND createdAt <=3D '2014-05-05 23:59:59' GROUP BY hotelRe=
quest, flightRequest, DATE(createdAt)

> > > > > _______________________________________________ > Entwicklung mailing list > Entwicklung@lists.traso.de > https://lists.traso.de/listinfo/entwicklung --=20 Mit freundlichen Gr=C3=BC=C3=9Fen =20 Stefan Rank-Kunitz - Entwicklung - ________________________________________________________ TraSo GmbH =20 Georg-Schumann-Str. 294 D-04159 Leipzig Tel.: +49 341 909 87 45 / Fax: +49 341 909 87 49 =20 E-Mail: s.rank-kunitz@traso.de Internet: http://www.traso.de =20 ________________________________________________________ Gesch=C3=A4ftsf=C3=BChrer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig, HRB 21850 --===============9200057396656691022== Content-Type: application/pgp-signature Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="signature.asc" MIME-Version: 1.0 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcgdjEuNC4xNCAoR05V L0xpbnV4KQpDb21tZW50OiBVc2luZyBHbnVQRyB3aXRoIFRodW5kZXJiaXJkIC0gaHR0cDovL3d3 dy5lbmlnbWFpbC5uZXQvCgppUUVjQkFFQkFnQUdCUUpUYVM1OUFBb0pFRVg2MXhjbGp6WnpFR1lI LzN0TVBBMXhPOWVwNWY0TUQxOHN6VEE2CmpPcUYxcEpHbGRIOXFIZHlFTGFGcExjYTlqRmdBRG01 WUNPb0xpZ2thOHE4WFJ2N2crVE9BeDJyQVRUTlRyMkkKcHhwbmd1NjJGNjI3cUZaL2RKb2dNQnZI a0RJVjF4MndhVGliUlRRSUR4SXZWdHpwU3RwQmpNallTaFZCRlNtbgpRY1pVSzgwYmROMUJNQWFv ZzRFZXpBVGw0K2xLR1RxOTBzWmVkVElJNjh3WVJFRzc1OE5sUHl3ZDVLUHlUdXh2CkxReDRuZHh4 QWtHVFlBTlRPTWEwMjYyTk5ha1FvdWpNTDk0N3NaRDdHZ3BmSmxuWUFZZ1NNNEIwYTdRZGF5YmYK STl1dkdTdnkxVU5oOXFxOXcycFJCU0NDMlNVNDYwM0J5QXdWbGxEbjcvWnFiU2NSNGk0K3BZOWNs QjhDVUdZPQo9NWNNWgotLS0tLUVORCBQR1AgU0lHTkFUVVJFLS0tLS0K --===============9200057396656691022==--