Re: squid authentication , & ACL select from databse SQL , is that possible ?

squid-list <squid@xxxxxxxxxxx> · Wed, 11 Feb 2015 23:42:36 +0530



    Hi,

    
    You can authenticate user and password from sql database using the
    helper "squid_db_auth".

    
    But, allowing website for corresponding user by storing in db is not
    possible. You can use various ACLs to control the site access for
    the individual users.

    
    Instead of storing website in particular column in db, you can store
    it in separate txt file and can control the site access of the
    users. 

    
    Squid will support user defined helper. If it necessary to verify
    site from db, you can create your own helper as per you requirement
    and you can use it. If you need any customization assistance, you
    can contact us(squid@xxxxxxxxxxx).

    
    Regards,

    Siva Prakash

    ViSolve Squid Team

    
    On 02/12/2015 06:25 AM, snakeeyes
      wrote:

    
        Hi 
        I need to do many operations :
        I need squid with sql with the following
          needs :
        1-      Squid authenticate user/pwd from sql
          databse.
        2-      Then if authentication was okay  , they I
          need to see that username logged in and go to sql databse and
          select from there a cloum with the websites correspond to that
          user
        3-      Then I will do access list that permit the
          websites domain name only for that user based on info from
          sql.
        Is that possible with squid ?
        Im using last squid stable version 3.5.1
          and hope it be okay .
         
         
        cheers
      
      
      _______________________________________________
squid-users mailing list
squid-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.squid-cache.org/listinfo/squid-users

    
_______________________________________________
squid-users mailing list
squid-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.squid-cache.org/listinfo/squid-users