2,187
edits
(→Troubleshooting: Added "Reboot Required?") |
(Added Syslog) |
||
Line 525: | Line 525: | ||
** Updates can only be added in chronological order, therefore you may need to delete the data file for a particular month, and rebuild it entirely. | ** Updates can only be added in chronological order, therefore you may need to delete the data file for a particular month, and rebuild it entirely. | ||
Scheduled updates are configured in <code> /etc/cron.d/awstats </code> | Scheduled updates are configured in <code> /etc/cron.d/awstats </code> | ||
== Syslog to MySQL Database == | |||
This procedure achieves two things... | |||
# Allows remote hosts to use the local server as a syslog destination | |||
# Directs syslogs to MySQL database on the server | |||
...it is assumed that you already have a local MySQL server running! | |||
# Set-up your server to send syslog messages to a MySQL database | |||
#* <code> apt-get install rsyslog-mysql </code> | |||
#* Enter the root password to your MySQL instance when prompted | |||
# Update the <code> rsyslog </code> config (<code>/etc/rsyslog.conf</code>) to recieve syslog data, and to route messages through a queue | |||
## Uncoment the following.. | |||
##* <code>$ModLoad ommysql # load the output driver (use ompgsql for PostgreSQL)</code> | |||
##* <code>$ModLoad imudp # network reception</code> | |||
##* <code>$UDPServerRun 514 # start a udp server at port 514</code> | |||
## Add the following... | |||
##* <code>$WorkDirectory /rsyslog/work # default location for work (spool) files</code> | |||
##* <code>$ActionQueueType LinkedList # use asynchronous processing</code> | |||
##* <code>$ActionQueueFileName dbq # set file name, also enables disk mode</code> | |||
##* <code>$ActionResumeRetryCount -1 # infinite retries on insert failure</code> | |||
## Restart the service | |||
##* <code> service rsyslog restart </code> | |||
== Troubleshooting == | == Troubleshooting == |