Security

 View Only
last person joined: 2 days ago 

Enterprise security using ClearPass Policy Management, ClearPass Security Exchange, IntroSpect, VIA, 360 Security Exchange, Extensions and Policy Enforcement Firewall (PEF).
Expand all | Collapse all

CPPM 6.11 - Auth Sources Missing SQL Filter Queries

This thread has been viewed 7 times
  • 1.  CPPM 6.11 - Auth Sources Missing SQL Filter Queries

    Posted 21 days ago
    Looking at my freshly-installed 6.11 server, I no longer see the attribute filter queries for the Authentication Sources - like Guest User Repository and Guest Device Repository.

    Were these removed, or are they hidden? They must still be functioning somehow for the standard values to be retrieved. I wanted to call to a special attribute I added in CP:Guest for my devices and users.


  • 2.  RE: CPPM 6.11 - Auth Sources Missing SQL Filter Queries

    EMPLOYEE
    Posted 20 days ago
    Can you please open a TAC Case? I have not seen this before and may or may not be intentional. Please be aware that modifying factory default sources/roles/policies/services should be avoided whenever possible. You can create a SQL source with the appexternal account to create custom lookups/queries.

    ------------------------------
    Herman Robers
    ------------------------
    If you have urgent issues, always contact your Aruba partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact Aruba TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or Aruba Networks.

    In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.
    ------------------------------



  • 3.  RE: CPPM 6.11 - Auth Sources Missing SQL Filter Queries

    Posted 20 days ago
    Good to know about not adding to the default SQL queries. I will try to avoid this.
    I will reach out to TAC to look at the missing query info - I was surprised as well, and figured it was hidden to prevent what I am trying to do.

    With the appexternal method you suggest, I can make that work well enough - should function great.

    Do you know if there are any special considerations when connecting to its localhost postgresql database besides using the other account name? Do I need to connect to both 5433 and 5432 as the release notes suggest? I am unsure why that would be the case or how to make two connections. I’ll try it out later and follow up.

    ---------------------------------
    ryh
    ---------------------------------





  • 4.  RE: CPPM 6.11 - Auth Sources Missing SQL Filter Queries

    EMPLOYEE
    Posted 18 days ago

    Just use 5432, and as/if you are using the loopback address 127.0.0.1, you don't need to care about opening up ports.

    BTW, port 5433 is only used starting ClearPass 6.11 to separate the configuration and log databases:

    Ensure port 5433 is open in order to access the Insight database. Port 5433 is also used for connecting to the tipsLogDb in ClearPass 6.11.0.
    For Insight queries you may need to change the port to 5433, but endpoint db/Guest you should be good with port 5432.



    ------------------------------
    Herman Robers
    ------------------------
    If you have urgent issues, always contact your Aruba partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact Aruba TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or Aruba Networks.

    In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.
    ------------------------------