30 Jul 2009 von Alexander Kornbrust.

Yesterday Chris Gates gave his presentation (here the summary) about hacking Oracle with Metasploit at the Blackhat 2009 USA. Chris described the Oracle Attack Methodology and how to use Metasploit for this methodology (here is one of my older tutorials for Backtrack2 from 2006 following this methodology (but showing only a subset)):

• Locate Oracle Systems.
• Determine Oracle Version.
• Determine Oracle SID.
• Guess/Bruteforce USER/PASS.
• Privilege Escalation via SQL Injection.
• Manipulate Data/Post Exploitation.
• Cover Tracks.

The first new Metasploit module is TNS mixin (similar functionality to tnscmd.pl).
This module is detecting the SID via status command (8-9i only), via Brute Force, via Dictionary Attack (with the SID.txt from Red-Database-Security),spying the SID from Enterprise Manager Control/Database Control. If you need more information about detecting Oracle SID you should hava a look on “Detecting Oracle SIDs” is from Alexandr Polyakov.

A small correction: Th TNS MIXIN is detecting the version of the TNS listener and NOT the version of the Oracle database. In most cases this is identifical but not always. A pentester should check the results from the view v$version as well (”select * from v$version”).

The next step is to use guess username/password combinations using Pete’s Oracle default password list. If this was successful, it is possible to escalate the privileges if the database is unpatched. Chris provides SQL exploits for several (older) PL/SQL packages (lt_findricset, lt_findricset_cursor, dbms_metadata, dbms_cdc_ipublish, dbms_cdc_publish, lt_compressworkspace, lt_mergeworkspace, lt_removeworkspace, lt_rollbackworkspace).

After the privilege escalation Metasploit can run OS commands (e.g. install a trojan, get a remote shell, create users, …). Chris was using Java to run OS commands via Oracle. Keep in mind that this is one possibility. Additional options can be found in the Oracle documentation or here.

If you need more info about Oracle security you can check my “Oracle Security Cheat Sheet” paper.

Well done Chris.

Geschrieben in Oracle Security | Drucken | 2 Kommentare »

29 Jul 2009 von Alexander Kornbrust.

The Oracle & Metasploit material (PDF, Slides) from the Blackhat 2009 conference from Chris Gates is already online. A short review will be done tomorrow.

Geschrieben in Tools, SQL Injection, Security | Drucken | Keine Kommentare »

27 Jul 2009 von Alexander Kornbrust.

I just posted 2 new advisories for the July 2009 CPU from Oracle on my website.

The first advisory (CVE-2009-1021) is about PL/SQL Injection vulnerabilities in the package DBMS_EXPORT_EXTENSION. In July 2006 Oracle fixed already vulnerabilities in this package but the bugfix was not implemented properly.

The second advisory (CVE-2009-1969) is about an information disclosure problem in Oracle audit logs. In some cases these audit logs can contain password hashes.

Last Friday Denis Yurichev released 4 new advisories concerning the TNS Listener in Oracle 10g/11g. All advisories are explained with a proof-of-concept code.

The first and most critical bug (CVSS 9.0 Win/6.5 Linux) advisory (CVE-2009-1020)  is remote exploitable but requires an authentication. All databases (9.2.08, 10.1.0.5, 10.2.0.4 and 11.1.0.7) are affected.

The second advisory (CVE-2009-1019) is remote exploitable without authentication. The P.o.C.of Denis creates a denial of service against the database. All databases (9.2.08, 10.1.0.5, 10.2.0.4 and 11.1.0.7) are affected.

The third advisory (CVE-2009-1963) is remote exploitable with authentication. The P.o.C.of Denis creates a denial of service against the database.  11.1.0.7 is affected.

The fourth advisory (CVE-2009-1970), remote exploitable without authentication, is  a denial of service vulnerability against the database. Oracle  10.1.0.5, 10.2.0.4 and 11.1.0.6 are affected.

Geschrieben in CPUJul2009 | Drucken | Keine Kommentare »

26 Jul 2009 von Alexander Kornbrust.

Bernardo Damele has released a new version of his SQL Injection Tool SQLMap 0.7.1. This version comes with new features like support for Mac OSX, support of Metasploit wrapping functions plus several bugfixes (changelog).

Geschrieben in SQL Injection, software | Drucken | Keine Kommentare »

24 Jul 2009 von Alexander Kornbrust.

Today Eric Maurice from Oracle Global Product Security released an interesting article about “Ensuring Critical Patch Update Quality“. He explains the entire test process,  timeline (e.g. 15 weeks before the CPU is released the fixes will be selected), ….

Geschrieben in Security, Oracle Security | Drucken | 1 Kommentar »

20 Jul 2009 von Alexander Kornbrust.

This time I am writing this blog entry as a victim…

My data (including my creditcard number) was stolen from the website elance.com. 24 hours later my creditcard number as abused. Luckily the criminals did a test booking for approx. 1 USD (in a webshop in the US) and the fraud detection team from Mastercard immediately locked my creditcard.

Here the short history:

Last friday, 18 July 2009, I received an email from Elance.com:
We recently learned that certain Elance user information was accessed without authorization, including potentially yours. The data accessed was contact information — specifically name, email address, telephone number, city location and Elance login information (passwords were protected with encryption). This incident did NOT involve any credit card, bank account, social security or tax ID numbers.

We have remedied the cause of the breach and are working with appropriate authorities. We have also implemented additional security measures and have strengthened password requirements to protect all of our users.

We sincerely regret any inconvenience or disruption this may cause.

If you have any unanswered questions and for ongoing information about this matter, please visit this page in our Trust & Safety center: http://www.elance.com/p/trust/account_security.html

For information on re-setting your password, visit: http://help.elance.com/forums/30969/entries/47262

Thank you for your understanding,

Michael Culver
Vice President
Elance

I thought: “Good to know that this happened. My creditcard information is not affected.”
20. july - Monday morning:  I tried to buy some gasoline. This was not possible because my card was not accepted: “Errorcode 02” . I payed with a different card and called the lufthansa mastercard service. They explained me that someone tried to buy something for 1 USD in Arizona and Mastercard has locked my card…

I will get a new creditcard within the next few days.

20. july - Noon: At home I read the email from elance again and I was really pissed off (passwords encrypted and not hashed) that they lied in the previous email. Send an email to elance.com (ticket#20836) and asked for details of this break-in. No answer so far…

will be continued….

Geschrieben in Security | Drucken | 1 Kommentar »

15 Jul 2009 von Alexander Kornbrust.

Yesterday night Oracle released the July 2009 CPU. This CPU contains 30 fixes for several Oracle products. 10 security issues are fixed in the Oracle Database Server.As always the usual suspects (Esteban, David, Joxean, Alexandr, Dennis) and a few others reported issues in Oracle products.

The 3 most critical bugs this time are related to the TNS Listener and one of the bugs be exploited without authentication.These issues CVE-2009-1020, CVE-2009-1019, CVE-2009-1963 are rated with CVSS 9 (for Windows), 7.5 for Unix.
Oracle has also fixed 3 of my findings in the database (3 out of 10 :-))

• SQL Injection in DBMS_EXPORT_EXTENSION (previously fixed in April 2006)
• Information Disclosure (Password Hash) in Database Vault
• Information Disclosure (Password Hash) in Audit Vault

More details will be published within the next few days. The updates for our Oracle database scanner Repscan (free trial available) will be released within the next 2 days.

Geschrieben in CPUJul2009, SQL Injection, Security, Allgemein | Drucken | 1 Kommentar »