phpList 2.10.17 Remote SQL Injection and XSS Vulnerability

2012-03-21T00:00:00
ID ZSL-2012-5081
Type zeroscience
Reporter Gjoko Krstic
Modified 2012-03-21T00:00:00

Description

Title: phpList 2.10.17 Remote SQL Injection and XSS Vulnerability
Advisory ID: ZSL-2012-5081
Type: Local/Remote
Impact: Exposure of System Information, Exposure of Sensitive Information, Manipulation of Data, Cross-Site Scripting
Risk: (3/5)
Release Date: 21.03.2012

Summary

phplist is the world's most popular open source email campaign manager. phplist is free to download, install and use, and is easy to integrate with any website. phplist is downloaded more than 10,000 times per month.

Description

Input passed via the parameter 'sortby' is not properly sanitised before being returned to the user or used in SQL queries. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code. The param 'num' is vulnerable to a XSS issue where the attacker can execute arbitrary HTML and script code in a user's browser session in context of an affected site.

Vendor

phpList Ltd - <http://www.phplist.com>

Affected Version

2.10.17

Tested On

Microsoft Windows XP Professional SP3 (EN)
Apache 2.2.21
PHP 5.3.9
MySQL 5.5.20

Vendor Status

[05.03.2012] Vulnerabilities discovered.
[19.03.2012] Submited details to the vendor's bug tracking system.
[19.03.2012] Vendor investigates, confirms and fixes the issues.
[19.03.2012] Sent patch release coordination to the vendor.
[21.03.2012] Vendor releases version 2.10.18 to address these issues.
[21.03.2012] Coordinated public security advisory released.

PoC

phplist.txt

Credits

Vulnerability discovered by Gjoko Krstic - <gjoko@zeroscience.mk>

References

[1] <https://www.phplist.com/?lid=567>
[2] <https://mantis.phplist.com/view.php?id=16557>
[3] <http://www.exploit-db.com/exploits/18639/>
[4] <http://www.1337day.com/exploits/17788>
[5] <http://www.securityfocus.com/bid/52657>
[6] <http://secunia.com/advisories/48491/>
[7] <http://cxsecurity.com/issue/WLB-2012030192>
[8] <http://packetstormsecurity.org/files/111080>
[9] <http://xforce.iss.net/xforce/xfdb/74206>
[10] <http://xforce.iss.net/xforce/xfdb/74207>
[11] <http://www.osvdb.org/show/osvdb/80283>
[12] <http://www.osvdb.org/show/osvdb/80284>
[13] <http://securitytracker.com/id/1027181>
[14] <http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2740>
[15] <http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2741>

Changelog

[21.03.2012] - Initial release
[22.03.2012] - Added reference [3], [4], [5], [6] and [7]
[23.03.2012] - Added reference [8], [9], [10], [11] and [12]
[25.06.2012] - Added reference [13], [14] and [15]

Contact

Zero Science Lab

Web: <http://www.zeroscience.mk>
e-mail: lab@zeroscience.mk

                                        
                                            
phpList 2.10.17 Remote SQL Injection and XSS Vulnerability


Vendor: phpList Ltd
Product web page: http://www.phplist.com
Affected version: 2.10.17

Summary: phplist is the world's most popular open source
email campaign manager. phplist is free to download, install
and use, and is easy to integrate with any website. phplist
is downloaded more than 10,000 times per month.

Desc: Input passed via the parameter 'sortby' is not properly
sanitised before being returned to the user or used in SQL queries.
This can be exploited to manipulate SQL queries by injecting
arbitrary SQL code. The param 'num' is vulnerable to a XSS issue
where the attacker can execute arbitrary HTML and script code in
a user's browser session in context of an affected site.

Tested on: Microsoft Windows XP Professional SP3 (EN)
           Apache 2.2.21
           PHP 5.3.9
           MySQL 5.5.20


Vulnerability discovered by Gjoko 'LiquidWorm' Krstic
                            liquidworm gmail com


Vendor status:

[05.03.2012] Vulnerabilities discovered.
[19.03.2012] Submited details to the vendor's bug tracking system.
[19.03.2012] Vendor investigates, confirms and fixes the issues.
[19.03.2012] Sent patch release coordination to the vendor.
[21.03.2012] Vendor releases version 2.10.18 to address these issues.
[21.03.2012] Coordinated public security advisory released.


Advisory ID: ZSL-2012-5081
Advisory URL: http://www.zeroscience.mk/en/vulnerabilities/ZSL-2012-5081.php

Vendor Advisory: https://www.phplist.com/?lid=567
                 https://mantis.phplist.com/view.php?id=16557


05.03.2012

---


SQLi: http://localhost/public_html/lists/admin/?blacklisted=1&change=Vai&find=&findby=email&id=0&page=users&sortorder=desc&start=0&unconfirmed=1&sortby=1[SQL Injection Point]

XSS:  http://localhost/public_html/lists/admin/?num=&lt;script&gt;alert(1);&lt;/script&gt;&option=bounces&page=reconcileusers