How to Reset Sitecore 7.1 & Sitecore 7.5 Forgotten/Lost Admin Password
In working on implementing a Sitecore site into an existing code base inherited from another vendor, I discovered that the admin password had been modified and the vendor would not share it. Not being able to login to the admin section of Sitecore was not ideal to say the least. After scouring the web, most articles contained instructions on how to reset the password, but almost all of them applied to Sitecore 6 and below. For Sitecore 7 and above, most articles were not applicable as they introduced the PasswordSalt field into the database which Sitecore uses to hash the password.
If you’ve run into a similar situation, or you’ve forgotten or lost your admin account password, getting access back to everything is pretty simple. Load SQL Management (or your favorite SQL editor) and execute this query against your Core database:
UPDATE dbo.aspnet_Membership SET [Password]=’qOvF8m8F2IcWMvfOBjJYHmfLABc=’, [PasswordSalt]=’OM5gu45RQuJ76itRvkSPFw==’, [IsApproved] = ‘1’, [IsLockedOut] = ‘0’ WHERE UserId IN (SELECT UserId FROM dbo.aspnet_Users WHERE UserName = ‘sitecore\Admin’)
This will now reset the default admin password to ‘b’ so that you may login to the Sitecore desktop. Happy editing!
How to Import Multiple VCF contacts into iCloud
One of my users recently came to me with an interesting problem this week. She had left her old job but had left all her contacts on her work account. Once the account was deleted, all the addresses were wiped out as well. By sheer luck, her iPad had a copy of the contacts since she never connected it to a new network which prevented any type of sync. We managed to export the contacts off the iPad to VCF cards but were now left with the tedious task of importing them all into iCloud for her to use on her phone. I tried dragging and dropping all the VCF cards into the browser but iCloud displayed 300+ errors saying the card could not be imported, without specifying which ones were a problem. The import would error out after clicking OK at around 300 times and not actually import a single one.
I remembered that the format of the cards is simple text and you can easily merge the files into one big file to import.
- Copy the VCF cards to a folder like c:\temp\vcf.
- Right mouse click on c:\temp\vcf while holding shift and you’ll see an option that says “Open with Command Prompt”
- You can also open command prompt by clicking Start -> Run, or windows button + r and type cmd to launch it.
- Enter the command copy /a *.vcf merge.vcf in the command prompt.
This will merge all cards into a single VCF file. Now return to iCloud Contacts, click on the gears icon on the bottom left, and click “Import Contact” and choose the generated VCF card. iCloud will now display a progress bar of the import and any errors. In a strange coincidence, importing the contacts this way only prompted me with three or so errors. I’m not exactly sure why the error count was reduced doing it this way. (There were over 1500 contacts to import and I wasn’t about to sift through them to see what was different since it was for personal contacts.)
Soylent
If you haven’t heard of Soylent, you’ve probably been living under a rock. It’s a meal replacement that’s become a hot topic of discussion on many sites and forums from Reddit to Tim Ferris’ own blog.
I bought into the craze and decided to give it a go for a month to see if it works for me. I honestly have no expectations or assumptions as most products and gimmicks always end up failing for me despite working for everyone else. I’ve tried the Slow Carb diet but found it unsustainable for myself for long-term use for multiple reasons. The diet works but quickly becomes very expensive. Unless you have serious will-power, it becomes very hard to stick with it for long durations since it’s such a significant lifestyle change for a foodie like myself.
I’m going to log my experience with Soylent here for a month and see how it works out for me.
Mac Outlook 2011 Reply All Includes My E-mail (with solution)
I’ve started a new job and was assigned a Macbook for my daily work. I’ve found equivalents for most of my applications. Personally, I find the native Mac apps are just extremely underpowered for my computing needs. I hate Mail especially, and even more so how all the apps are split out into separate apps. Luckily I have Office for Mac. Not so luckily, Outlook Mac 2011 is not as well designed as Outlook for Windows in so many ways.
One of the bugs I ran into was the “Reply All” bug where your e-mail is included in the CC field. It’s rather annoying having to choose from having to manually delete your address or having an extra e-mail to delete from your inbox.
The fix turned out to be rather simple for me. It turns out that Outlook for Mac isn’t very smart. It doesn’t seem to be able to tell which address you’re sending the e-mail from even though it’s doing the sending. When my account was initially setup, the company set it up with one of their subsidiary domains which was incorrect. Rather than creating a new inbox, they simply created an alias for the domain but never updated my configuration.
To fix the issue, do the following:
- Go to Tools -> Accounts.
- Ensure that your e-mail address field is set to match the address you are sending from.
My e-mail address had been set to the old one and still worked due to the aliasing. As soon as I updated the address to match the corrected domain, the reply all stopped including my e-mail address.
Safari Prompts Authorization for Video in Password Protected Folders
Using Safari 6 and trying to password protect a site with videos? You might run into issue where Safari prompts you for a password. Unexpectedly, you’ll find that you’re unable to interact with the fields to re-authenticate or even move the box to get it out-of-the-way.
If you run into this issue, check your folder structure. If your videos are in a password protected folder and inherit from the parent like below, you’ll have to move the video files out of the password protected folder to get the videos to play.
Main
—Password Protected Folder
——Videos
Your new folder structure will need to be similar to something like:
Main
—Password Protected Folder
—Videos
Once you do that, your videos should play with no issues. I’ve already reported the issue to Apple when I first encountered the issue but there’s been no fix to date.
Photography Blog is Now Live
It’s been a while since I’ve updated this blog but I’ll be adding more posts about thoughts and technology soon. On an unrelated note, I’ve gotten heavily into photography and am becoming quite proud of the art I’ve created. With the amount of photos I’ve taken, I’ve decided to split the photography into its own blog that’s more suited for showcasing the work. The wolf picture above is one of the latest pictures I’ve taken and there’s plenty more that you can see at http://gregv.photography.
How to Capture Google Analytics Before Redirect
Up until today, everyone I know has struggled to capture a Google Analytics event on redirect links. We’ve all had to come up with hacks and workarounds to ensure that the initial landing page is tracked. Today I finally figured out a solution that works. Google analytics now offers a callback event which lets you fire the redirect (or any custom functionality after the main tracking event fires.
The snippet to add after the Google analytics tracking code setup is below:
ga('send', 'pageview', {
'page': '/my-new-page',
'hitCallback': function() {
window.location.replace = "[new url]";
}
});
ESET AntiTheft Causes Dell Machines to Lose Permissions on C:
I just spent the past two days complaining about Windows 8 to everyone I know because of how awful the experience is. I installed Windows updates, rebooted, and the system stops working.
It turns out it wasn’t Windows causing the problem but ESET AntiTheft on Dell laptops. It turns out there’s a permission bug specific to Dell machines when ESET creates it’s ghost account and instead of giving it restricted access, the system essentially copies the permissions and then changes everything on the C: drive to a state where the permissions are no longer accessible.
Unfortunately, the only known fix at this point is to contact ESET support. I called their support line in North America and the tech knew about the issue right away. You’ll have to reboot into safe mode, and then get them to remote in to install a utility that runs a script that resets the permissions.
Contact Info here: http://www.eset.com/us/about/contact/
The tech assured me they are working with Dell to get this issue resolved so until they do, make sure you don’t activate ESET’s AntiTheft on the Dell machine.
What’s the Problem?
A few years ago, I started at a company as a help desk tech. After establishing myself, I’d often get put on all the…interesting issues. When nobody else could figure out the problem, I’d get called in to figure out the issue. During my early days as a new tech there, the manager of the team passed me a ticket and stopped by to give me background on the situation. This particular client would call in every week because one computer couldn’t talk to the server and at one point, every tech on the team had worked on the problem and nobody had been able to figure it out. My manager told me not to stress about it because it was definitely something on their side but he treats the situation as a rite of passage for all new hires.
I give the doctor a call back and he gets me connected to his PC and begins to elaborate on the problem and all the things everyone has had him do. He explains how his tech knows the problem is with our software since everything on the network side works. He clicks on the Windows XP start menu and by sheer luck, the tech had set the menu back to classic which meant the banner along the left showed which version of Windows was running. As the doctor continued on with his explanation, I noticed the banner on the start menu said “Windows XP Home Edition”.
I politely interrupted the doctor and informed him that I had figured out the problem. He went quiet for a few seconds and said “You haven’t done anything yet and I haven’t finished explaining everything. How could you possibly have figured out the problem?” I informed him that he’s running Windows XP Home Edition which doesn’t support business networking and explains why he couldn’t connect to the server. He insisted that all his computers are running Windows XP Pro and besides, how could I possibly know that without having even done anything?
I asked him to click on the start menu and then he went quiet. I asked if he was there and he apologized and said he was going to call his tech to get the OS fixed. He asked if it would be alright for him to call and request my help if there are any problems from there.
I closed the ticket with “Problem solved. Issue was Microsoft Windows XP Home Edition”.
Maple Syrup Pie Recipe from Aux Anciens Canadiens Restaurant
In January, I decided to take advantage of vacation deals and went to Quebec for a weekend to explore Quebec, Chateau de Frotenac, and the Ice Hotel. I had an incredible time overall. During my stay at the Chateau, I wandered around a bit and discovered the Aux Anciens Canadiens Restaurant, supposedly the oldest building in Quebec. The restaurant is located in the historic Maison Jacquet, just down the block from the hotel. The food was incredible and the service was impeccable.
After my incredibly sumptuous dinner, they presented me with a dessert menu and I noticed one I’ve never had before called the Maple Syrup Pie. It was the house speciality so I decided I had to try it right away. If you can make it out there, I highly encourage you to go to the restaurant and try the restaurant’s amazing food. Until you can enjoy this unique dessert at the Aux Anciens Canadiens Restaurant, you can make it yourself with this easy recipe.
Maple Syrup Pie
Aux Anciens Canadiens (www.auxancienscanadiens.qc.ca)
34, rue Saint-Louis C. P. 175 succursale Haute-Ville
Québec QC G1R 4P3
418-692-1627
- 1 ¼ cup brown sugar
- ½ cup 35% cream
- 2 large eggs at room temperature
- 1/3 cup maple syrup
- 2 teaspoon butter at room temperature
- 1 pie crust
- Preheat oven to 350 F (180 C).
- Blend brown sugar, cream, eggs, maple syrup and butter in an electric blender until unctuous consistency.
- Pour into a pie crust.
- Bake for around 45 minutes.
- Serve at room temperature with fresh cream.