[squid-users] Can't store log in mysql 8.0 database

[Matus UHLAR - fantomas]

On 03.03.23 14:22, Francisco wrote:
>Hi, I\m trying to store logs in a mysql server 8.0 database from squid 5.7
>in Debian 11.
>
>My idea is store all logs in /var/log/squid/ dir, and logs from specifics
>urls, domains and sites store in mysql database ('access_log_internet'
>table) to restrict those users that overcuote an specific amount of MB.
>
>

>*logfile_daemon /usr/lib/squid/log_db_daemon*
>*access_log
>daemon:/192.168.56.2:3306/squidmgr/access_log_internet/squidmgr/squidmgrsquid
>!dominios !dominios_parciales !sitios !dominio_cu*

>when try start squid, it's fail:
>*Dec 31 19:00:00 1969Use of uninitialized value $DBI::errstr in
>concatenation (.) or string at /usr/lib/squid/log_db_daemon line 403.Dec 31
>19:00:00 1969Cannot connect to database:  at /usr/lib/squid/log_db_daemon
>line 403.


if you run the logfile daemon manually, does it work?
it may be problem in permissions
-- 
Matus UHLAR - fantomas, uhlar at fantomas.sk ; http://www.fantomas.sk/
Warning: I wish NOT to receive e-mail advertising to this address.
Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu.
Saving Private Ryan...
Private Ryan exists. Overwrite? (Y/N)