Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Squidguard and mysql

    Scheduled Pinned Locked Moved General pfSense Questions
    1 Posts 1 Posters 782 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • O
      ottaviane
      last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.