Difference between revisions of "Datamining"

Line 8: Line 8:
 
easy.
 
easy.
  
Usage:
+
==Usage==:
 
  /opt/open-xchange/sbin datamining
 
  /opt/open-xchange/sbin datamining
  
Available Parameters:
+
==Available Parameters==:
  
 
-?, -h, --help                          Print this helpfile                     
 
-?, -h, --help                          Print this helpfile                     
-d, --dbName <dbname>                  Name of the MySQL-database that      
+
-d, --dbName <dbname>                  Name of the MySQL-database that contains the Open-Xchange configDB (default: configdb)                                        
                                          contains the Open-Xchange configDB  
+
--dbPort <port>                        Port where MySQL is running on the host specified with "-hostname" (default: 3306)                       
                                          (default: configdb)                
+
* -n, --hostname <hostname>            Host where the Open-Xchange MySQL-database is running                   
--dbPort <port>                        Port where MySQL is running on the    
+
* -p, --dbPassword <dbpassword>        Password for the user specified with "-dbUser"                               
                                          host specified with "-hostname"    
+
--reportfilePath <path>                Path where the report-file is saved (default: )                           
                                          (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     
 
* -u, --dbUser <dbuser>                Name of the MySQL-User for configdb     
-v, --verbose                          With this the tool prints what it is  
+
-v, --verbose                          With this the tool prints what it is doing live
                                          doing live
 
  
What questions are answered?
+
==What questions are answered?==

Revision as of 12:19, 11 January 2012

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?