{================================================================================} { [waraxe-2004-SA#021] } {================================================================================} { } { [ Multiple vulnerabilities in phprofession 2.5 module for PostNuke ] } { } {================================================================================} Author: Janek Vind "waraxe" Date: 21. April 2004 Location: Estonia, Tartu Web: http://www.waraxe.us/index.php?modname=sa&id=21 Affected software description: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ phprofession 2.5 by Aidan Peiser Recruitment module for PN.712 www.phpsolutions.co.uk https://sourceforge.net/projects/profession/ Vulnerabilities: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ A. Full path disclosure: If we make http request like this: http://localhost/postnuke0726/modules/phprofession/upload.php we will provoke php error messages: Warning: main(header.php): failed to open stream: No such file or directory in D:\apache_wwwroot\postnuke0726\modules\phprofession\upload.php on line 19 Warning: main(): Failed opening 'header.php' for inclusion (include_path='.;c:\php4\pear') in D:\apache_wwwroot\postnuke0726\modules\phprofession\upload.php on line 19 ... B. Cross-site scripting aka XSS: Unsanitaized variable "jcode" will open a way to exploit the XSS in phprofession: http://localhost/postnuke0726/modules.php?op=modload&name=phprofession&file=upload&jcode=[xss code here] Remark: successful exploiting of the XSS on PostNuke is possible only, if special measures to evade the XSS filters are used. C. Sql injection: Typical sql injection case, where injection occurs after ORDER BY keywords. This time the "weak point" is the vaiable "offset", but i have seen many scripts, where unsanitaized "limit" variable gets passed to sql query too. Good thing for webmasters (and bad for attackers) is, that in case of MySql version <= 4.0 there is no practical way to exploit this sql injection, other than failing it. Reason is, that after the "ORDER BY" keywords we can't use "UNION" and any other "useful" things. But in near future, when MySql version 4.1 will be in use, new feature will be present - subselects. And then can be possible using of the "half-blind" and "blind" methods to pull out any information from database, and that's WITHOUT "union" keyword. What's the point? Point is, that this sql injection is in this moment non-critical, but it's needed to fix as soon as possible. http://localhost/postnuke0726/modules.php?op=modload&name=phprofession&file=index&offset=foobar Error in query: SELECT phpro_joblisting.designation, phpro_joblisting.jcode, phpro_joblocation.location, phpro_jobsalary.salary, phpro_joblisting.posted from phpro_joblisting, phpro_joblocation, phpro_jobsalary WHERE phpro_joblisting.checked= 1 AND phpro_joblocation.id = phpro_joblisting.fk_location AND phpro_jobsalary.id = phpro_joblisting.fk_salary AND DATE_ADD(posted, INTERVAL 80 DAY) > now() order by posted desc limit foobar,20. 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 'foobar,20' at line 13 Greetings: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Greets to torufoorum members and to all bugtraq readers in Estonia! Tervitused! Special greets to UT Bee Clan members at http://bees.tk ! "Hold this position!" ;) Contact: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ come2waraxe@yahoo.com Janek Vind "waraxe" Homepage: http://www.waraxe.us/ ---------------------------------- [ EOF ] ------------------------------------