Changes

From SME Server
Jump to navigationJump to search
670 bytes removed ,  06:26, 8 March 2016
→‎Logging to a MySQL database: included in SME8 and SM9 rpm
Line 64: Line 64:  
  config setprop mailstats Base ("Midnight"|Midday"|"Now"|"##")
 
  config setprop mailstats Base ("Midnight"|Midday"|"Now"|"##")
 
Note: a number is interpreted as the hour of the day (0-23)
 
Note: a number is interpreted as the hour of the day (0-23)
  −
==Logging to a MySQL database==
  −
In order to log your data to a MySQL database, you will need to create a database named 'mailstats'. 
  −
  −
There is a script to create the mailstats database held in Brian Read's contrib area, courtesy of Hartmut Trepkau.
  −
  −
http://mirror.contribs.org/smeserver/contribs//bread/mailstats/sql%20create/
  −
  −
You can use this to create the database and tables, and it will also set the configuration entry to enable the saving to the database.
  −
  −
Note that the create-mysql.sh script will delete any previous database (and the associated data) of the name "mailstats". 
  −
Also note the that script requires the tables.sql file in the same directory.
      
==Additional Notes==
 
==Additional Notes==
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,228

edits

Navigation menu