Datamining: Difference between revisions
Karsten.will (talk | contribs) No edit summary |
Karsten.will (talk | contribs) No edit summary |
||
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) | ||
--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 | |||
--dbPort <port> Port where MySQL is running on the | * -p, --dbPassword <dbpassword> Password for the user specified with "-dbUser" | ||
--reportfilePath <path> Path where the report-file is saved (default: ) | |||
* -n, --hostname <hostname> Host where the Open-Xchange MySQL- | |||
* -p, --dbPassword <dbpassword> Password for the user specified with "- | |||
--reportfilePath <path> Path where the report-file is saved | |||
* -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 | ||
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