Upgrade Ubiquiti NVR

The upgrade is a long process overall, so don’t panic too much as the process upgrades the database and the recordings. I created this after poking around the forums, I found LLigetfa advice very useful, so he needs some thanks for “kicking this off”. As ever reboot the device at the end of the process.

SSH into NVR device using putty, use IP of device and port 22

My IP is


If you get this just click yes


Default login is root


Password is default ubnt, but I have changed mine during the original setup so I used this.


You should now get this


See Comments below for Purging the install

sudo apt-get remove --purge airvision

Next – Download the latest Debian .deb file (at the time of doing this it was 3.0.2) the file name structure is dpkg -i <airVision_Bin_File>

wget http://www.ubnt.com/downloads/unifi-video/release/unifi-video_3.0.2~Debian7_amd64.deb



Next install the package                dpkg -i unifi-video_3.0.2~Debian7_amd64.deb


This may take a while, so relax doing something else and come back to it.


Finally after 10-15 minutes (this particular device had a month worth of videos on it)


Next log into the device as normal – yes I work for a hotel group.


Again relax while it sorts itself out (took another 10 minutes), eventually you will be allowed to upgrade the cameras. (This is where I panicked on my first upgrade)


Give it a while and you get the option to upgrade the cameras


After upgrading my NVR version was still stuck a 2.0, should be 3.2 and no recordings are being made due to what seems to be a lower setting for motion detection, left it again for a while.


Again I started to panic a little, but then after 20 minutes I started getting recordings. The V2 label on the NVR seems to be a bug.


Finally check you NVR retention settings, it defaults to 7 days, I need longer.


Original post



Adding Google Fonts to Magento

Pick a font from http://www.google.com/webfonts

Click on “Use this font” tab

Choose the styles and character set you want to use the copy the code Google generates for you.

Go to your Magento admin, click the “system” menu then “configuration”.

Under the “General” tab on the left, click on “Design”

In the HTML HEAD section, add the code you copied from Google to the section  “Miscellaneous Scripts”.

<link href=’http://fonts.googleapis.com/css?family=Alegreya+SC:400,900&#8242; rel=’stylesheet’ type=’text/css’>

Click “Save Config”.

Now goto whichever custom CSS thats controlling your site and add the font


font: Alegreya

iPad – Exchange Sync Problem

So I spent the last few hours trying to connect a new iPad 3 to a clients Exchange 2007 server.

He had previously created his account on the iPad using a 3G connections, the account was verified and all looked good.

He then went to open his Mail app and got an error saying that the connection to the server failed.

At first I thought it might be something to do with server address/auto-discovery and he was trying to connect over 3G. I headed over to his office and grabbed his iPad, made sure it was conected to his company WiFi, removed the old account, recreated and tested.

Same problem. Checked his Exchange account, active-sync was enabled.

I then went to his OWA account and checked his Mobile Phones under options and the iPad showed up but without a Synch date.

I removed the device from his account in OWA, cleared his iPad, recreated and tested. No joy.

Next I removed the account from the iPad, removed from the iPad from OWA and setup a test account, joined his iPad and…working, no problem.

So at this point I determined that the problem must be with his account. Nothing obvious from his Active Directory or Exchange account EXCEPT – the iPad wasnt showing up as a mobile device in his Exchange settings. Interestingly, it WAS showing up against the test account.

At this point I head back over to the AD user account properties, check security, advanced and make sure the the Exchange Servers permissions are INHERITED (they werent).

Go back, recreated the acount on his iPad – all working perfectly now.

Delete a Windows Service

If you need to delete a service from Windows (say one left behind by a failed uninstall) use the following command prompt with admin rights

sc delete [servicename]

Photo.jpg wont open In Outlook 2003

When users receive attachments called photo.jpg (the default name for photos taken with iPhones/iTouch/iPad) in Outlook 2003 they sometimes receive an error telling them that Outlook cannot open this type of file.

To fix, clear the Outlook temp folder.

To find out which folder Outlook is using open regedit and navigate to HKEY_CURRENT_USERS\Software\Microsoft\Office11.0\Outlook\Security

On the right hand side note the Temp folder directory being used

Navigate to this folder in Explorer and delete the content

You should now be able to open photo.jpg from Outlook again

MS Exchange 2010 – How to View Mailbox Properties

Taken from Microsoft – the Exchange 2010 management console has removed the ability to view mailbox stats (such as Size and Items) from the GUI. You now need to run a PowerShell script as described below.

Also, note you need to run the Exchange Management Shell, not the regular Powershell

You can use the Get-MailboxStatistics cmdlet to obtain information about a mailbox, such as the size of the mailbox, the number of messages it contains, and the last time it was accessed. In addition, you can get the move history or a move report of a completed move request.


Get-MailboxStatistics -Identity[-Archive] [-DomainController] [-IncludeMoveHistory] [-IncludeMoveReport]

Get-MailboxStatistics -Database[-DomainController]

Get-MailboxStatistics -Server[-DomainController]

Detailed Description
On Mailbox servers only, you can use the Get-MailboxStatistics cmdlet without parameters. In this case, the cmdlet returns the statistics for all mailboxes on all databases on the local server.


The Get-MailboxStatistics cmdlet requires at least one of the following parameters to complete successfully: Server, Database, or Identity.

You can use the Get-MailboxStatistics cmdlet to return detailed move history and a move report for completed move requests to troubleshoot a move request. To view the move history, you must pass this cmdlet as an object. Move histories are retained in the mailbox database and are numbered incrementally, and the last executed move request is always numbered 0. .

Setting and Changing Collation – SQL Server 2008

You can change the collation of sql server without uninstalling. Lets discuss the necessary steps for changing collation for sql server.

Steps for changing collation

  • Take backup of all the databases & logins exists in the server for safer side.
  • Detach all the user databases
  • Insert SQL Server 2008 CD DVD into drive.
  • Below is the syntax for changing the collation at serverlevel, please note that this will rebuild all the system databases in that instance/.
setup.exe /q /ACTION=RebuildDatabase /INSTANCENAME=InstanceName /SAPWD="New SA Password" /SQLCollation=CollationName /SQLSYSADMINACCOUNTS="Admin ID"



/q – perform silent installation

/Action – We are rebuilding the system databases to change the collation hence the parameter is always RebuildDatabase only

/INSTANCENAME – Name of the instance you are going to change the collation

/SAPWD – Provide new password for SA login

/SQLCollation – Provide the new collation name of SQL Server

/SQLSYSADMINACCOUNTS – Provide a account name which has admin rights in sql server. Please note that this account should be windows authenticated account having sysadmin privilege in sql server

  • Once its done check the new collation of sql server
  • Attach all the user databases to SQL Server and r

Thanks to sql-articles.com
Read more: http://sql-articles.com/articles/dba/how-to-change-server-collation-in-sql-server-2008/#ixzz1pu2S8XW3