About the module

The dbDaemon module allows you to write Squid logs directly to the database, without access.log, and process them on the fly.

Capabilities

• Logging directly to the database without writing to the file

Using

Go to the "Manager modules", find dbDaemon and click on the "Install" link.

The fetch_db_daemon.pl script is used to implement the Squid log entry write directly in the database. It must be added as a log processing daemon in squid.conf.

As with other Screen Squid perl scripts, you need to configure a database connection.

In order for the daemon to work, make changes to squid.conf:

#log to daemon
access_log daemon: squid
logfile_daemon /path/to/script/fetch_db_daemon.pl

If you want to save the output to the access.log file, add another line:

#this is default. Log to file.
access_log stdio: /path/to/log/access.log squid

Remember to specify the correct / path / to / script and / path / to / log /

Reboot Squid.

After that, the scsq_mod_dbDaemon table will begin to fill with data from Squid.

The second step is to configure fetch_db.pl.

As with other Screen Squid perl scripts, you need to configure a database connection.

After that add fetch_db.pl to cron. Run it no more than once every five minutes.

Important Notice

Using the classic fetch.pl and fetch_db.pl together on the same base is unacceptable. Duplication of data is possible.

Ideas, bugs, questions?

Feel free to contact us http://t.me/screensquid