Changes
From SME Server
Jump to navigation
Jump to search
← Older edit
Newer edit →
Mailstats
(view source)
Revision as of 05:26, 8 March 2016
670 bytes removed
,
05: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==
Unnilennium
Super Admin, Wiki & Docs Team,
Bureaucrats
,
Interface administrators
,
Administrators
3,254
edits
Navigation menu
Page actions
Page
Discussion
View source
History
Page actions
Page
Discussion
More
Tools
In other languages
Personal tools
English
Log in
Koozali SME Server
Main Page
Welcome
Releases
Testimonials
Documentation
SME Server FAQ
Volunteering
Commercial Support
Recent activities
Dashboard
Recent wiki changes
Recent bug changes
Unread Forum posts
Koozali resources
Contribs
How-To's
Forums
Bugzilla
Mailing Lists
Translations
Download
Koozali SME Server wiki
Wiki statistics
Wiki categories
Wiki Help
Koozali Wiki Help
Tools
Special pages
Printable version
Search