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

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

    Cache/Proxy
    44
    135
    124.2k
    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
      evanderv
      last edited by

      @percyiii:

      Loaded the upgrade because of the openssl scare..
      Dans now at 2.12.0.3_2 pkg v.0.1.8
      Says no file /usr/pbi/dansguardian-amd64/etc/dansguardian/authplugins/proxy-ntlm.conf
      So i loaded one from another box..
      now says
      auth_plugin_load() returned NULL pointer with config file: /usr/pbi/dansguardian-amd64/etc/dansguardian/authplugins/proxy-ntlm.conf
      Any ideas?
      THX

      I am having this same problem also.  proxy-ntlm.conf was never put into the authplugins on the latest dansguardian from pfsense.

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

        Ok…..
        1. Install the broken package with the package manager.

        2. from the command line "pkg_info" you will see dansguardian 2.12.0.3_2 is installed.

        3. from the command line "fetch http://files.pfsense.org/packages/amd64/8/All/dansguardian-2.12.0.3-amd64.pbi"

        4. from the command line "pbi_add --no-checksig -f dansguardian-2.12.0.3-amd64.pbi"

        5. from the command line "pkg_info" you will now see dansguardian-2.12.0.3_1 is installed.

        Then go to /tmp and deleted the two dansguardian files..
        Go and save the settings pages in Dans..
        BUTTT...... Now the web upload is broke... I fix the web upload.
        If I fix it like below... It dies again.. because one writes over the other...
        https://forum.pfsense.org/index.php?topic=58442.msg409913#msg409913.

        Any ideas?

        1 Reply Last reply Reply Quote 0
        • 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
                                            • First post
                                              Last post