Warning: strpos() [function.strpos]: needle is not a string or an integer in /home/beardedd/public_html/home/index.php on line 71
Easy Way to Track Domains in PiHole 
After you install Pi-Hole to suck ads from your network, you probably will load some domain lists (gravity lists or something they call them) to black or white list domains. If you start using your devices on the network, you'll probably find somethings don't work because domains are being blocked, and some thing wont block ads.

To monitor pihole's activity you use:

pihole -t

on the linux console command line. This will show in real-time the activity that the pihole software is undertaking. it's very hard to keep track of whats going on with this, as you have to verify the IP of the client and then try to see which domains etc. there's just generally a lot of info going on and the screen scrolls up rather quickly even with only 2 devices connected to pihole.

Instead, you should filte rthe pihole activity down to a single client, the client device you are using to troubleshoot. To do this, just use a pipe and grep the output based on the IP of the device you want to see:

pihole -t | grep .188

For example, this will show me the activity of the device on my network that is

It also filters out the lines in the output that say whether a domain was blocked or not, it will just show us that client .188 accessed whatever domain. We can then load the pihole web interface and check the Query Log to see if the domain is blocked or not, then black/whitelist it to see if it makes the desired change we want.

[ view entry ] ( 97 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3.2 / 51 )
rsync --delete not working? 
If you issue an rsync command with the --delete option in it and you find it isn't removing non-existent source files from the target, when you google you will find a whole host of answers that say "don't use a wildcard character * on the end of the target path!"

that's all well and good until you aren't using wildcards and --delete still isn't working!

what you do need on the end of the target path is a trailing slash / character for --delete to work!


rsync -avzh --progress --delete -e 'ssh -p 31337 -i /home/user/keyfile.private' user@host.net:/home/user/backups /home/localuser/backups

will NOT do the --delete for you!

rsync -avzh --progress --delete -e 'ssh -p 31337 -i /home/user/keyfile.private' user@host.net:/home/user/backups/ /home/localuser/backups

WILL do the --delete for you!

[ view entry ] ( 47 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 2.9 / 68 )
Mazda CX9 / Vehicle Spare Parts 
This is an entry to explain how to look up spare parts for cars online.

SupercheapAuto My Garage

The best way to find spare parts for your Mazda CX9 or any vehicle is to go to supercheapauto.com.au and use their "My Garage" feature. Enter your vehicle registration number, or choose which model vehicle you want to find parts for, click the little yellow arrow head that points down on the My Garage section on the main website page and then click "Shop All Parts For My Vehicle".

The page that loads will look a bit like a website from 1998, and it shows you all the spare part categories on the left which you can use to filter the products shown on the right. This catalog system is pretty good and it shows you photos of the parts in some cases which is really helpful. Once you find a part you want, you should then get some sort of part number, code or brand name you can google further to get more info.

Google for more Info

For example, I was after an air conditioning/heater blower motor for my Mazda CX9. I looked up the part in SCA's My Garage, then noticed it was made by a company called JAS Oceania.

Googling JAS Oceania brought up a location only about 1km away from the SupercheapAuto store's location in my area. In other words, the supplier of the part is in the same suburb as SupercheapAuto's store. I might be able to buy directly from the spare part manufacturer? The advantage to doing this is a lower lead time. I might be able to get the part immediately instead of waiting for SCA store to have it sent over to them, which can take at least a half day and usually takes a day on average in my experience.

Most spare parts, but not all, will have a part number on them and perhaps a brand name. This is a really good way to find the part online. Google for the brand and part number and you will find you can probably buy the part from a number of online stores, but buyer beware - I found the blower part I wanted on AliExpress but it wasn't the full part with the cylindrical fan blades attached. It was only the motor segment of the part and the pricing was about the same as buying the whole part locally. I prefer and recommend buying locally over online, especially for automotive spares because if the part is incorrect you can return it and exchange it or get a refund. Doing this is a big hassle with online purchases.

[ view entry ] ( 65 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 2.9 / 75 )
SQLite How to select a particular day of the week using date function 
This will select last Thursday's date:

SELECT date('now', 'weekday 4', '-7 days')

weekday 4 = Thursday, but if we want last week we have to -7 days from it.

If you want the date to be returned as unix epoch value, do the following:

SELECT strftime('%s', date('now', 'weekday 4', '-7 days'))

[ view entry ] ( 228 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3 / 178 )

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next> Last>>