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

    Squid+Dansguardian with Active Directory (NTLM) Single Sign On WORKING!!!

    Scheduled Pinned Locked Moved Cache/Proxy
    135 Posts 44 Posters 131.4k 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.
    • E
      endyrx
      last edited by

      Hi guys. I successfuly install eveerything. In first moment i decide everything is ok. FW are binded to my wind 2003 domain wbinfo -t/-u/-g show me everything - users, groups etc. etc. But tail -f /var/log/dansguardian/access.log show me only ip not users id. Also my users wont populate on Services > Dansguardian > Users. I see only checkmark there which is unchecked right now. Also i think Dansguard does not watch LDAP group i chose for internet access. I test with a normal user - no metter if the user are in or out of the groupe he have internet.
      Any ideas ?

      1 Reply Last reply Reply Quote 0
      • E
        echowings
        last edited by

        Okay, and please try this command:

         tail -f /var/squid/log/access.log
        1 Reply Last reply Reply Quote 0
        • E
          endyrx
          last edited by

          Somehow i am able to get authenticated on squid also on dansguard
          this is my squid log
          1401128431.777      0 192.168.250.70 TCP_DENIED/407 4861 GET http://www.dir.bg/my/comments/count.php? - NONE/- text/html
          1401128431.780    20 192.168.250.70 TCP_MISS/200 612 GET http://r5.dir.bg/passimg.php? bilyanastefanova DIRECT/194.145.63.27 image/gif
          1401128431.790    14 192.168.250.70 TCP_MISS/200 522 GET http://www.dir.bg/new/dirfp_weather_new.html? bilyanastefanova DIRECT/194.145.63.12 text/html
          1401128431.791    15 192.168.250.70 TCP_MISS/200 445 GET http://www.dir.bg/new/dirfp_weather_block.json? bilyanastefanova DIRECT/194.145.63.12 application/json
          1401128431.793    16 192.168.250.70 TCP_MISS/200 243 GET http://www.dir.bg/new/usd.txt bilyanastefanova DIRECT/194.145.63.12 text/plain
          1401128431.804    27 192.168.250.70 TCP_MISS/200 695 GET http://www.dir.bg/JSAJAX/get_user_info.php? bilyanastefanova DIRECT/194.145.63.12 text/plain
          1401128431.836      5 192.168.250.70 TCP_CLIENT_REFRESH_MISS/304 298 GET http://i.dir.bg/dir5/dir-new/html/img/vremeto-small/pda_20.png bilyanastefanova DIRECT/194.145.63.18 -
          1401128431.838    126 192.168.250.70 TCP_CLIENT_REFRESH_MISS/200 3656 GET http://ni.dir-i.net/esspresso/images/calendar/cells.png bilyanastefanova DIRECT/194.145.63.18 image/png
          1401128431.842    62 192.168.250.70 TCP_MISS/200 676 GET http://www.dir.bg/my/comments/count.php? bilyanastefanova DIRECT/194.145.63.12 text/html
          1401128431.966    155 192.168.250.70 TCP_MISS/200 309 GET http://smart.dir.bg/mobile_check.php? bilyanastefanova DIRECT/194.145.63.11 text/html

          and this is dansguardian log
          1401128431.388    19 192.168.250.70 TCP_MISS/200 0 GET http://r5.dir.bg/js.php?Code=00_section_novini&enc=u bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/html
          1401128431.388    19 192.168.250.70 TCP_MISS/200 0 GET http://r5.dir.bg/js.php?Code=00_section_novini_2&enc=u bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/html
          1401128431.390    23 192.168.250.70 TCP_MISS/200 0 GET http://r5.dir.bg/js.php?Code=00_corner bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/html
          1401128431.718    33 192.168.250.70 TCP_MISS/200 101 GET http://r5.dir.bg/utb.php?rnd=1287221401128435608&ref=http%3A//www.dir.bg/&reff= bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/javascript
          1401128431.769      4 192.168.250.70 TCP_DENIED/403 0 GET http://www.google-analytics.com/__utm.gif?utmwv=1.4&utmn=98558728&utmcs=utf-8&utmsr=1920x1080&utmsc=24-bit&utmul=en-us&utmje=1&utmfl=13.0%20r0&utmdt=Dir.bg%20-%20%D0%91%D1%8A%D0%BB%D0%B3%D0%B0%D1%80%D1%81%D0%BA%D0%B8%D1%8F%D1%82%20%D0%98%D0%BD%D1%82%D0%B5%D1%80%D0%BD%D0%B5%D1%82%20%D0%BF%D0%BE%D1%80%D1%82%D0%B0%D0%BB!&utmhn=www.dir.bg&utmhid=1711608986&utmr=-&utmp=/&utmac=UA-436010-11&utmcc=__utma%3D95319433.1662311826.1401125196.1401125196.1401128436.2%3B%2B__utmz%3D95319433.1401125196.1.1.utmccn%3D(direct)%7Cutmcsr%3D(direct)%7Cutmcmd%3D(none)%3B%2B bilyanastefanova DEFAULT_PARENT/127.0.0.1 -
          1401128431.792    19 192.168.250.70 TCP_MISS/200 501 GET http://www.dir.bg/new/dirfp_weather_new.html?ts=0.17504705565709982 bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/html
          1401128431.794    20 192.168.250.70 TCP_MISS/200 13 GET http://www.dir.bg/new/usd.txt bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/plain
          1401128431.806    30 192.168.250.70 TCP_MISS/200 7 GET http://www.dir.bg/JSAJAX/get_user_info.php?enc=utf-8&now=0.004187991262348867&=1401128435698 bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/plain
          1401128431.843    66 192.168.250.70 TCP_MISS/200 4 GET http://www.dir.bg/my/comments/count.php?jnl_id=3&ctype_id=1&topic_id=12251378&list=all&ran=0.153130255537684&          =1350479627602 bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/html
          1401128431.967    157 192.168.250.70 TCP_MISS/200 79 GET http://smart.dir.bg/mobile_check.php?callback=jQuery17105069666413485266_1401128435330&url=http%3A%2F%2Fwww.dir.bg%2F&method=post&_=1401128435737 bilyanastefanova DEFAULT_PARENT/127.0.0.1 text/html

          But i still can't denie connections for users who is out of my internet groupe. Everyone have an internet right now.

          1 Reply Last reply Reply Quote 0
          • F
            fedetehue
            last edited by

            @wheelz:

            I am on version 2.1 and am using it fine.  I think some of the versions are different now for the extra pkg_add commands but other than that I don't think there were too many differences in what I had to do.

            How did you create the firewall and nat rules of steps 6 and 10? I'm on 2.1.3 and I'm stuck at that. Thanks in advance.

            1 Reply Last reply Reply Quote 0
            • F
              fedetehue
              last edited by

              10.  Services –> Firewall
                a.  Rules –> LAN tab – Create a filtered proxy rule to allow TCP port 8080 to the LAN address
                b.  NAT –> Port Forward tab - Create a filtered proxy port forward from LAN on port 8080 to the loopback adapter (127.0.0.1)

              Ok, sorry for bumping this thread again, but I need help with this part. Could someone post screencaps of how would the NAT and Rules gui screen would look when you set up things on step 10? I tried to do it and I locked myself out of the webgui. I need DG to filter HTTP and HTTPS traffic.
              Thanks again to anyone that helps me with that.

              1 Reply Last reply Reply Quote 0
              • S
                sowen
                last edited by

                First: I don't mean to steal this thread…but there is an easier way to do much of this. Unless you absolutely must use NTLM.

                look at
                http://sourceforge.net/projects/squidtrust/files/SquidtrustIII/

                or google "Squidtrust"

                you will find a Perl authentication helper, and a workstation agent that can easily be integrated into a PfSense environment.
                originally … I wrote the helper and agent to work on pfSense. I have been using them for over two years on a network w/800+ workstations and 2500+ users.

                the short version:
                Install the perl helper on pfSense, configure it to poll the agent for your desired user credentials.
                run the agent on all workstations via login scrpt/GPO
                ta-da...transparent user authentication.

                read the docs for more detail.

                1 Reply Last reply Reply Quote 0
                • D
                  dig1234
                  last edited by

                  This is certainly easier to setup and I am impressed with your solution. However this model does not appear to have any protection from easily being spoofed by a rouge user? ie a user could claim to be someone they are not.

                  @sowen:

                  First: I don't mean to steal this thread…but there is an easier way to do much of this. Unless you absolutely must use NTLM.

                  look at
                  http://sourceforge.net/projects/squidtrust/files/SquidtrustIII/

                  or google "Squidtrust"

                  you will find a Perl authentication helper, and a workstation agent that can easily be integrated into a PfSense environment.
                  originally … I wrote the helper and agent to work on pfSense. I have been using them for over two years on a network w/800+ workstations and 2500+ users.

                  the short version:
                  Install the perl helper on pfSense, configure it to poll the agent for your desired user credentials.
                  run the agent on all workstations via login scrpt/GPO
                  ta-da...transparent user authentication.

                  read the docs for more detail.

                  1 Reply Last reply Reply Quote 0
                  • S
                    sowen
                    last edited by

                    New thread started here:
                    https://forum.pfsense.org/index.php?topic=78770.0

                    1 Reply Last reply Reply Quote 0
                    • F
                      fedetehue
                      last edited by

                      Well, apparently http://e-sac.siteseguro.ws/ is down. Where else can I find the packages?

                      1 Reply Last reply Reply Quote 0
                      • P
                        pitoganzado
                        last edited by

                        Hi to all

                        [2.1.4-RELEASE][root@proxysrv.blablabla.com]/root(49): wbinfo -t
                        checking the trust secret for domain blablabla via RPC calls succeeded

                        [2.1.4-RELEASE][root@proxysrv.blablabla.com]/root(49): wbinfo -u
                        show all users

                        The problem is when i create the groups on dansguardian, they apear empty on "users" tab

                        Anyone can help me?
                        Thanks :)

                        1 Reply Last reply Reply Quote 0
                        • F
                          fedetehue
                          last edited by

                          @pitoganzado:

                          Hi to all

                          [2.1.4-RELEASE][root@proxysrv.blablabla.com]/root(49): wbinfo -t
                          checking the trust secret for domain blablabla via RPC calls succeeded

                          [2.1.4-RELEASE][root@proxysrv.blablabla.com]/root(49): wbinfo -u
                          show all users

                          The problem is when i create the groups on dansguardian, they apear empty on "users" tab

                          Anyone can help me?
                          Thanks :)

                          A similar thing happens to me:

                          wbinfo -t shows "checking the trust secret for domain blablabla via RPC calls succeeded"

                          but

                          wbinfo -u doesn't show anything

                          also

                          wbinfo -a username let's me authenticate

                          any ideas?

                          1 Reply Last reply Reply Quote 0
                          • F
                            fedetehue
                            last edited by

                            Ok, a few things, since no one has replied so far:

                            I'm on 2.1.4 x86

                            • One of the packages (not sure which) broke the package manager, and now i get an error "Fatal error: Call to undefined function curl_init() in /etc/inc/pfsense-utils.inc on line 1641 " when pfsense checks for updates. Also, I can't install any new packages.

                            • Not sure who mantains http://e-sac.siteseguro.ws/packages but the ldd folder is gone, for both x86 and x64, so I'm not sure where to find those files if I want to make a fresh install.

                            • wbinfo -u problem is still happening

                            1 Reply Last reply Reply Quote 0
                            • F
                              fedetehue
                              last edited by

                              Well, after doing some stuff. I joined pfsense to my domain. wbinfo works (groups and users show).

                              But now Dansguardian doesn't show any users in the Users tab.

                              php /usr/local/www/dansguardian_ldap.php shows "User list from LDAP is already the same as current group, no changes made"

                              Any ideas?

                              1 Reply Last reply Reply Quote 0
                              • D
                                damasceno
                                last edited by

                                fedetehue I have the same problem, I also have two more problems: https://forum.pfsense.org/index.php?topic=82765.0

                                Does anyone have any idea? I don't know how to solve that  :-\

                                1 Reply Last reply Reply Quote 0
                                • P
                                  psob
                                  last edited by

                                  i'm newbie
                                  PC 2.1.5-RELEASE x64, Dansguardian 2.12.0.3_2 pkg v.0.1.12

                                  installed from this manual, it's work, but no automatic

                                  i set Default group to banned mode, and AD group update frequency = 1m
                                  after changes group's members in AD - dansguardian Users tab normaly updated
                                  but Users Counter's in header tabs no refresh, and new added users blocking
                                  after manualy press Save button on Users tab, Counter's refreshed and new users start working.

                                  it's normal after every edit AD group, i must save dansguardian Users tab?

                                  2fedetehue,
                                  dansguardian_ldap.php checks 2 argv
                                  try variant your chose in LDAP group name source (by field name or field description)
                                  php /usr/local/www/dansguardian_ldap.php name inettest
                                  php /usr/local/www/dansguardian_ldap.php description "inet-group"

                                  1 Reply Last reply Reply Quote 0
                                  • N
                                    neophyteJJ
                                    last edited by

                                    Thanks for the input.

                                    I have a problem in step 13.

                                    Login via SSH using PuTTY, home income ADMIN pfSense Firewall?
                                    Or should enter the MYADMIN@MYDOMAIN.LOCAL account?

                                    Login with MYADMIN@MYDOMAIN.LOCAL not accept the password.

                                    to enter with pfSense Firewall Local ADMIN if income perfectly. Running / usr / local / bin / kinit myadmin net ads join-U myadmin
                                    Result:

                                    myadmin@MYDOMAIN.LOCAL.'s Password:

                                    When entering the password, it gives the following error:
                                    kinit: krb5_get_init_creds: unable to reach any KDC in realm mydomain.local.

                                    NOTE: I have a DC with mydomain.local domain and create a user myadmin

                                    Who can help me validate that I like to check and validate against the server.

                                    2.1.5-RELEASE (amd64)
                                    built on Mon Aug 25, 2014 7:44:45 EDT
                                    FreeBSD 8.3-RELEASE-p16

                                    Package Name               Category Package Version
                                    Dansguardian               Services 2.12.0.3_2 pkg v.0.1.12
                                    Shellcmd                       Services 0.5
                                    squid3-dev                       Network 3.3.10 pkg 2.2.6

                                    AD Windows 2012 Server

                                    Gracias por el aporte.

                                    Tengo un problema, en el paso 13.

                                    Ingresar vía SSH usando PuTTY, ingreso como ADMIN local del Firewall PFSENSE ?
                                    O deberia ingresar con la cuenta  MYADMIN@MYDOMAIN.LOCAL ?

                                    Login con MYADMIN@MYDOMAIN.LOCAL no acepta la contraseña.

                                    al ingresar con ADMIN local del Firewall PFSENSE si ingreso, perfectamente. Al ejecutar /usr/local/bin/kinit myadmin net ads join -U myadmin
                                    Resultado:

                                    myadmin@MYDOMAIN.LOCAL.'s Password:

                                    Al ingresar la Contraseña, da el siguiente error:
                                    kinit: krb5_get_init_creds: unable to reach any KDC in realm MYDOMAIN.LOCAL.

                                    NOTA: Tengo un DC con el dominio MYDOMAIN.LOCAL y cree un usuario myadmin

                                    Quien me puede ayudar a validar que debo verificar y como para que se valide contra el servidor.

                                    2.1.5-RELEASE (amd64)
                                    built on Mon Aug 25 07:44:45 EDT 2014
                                    FreeBSD 8.3-RELEASE-p16

                                    Package Name               Category Package Version
                                    Dansguardian               Services 2.12.0.3_2 pkg v.0.1.12
                                    Shellcmd                       Services 0.5
                                    squid3-dev                       Network 3.3.10 pkg 2.2.6

                                    AD Windows 2012 Server

                                    1 Reply Last reply Reply Quote 0
                                    • T
                                      tk
                                      last edited by

                                      I had similar issues and I simply replaced the hostnames with their IPs.

                                      1 Reply Last reply Reply Quote 0
                                      • X
                                        xalex1977
                                        last edited by

                                        PfSense 2.2 + squid3 + squidguard-devel integration with Active Directory
                                        works this configuration?
                                        can anyone help me?

                                        1 Reply Last reply Reply Quote 0
                                        • marcellocM
                                          marcelloc
                                          last edited by

                                          you will need a samba3 or 4 compiled on freebsd to use it.

                                          Treinamentos de Elite: http://sys-squad.com

                                          Help a community developer! ;D

                                          1 Reply Last reply Reply Quote 0
                                          • P
                                            percyiii
                                            last edited by

                                            Ok so tried updating to 2.2
                                            my squid custom integretion

                                            http_access allow whitelist
                                            acl_uses_indirect_client on
                                            follow_x_forwarded_for allow localhost
                                            auth_param ntlm program /usr/local/bin/ntlm_auth –use-cached-creds --helper-protocol=squid-2.5-ntlmssp
                                            auth_param ntlm children 10
                                            auth_param ntlm keep_alive on
                                            acl password proxy_auth REQUIRED
                                            http_access allow password

                                            Squid will now not start because of
                                            auth_param ntlm program /usr/local/bin/ntlm_auth --use-cached-creds --helper-protocol=squid-2.5-ntlmssp

                                            Shared object "libcrypto.so.6" not found, required by "ntlm_auth" which was part of squid 2.5 isntall i believe..

                                            Any ideas.. I take that line out and authentication fails

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