anudeepND / whitelist

A simple tool to add commonly white listed domains to your Pi-Hole setup.
MIT License
4.18k stars 281 forks source link

Unable to apply latest whitelist entries using script #204

Closed jmrstrs1 closed 3 years ago

jmrstrs1 commented 3 years ago

Using Pi-hole v5.2.4 Web Interface v5.4 FTL v5.7

I followed the instructions to run the whitelist script, but everytime I run it, none of the 191 items are added to the database. What could be wrong? Ive tried running with sudo and without. Does my pihole whitelist need to be completely empty? See output below.

sudo python3 whitelist/scripts/whitelist.py

[i] Pi-hole path exists [i] Write access to /etc/pihole verified [i] Pi-Hole Gravity database found [i] 191 domains and 191 SQL queries discovered [i] Connecting to Gravity. [i] Successfully Connected to Gravity. [i] Checking Gravity for domains added by script. [i] 0 Domains from script in whitelist already. [i] Checking Gravity for domains added by user that are also in script. [i] Found 0 domains added by the user that would be added by script. [i] Checking Gravity for domains previously added by script that are NOT in new script. [i] Found 0 domain(s) added previously by script that are not in script. [i] Checking script for domains not in Gravity. [i] 191 domain(s) NOT in Gravity that are in new script.

- Adding 0.client-channel.google.com
- Adding 1drv.com
- Adding 2.android.pool.ntp.org
- Adding akamaihd.net
- Adding akamaitechnologies.com
- Adding akamaized.net
- Adding amazonaws.com
- Adding android.clients.google.com
- Adding api.ipify.org
- Adding app-api.ted.com
- Adding api.rlje.net
- Adding appleid.apple.com
- Adding apps.skype.com
- Adding appsbackup-pa.clients6.google.com
- Adding appsbackup-pa.googleapis.com
- Adding apt.sonarr.tv
- Adding aspnetcdn.com
- Adding attestation.xboxlive.com
- Adding ax.phobos.apple.com.edgesuite.net
- Adding brightcove.net
- Adding c.s-microsoft.com
- Adding cdn.cloudflare.net
- Adding cdn.embedly.com
- Adding cdn.optimizely.com
- Adding cdn.vidible.tv
- Adding cdn2.optimizely.com
- Adding cdn3.optimizely.com
- Adding cdnjs.cloudflare.com
- Adding cert.mgt.xboxlive.com
- Adding clientconfig.passport.net
- Adding clients1.google.com
- Adding clients2.google.com
- Adding clients3.google.com
- Adding clients4.google.com
- Adding clients5.google.com
- Adding clients6.google.com
- Adding cpms.spop10.ams.plex.bz
- Adding cpms35.spop10.ams.plex.bz
- Adding cse.google.com
- Adding ctldl.windowsupdate.com
- Adding cws.conviva.com
- Adding livepassdl.conviva.com
- Adding zee.cws.conviva.com
- Adding pings.conviva.com
- Adding gfwsl.geforce.com
- Adding appspot-preview.l.google.com
- Adding d2c8v52ll5s99u.cloudfront.net
- Adding d2gatte9o95jao.cloudfront.net
- Adding dashboard.plex.tv
- Adding dataplicity.com
- Adding def-vef.xboxlive.com
- Adding delivery.vidible.tv
- Adding dev.virtualearth.net
- Adding device.auth.xboxlive.com
- Adding display.ugc.bazaarvoice.com
- Adding displaycatalog.mp.microsoft.com
- Adding dl.delivery.mp.microsoft.com
- Adding dl.dropbox.com
- Adding dl.dropboxusercontent.com
- Adding dns.msftncsi.com
- Adding download.sonarr.tv
- Adding drift.com
- Adding driftt.com
- Adding dynupdate.no-ip.com
- Adding ecn.dev.virtualearth.net
- Adding edge.api.brightcove.com
- Adding eds.xboxlive.com
- Adding fonts.gstatic.com
- Adding forums.sonarr.tv
- Adding g.live.com
- Adding geo-prod.do.dsp.mp.microsoft.com
- Adding geo3.ggpht.com
- Adding giphy.com
- Adding github.com
- Adding github.io
- Adding googleapis.com
- Adding gravatar.com
- Adding gstatic.com
- Adding help.ui.xboxlive.com
- Adding hls.ted.com
- Adding i.ytimg.com
- Adding i1.ytimg.com
- Adding imagesak.secureserver.net
- Adding img.vidible.tv
- Adding imgix.net
- Adding imgs.xkcd.com
- Adding instantmessaging-pa.googleapis.com
- Adding intercom.io
- Adding jquery.com
- Adding jsdelivr.net
- Adding keystone.mwbsys.com
- Adding lastfm-img2.akamaized.net
- Adding licensing.xboxlive.com
- Adding live.com
- Adding login.live.com
- Adding login.microsoftonline.com
- Adding manifest.googlevideo.com
- Adding meta-db-worker02.pop.ric.plex.bz
- Adding meta.plex.bz
- Adding meta.plex.tv
- Adding microsoftonline.com
- Adding msftncsi.com
- Adding my.plexapp.com
- Adding nexusrules.officeapps.live.com
- Adding npr-news.streaming.adswizz.com
- Adding nine.plugins.plexapp.com
- Adding no-ip.com
- Adding node.plexapp.com
- Adding notify.xboxlive.com
- Adding ns1.dropbox.com
- Adding ns2.dropbox.com
- Adding o1.email.plex.tv
- Adding o2.sg0.plex.tv
- Adding ocsp.apple.com
- Adding office.com
- Adding office.net
- Adding office365.com
- Adding officeclient.microsoft.com
- Adding om.cbsi.com
- Adding onedrive.live.com
- Adding outlook.live.com
- Adding outlook.office365.com
- Adding placehold.it
- Adding placeholdit.imgix.net
- Adding players.brightcove.net
- Adding pricelist.skype.com
- Adding products.office.com
- Adding proxy.plex.bz
- Adding proxy.plex.tv
- Adding proxy02.pop.ord.plex.bz
- Adding pubsub.plex.bz
- Adding pubsub.plex.tv
- Adding raw.githubusercontent.com
- Adding redirector.googlevideo.com
- Adding res.cloudinary.com
- Adding s.gateway.messenger.live.com
- Adding s.marketwatch.com
- Adding s.youtube.com
- Adding s.ytimg.com
- Adding s1.wp.com
- Adding s2.youtube.com
- Adding s3.amazonaws.com
- Adding sa.symcb.com
- Adding secure.avangate.com
- Adding secure.brightcove.com
- Adding secure.surveymonkey.com
- Adding services.sonarr.tv
- Adding skyhook.sonarr.tv
- Adding spclient.wg.spotify.com
- Adding ssl.p.jwpcdn.com
- Adding staging.plex.tv
- Adding status.plex.tv
- Adding t.co
- Adding t0.ssl.ak.dynamic.tiles.virtualearth.net
- Adding t0.ssl.ak.tiles.virtualearth.net
- Adding tawk.to
- Adding tedcdn.com
- Adding themoviedb.com
- Adding thetvdb.com
- Adding tinyurl.com
- Adding title.auth.xboxlive.com
- Adding title.mgt.xboxlive.com
- Adding traffic.libsyn.com
- Adding tvdb2.plex.tv
- Adding tvthemes.plexapp.com
- Adding twimg.com
- Adding ui.skype.com
- Adding video-stats.l.google.com
- Adding videos.vidible.tv
- Adding widget-cdn.rpxnow.com
- Adding win10.ipv6.microsoft.com
- Adding wp.com
- Adding ws.audioscrobbler.com
- Adding www.dataplicity.com
- Adding www.googleapis.com
- Adding www.msftncsi.com
- Adding www.no-ip.com
- Adding www.youtube-nocookie.com
- Adding xbox.ipv6.microsoft.com
- Adding xboxexperiencesprod.experimentation.xboxlive.com
- Adding xflight.xboxlive.com
- Adding xkms.xboxlive.com
- Adding xsts.auth.xboxlive.com
- Adding youtube-nocookie.com
- Adding youtu.be
- Adding yt3.ggpht.com
- Adding vidtech.cbsinteractive.com
- Adding continuum.dds.microsoft.com
- Adding connectivitycheck.gstatic.com
- Adding connectivitycheck.android.com
- Adding www.msftconnecttest.com

[i] Checking Gravity for newly added domains.

[i] All 191 new domain(s) have not been added to Gravity. [i] There are a total of 231 domains in your whitelist (regex(0) & exact(231)) [i] The database connection is closed [i] Restarting Pi-hole. This could take a few seconds

jmrstrs1 commented 3 years ago

nvm.. sorry I just had to remove existing entries first. Working now. Thanks!