BiggiWiki

rsyslog-remote

biggi (biggi@undisclosed.example.com) — 2020-10-22T07:35:11+00:00

Using SALTStack & rsyslog? Need a way to send your syslogs to a centralized place? Look no further! /etc/rsyslog.d/10-remotesyslog.conf: file.managed: - contents: "*.* @@10.55.55.55:514" rsyslog: service.running: - enable: true - restart: true - watch: - /etc/rsyslog.d/10-remotesyslog.conf

add_to_influxdb

biggi (biggi@undisclosed.example.com) — 2017-11-29T22:06:25+00:00

I'm trying to “IoT-up” my house, and thought MQTT would be a good distributer for data to different services. I recently set up temperature+humidity sensors, and wanted to graph that data. Grafana+InfluxDB seemed like a good choice, but getting data from MQTT to InfluxDB seemed like a hassle with the available tools, so I wrote a short bash script to grab the data + send it to InfluxDB:

mysql_queries_per_second - created

biggi (biggi@undisclosed.example.com) — 2017-11-23T09:27:42+00:00

Oneliner: LASTVAL=0; CURRVAL=0; while true; do CURRVAL=`mysqladmin status | awk {'print $6'}`; echo "QPS: $((CURRVAL-LASTVAL))"; LASTVAL=$CURRVAL; sleep 1; done Output example: [root@thismachine ~]# LASTVAL=0; CURRVAL=0; while true; do CURRVAL=`mysqladmin status | awk {'print $6'}`; echo "QPS: $((CURRVAL-LASTVAL))"; LASTVAL=$CURRVAL; sleep 1; done QPS: 11429108706 QPS: 8047 QPS: 7783 QPS: 7909 QPS: 9965 QPS: 9835 ^C

disable_synaptics_coasting - created

biggi (biggi@undisclosed.example.com) — 2016-08-09T14:00:12+00:00

To disable the very annoying feature that keeps scrolling even after you let go of the touchpad, run the following command: synclient CoastingSpeed=0 Instead of “Coasting”, I vote that the feature is renamed to “Drunk emulator”. Source:

reset_outlook_ost_cache - created

biggi (biggi@undisclosed.example.com) — 2015-11-19T08:24:46+00:00

This could also have been a .bat file, there is no specific reason that I made it into an AutoIT script. So, now you know that ;) ; Kill Outlook RunWait(@ComSpec & " /c taskkill /f /im outlook.exe") ; zZz Sleep(1000) ; Delete OST file RunWait(@ComSpec & " /c del %LOCALAPPDATA%\Microsoft\Outlook\*.ost") ; zZz Sleep(1000) ; Start Outlook RunWait(@ComSpec & " /c start outlook")

set_default_printer - created

biggi (biggi@undisclosed.example.com) — 2015-11-19T08:19:56+00:00

#include Local $sAnswer = InputBox("Set default printer", "Enter the name of the printer you want to be default", "DKTASA06", "", -1, -1, 0, 0) if $sAnswer <> "" Then Run("RUNDLL32 PRINTUI.DLL,PrintUIEntry /y /n " & $sAnswer) EndIf

auto_kill_ie

biggi (biggi@undisclosed.example.com) — 2015-08-20T20:07:29+00:00

Some user kept on browsing sites he wasn't supposed to. I was asked to uninstall IE, but that was not possible on that OS, so I just wrote a small script to keep the browser closed at all times. ; Remove tray icon TraySetState(2) ; Loop diz' biatch. KILL, KILL, KILL! While 1 ProcessClose("iexplore.exe") Sleep(1000) WEnd

firefox_change_default_values

biggi (biggi@undisclosed.example.com) — 2015-08-20T19:59:59+00:00

These are the values I change to make my Firefox browser fit my needs: Item Value Effectbrowser.urlbar.autoFillFALSE Disables autocomplete of url's (e.g. 192.168.5.1 makes Firefox autofill 192.168.5.108, causing me to go the wrong URL)browser.urlbar.trimURLs

start

biggi (biggi@undisclosed.example.com) — 2015-08-20T19:49:46+00:00

Not much going on here. Some personal notes mostly. Check out the sitemap, there might be some useful code. BiggiWiki index

sqldo

biggi (biggi@undisclosed.example.com) — 2015-03-20T08:14:24+00:00

function sqldo($query, $howparse = "", $querydb = "") { // DB change for the query? if (!empty($querydb)) { $retvar = mysql_db_query($querydb, $query) or die("x203 - ".mysql_error()); } else { // Otherwise just do the query $retvar = mysql_query($query) or die("x203 - ".mysql_error()); } // Parse the query as requested (if requested :P) if ($howparse == "fetch_array") { $rows = array(); while ($row …

migrate_all_libvirt_machines_to_other_host

biggi (biggi@undisclosed.example.com) — 2015-03-07T18:22:35+00:00

To migrate all running VPSes to another host, do the following: for x in `virsh list | grep running | awk {'print $2'}`; do echo "Migrating $x"; virsh migrate-setspeed $x --bandwidth 1000 && virsh migrate $x qemu+ssh://USERNAME@HOSTNAME/system; sleep 10; done

fetch_all_exchange_mail_addresses - created

biggi (biggi@undisclosed.example.com) — 2015-01-12T10:50:42+00:00

Once in a while I need to do some Windows management. This time I needed to extract a list of all mail addresses in specific active directory containers. Both the “Primary address” and “Alternate addresses” will be fetched and placed in C:\.txt:

taskbar_popup_example.png - created

biggi (biggi@undisclosed.example.com) — 2014-04-04T09:01:19+00:00