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 /etc/init.d/exim start I had about 120k emails in queue and it took about 20 seconds to ...

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    

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

Can Dell PE860 (power edge 860) run 3TB drives on the motherboard SATA?

I found out the answer is yes! I have hooked up 2 3TB drives into the onboard SATA and was able to successfully raid 1 them within Ubuntu 12.10. I was not able to do this with the Perc raid controller, as it only saw 2.2TB.