On 11/3/23 8:27 AM, Amos Jeffries wrote:
On 3/11/23 08:14, jose.rodriguez wrote:
On 2023-11-02 13:46, Brendan Kearney wrote:
list members,
i am trying to log to a mariadb database, and cannot get the
log_db_daemon script working. i think i have everything setup, but
an error is being thrown when i try to run the script manually.
/usr/lib64/squid/log_db_daemon
/database:3306/squid/access_log/brendan/pass
Connecting... dsn='DBI:mysql:database=squid:database:3306',
username='brendan', password='...' at /usr/lib64/squid/log_db_daemon
line 399.
(Replied without looking and it did not go to the list, but to the
personal email, so will repeat it for completeness...)
That DSN seems wrong, as far as I can find it should look like this:
DBI:mysql:database=$database;host=$hostname;port=$port
Something is not being 'fed' right to the script?
Thank you for the catch. I have now opened this to fix it:
<https://github.com/squid-cache/squid/pull/1570>
Cheers
Amos
_______________________________________________
squid-users mailing list
squid-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.squid-cache.org/listinfo/squid-users
in reading the description in the man page/perl script, i find that the
only supported log format is the native squid format. i have a custom
log format that i use to log via syslog, and wonder what limitations
exist in trying to expand the capability of the log_db_daemon. i have
the custom log format, and corresponding table structure for it. is the
effort involved more than just adding columns to the table, then
updating the @db_fields and insert routine?
thanks,
brendan
_______________________________________________
squid-users mailing list
squid-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.squid-cache.org/listinfo/squid-users
