Product: Procapita (school administration system)
Vendor: TietoEnator Abp
Vulnerable versions: unknown
Impact: high
Found: months ago
The login screens of the school administration database system, "login.asp" and "inloggning.asp", as used in an unnammed school district in Finland, contain SQL injection vulnerabilities, which can be easily detected by inserting '||' (the oracle string concatenation operator and ending and starting quotes) within a valid password or username (they still work), or adding an odd number of quotes (resulting in an exception). The "input validation" in JavaScript must be "defeated" first - there is no signs of any validation done server side.
The program also contains other SQL injection vulnerabilities in text fields
etc. accessible after login - especially ones that are used to search for
information, which may allow compromise of sensitive personal information in
the database via injection to a SELECT query.
The program prints exception handlers to the browser, including Oracle database
error strings.
The session cookie lacks the 'secure' flag, and if a logged-in user clicks a
link with the http: scheme (such links exist in the school district's web
pages) the cookie will be sent in plain text.
The session cookie is not tied to the visitor's IP address.
The program contains pages that automatically print themselves using JavaScript, leading
to possible unintended printing of private information to a network printer since users
are accustomed to clicking "OK".
The program gives the user no way of changing the password or disabling the
login. The un-changeable password generated by the system is alphanumeric and
only six characters.
The versioning of the program is so vague (the pages have either no version
information at all or conflicting information) that it is impossible to say
which versions are vulnerable, especially since I have no access to multiple
installations, any docs or source.
The vulnerabilities have been reported to the vendor when they were found.
Exploits: None known
Fix: Modify code to properly sanitize user input server side.