Logs¶

Log files of SeaTable server¶

The SeaTable logs are under /shared/seatable/logs in the docker, or /Your SeaTable data volume/seatable/logs in the server that run the docker.

Main log files:

• dtable_web.log: logs for dtable-web
• dtable-events.log: logs for dtable-events
• dtable_events_io.log: logs for Base's import or export and Excel or CSV file import or export
• dtable_events_message.log: logs for sending emails in the dtable-events background
• dtable-server.log: logs for dtable-server
• dtable-db.log: logs for dtable-db
• dtable-db-error.log: error logs for dtable-db
• dtable-db-access.log: query log for dtable-db
• dtable-db-slow.log: slow query log for dtable-db

Other log files:

• seafile.log: logs of Seafile server
• slow_logs: Slow request logs, which can be used to debug performance issues
• monitor.log: Monitor logs, monitor.sh can auto restart the unexpectedly closed server
• init.log: Logs for docker initialization script

Log files of Nginx server¶

The Nginx logs are under /shared/nginx-logs, or /Your SeaTable data volume/nginx-logs in the server that run the docker.

• dtable-web.access.log
• dtable-web.error.log
• access.log
• error.log

Logrotate¶

SeaTable's Docker container executes nightly log rotation cron jobs for both SeaTable and nginx logs. The cron jobs are configured as follows:

54 23 * * * /usr/sbin/logrotate -vf /templates/logrotate-conf/seatable-nginx 2>> /opt/seatable/logs/logrotate.log
55 23 * * * /usr/sbin/logrotate -vf /templates/logrotate-conf/seatable 2>> /opt/seatable/logs/logrotate.log

Logrotate Configuration¶

The log rotation configuration is straightforward and includes the following parameters:

{
        daily
        missingok
        rotate 7
        # compress
        # delaycompress
        dateext
        dateformat .%Y-%m-%d
        notifempty
        create 644 root root
        sharedscripts
        postrotate
                if [ -f /opt/seatable/pids/seafile.pid ]; then
                        kill -USR1 `cat /opt/seatable/pids/seafile.pid`
                fi

                if [ -f /opt/seatable/pids/dtable-db.pid ]; then
                        kill -USR1 `cat /opt/seatable/pids/dtable-db.pid`
                fi

                if [ -f /opt/seatable/pids/dtable-storage-server.pid ]; then
                        kill -USR1 `cat /opt/seatable/pids/dtable-storage-server.pid`
                fi

                if [ -f /opt/seatable/pids/api-gateway.pid ]; then
                        kill -USR1 `cat /opt/seatable/pids/api-gateway.pid`
                fi

                if [ -f /opt/seatable/pids/dtable-web.pid ]; then
                        pkill -HUP gunicorn
                fi

                find /opt/seatable/logs/ -mtime +7 -name "*.log*" -exec rm -f {} \;
        endscript
}

This configuration ensures:

• Daily log rotation.
• Retention of logs for seven days.
• Addition of timestamps to rotated logs using dateext.
• Automatic removal of old logs older than seven days.

All relevant configuration files are located in /templates/logrotate-conf within the SeaTable Docker container.

Customizing Logrotate Configuration¶

To modify the log rotation settings, you can mount a custom configuration file using Docker Compose. Add the following snippet to your yml-file:

services:
  seatable-server:
    image: ...
    ...
    volumes:
      - "./logrotate-seatable-custom.conf:/templates/logrotate-conf/seatable:ro"
      ...

# create a custom copy
cp seatable-server.yml custom-seatable-server.yml

# Don't forget to update the filename in your .env