Squidguard and mysql



  • hello all,
    do yow know documentations or books explaining squidguard?
    I'm not able to configure it to use db mysql and documentation online is very very insufficient.
    help me please.
    infact in configuration file like this```
        dbhome /var/lib/squidguard/db
        logdir /var/log/squidguard

    mysqlusername utentedb
        mysqlpassword lamiapassword
        mysqldb nomedeldatabase

    src utenti-super {
        userquery select data from tabella_utenti_super
        }

    src utenti-normali  {
        userquery select data from tabella_utenti_registrati_per_accesso_squid
        }

    dest siti-negati{
                    domainlist /etc/sqid3/siti_negati
            }
        dest siti-consentiti{
                    domainlist /etc/sqid3/siti_consentiti
            }

    acl {
            utenti-super {
                pass all
                redirect http://localhost/cgi/blocked?clientaddr=%a&clientuser=%i&clientgroup=%s&url=%u
            }
            utenti-normali {
                pass !siti-negati siti-consentiti all
                redirect http://localhost/cgi/blocked?clientaddr=%a&clientuser=%i&clientgroup=%s&url=%u
            }

    default {
                pass none
                redirect http://localhost/cgi/blocked?clientaddr=%a&clientuser=%i&clientgroup=%s&url=%u
            }
        }

    
    when I do the command
    

    echo "http://www.sex.com 10.0.0.1/ - - GET" | squidGuard -c /etc/squidguard/squidGuard.conf -d

    it returns an error
    

    syntax error in configfile /etc/squidguard/squidGuard.conf line 4

    and line 4 is```
    mysqlusername utentedb
    

    Please help me please.
    bye.


Log in to reply