removing the limit of 100 rows in squirrel

Using the squirrel app: http://www.squirrelsql.org/ I had issues with only seeing 100 rows in a table. I fixed this by going to File -> New Sessions Properties -> Object Tree -> Contents -> limit rows. The default is 100, but you can uncheck it and you should be good. If not, you can also do ...

alt f4 on surface pro with type keyboard 2

I couldn’t get alt f4 working on any of my apps on my new microsoft surface pro with type keyboard 2. It ended up being that my function lock was set! I had to unlock that via: function + caps lock (Thanks rsutoratosu on Anandtech). And now ALT F4 works, time to go kill some ...

bitfeniex prodigy with 7 hard drives

I bought this bitfenix prodigy case for about $30 off craiglist, someone didn’t like that it was white, and for $30, couldn’t be beat for this case. As it was retailing for about $80 at newegg/microcenter. I was going to build my girlfriend a new PC and thought ITX was the way to go, after ...

Windows 7 – Windows cannot be installed to this disk

I was trying to install windows on my new ASRock H81M-ITX motherboard and for some reason loading windows 7 pro 64bit to my OCZ agility 2 I got this error message: Windows cannot be installed to this disk. This computer’s hardware may not support booting to this disk. Ensure that the disk’s controller is enabled ...

Could not open external command file for reading via open(): (13) -> Permission denied in nagios v4.01

I ended up getting this in my nagios.log, the fix was to change the permissions on the rw file! chmod 777 /usr/local/nagios/var/rw/nagios.cmd

Directory index forbidden by Options directive: /var/www/html/

I was receiving this error in my nagios apache log: Directory index forbidden by Options directive: /var/www/html/ to fix this, I just did touch index.html to /var/www/html It creates a file in the directory that is empty. I found this safer then turning on indexes for my nagios install.

How to delete all mail in queue for cPanel exim

I ran into an issue where a user was spamming and queue up thousands of email in our cPanel server. To clear it out, I did this: /etc/init.d/exim stop exim -bpru | awk {'print $3'} | xargs exim -Mrm or exim -bpru|grep frozen|awk {'print $3'}|xargs exim -Mrm /etc/init.d/exim start I had about 120k emails in ...

internal server error with CSF (Config Server Firewall) in cPanel after upgrade in cPanel

So I was receiving this error after cPanel upgraded: Internal Server Error 500 No response from subprocess (/usr/local/cpanel/whostmgr/docroot/cgi/addon_csf.cgi): subprocess exited with status 2   This did not fix it:   /usr/sbin/csf -x /scripts/perlinstaller --force URI /usr/sbin/csf -e /usr/sbin/csf -u If that doesn’t work this will:   curl -s configserver.com/free/csupdate | perl    

STEAM and Darkfall Unholy Wars screenshots when pressing i

I noticed when I was playing Darkfall Unholy Wars it would alwyas screenshot when pressing i, even though my steam screenshot was set to F12. I changed it to SHIFT + F12 and I was good. People were recommended disabling the overlay, but I enjoy being able to chat with STEAM friends still, and changing ...

How to move files that are older then x days in linux

I found this useful: sudo find ./* -mtime +2 -exec mv {} /hosting/dropbox/ops/user/client/ \; breakdown… ./* is the current directory, including all files, but you could use full path. mtime +2 is 2 days old mv is the command being executed and after the brackets is the directory the files are moving to