[squid-users] [DMARC] log_db_daemon errors

[Brendan Kearney]

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 at lists.squid-cache.org
> 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