Disable user access log?

[Olodin]

Are there options for the access logging of user accounts?

I have a small installation of tine20 with <10 users. Some of them using ActiveSync which produces an entry in the access_log table everytime a sync is started. This access_log table is the largest table in this tine20 installation but we don't need the data (nor the wasted RAM . An option to limit the data in this table would be nice. Any plans for that?

[nelius]

we should thing of automatic log cycling/trashing here
can you provide a feature request?

[Olodin]

we should thing of automatic log cycling/trashing here
can you provide a feature request?

Jepp, filed it in http://www.tine20.org/bugtracker/view.php?id=2924.

[konus]

After 3 Month of usage as a single user with one mobile client my access log was over 600.000 entries long and had a size of about 160 MB . This is not good for backup.

I tried to reopen the http://www.tine20.org/bugtracker/view.php?id=2924 but had no rights to do so. Should I open a new ticket?

In my opinion the solution to delete all entries with a given date by calling from command line is not optimal.
1. There only a few shared webhoster who give access to commandline.
2. I was able to help myself by creating a cron job with the commands, but I know not all webhoster allow cron jobs.
3. Using a cron job to truncate automatically is not possible, because it is always necessary to adjust the date.

I would like to wish one or two of the original solutions:
* provide possibility to truncate data in this table via a user defined limit (e.g. keep X days of data)
* option to completely disable logging in this table

Would it be possible to enhance Tinebase.clearTable to use someting like --date="older than last 10 days"

[Olodin]

Would it be possible to enhance Tinebase.clearTable to use someting like --date="older than last 10 days"

Try something like

Code: Select all

tine20.php -d --username $tineuser --method Tinebase.clearTable $i -- date=$(date -v-10d +%Y-%m-%d)

to do just that with shell/bash means (you might have to adjust the path for "date". I use this in a cronjob.

And I agree with you: there should be an option in "Admin" to do just that:
* clear all
* clear anything older than x days
* and maybe an option to store access log in plain files

[ph_il]

please add a new feature request with your suggestions.

[konus]

Feature Request: https://forge.tine20.org/mantisbt/view.php?id=7224