The OptionKey is a Technology blog. How to tips and useful documentation on Apple, Microsoft, Open Source Project.
Tuesday, May 26, 2015
Veeam Backup and Recovery
Friday, May 22, 2015
Printing a customized fixed header from MS Excel on every page
In MS office ribbon go to the Page Layout Tab -> Print Titles
Then you will see this page setup pop up screen.
In the rows to repeat at top put in the range that you want to put on every page. In this case I want rows 33 to 36 to repeat on every page I print.
Then select print preview to see the rows repeated on the top of every page.
Then Print your document.
Sunday, April 05, 2015
Cyptowall 3. From Infection to Recovery.
Disclaimer - for protection of the companies and their staff involved I will not name or reference them any other way then "The Company" and "Staff".
I was however able to get back approximately 2/3 of the differential data from the drives using some recovery software and specifying the date range from the last backup to the day before the virus infected the system. My preferred choice of recovery software for windows is Active Undelete.
The software is very intuitive, reasonably priced and has helped me recover more files for clients from accidental deletion, dead hard drive or an accidental format. I ran a full drive scan, took about 6 hours through USB 3 on a laptop to recover the differential data. Of that differential data 80% of the data appeared to be uncorrupted,usable and accurate as of the day modified.
I will be doing a follow up post on this for a backup solution that is ransomware resistant to with-in 24 hours from the time of the infection. It really is a post you don't want to miss.
Cisco did a very good blog post on the technical aspects of cryptowall 3.
Here are some links on the very first type of this crypto-ransomware cryptolocker.
http://en.wikipedia.org/wiki/CryptoLocker
The TWIT network did a great breakdown on cryptolocker on Security Now!
http://twit.tv/show/security-now/427
Monday, December 29, 2014
Build your own cloud
Tuesday, November 25, 2014
How to install and Remove Java on Ubuntu
Install Oracle Java in Ubuntu by PPA
This provides instructions on how to install the Oracle Java JDK (which includes Java JDK, JRE and the Java browser plugin). The PPA provides the full Oracle JDK package.
To add the PPA and install Oracle Java 7 in Ubuntu use this:
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer
To add the PPA and install Oracle Java 8 in Ubuntu use this:
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer
If you want to see your version of java run the following command in the terminal:
java -version
It should return something like this
Java version "1.7.0_51" (version 7) or "1.8.0" (version 8)
Java(TM) SE Runtime Environment (build 1.7.0_51-b13) - version 7
Java(TM) SE Runtime Environment (build 1.8.0-b132) - version 8
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode) - version 7
Java HotSpot(TM) 64-Bit Server VM (build 25.0-b70, mixed mode) - version 8
If the Java version in use is not 1.7.0, you can try to run the following command in the terminal:
sudo update-java-alternatives -s java-7-oracle
The installer requires you accept the Oracle license before the installation begins. This is only required once. If you need the installation to be automated, you can run the following command to automatically accept the Oracle license:
Version 7
echo oracle-java7-installer shared/accepted-oracle-license-v1-1 select true | sudo /usr/bin/debconf-set-selections
Version 8
echo oracle-java8-installer shared/accepted-oracle-license-v1-1 select true | sudo /usr/bin/debconf-set-selections
Setting Java environment variables To automatically set up the Java 7 environment variables, you can install the following package:
sudo apt-get install oracle-java7-set-default
If you've already installed oracle-java6-set-default or oracle-java8-set-default, they will be automatically removed when installing oracle-java7-set-default (and the environment variables will be set for Oracle Java 7 instead). Switch back and forth between Java 7 and 8
Switch to Java 7
sudo update-java-alternatives -s java-7-oracle
And, switch back to Oracle Java 8 using:
sudo update-java-alternatives -s java-8-oracle
If you get some warnings when running these two commands, ignore them.
How to Remove Oracle Java To remove java on your system and want to go back to OpenJDK or remove java completely, all you have to do is remove the Oracle JDK7 Installer and the previous Java (OpenJDK, etc.) version will be used:
sudo apt-get remove oracle-java7-installer
sudo apt-get remove oracle-java8-installer
Special thanks to webupd8.org for their great tutorial for which this is based.
Tuesday, November 18, 2014
Disable Encryption on Ubuntu VNC Server
Option 1 - Command Line:
edit ~/.bashrc and on the last line add
dconf write /org/gnome/desktop/remote-access/require-encryption false
save the file and reboot the system
Option 2 - GUI
On the linux server open the terminal and install dconf-editor
sudo apt-get install dconf-editor
Open the program it Navigate to:
org >> gnome >> desktop >> remote-access and Disable "require encryption"
After doing this your windows VNC client will have no problem connecting to the Ubuntu Server using Screen Sharing.
Troubleshooting Tip: If your having problems with the screen redraws make sure your using the XORG driver. Using the proprietary driver can cause redraw issues with VNC
Friday, November 14, 2014
Removing Java Runtime from OS X
| Java 8 removes the Medium Security Setting in OS X |
Removing Java From OS X
Since Java 8 came out you no longer have the ability to run self signed java runtimes. This is a good thing from a security perspective but some devices like iKVM's use java self signed certificates to allow access and if your running Java 8 and OS X you might have a problem. My solution to this was to uninstall java 8 using the following commands
sudo rm -rf /Library/Java/JavaVirtualMachines/jdk{version}.jdk sudo rm -rf /Library/PreferencePanes/JavaControlPanel.prefPane sudo rm -rf /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin
Then I installed the latest version of Java 7 which will only be available until April 2015, but it will still be made available though the Java Archive.
Wednesday, December 18, 2013
Expanding a FREENAS ZFS volume by drive replacement
Just reciently I've found my self down to 100GB of my 6.4 TB NAS and decided it was time to upgrade my storage space. Now upgrading storage space on freenas isn't as simple as just replacing a bunch of drives; you must replace them one at a time and you wait for the drive to be completely replaced (resilvered) before replacing another drive otherwise you risk data corruption or loss. By default the auto grow is set to off so if you want to grow the space on your nas you must enable the auto expand feature in freenas. As always you should have another backup of this data.
So on your FreeNAS server you want to login via SSH or use the shell console provided in the web interface. Type the following command.
Once that is enabled you may now grow your freenas storage by replacing drives. As for myself I've replaced 4 320GB drives with 4 1TB drives moving my NAS from 6.4 GB to 8.3GB of storage space and to replace the drives it is a daily process with replacing a drive once a day until they are done.
Thursday, December 12, 2013
Backing up your Android Phone's Stock Rom and Recovery
Backing up your Android Phone's Stock Rom and Recovery
Have you ever wanted to mod your new android phone but wanted a way to get back to the factory settings without having to mod the phone first? It is possible to do but you need a few things, the Android Dev tools, fast boot, and some command line know how. For this example I will be using a HTC One X on the Telus Network.With HTC you have to get a developer token which can be obtained from http://www.htcdev.com. You will have to sign up as a dev to get your developer token. HTC has a great tutorial on how to unlock your bootloader on the htcdev site.
Thursday, November 21, 2013
Freenas Format Error: Operation Not Permitted
Freenas Format Error
If your trying to erase a drive in freenas and you get an error "Can't Erase Drive /dev/To solve this turn off the sysctl variable from the console.
sysctl kern.geom.debugflags=0x10
Wednesday, November 13, 2013
Connecting A Mac To A Windows Share
Connecting A Mac to a Windows Share
With the exception of mobile devices we still live in a "Windows World" and with the latest version of OS X comes an update on how to connect to a windows share using SMB2 instead of SMB.
On Mac OS X (Pre Mavericks or 10.9) we connected to a windows share using smb.
From the Finder press the "Command" + "K" keys or go to the "Go" menu and select Connect to Server. In the server address field put in either smb for pre 10.9 or cifs for 10.9
On a workgroup it looks something like this:
smb://thecomputer/sharedfolder
On an active directory the samba setup it looks more like this
smb://domain.ext/dfs/sharedfolder on a domain using a DFS Share
Now on OS X Mavericks we use cifs to connect to the windows shares.
cifs://thecomputer/sharedfolder on a workgroup and
cifs://theremotecomputer/sharedfolder$ on a domain using a DFS Share
If you are not logged into the domain or if the share doesn't have anonymous access it will prompt you for a username and password.
Friday, November 08, 2013
How to ssh into a Linux/Unix System without a password
Login to a Linux/Unix System without a password

Setting up SSH/RSH Keys for Remote Administration Under Linux/Unix can be one of the most time saving things you can do. I've set this up because I am managing a dozen Linux based kiosks based Lubuntu Linux and Mozilla FireFox on that need to remotely shutdown and startup.
For managing the kiosks I am using Ubuntu 12.04 LTS, on a VLAN network. This server also remotely shuts down some Windows based stations and is used for Imaging using the FOG project. I need to update the RSH Public and Private Key because I have replaced the server.
Setting up RSH Public and Private keys are trivial but this allows me to control the systems without having to enter a password every time I want to do something to the computer (besides something that requires root privileges).
The first thing I do on the computer I want to control the other computers with is generate a public and private key. I've done this in a .ssh directory using the Terminal
$ mkdir -p $HOME/.ssh
$ chmod 0700 $HOME/.ssh
$ ssh-keygen -t dsa -f $HOME/.ssh/id_dsa -P ''
This should create two files, $HOME/.ssh/id_dsa (private key) and $HOME/.ssh/id_dsa.pub (public key).
In my case I'm using a script called dafturn-ofris which is kind of a steady state script for linux which prevents users from making changes to the system and rebooting restores the system to the state it was frozen in. So I unfreeze the client system (the system I want to control remotely) and copy the public key from the "Server" to the client; I used SCP to accomplish this.
On the computer you created the key on open the Terminal move to the directory you generated the public key. In my case it is the .ssh folder in the $HOME directory of the user I'm logged in as.
$ scp id_dsa.pub username@remotehost:directory/to/save/it/in/
Enter in your password and this will complete the file copy.
Then login the remote client move into the directory where you saved the public key and run the following commands.
$ cat id_dsa.pub >> $HOME/.ssh/authorized_keys2
$ chmod 0600 $HOME/.ssh/authorized_keys2
Depending on the version of OpenSSH your using the following commands may also be required.
$ cat id_dsa.pub >> $HOME/.ssh/authorized_keys
$ chmod 0600 $HOME/.ssh/authorized_keys
An alternative is to create a link from authorized_keys2 to authorized_keys; your choice.
$ cd $HOME/.ssh >> ln -s authorized_keys2 authorized_keys
Now you should be able to remote into the client computers you want to control from the server computer without being prompted for a password; with the exception of root access. I use this for running rsh command that remotely shuts down client stations when its closing time.
Source Credit: http://csua.berkeley.edu/~ranga/notes/ssh_nopass.html
Tuesday, February 26, 2013
Creating A Secure Password
Creating a Secure Password
Password security is critical to your online life. If you don't have a secure password you will be easily hacked, many passwords are set to be 12345 or password.
The best passwords have upper and lower case, numbers and alternate characters like underscores, dashes, asterix and are long typically over 8 characters; 8 characters would be a minimum length for a password today. Try remembering this password created by Data on Star Trek The Next Generation.
Creating a good password is hard, and making one you can remember is even harder but not impossible.
Elements Every Password Should Have:
- Be longer then 8 characters should be more like 20
- Not be a dictionary password
- Should have at least 2 numbers
- Should have at least 2 capitals
- It should have at least one alternate character
- Should not be the SAME PASSWORD on every site.
Here is a form to help you create a good password; please fill out the following:
Favorite Animal/Colour/Activity: ______________________________________
Favorite Object/Word/Family Member: ________________________________
Select one of the or more of the following characters: ! @ # $ % ^ & * ( ) _ - + = | ? /
Put down your favorite Number ____________________
(if your favorite number is a single digit please put a 0 in front of it. Ie. 01)
Example:
Favorite Animal/Colour/Activity: __cat_
Favorite Object/Word/Family Member: _orange_
Select one of the or more of the following characters: ! @ # $ % ^ & * ( ) _ - + = | ? / Put down your favorite Number ______24_______
Your password can be OrangeCat@24 or other variants can be used what ever is easiest to remember.
Password Testers
Password Generators
Crazy Password Generators
For the regular user expecting them to change their password every two weeks for all their online services is pretty crazy. However for them to have a tiered password system or create a good password that is related to the site you are visiting but not obvious using the rules shown above. For example if I create a hotmail account I might make my password something like MyOrang3h0tM@!lAcc0unt24
And in case your wondering it would take an average desktop over 18 trillion years to crack my password. How about yours, try it out on http://howsecureismypassword.net/
The best passwords have upper and lower case, numbers and alternate characters like underscores, dashes, asterix and are long typically over 8 characters; 8 characters would be a minimum length for a password today. Try remembering this password created by Data on Star Trek The Next Generation.
Creating a good password is hard, and making one you can remember is even harder but not impossible.
Elements Every Password Should Have:
Here is a form to help you create a good password; please fill out the following:
Favorite Animal/Colour/Activity: ______________________________________
Favorite Object/Word/Family Member: ________________________________
Select one of the or more of the following characters: ! @ # $ % ^ & * ( ) _ - + = | ? /
Put down your favorite Number ____________________
Example:
Favorite Animal/Colour/Activity: __cat_
Favorite Object/Word/Family Member: _orange_
Select one of the or more of the following characters: ! @ # $ % ^ & * ( ) _ - + = | ? / Put down your favorite Number ______24_______
Your password can be OrangeCat@24 or other variants can be used what ever is easiest to remember.
Password Testers
Password Generators
Crazy Password Generators
And in case your wondering it would take an average desktop over 18 trillion years to crack my password. How about yours, try it out on http://howsecureismypassword.net/
Creating A Secure Password
Creating a Secure Password
Password security is critical to your online life. If you don't have a secure password you will be easily hacked, many passwords are set to be 12345 or password.Here is an example of a bad password. https://www.youtube.com/watch?v=a6iW-8xPw3k
The best passwords have upper and lower case, numbers and alternate characters like underscores, dashes, asterix and are long typically over 8 characters; 8 characters would be a minimum length for a password today. Try remembering this password created by Data on Star Trek The Next Generation.
Creating a good password is hard, and making one you can remember is even harder but not impossible.
Elements Every Password Should Have:
- Be longer then 8 characters should be more like 20
- Not be a dictionary password
- Should have at least 2 numbers
- Should have at least 2 capitals
- It should have at least one alternate character
- Should not be the SAME PASSWORD on every site.
Here is a form to help you create a good password; please fill out the following:
Favorite Animal/Colour/Activity: ______________________________________
Favorite Object/Word/Family Member: ________________________________
Select one of the or more of the following characters: ! @ # $ % ^ & * ( ) _ - + = | ? /
Put down your favorite Number ____________________
(if your favorite number is a single digit please put a 0 in front of it. Ie. 01)
Example:
Favorite Animal/Colour/Activity: __cat_
Favorite Object/Word/Family Member: _orange_
Select one of the or more of the following characters: ! @ # $ % ^ & * ( ) _ - + = | ? / Put down your favorite Number ______24_______
Your password can be OrangeCat@24 or other variants can be used what ever is easiest to remember.
Password Testers
Microsoft Password Checker
http://www.passwordmeter.com/
http://howsecureismypassword.net/
Password Generators
http://www.testyourpassword.com/
Crazy Password Generators
https://www.grc.com/passwords.htm
https://www.grc.com/ppp.htm
Top 500 Worst Passwords
For the regular user expecting them to change their password every two weeks for all their online services is pretty crazy. However for them to have a tiered password system or create a good password that is related to the site you are visiting but not obvious using the rules shown above. For example if I create a hotmail account I might make my password something like MyOrang3h0tM@!lAcc0unt24
And in case your wondering it would take an average desktop over 18 trillion years to crack my password. How about yours, try it out on http://howsecureismypassword.net/
Wednesday, February 15, 2012
Apple Rotten To The Core?
Is a mac the machine to buy? You might want to think twice!
I've been using Apple products since I was 7, so I'm very familiar with the way Apple does things but now I'm calling them out on the lack of a physical recovery disk when you purchase a mac instead opting to go with a recovery partition. Ok so why should you care? Here's why.
If your a geek like me you like to push your hardware to the limits, finding compatible cards, and accessories is fun and getting them to work is even more fun, and you do a lot of reinstalling, and if your not a geek you should also be concerned, because this takes getting your computer fixed out of your control. Now your better off to go with a Windows computer because at least you can make recovery disks.
Here is a copy of a letter I've sent Apple.
Dear Apple Support,
You probably won't care about this email but I'm writing it anyway. I must express my profound disappointment with your decision to go with a recovery partition over a recovery disk. As a tech person I am often helping people with their systems, and as such have the occasional time where a machine is past warranty and they don't have the money to purchase a new one, or they want to do some sort of hardware upgrade where a reinstall of the operating system is required.
Now that you are no longer offering bootable disks with your systems I must now categorize you in the company of HP or Dell, (That is a bad thing). I often recommended Apple Computers for their pick of hardware, but the fact you actually got some sort of other bootable media other then the hard drive if anything were to happen to your computer. Now that is not the case and the fact that you need an internet connection to do a restore will make things take longer and to frank about it is a joke. I know your trying to make the move to cloud computing but there are some things that the cloud can't do well and operating system installs is one of them. Now your going to tell me that I can take my Mac to any apple store and they will do it for me and at no doubt with some sort of charge. When you made this decision did you think everyone was made of money and time?
If you are going to sell computers without a recovery disk you should at least give users an option to guy a bootable flash drive of the OS or some sort of removable media. I've purchased every Apple OS from system 9 to 10.7 and have been a large supporter of apple computers in my social circles but now unless you change your current policy I can no longer do that. I always felt you were trying to do what is right on for the user but in this I can't support and won't support, you are taking away a user's right use their computer as they see fit and if that's your policy that's your policy there is nothing I can do about it but tell you about it and how I don't like it. (Hell at least Microsoft will let you make recovery disks you guys won't even do that; and the thought of that use to suck).
I hope you will reconsider shipping your systems with removable bootable media.
Trevor Tye
------------------UPDATE-----------------------
Apple does offer a USB Flash Drive of Lion for $70.00, which is a little outrageous but it is better then nothing.
http://store.apple.com/us/product/MD256Z/A?
There is also the Lion Recovery Disk Assistant that will let you make a recovery disk to DVD's or a Flash Drive
Apple getting rotten to the core?
Is a mac the machine to buy? You might want to think twice!
I've been using Apple products since I was 7, so I'm very familiar with the way Apple does things but now I'm calling them out on the lack of a physical recovery disk when you purchase a mac instead opting to go with a recovery partition. Ok so why should you care? Here's why.
If your a geek like me you like to push your hardware to the limits, finding compatible cards, and accessories is fun and getting them to work is even more fun, and you do a lot of reinstalling, and if your not a geek you should also be concerned, because this takes getting your computer fixed out of your control. Now your better off to go with a Windows computer because at least you can make recovery disks.
Here is a copy of a letter I've sent Apple.
Dear Apple Support,
You probably won't care about this email but I'm writing it anyway. I must express my profound disappointment with your decision to go with a recovery partition over a recovery disk. As a tech person I am often helping people with their systems, and as such have the occasional time where a machine is past warranty and they don't have the money to purchase a new one, or they want to do some sort of hardware upgrade where a reinstall of the operating system is required.
Now that you are no longer offering bootable disks with your systems I must now categorize you in the company of HP or Dell, (That is a bad thing). I often recommended Apple Computers for their pick of hardware, but the fact you actually got some sort of other bootable media other then the hard drive if anything were to happen to your computer. Now that is not the case and the fact that you need an internet connection to do a restore will make things take longer and to frank about it is a joke. I know your trying to make the move to cloud computing but there are some things that the cloud can't do well and operating system installs is one of them. Now your going to tell me that I can take my Mac to any apple store and they will do it for me and at no doubt with some sort of charge. When you made this decision did you think everyone was made of money and time?
If you are going to sell computers without a recovery disk you should at least give users an option to guy a bootable flash drive of the OS or some sort of removable media. I've purchased every Apple OS from system 9 to 10.7 and have been a large supporter of apple computers in my social circles but now unless you change your current policy I can no longer do that. I always felt you were trying to do what is right on for the user but in this I can't support and won't support, you are taking away a user's right use their computer as they see fit and if that's your policy that's your policy there is nothing I can do about it but tell you about it and how I don't like it. (Hell at least Microsoft will let you make recovery disks you guys won't even do that; and the thought of that use to suck).
I hope you will reconsider shipping your systems with removable bootable media.
Trevor Tye
Removing Show Recent History and Recently Open Documents from Windows Explorer
How to remove the Recent History and Recently Open Documents from Windows Explorer Using the Registry Editor Press the Windows Key + R, type...
-
When working in a test environment you don't exactly want something to have internet access; so you need to be able to download files in...
-
To see a video of the Rustdesk installation visit https://www.youtube.com/watch?v=t7UobpjDsRY and if you like the content please like and s...
-
Quick guide: Automatic login in Windows 10 Open the Registry Editor using [Windows] + [R] and “regedit” . Enter HKEY_LOCAL_MACHINE\SOF...















