] project-open [ Open Source Enterprise Business Application

1. ]project-open[Open Source Enterprise Business Application Human RessourceManagement Collaboration KnowledgeManagement ProjectManagement NagiosIntegration CustomerRelationshipManagement ProjectControlling FinancialControlling

2. ]project-open[in a Nutshell ]po[is an OSSWeb-based "Enterprise Project Management" software for project-based organizations. It integrates areas such as CRM, sales, project planning, project controlling, collaboration, timesheet, invoicing and payments. As one of the largest open-source based web applications in the world with more then 1,000,000 lines of code, ]po[ is used by more then 1000 companies in 25 countries to run their business a

3. Strategy, Policies, Culture, ... OperationalProcedures Service Level Mgmt. HRMgmt. ProviderMgmt. Customer Service Desk Incident Mgmt. Ticket Priorization /PortfolioMgmt. Request for Change Problem Mgmt. RfC Project Proposals Project Mgmt. Project ConfigurationMgmt. ReleaseMgmt. ChangeMgmt. LicenseMgmt SoftwareDevelopment Financial Mgmt. The ]po[ ITSM Process Map

4. Idea Definition Prototype Feedback 1st Cust 2nd Cust Product Current Status May 2008 Maturity Strategy, Policies, Culture, ... OperationalProcedures Service Level Mgmt. HRMgmt. ProviderMgmt. Incident Mgmt. CustomerService Desk Ticket Priorization /PortfolioMgmt. Request for Change Problem Mgmt. RfC Project Proposals Project Mgmt. Project ConfigurationMgmt. ReleaseMgmt. ChangeMgmt. LicenseMgmt SoftwareDevelopment Financial Mgmt.

5. Idea Definition Prototype Feedback 1st Cust 2nd Cust Product ]po[ as an Integration Platform Nagios OCS-Inventory Working unidirectional import BigBrother Simple import of BB4 statuscurrently for display-only H-Inventory Maturity First conversations about integration OTRS vTigerOutlook Plugin Outlook integration using vTiger CRM plugin Bug Zilla Email Generic mail import using SMTP/Fetchmail RT ]project-open[ CRM Tickets Events Invent. Finance Users Protocol Gantt Unidirectional import of SAP project costs into ]po[ SAP FI openProj Import of same data as GanttProject. Export of ]po[ financial information to NAV using UBL (see below) GanttProject Navision Complete bidirectional “round-trip” editing ]po[ CSV export readable by Lexware Buchhalter Lexware MS-Project GanttProject an import MS-Project schedules ]po[ CSV export suitable for Datev-based tax consultants Datev genericUBL UBL (Unified Business Language) is a simplified version of ebXML Generic ODBC interface to read data from ]po[ and to create new object via PlPg/SQL database API ODBC other Accounting Flexible CSV export allow to connect other accounting packages Generic and configurable XML-RPC interface. Allows to map XML-RPC calls into ]po[ TCL calls XML-RPC SOAP/WSDL Generic SOAP/WSDL implementation from University Vienna. However no customer installation yet. Active Directory and OpenLDAP LDAP Generic Linux PAM PAM Import scripts for customSQL user databases CustomUser-DB

6. Nagios Integration Overview ]project-open[ • ]po[ receives and parses Nagios alert emails. • ]po[ parses the Nagios configuration files and creates “Configuration Items” (=objects) for hosts and services SystemsMonitoring TicketTracking Config.Database Nagios Configuration File

7. Sample Nagios Configuration

8. The List of Tickets

9. Conf Items imported from Nagios

10. Conf Items imported from Nagios

11. Sample Nagios Ticket in ]po[

12. Conclusions • Nagios is a great interface to server infrastructure • Parsing the Nagios config files & mails wasn’t much fun, but it’s OK. Just please don’t localize! • Feature Requests: • API or other format to read the Nagios database. • Nagios returning the host’s list of hardware & software similar to OCS-Inventory • Send out emails in XML format for easier parsing?

13. ]project-open[ Human RessourceManagement Collaboration KnowledgeManagement ProjectManagement CustomerRelationshipManagement ProjectControlling FinancialControlling Please visist www.project-open.com and sign up to receive four times a year our newsletter and subscribe to our RSS feeds to stay up to date

14. Thanks for your attention ]project-open[ Ronda Sant Antonio 51, 1o 2a08011 Barcelona Spain Tel: +34 933 250 914 Cell: +34 609 953 751 Fax: +34 932 890 729 www.project-open.comwww.project-open.org

15. Nagios Integration Details • A locally running Postfix instance receives emails (possibly imported via fetchmail) and delivers them to ~/Maildir/new/ • An OpenACS “acs-mail-lite” process scans ~/Maildir every few minutes • ]po[‘s “intranet-nagios” package receives callbacks from acs-mail-lite, parses the Nagios subject line and extracts extract all important variables (host, service, status etc.): • ]po[ check is there is already an open ticket for the specified host/service and add the current message to the existing ticket • If necessary, ]po[ generates a new host and/or service as “Configuration Items” in the configuration database. • Alternatively, ]po[ can also parse the Nagios configuration files and import all hosts and services into the ConfDB.

16. Nagios Integration Details ]project-open[ NagiosImport 3 2 TicketTracking acs-mail-lite 4 ~/Maildir/new 1 ConfigurationDatabase Postfix 5 6 /usr/local/nagios/etc/nagios.cfg