May 2014 - Entwicklung

[WTF] Datenbankstruktur LMX
by Tilo Werner 23 May '14

23 May '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hallo, da LMX zu recht drängelt einen neuen DB-Server zu bekommen, habe ich die weiteren Schritte heute noch eingeleitet. Im ersten Schritt will ich die SQL-Dumps vom db02.lmx in einen Lenny/MySQL-5.0 Server (db04.lmx) mit "innodb-file-per-table" importieren. Dies habe ich eben angefangen und bin auf folgenden Fehler beim Import gestossen: create database xres_lmx_bookings ERROR 1166 (42000) at line 1740: Incorrect column name 'IF(method != 'CC' AND (bank_account IS NOT NULL OR bank_account ' Der Abschnitt im SQl-Dump, der den Fehler verursacht: - -- - -- Temporary table structure for view `view_payment` - -- DROP TABLE IF EXISTS `view_payment`; /*!50001 DROP VIEW IF EXISTS `view_payment`*/; /*!50001 CREATE TABLE `view_payment` ( `payment_id` int(11) unsigned, `booking_id` int(11) unsigned, `owner` varchar(30), `method` enum('CC','DN','RM','SEPA'), `cc_type` enum('EC','MC','VI','AX','CA'), `IF(method = 'CC' AND (cc_number IS NOT NULL OR cc_number != ''),` varchar(16), `cc_cvc2` char(3), `cc_valid` varchar(7), `bank_code` varchar(34), `bank_name` varchar(30), `IF(method != 'CC' AND (bank_account IS NOT NULL OR bank_account ` varchar(9), `amount` decimal(7,2), `cc_fee` decimal(5,2), `update_ok` tinyint(1) unsigned ) */; Ein Nachschauen in der Tabellenstruktur bei LMX bringt folgendes zu Tage: mysql> use xres_lmx_bookings; mysql> describe view_payment; Siehe Anhang. Querprüfung bei JT zeigt, dass es dort im Schema xres_jt_bookings keine Tabelle view_payments gibt, also habe den Teil im Dump gelöscht. lg, Tilo - -- Mit freundlichen Grüßen Tilo Werner - - Systemadministration - _______________________________________________ TraSo GmbH G.-Schumann-Str. 294 04159 Leipzig E-Mail: t.werner(a)traso.de Internet: https://www.traso.de _______________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig (HRB 21850) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iQIcBAEBAgAGBQJTfmTHAAoJEFfjOJdKpi1E32MQAKnb4PzBAvbiY+tlkp7glrJ2 KGeE1D4Ha3jVAXcPwXAFURopwxkrEbwi8qeK63BGtEGVgpKYTjTDjU7XKQXFgSXl uv12QaEjw8rQ/bzaxt8cpsOs3NVXbk/ofCIExknVN8RUEPs6LhJ6PA9jdjaC3B/r VadmgOj02W6ajp8Xbj1hy3r2p04u7qCKOeRB2eegh9scQJMfOUH1es0HfOmkMsHy kNPDwGw2BJEZ7DFq7ItKSEtPl5wYZzNTekO0Pe2rvaOj8sWmdBU2sfCm1u4P3mbU yCLdov/SPKdEBbzk5pwxhFS9FLWVuerEOuOZIoXvCpC+p+9yi6T9UthJ9+2CU1X2 2BtDB047DuOW23dJv3j/F+rRkC6Px8PkvDOUpTwL/E2dbhyqPLw1x3vgXjB6gC6G B56mSl9ZaveooPt5cVw+FhH2KhImUzRPKFZXD8VHLcqLQ6tUpt/4HGxgKh0MtAo8 GzZX4PzDMN97ub6sdKWURhnVDA8aGjrVphca6oEIGHyzSz+0uwzDDZww+zQl1SsT hgGxiTJO+ZMdiZHTVmRl8l7yVOy91EmF14h3hEi0pGr5UrfA3MMdagq7bDHKE+rs 07yRBZzcqq8FHt5tEqLHKVS7ADsLF2SYCCD20dJ+6yTpwSgYRMDh/ZUrtcEOtOWV SRMWrl9FtPltGHyZxRaZ =Z/9M -----END PGP SIGNATURE-----

3 2

[FOR] debugLevelTwo
by Tilo Werner 22 May '14

22 May '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 ... müllt die Platte voll! lg, Tilo - -- Mit freundlichen Grüßen Tilo Werner - - Systemadministration - _______________________________________________ TraSo GmbH G.-Schumann-Str. 294 04159 Leipzig E-Mail: t.werner(a)traso.de Internet: https://www.traso.de _______________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig (HRB 21850) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iQIcBAEBAgAGBQJTevL4AAoJEFfjOJdKpi1ExbkP/35/PbgXbBWJYzkzF7FfgNDn NSXLwCBOyeUOtjDeOyvZYLYNJ/eZjb0mxYNeyb6ANMpQxwnp+Nr24kDB9HDogLwp 0EfuF8twql8antkoVyVVWRZjmFXEp9w/SsLSq5tfmBch02MhLM+nVez4XOB/kxm3 5A4LCqxOJTmpFZcmY7uajt1i7qRgDD71r8WF2Dt2UnW86TYrpLTOte+WEugdaS2Q y5pNISTmmNHteJAIjtywzNo0TiBce58Fr+hexirvLzo41OtOTDP/E3ZiAaCu4s1h hNbfqXPYZiCc2D3V8nPzYwwKJm1Qi+hdYAxCXQhPslDrBrUx0l3it4QlEd1Tp568 7DqntKq0/DEuPiIsafd/1VTnj8Ew0se/e8Tht6f/bKOMpMST+8nBTOiW1qVUdegw pN2qAJvQupR47hEy+wq2sLzjAcnSmPXh2ME704hw2LxKXEh1xhvQog6Zgonm4gbd jbTDnm2SWJGlrH5rIBzCq50/jjpp5kjKsniHQrha/4K7jPm239tindkJvROJhb/e u5BGB7nN0u1PImGp2aJNJheEXT/I6kxpCmjooddj59BqmOqt8MUmiOudgCkGdIpZ 4W6bzvZBHr6WyzQ1ORzzmEdnCuTdffuPXCoFdanZp59ncKu2LscOBJkk8dF2p7M4 aUldzPYnup9mZoZZeh4b =SSps -----END PGP SIGNATURE-----

3 7

Fwd: Cron <root@service01> /usr/bin/php5 /var/www/xres_opd/utility/zf_cli.php //report/Bookingcoregatewaystatistic/calculate > /dev/null
by Tilo Werner 21 May '14

21 May '14

SPAM -------- Original-Nachricht -------- Betreff: Cron <root@service01> /usr/bin/php5 /var/www/xres_opd/utility/zf_cli.php //report/Bookingcoregatewaystatistic/calculate > /dev/null Datum: Wed, 21 May 2014 01:00:01 +0200 (CEST) Von: root(a)service01.fer.xres.de (Cron Daemon) An: root(a)service01.fer.xres.de Could not open input file: /var/www/xres_opd/utility/zf_cli.php

3 3

Fwd: Cron <root@test01> php5 /var/www/xres_lts/infx2cache/GC_obsolete_hotels.php > /var/www/xres_lts/infx2cache/log/GC_obsolete_hotels.html
by Tilo Werner 21 May '14

21 May '14

Neuerlicher Spam... -------- Original-Nachricht -------- Betreff: Cron <root@test01> php5 /var/www/xres_lts/infx2cache/GC_obsolete_hotels.php > /var/www/xres_lts/infx2cache/log/GC_obsolete_hotels.html Datum: Wed, 21 May 2014 07:00:01 +0200 (CEST) Von: root(a)test01.lts.xres.de (Cron Daemon) An: root(a)test01.lts.xres.de Could not open input file: /var/www/xres_lts/infx2cache/GC_obsolete_hotels.php

2 1

Integration Stadis-Konfiguration ins Deployment
by Tilo Werner 20 May '14

20 May '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bitte uns (Jan & mir) eine Anleitung geben, damit wir Änderungen selbstständig einpflegen können. Betrifft die "alten" Stadis-PHP-Scripte/Gateways. Danke, Tilo - -- Mit freundlichen Grüßen Tilo Werner - - Systemadministration - _______________________________________________ TraSo GmbH G.-Schumann-Str. 294 04159 Leipzig E-Mail: t.werner(a)traso.de Internet: https://www.traso.de _______________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig (HRB 21850) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iQIcBAEBAgAGBQJTex7yAAoJEFfjOJdKpi1EEEAQAIvr3LWG4NOpQa/RgclrP9ET 2B74fXqZcMrxFL1K+1SGJjN7d+igPhJ2Z92EniLr0a3Du/wtTdqa8TIdhSzC3Xl5 aTNGJyBwf4HKZ6rbhV0ypAKqyICEvU2jIL47Kf4AJnk1PxizsQQweRueP6XPphxX m5rciXDNXP5oYfpoXGX/AE2cOcED67NR7KAzrIdY1f1N7pWn5goFiE5rEA8LED+n Irchx7LtoeS+nrPe2qgVO1wMyl+ikYhOTXtTGHdqr8O8OJFd1zCaLr9yuRQ/v7p9 QtN1iXMusxxfzD+LB1gWQUo8OIMlxVibc6xNm89xFwIsBLuZsGvZjFjFyMJRn5RH x5LwQ42D0tdH/toavno3jqNmyjV09HJst7f8PNaIruSU9b1aPi6WGg+FDugQ3MZe Izp4FBuRXkilf3wOo6zINBOFTklGKKafDTNzRPm1NrKKaLMOjNpbXfvLan7aLonu /jAccd2OjfWVmls1QQdpzkHXka4naYoV1dxaFrBsskRmInfb2bdbRIDnHrHp/dyj KztU3W/4UNMNi56t8wLavbeCmuhSc7A5Db+zFYwnX7xV73WRsbT6Sqj2hRLHaaoQ IQgdcdASIOAchgpizfLUCwf3U1fyCtVcdlXNfAbBl4XpoxHRQqWy6BRixBnbKqw5 IsjOXAFFIPNW663DkJDo =Blfe -----END PGP SIGNATURE-----

2 1

steward.xres.traso.de (FlugServer)
by Tilo Werner 15 May '14

15 May '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hallo, der dedizierte Server für die AER-Importe? ist nun bereit euren (PHP?)-Befehlen zu gehorchen. Dies ist ein prototypisches Setup auf Basis von PHP 5.4 und Debian 7 aka Wheezy. Zu erreichen ist der Server via SSH unter: H: steward.gs.traso.de B: $YourNamedAccount P: ToSet Have a lot of fun, Tilo PS: Sollten Bibliotheken, Pear-Pakte usw. fehlen, dann bitte melden und nicht einfach selbst installieren! - -- Mit freundlichen Grüßen Tilo Werner - - Systemadministration - _______________________________________________ TraSo GmbH G.-Schumann-Str. 294 04159 Leipzig E-Mail: t.werner(a)traso.de Internet: https://www.traso.de _______________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig (HRB 21850) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iQIcBAEBAgAGBQJTdTsnAAoJEFfjOJdKpi1E6EoP/0nAY2w0iUVBMylX46l2ovV0 gSmyoWIlKLtrs9dtyBO2svTH9MMdeTnc3qBNOTBqPwHLvIIfwOg5RSOCMMKOa0jr +PvEZ7ay9KRHkh8grUpsz96FZCGO4EqecvQ7HV8zHTvRNZJDFW1QkHlG8P02xcJW r2lvJL6X2yzM1IWe1NBAe0rdbaVwizKsjh1l7zlEkA+BvkfPqYqgifKcamTh6Tmv bveuU1myn+pqb+c6jgPyTcQ2p9q4NLliO6JNEvStfKwpG/K6zAPL1IiqZ0Ai+tvQ ZHyG1SPuVi6U3XJ/qMmh4nheTdOPMya5ARe+LOKz4Lyu8hiZhSPVVXvwf9PjCvMk NyWAMuofg0acQgYE4vsThGkeZD3wUutJM4JCgW3UTyz2eVp6sc5eWgiBLz4GJL7R 9BVDrvDwPi0rAjkoUvi5Oxm6VmvmTdqjMB2/5tIIDARYnFjUZ3tMATqFlWuGv3x+ R19LawgDOFqgGfXWEZaLKjKT7qlCMGTeoQQ98X79xpkV2VlxotU994P6dm6Rgt5N dZSCyUGyqyNRv/GEubBkd0cOucvi6FJcV/dmSkSD62/q3tDlO0adQKeS68yu6IyX tmZ36NWKUxuGwuaCNpKYWxKkv3Ur+USnfHF5htKC2NSbrf1ScCx5Hw6uyhcVr8dY qXgqmBWruA+oGCvG7W+T =AH0G -----END PGP SIGNATURE-----

2 1

Optimierungen im GIT-Prozess
by Stefan Rank Kunitz 09 May '14

09 May '14

Hallo Entwickler(innen), Im Task http://jira.app.activate.de/browse/XRES-2009 habe ich die besprochenen Optimierungen am GIT-Prozess zusammengefasst und bitte um ZurKenntnisNahme. Viele Grüße SRK -- Mit freundlichen Grüßen Stefan Rank-Kunitz - Entwicklung - ________________________________________________________ TraSo GmbH Georg-Schumann-Str. 294 D-04159 Leipzig Tel.: +49 341 909 87 45 / Fax: +49 341 909 87 49 E-Mail: s.rank-kunitz(a)traso.de Internet: http://www.traso.de ________________________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig, HRB 21850

1 0

Fwd: Cron <root@service01> /usr/bin/php5 /var/www/xres_opd/utility/zf_cli.php //report/Bookingcoregatewaystatistic/calculate > /dev/null
by Tilo Werner 06 May '14

06 May '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bitte prüfen. - -------- Original-Nachricht -------- Betreff: Cron <root@service01> /usr/bin/php5 /var/www/xres_opd/utility/zf_cli.php //report/Bookingcoregatewaystatistic/calculate > /dev/null Datum: Tue, 6 May 2014 01:00:01 +0200 (CEST) Von: root(a)service01.fer.xres.de (Cron Daemon) An: root(a)service01.fer.xres.de Could not open input file: /var/www/xres_opd/utility/zf_cli.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iQIcBAEBAgAGBQJTaNFlAAoJEFfjOJdKpi1E5awQAIPztrQCE5SRFHVJXnvAtVHL jAvzADkoyO9/oI2vy2QaE6W9+5cbG56Go5j5ofUglaAIUYkWc8vqFvuS4pPYU80x pGT/vDs8V90NDUzCFK6yJN0RK5455XDQ1u9BQe46Cy65CEYLrTXx63Ih300ZKs4e HFSLlXgXAHWye6VBEp/a8EaKsQiU52+dnPFv+wL/U4lo4j+poSkbjuktHMscwhgM r9uwDC2e6pxY6w35WzUJpdPOFiHtcvBRq3HnEA84ZGEm3XVFaAZ0Yn819KtacEUU QdcT6n9yk3K4iHAEH8MqE5EPTKccIgXd7769tzAPF0z/qMxi3HUUQfvTWVwIDlJ/ XnISV5KdTIf6ryMM7s53R2tP5KV7XItzxM+JJ4oAsM7fc4rDpT5KYchvCusk3swm sj0sE/GYV3G16YHMG1Ke6lvarg5MWIYYk2+5BE/cNO7pMjT71ezYLF7dVe1thjel aimZimrBbHfkCelguLplFCUlro27R+ULbt3A9bF9os0JKdTbtFLQ3D6AsqVPkibm X+65rgivBtp7ur1cHPGUwAmRoBbrqtViYwB5W4U6io1GyOCMYwQeONVPNjnCasHD iooYR9P2CRrosVrHuoO4pF7/lWX9baTWItmFFD+ZCt5GlQtsmNnWycjJwmGdS6PH 9GErL83ZV+U9t/zMxMtL =k0uh -----END PGP SIGNATURE-----

2 1

Re: [Entwicklung] Cron <root@service01> php5 /var/www/xres_lmx/utility/importContingentTocs.php
by Tilo Werner 06 May '14

06 May '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dieser Cron-Job spamt auf den service01 von * lmx * lts * jt * hocl Bitte prüfen. Am 05.05.2014 20:02, schrieb Cron Daemon: > 81 TOCs importiert - -- Mit freundlichen Grüßen Tilo Werner - - Systemadministration - _______________________________________________ TraSo GmbH G.-Schumann-Str. 294 04159 Leipzig E-Mail: t.werner(a)traso.de Internet: https://www.traso.de _______________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig (HRB 21850) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) iQIcBAEBAgAGBQJTaNEHAAoJEFfjOJdKpi1EipoP/3FEecSnGSzJSpl++/tsXQXb 8SvzLTPsgqGX/YnHNHkJpH/CpWn6152OxaQVfrI/Vi99hOCoxCylvhBL7GGNZEQf AScTCAS0x2tPmqE7R7NfoPJF+klDa4stL7Ly0FBxTrxJUXdAO2NHili5GgcqoPfa TziHe4wpME4qJbA586diPIseBCA8Ze1WvDf3Dq/c/fu895mp0chmQb2pUnHmsiaW 5guu9l33fSAU5xWwI8fC5NGWdls1Izm01Gbqa8KlPkq9j10Qyj8j7RSk2eJIMN5j fCynjyOP5N2awHODk+arLwlrTEOEQ815yxSdKzHDkRwDzyHXqSJZOBKCDPjQYn3v e9VTYLgdN9dKHxeYMGPomdMoyepdy1El5J+WxxoOH0oERHgFjotAlBpPEHAReEWi H/rX0cs1RZPwZOuJpQ6gRdP03aFemc1HKn/tfK2rqjf96kkk7gaAftwggNN3h+JO 9TgbQmIGaQGFzO44IV5RRJNssbXWkaHLLIf3ieguYkvsv+ZlOVIDacTf6Y1Vh5Sm ETieRH9ALNdT0ztqgZd6xmFa/xpyYnAijK5QRYqaS9P+ATWjcGFDFZFXVoels0Gt B3TXqWUFSZFDMNzlJDRqbFeqdYDPx2sUPvKMZJFHu1pQRQXZBQfpEfeP1u/aJZOq 0lLG/wNhRUVo/ZtarKXJ =zdJI -----END PGP SIGNATURE-----

2 1

Fwd: Cron <root@service01> php5 /var/www/xres_xpur/utility/calculateLogHistory.php
by Tilo Werner 06 May '14

06 May '14

Dieser CronJob spamt auf allen service01 Servern der Kunden, bitte prüfen. -------- Original-Nachricht -------- Betreff: Cron <root@service01> php5 /var/www/xres_xpur/utility/calculateLogHistory.php Datum: Tue, 6 May 2014 01:00:01 +0200 (CEST) Von: root(a)service01.xpur.xres.de (Cron Daemon) An: root(a)service01.xpur.xres.de [2014-05-06T01:00:01+02:00] DEBUG = [3] display data and XML<br><!DOCTYPE html><head><style type="text/css"></style><script type="text/javascript" src="../../xadmin/js/jquery14/jquery-1.4.2.min.js"></script><script type="text/javascript" src="../../xadmin/js/jquery14/jquery-ui-1.8.4.custom.min.js"></script><script type="text/javascript">// Shows all entries that are of this debug id, hides all other function showEntries(currentId) { $("div.header").hide(); $("div.data").hide(); $("div[class$=" + currentId + "]").show(); $("input.searchLevelTwo").val(currentId); } // Shows all entries function showAllEntries() { $("div.header").show(); $("div.data").show(); } // searches for a certain pattern function search() { var searchText = $("input.search").val(); // Input field text var objectArray = new Array(); var dataBlocks = $("div.data"); var arrayLength = dataBlocks.length // Iterating through the items and scanning the html code for (var i = 0; i < arrayLength; i++) { if (dataBlocks[i].innerHTML.search(searchText) > -1) { // We found an entry and remember the id var id = dataBlocks[i].getAttribute('class').replace("data ", "").replace("header ", ""); objectArray[id] = id; } } // Hiding everything $("div.header").hide(); $("div.data").hide(); // Showing the ones we want for (var key in objectArray) { $("div." + key).show(); } } // Links ot the level 2 logs ans filters the given ID function searchLevelTwo() { var searchText = $("input.searchLevelTwo").val(); // Input field text var newURL = window.location.href.replace('debugLog', 'debugLogLevelTwo')+ '?id=' + searchText; window.location.href = newURL; } // Grabs the parameter from the url and filters the level two log for that one function filterLevelTwo() { var url = window.location.href; var id = url.substr(url.indexOf('?id=') + 4); $("input.filterLevelTwo").val(id); showEntries(id); } function backToLevelOne() { var newURL = window.location.href.replace('debugLogLevelTwo', 'debugLog'); newURL = newURL.substr(0, newURL.indexOf('?id=')); window.location.href = newURL; } function toDbEntry(processId) { var newURL = window.location.href.substr(0, window.location.href.indexOf('/xres/')); newURL = newURL + '/xres/showLogEntry.php?processid=' + processId; console.log(newURL); window.location.href = newURL; } function backToMainPage() { window.history.back(); }</script></head><body><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.00s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b></b><br>Testbeginn</div><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.03s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b>Mapper_Log_Abstract::getLastDays</b><br>Search SQL</div><pre><div class="data 13993308018381">SELECT hotelRequest, flightRequest, DATE(createdAt), COUNT(*) as amount, SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) as successes, ROUND((SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) / SUM(1)), 2) as ratio, ROUND(AVG(runtime),2) as avgRunTime FROM log_ba WHERE createdAt >='2014-05-05' AND createdAt <= '2014-05-05 23:59:59' GROUP BY hotelRequest, flightRequest, DATE(createdAt)</div></pre><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.10s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b>Mapper_Log_Abstract::getLastDays</b><br>Search SQL</div><pre><div class="data 13993308018381">SELECT hotelRequest, flightRequest, DATE(createdAt), COUNT(*) as amount, SUM(IF(responseCode IN('200','206','712','733','923'),1,0)) as successes, ROUND((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 >='2014-05-05' AND createdAt <= '2014-05-05 23:59:59' GROUP BY hotelRequest, flightRequest, DATE(createdAt)</div></pre><div class="header 13993308018381" style="background-color: #411931">Entry ID: 13993308018381 Time: 01:00:01 Runtime: 0.11s <div class="click" onclick=showEntries(13993308018381)>(click to select)</div><br><b></b><br>result</div>

2 1