Bug 1065396 – VUL-1: CVE-2017-14807: studio: SQL injection in ui-server/app/models/diary_entry.rb

Bug 1065396 - (CVE-2017-14807) VUL-1: CVE-2017-14807: studio: SQL injection in ui-server/app/models/diary_entry.rb

(CVE-2017-14807)
Summary:	VUL-1: CVE-2017-14807: studio: SQL injection in ui-server/app/models/diary_en...

Status:	RESOLVED WONTFIX

Classification:	Novell Products
Product:	SUSE Security Incidents
Classification:	Novell Products
Component:	Incidents
Version:	unspecified
Hardware:	Other Other

Priority:	P4 - Low Severity: Minor
Target Milestone:	---
Assigned To:	Security Team bot
QA Contact:	Security Team bot

URL:
Whiteboard:	maint:planned:update CVSSv2:NVD:CVE-2...
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Create test case

Clone This Bug

Reported:	2017-10-27 07:25 UTC by Johannes Segitz
Modified:	2020-02-05 00:39 UTC (History)
CC List:	0 users

See Also:
Found By:	---
Services Priority:
Business Priority:
Blocker:	---
Marketing QA Status:	---
IT Deployment:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Johannes Segitz 2017-10-27 07:25:30 UTC

in self.paginated_search sql query is build manually from untrusted input:
      sql += " LOWER(event) LIKE LOWER('#{event.downcase}')"
Event is controlled by the user. 

Example: 
http://192.168.122.76/admin/diary?utf8=%E2%9C%93&authenticity_token=qzFRENODQHjMqJNJ&diary_from=YYYY-MM-DD&diary_to=now&event=logged_in%27)%20or%20(%271%27=%271&commit=Apply+filter

As far as I can see the diary is only accessible to the admin. I'm not sure if in the SUSE studio context 'studio admin' == 'server admin'. If not we should fix it if we do another update for studio.

Comment 1 Johannes Segitz 2020-01-27 08:52:57 UTC

Studio EOL