Re: [squid-users] flat file parsing vs db filter rules parsing

From: Muthukumar <kmuthu_gct@dont-contact.us>
Date: Thu, 28 Oct 2004 12:27:29 +0530

>> If you are doing this inside Squid then whatever you do should fulfill the non-blocking property. You do not want Squid to stop
>> processing requests only because it is waiting for an response from the DB system.
>
> We have started analysis on making flat file filter rules to DB Based.
>
> Our Objective is to make as,
> acl <aclname> <acltype> "FLAT FILE" --> acl <Aclname> <acltype> "DB"
>
> We are planning to use MySQL as DB, because of good API support to coding.
>
> How the flat file "FLAT FILE" filter rules are parsed and stored in linked list structure? I have tried to start squid with
> debug_options ALL,9 to get some useful informations regarding flat file parsing, But FLATFILE parsing is not being in debug output
> as,
>
> grep 'testsite' cache.log
> 2004/10/28 09:34:29| aclMatchAcl: checking 'acl site dstdomain -i "/usr/local/squidsauth/etc/testsite"'
> 2004/10/28 09:34:29| aclMatchAcl: checking 'acl site dstdomain -i "/usr/local/squidsauth/etc/testsite"'
>
> Which file parses FLATFILE details and storing into system memory on squid?

I got the source file and function as,

    cache_cf.c / strtokFile()

I am Having doubts on strtokFile() code as,

strtokFile
LOCAL_ARRAY(char, buf, 256);

/* fromFile */
   if (fgets(buf, 256, wordFile) == NULL) {
/* stop reading from file */

Will squid only parse 256 characters of filter rules in that file? what will happened when the pattern limit exceeds 256 length?

Is it need to raise this buffer range of 256 more when try to make filtering with DB based?

We are needing your another guide on selecting Database. Which will be good to use? We are now progress with MySQL.

Thanks for your inputs.

Regards
Muthukumar.

=======================================================================================

---
===============  It is a "Virus Free Mail" ===============
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004 
Received on Thu Oct 28 2004 - 00:59:02 MDT

This archive was generated by hypermail pre-2.1.9 : Mon Nov 01 2004 - 12:00:02 MST