Give your hand some relief from reaching for Ctrl and take advantage of the close proximity of Caps Lock.
# Note any previous values for xdb-options (most likely none)
gsettings get org.gnome.desktop.input-sources xkb-options
# Set our xkb-options (plus anything from our get, if needed)
gsettings set org.gnome.desktop.input-sources xkb-options "['ctrl:nocaps']"
Now …
$ dig +short myip.opendns.com @resolver1.opendns.com
First, make sure we remove .svn folders and files from tracking by adding a new line ".svn/" to our .gitignore file.
Next, we will find all folders that are named .svn and for each folder found remove all files contained within it. Note the only difference between the …
Commands like SHOW DATABASES and SHOW TABLES are great but what if I need all the columns inside a table?
SELECT column_name FROM information_schema.columns WHERE table_schema = 'your_db' ORDER BY table_name, ordinal_position;
Source: http://stackoverflow.com/questions/5648420/get-all-columns-from-all-mysql-tables
Today I added a new server to PostgreSQL's host-based authentication file (pg_hba.conf) on a very active PostgreSQL server. Restarting the PostgreSQL service would have lead to service disruption across multiple services. Thankfully the folks at PostgreSQL are one-step ahead of me on this one. There is an option …
I must have it saved somewhere but it was nowhere to be found. The password was lost. My root account was forever secure--or was it?
# service mariadb stop
# mysqld_safe --skip-grant-tables &
# mysql -u root
> USE mysql
> UPDATE user SET password=PASSWORD("mynewpassword") WHERE User='root';
> FLUSH PRIVILEGES …
GitLab was throwing me a 500 server error this morning after an upgrade via yum. To troubleshoot, I ran the self diagnose command from terminal:
# gitlab-rake gitlab:check
Which gave me the following error to fix:
All migrations up? ... no
Try fixing it:
sudo -u git -H bundle exec …
$ VBoxManage modifyhd YOUR_HARD_DISK.vdi --resize SIZE_IN_MB
Source: http://askubuntu.com/questions/88647/how-do-i-increase-the-hard-disk-size-of-the-virtual-machine
Use dmesg after plugging in your USB thumb drive to find the device name (/dev/sdb).
# umount /media/username/devicename
# dd bs=4M if=/path/to/filename.iso of=/dev/sdb
Note, do not output to a partition (e.g. /dev/sdb1). In the past this has created a loop device instead of copying the input file to the USB …
if [ "$TERM" = "linux" ]; then
echo -en "\e]P0232323" #black
echo -en "\e]P82B2B2B" #darkgrey
echo -en "\e]P1D75F5F" #darkred
echo -en "\e]P9E33636" #red
echo -en "\e]P287AF5F" #darkgreen
echo -en "\e]PA98E34D" #green
echo -en "\e]P3D7AF87" #brown
echo -en "\e]PBFFD75F" #yellow
echo -en "\e]P48787AF" #darkblue
echo -en "\e]PC7373C9" #blue
echo -en "\e]P5BD53A5" …
# apt-get install unattended-upgrades
# dpkg-reconfigure --priority=low unattended-upgrades
More at https://help.ubuntu.com/community/AutomaticSecurityUpdates
dmesg | grep -i bluetooth
bluetooth hci0: Direct firmware load for brcm/BCM20702A1-0b05-17cb.hcd failed with error -2
%AsusBT400.DeviceDesc%=RAMUSB17CB, USB\VID_0B05&PID_17CB ; 20702 standalone
;;;;;;;;;;;;;RAMUSB17CB;;;;;;;;;;;;;;;;;
[RAMUSB17CB.CopyList]
bcbtums.sys
BCM20702A1_001.002.014.1315.1347.hex
[RAMUSB17CB.NTX86]
Include=bth.inf
Needs=BthUsb.NT
FeatureScore=F0 …Not doing anything but your hard drive is screaming? iotop to the rescue.
iotop
In my case, updatedb.mlocate was the culprit.
# systemctl mask sleep.target suspend.target hibernate.target hybrid-sleep.target
Monitor will still go into power save mode.
This script will find (including subdirectories) and convert all m4a files to mp3.
find -name "*.m4a" -exec ~/m4atomp3 {} \;
m4atomp3:
#!/bin/bash
m4afile=$@
avconv -i "$m4afile" -ab 320k "${m4afile/.m4a/.mp3}"
Remember to chmod +x m4atomp3.
Sometimes the remote is too far away to change the volume of music playing through the Raspberry Pi. Whilst at the terminal, alsamixer offers a great solution:
alsamixer