There are plenty of articles and Youtube videos showing how to switch the Option and Command keys when you adapt a PC keyboard for use on the Mac.Â (System Prefs – Keyboard – Modifier Keys – Choose the correct keyboard, then switch Command and Option).
But even after doing that, the Options key wouldn’t work.Â I finally noticed the “Win Lk” light at the top right.Â Gaming keyboards let you turn off the Windows key in case you accidentally hit it during a game, and that’s the key that is now mapped to Option for my Mac.
Turning if off just requires holding Fn and pressing F8, which also has a “no Windows” symbol.
In a recent iOS update, Apple started requiring an extra click of the home button to unlock your iPhone, instead of just allowing a “click with finger resting on Touch ID” to unlock the phone. Â It’s not a big change, but just different enough to be frustrating.
To go back to the original behavior, go to Settings – General – Accessibility – Home Button and enable “Rest Finger to Open”.
Zapier has published a free ebook called The Ultimate Guide to Google Sheets, and it mentions my “Insert and Delete Cells” Sheets Add-on!
The Rackspace web dashboard allows you to attach a certificate and private key to a cloud load balancer for ssl offloading. Â But even though the load balancers support SNI and multiple certificates, neither the web console nor the “rack” command line scripts expose this functionality.
If you want to attach additionalÂ certificates to a load balancer from the command line, check out racklb.sh atÂ https://github.com/karlkranich/racklb. Â The script doesn’t do a lot yet, but does the two things that I miss most from the web console:
- Expose the private (ServiceNet) address of a load balancer
- Manipulate the certificate mappings
To get started with it, clone the repo and check out the readme and “racklb.sh -h”
Thanks to Adam Bull at www.haxed.me.uk for the inspiration and sed magic in this script!
We have an increasing number of Windows 10 machines in our office, and realized that we couldn’t get them to connect to shares on our OS X 10.10.5 (Yosemite) server. Â We have a bunch ofÂ Local Network Users, and had no problem connecting as them from Windows 7 machines. Â But Windows 10 machines would just pop up the authentication dialog again with the message “The specified network password is not correct”.
I tried all of the Local Security Policy changes that people have mentioned on the ‘net, and nothing worked. Â I finally came across somebody mentioning that you have to put the server NetBIOS Name in ALL CAPS when you authenticate. Â So, in our case, we needed to make one Local Security Policy change on the Windows 10 clients and put the server name in all caps when authenticating.
Continue reading →
While working with the development version of a document library that uses Oracle for storage on a Windows 8.1 laptop, we ran into the error “ODBC error: [Oracle][ODBC][Ora]ORA-28001: the password has expired”.
It turns out that up until Oracle 10, the default password policy was no password expiration. Â Starting with Oracle 11, there is a default password lifetime of 180 days.
Here are the steps we took to fix it:
1. Get DBA privileges
Assuming you’re logged into Windows as “joe”, check if you’re in the “ora_dba” group by running cmd.exe and issuing the command “net user joe”. Â You’ll see a list of local groups that you belong to near the end of the output. Â If you don’t know who you’re logged in as, try “whoami”.
If you’re not in the ora_dba group, you can add yourself with the Local Users and Groups tool in Computer Management. Â Except that tool is gone in Windows 8.1. Â Very frustrating! Â In that case, issue the command “net localgroup ora_dba joe /add”.
2. Set the password lifetime to unlimited
Now you can change the password lifetime with this series of commands:
connect / as sysdba
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
3. Change Oracle user passwords
You may or may not need to change the password of Oracle users on your system.
From the sqlplus prompt, use the following command (use double quotes around the new password and replace the username “system” as needed):
ALTER USER systemÂ IDENTIFIED BY “new_password”;
Hope this helps some people!
My Macbook Pro (mid-2009) hard drive crashed a few weeks ago. Â Since I had a current Time Machine backup, I figured that it would be super-simple to install a new hard drive and do a restore. Â Well, it wasn’t as simple as I’d hoped.
Continue reading →
I wanted to temporarily redirect people who browse to www.keynote.org to the page www.keynote.org/donate.Â Since this is a WordPress site, I should have been able to easily do this by logging into the dashboard and going to Settings – Reading and changing the static front page to the Donate page.Â For some reason, the Donate page wasn’t rendering properly, even though the page looked fine when it wasn’t set as the front page.
Rather than take the time to figure out what is going on in the WordPress processing, I added the following line to the .htaccess file after “RewriteBase /”:
RewriteRule ^$ http://www.keynote.org/donate [L]
This matches any browser requests that don’t have anything after the hostname and redirects them to /donate. It seems to be working well so far.
I love the idea of using a custom Â error page to communicate the gospel — I wish I were that creative! Â Above is the 404 page that you used to get from Mars Hill Church.
Think about ways that you can use your 404 page to educate, encourage, or entertain.Â Hopefully your site is organized well enough that people won’t see the page often, but they will eventually — it might as well be a positive experience!
Depending on how you’re hosting your web site, there are different ways to customize your error pages.Â If you’re using WordPress, your theme might have a custom 404 page template as described here.Â If you’ve coded your site manually, your web host might have a control panel to edit error pages, or you can point to custom error pages via your .htaccess file. Â The web hostÂ 1and1 shows how to use the .htaccess file here.
This is one of those frustrating stories for a tech, where you bang your head against a problem for a few hours, finally fix it, then try to break it again to document it and it doesn’t behave the way you expect.Â But it’s still working, so maybe it will still help someone else…
I was trying to upload a 4 MB photo to my WordPress 3.4.2 site hosted at 1&1, and the uploader told me that it was too big — that the maximum upload file size was set to 2 MB in php.ini.Â It doesn’t appear that 1&1 gives me access to the main php.ini, so I tried to add one to the root folder and/or the wp-admin folder of my WordPress installation.Â Neither seemed to work, but I eventually figured out that I needed the file in the wp-admin folder and I needed to log out and back into the WordPress dashboard.Â Here’s the simple php.ini that I added to the wp-admin folder:
upload_max_filesize = 10M
post_max_size = 10M
What was extra frustrating was what happened when I removed the php.ini to document this: instead of going back to 2 MB, the maximum upload size went to 8 MB.Â That’s bigger than I needed, and if it had started that way I wouldn’t have had to go through all of this.Â I can’t explain it!