cPanel custom Dovecot Query to delete email

In cPanel under an email account you can Free up Email Storage. There is a Custom query field which allows you to specify a custom Dovecot query to run. Couple examples below.

Delete email from email address

from sent@email.com

Email that contains a specific string in the message body

body "string to match in message body"

Other useful info
https://wiki2.dovecot.org/Tools/Doveadm/SearchQuery

CPU stuck at 800Mhz or (.78Ghz)

Problem: CPU frequency is stuck at about 780 or 800mhz after waking up from sleep.

What causes the issue? Not sure what causes the issue, but seems to have something to do with unplugging the power adapter while putting to sleep or waking the system when it is pluged in after it was put to sleep on battery. Issue is random.

It appears that this issue can be temporarily resolved by disabling BD PROCHOT using ThrottleStop. Make sure the box is unchecked.

Download ThrottleStop from here

Things to try

Restart computer
Unplug and plug the power adapter in while computer is on
Put to sleep, plug or unplug power adapter, rewake up
Some other combination of the above.

More Info

https://forums.tomshardware.com/threads/laptop-i5-6300hq-cpu-suddenly-underclocking-stuck-at-0-78-ghz.2949019/
https://www.reddit.com/r/Dell/comments/6jecqd/thermal_throttling_idle/

Inkscape – Center objects on page

Select the objects you want to center

Go to Object -> Align and Distribute… or Ctrl + Shift + A

In the right hand side you should get the Align and Distribue box. Make sure that “Treat selection as group” is selected if you want the objects to mantain the distance between themselves.

Hit the “Center on vertical axis” and “Center on horizontal axis”

TFTP firmware to Ubiquiti radio

Boot up radio in tftp mode by pressing the reset button for ~20seconds or till you get the crossing blinky lights.

Enable TFTP
In Windows, search for
“turn windows features on or off”
Open up and select tftp client. Then hit OK.

That should install the tftp client

Flash firmware
To flash the firmware, open up a command prompt and run the tftp command

tftp -i 192.168.1.20 PUT "\Users\bob\Downloads\XM.v6.1.3.31939.171117.1238.bin"

LibreNMS dump devices in MySQL database

All the devices are stored in the librenms datebase devices table.

You can dump all of them with the following command from a shell prompt.

sudo mysql -u librenms  -p librenms -e "select hostname,sysName from devices"

Example output

[jim@localhost ~]$ sudo mysql -p librenms -e "select hostname,sysName from devices"
 Enter password:
 +----------------------------------------+--------------------------------+
 | hostname                               | sysName                        |
 +----------------------------------------+--------------------------------+
 | 192.168.1.1                            | linksys                        |
 | 192.168.1.9                            | wifi-unifi                     |
 +----------------------------------------+--------------------------------+