Datamining

From Open-Xchange
Revision as of 12:17, 11 January 2012 by Karsten.will (talk | contribs)

What is this?

This is a simple Tool to get an idea how a specific installation of Open-Xchange is used. Operating on the MySQL-database exclusively it is quite fast and uses few resources. Off-hours are still recommended for its usage to limit any performance-impact, though. It will find its required parameters automatically in the file /opt/open-xchange/etc/groupware/configdb.properties. It is also possible to specify all parameters explicitly. Output is a single text-file. The filename starts with "open-xchange_datamining" and includes the current date in YYYY-MM-DD format. The content of the file is camelCased-Parameters, unique and one per line. This should make using these files as input, for example for a visualization, pretty easy.

Usage:

/opt/open-xchange/sbin datamining

Available Parameters:

-?, -h, --help Print this helpfile -d, --dbName <dbname> Name of the MySQL-database that

                                         contains the Open-Xchange configDB   
                                         (default: configdb)                  

--dbPort <port> Port where MySQL is running on the

                                         host specified with "-hostname"      
                                         (default: 3306)                      
  • -n, --hostname <hostname> Host where the Open-Xchange MySQL-
                                         database is running                  
  • -p, --dbPassword <dbpassword> Password for the user specified with "-
                                         dbUser"                              

--reportfilePath <path> Path where the report-file is saved

                                         (default: )                          
  • -u, --dbUser <dbuser> Name of the MySQL-User for configdb

-v, --verbose With this the tool prints what it is

                                         doing live

What questions are answered?