Controller v5 mongodb quesion

Controller v5 mongodb quesion

Controller v5 mongodb quesion
Controller v5 mongodb quesion
2 weeks ago - last edited 12 hours ago
Hardware Version: V5
Firmware Version: 5.14.26.1

I need some assistance with the omada controller's MongoDB schema.  I need to add around 30,000 urls to the url filtering list, which is not doable using the web gui for obvious reasons.   I've located the correct table in mongodb, and have what I need to populate all the fields except entryID (int32).  Is this an arbitrary number, or is it a reference to a field somewhere else that I need to relate to?  Any help identifying this tidbit would be greatly appreciated!

 

Sample data from urlfiltering collection (table):  

[
  {
    "_id": {"$oid": "688fbfe01032dd538fec7fc8"},
    "entry_id": 1885802063,
    "index": 1,
    "mode": 0,
    "name": "MPAA 1",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  },
  {
    "_id": {"$oid": "688fc1021032dd538fec800d"},
    "entry_id": 1604714707,
    "index": 2,
    "mode": 0,
    "name": "vungle advertising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  },
  {
    "_id": {"$oid": "688fc2171032dd538fec802f"},
    "entry_id": 1811550511,
    "index": 3,
    "mode": 0,
    "name": "applovin advertising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["EDACTED"]
  },
  {
    "_id": {"$oid": "688fc25b1032dd538fec804e"},
    "entry_id": 1727656182,
    "index": 4,
    "mode": 0,
    "name": "unity advertising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  },
  {
    "_id": {"$oid": "688fc3281032dd538fec8056"},
    "entry_id": 1147305133,
    "index": 5,
    "mode": 0,
    "name": "adrtaREDACTED adverstising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  },
  {
    "_id": {"$oid": "688fc3641032dd538fec805b"},
    "entry_id": 481019033,
    "index": 6,
    "mode": 0,
    "name": "opera advertising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  },
  {
    "_id": {"$oid": "688fc3cc1032dd538fec8080"},
    "entry_id": 1173214081,
    "index": 7,
    "mode": 0,
    "name": "startappelbREDACTED advertising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  },
  {
    "_id": {"$oid": "688fc40f1032dd538fec8083"},
    "entry_id": 923489013,
    "index": 8,
    "mode": 0,
    "name": "chartboost ads",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["rREDACTED"]
  },
  {
    "_id": {"$oid": "688fc5901032dd538fec80af"},
    "entry_id": 1287807531,
    "index": 9,
    "mode": 0,
    "name": "google advertising",
    "omadac_id": "REDACTED",
    "policy": 0,
    "site_id": "REDACTED",
    "source_ids": ["6619b9ef15731a75b16152ad"],
    "source_type": 0,
    "status": true,
    "type": "gateway",
    "urls": ["REDACTED"]
  }
]

  0      
  0      
#1
Options
1 Accepted Solution
Re:Controller v5 mongodb quesion-Solution
12 hours ago - last edited 12 hours ago

Hi  @Kelemvor 

 

Thanks for posting here.

 

Why there would be 3000 URLs need to be configured?

One domain name with a wildcard (*) can match multiple subdomains. There might be a slight misunderstanding on your part. Here's a link with step-by-step instructions for configuring the URL – we recommend referring to it.

 

How to configure URL blacklist or whitelist using Omada Controller's URL Filtering feature

Recommended Solution
  0  
  0  
#3
Options
2 Reply
Re:Controller v5 mongodb quesion
2 weeks ago - last edited 2 weeks ago

I just realized gateway rules aren't working with my er8411.   The EAP rules work with wireless EAP783 clients, but no rule I configure seems to work on the ER8411 gateway.  Maybe URL filtering doesn't work on the gateway or there's something misconfigured, but until I figure that out it makes adding a proper filter list into the database a useless effort.

  0  
  0  
#2
Options
Re:Controller v5 mongodb quesion-Solution
12 hours ago - last edited 12 hours ago

Hi  @Kelemvor 

 

Thanks for posting here.

 

Why there would be 3000 URLs need to be configured?

One domain name with a wildcard (*) can match multiple subdomains. There might be a slight misunderstanding on your part. Here's a link with step-by-step instructions for configuring the URL – we recommend referring to it.

 

How to configure URL blacklist or whitelist using Omada Controller's URL Filtering feature

Recommended Solution
  0  
  0  
#3
Options