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 …
$ 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 …
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'; > …
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 …
$ 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 …
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 …
# 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
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