SNS Vulnerability

mySeat Restaurant Reservation System Cross-Site Scripting and SQL Injection Vulnerabilities

Description

Multiple vulnerabilities have been discovered in mySeat Restaurant Reservation System, which can be exploited by malicious people to conduct cross-site scripting and SQL injection attacks.
1) Input passed via the "term" GET parameter to /web/ajax/autocomplete_res.php and /web/ajax/autocomplete.php is not properly sanitised before being used in a SQL query. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code.
2) Input passed via the "user" POST parameter to PLC/index.php (when "submit" is set to "LOG ME IN") is not properly sanitised before being returned to the user. This can be exploited to execute arbitrary HTML and script code in a user's browser session in context of an affected site.
The vulnerabilities are confirmed in version 0.2134. Other versions may also be affected.

Vulnerable Products

Vulnerable Software:
mySeat Restaurant Reservation System 0.x

Solution

No official solution is currently available.

CVE

References

vinicius777:
http://packetstormsecurity.com/files/124930/mySeatXT-0.2134-SQL-Injection.html
Mavituna Security (NS-14-009):
https://www.netsparker.com/critical-xss-vulnerabilities-in-myseatxt/

Vulnerability Manager Detection

IPS Protection

ASQ Engine alarm	Available Since
SQL injection Prevention - GET : suspicious OR statement in URL	3.2.0
SQL injection Prevention - GET : suspicious combination of 'OR' or 'AND' statements in URL	3.2.0
SQL injection Prevention - GET : suspicious CREATE statement in URL	3.2.0
SQL injection Prevention - GET : suspicious CAST statement in URL	3.2.0
SQL injection Prevention - GET : suspicious OPENROWSET statement in URL	3.2.0
SQL injection Prevention - GET : suspicious DECLARE statement in URL	3.2.0
SQL injection Prevention - GET : suspicious OPENQUERY statement in URL	3.2.0
SQL injection Prevention - GET : suspicious shutdown statement in URL	3.2.0
SQL injection Prevention - GET : suspicious UNION SELECT statement in URL	3.2.0
SQL injection Prevention - GET : possible database version probing	3.2.0
SQL injection Prevention - GET : suspicious UPDATE SET statement in URL	3.2.0
SQL injection Prevention - GET : suspicious SELECT statement in URL	3.2.0
SQL injection Prevention - GET : suspicious INSERT statement in URL	3.2.0
SQL injection Prevention - GET : suspicious DROP statement in URL	3.2.0
SQL injection Prevention - GET : suspicious EXEC statement in URL	3.2.0
SQL injection Prevention - GET : block comment delimiters in URL	3.2.0
SQL injection Prevention - GET : suspicious SQL statement in header	4.0.0
SQL injection Prevention - GET : Authentication bypass attempt with OR statement	5.0.0

Risk level

Moderate

Vulnerability First Public Report Date

2014-01-24

Target Type

Server

Possible exploit

Remote