Microsoft KB2670838 the EVIL update

Evil MS Update KB2670838

When patching desktops in particular, this update in some instances kills all Aeroglass ability and Windows Desktop Experience management.  I first noticed this on my personal Windows 7 64 bit laptop with a 2GB Nividia card, the Aeroglass wouldn’t work and all my applications were running on strictly hardware only for video settings.
Some MS blogs point out this update is necessary for IE10, which already has a slew of problems for business environments.  My advice is to avoid this update until IE10 is ready for prime time!

Ninite – update (almost) everything in one shot

 

Still sitting at your computer updating one application at a time, chained to your desk perpetually hitting the “next” button until the next prompt?  Unchecking boxes so bloatware doesn’t sneak into your installations?  Screw that – take control of your updates with ninite.  Ninite installs multiple applications at once, with some very important caveats:

1. It is unattended

2. It does not install any additional bloatware

3. It does not require you to go to more than one website to accomplish either 1 or 2.

It’s simple: head to www.ninite.com and choose the apps you want, download the installer and save to desktop or run from browser.  It walks you through what it’s doing with each installer and gives you the most up to date software for whatever you picked.

You can even save the file, and double-click it later on to update your software without having to pick them again.  How easy is that?

 

As an IT guy, this helps tremendously; any tool I can use that can automate my day and gives me more time to do other stuff is great.  Now I can get back to facebook creeping people.

 

-Dexter

Handy App of the day: Space Sniffer

If you’ve been working on Windows based computers or servers, or Windows File Servers, a time will come when you have to figure out how much space you’re using and what type of files are taking up space.  I’ve used Tree Size Free, WinDirSTAT and Filemenu Tools many times in the past but always found that they take too much time, need to be installed or don’t have proper visualizations.

SpaceSniffer seems to be the near perfect solution: it’s free, runs portable (no installer necessary), has great visualizations and is FAST.

Color Coding comes in handy for types of media, file classes, and even free space.
Color Coding comes in handy for types of media, file classes, and even free space.

Compared to Filemenu tools or WinDirSTAT, Spacesniffer also does it’s calculations in real time; deletion of a file updates the entire diagram.  There’s also the ability to ‘Zoom’ into a directory or choose a network location.

Simply awesome freeware.

 

-Dexter

How to: turn a DLink DNS-323 into a Rsync backup location

Rsync backups

*Updated Jan 21, 2021*

After purchasing a Synology DS-413J to replace my DNS-323 device, I wanted to repurpose the old NAS into a backup server.  In my mind, I pictured using a Richcopy or Robocopy scheduled task from a Windows machine to talk to the 2 devices.  As it turns out, both the NAS’s can speak the same language (linux) and there’s a handy little tool that takes a couple steps to do, but is well worth the effort if you want re-purpose a DNS-323.

DNS-323 instructions: You need Funplug!

1. Funplug instructions have been around for a while, NAS-TWEAKS has an excellent blog style article you can follow.  Here’s the cole’s notes version:

-After reformatting your DNS-323 device, download the fun_plug file and fun_plug.tgz and place them on the ‘volume_1’ share of your DNS-323.

reboot the DNS-323 connect via telnet to port 23 (no password required at this point)

-install the extra packages onto your DNS-323 (particularly, RSYNC) which is included:

rsync -av inreto.de::dns323/fun-plug/0.5/packages .
funpkg -i *.tgz
-enable root, and set a password
pwconv
passwd
login
store-passwd.sh
-enable and auto restart ssh services
cd/mnt/HD_a2/ffp/start
sh sshd.sh start
chmod a+x sshd.sh

Issue this command so you’re not just stuck with the busybox-only prompt:

usermod -s /ffp/bin/sh root
Change the default directory in ssh to something more familiar:
usermod -d /mnt/HD_a2/ root

That’s the most condensed version of Funplug I can give you guys, there’s lots of more minute details, but for now that will do to get what’s necessary: RSYNC and SSH services on the DNS-323.

2. Configuration of RSYNC requires some small knowledge of text editor vim or ‘vi’ as the busy box package has. First, SSH in with the root account, and create a new file named rsyncd.conf in the /mnt/HD_a2/ffp/etc directory:

login as: root
root@DNS323's password:
root@DNS323:/mnt/HD_a2# cd/ffp/start
root@DNS323:/mnt/HD_a2/ffp/start# sh rsyncd.sh status
rsync not running
root@DNS323:/mnt/HD_a2/ffp/start# cd ..
root@DNS323:/mnt/HD_a2/ffp# cd etc
root@DNS323:/mnt/HD_a2/ffp/etc# vi rsyncd.conf

The contents of rsyncd.conf should look like the below:

# /ffp/etc/rsyncd.conf configuration file
max connections = 2
secrets file = /ffp/etc/rsyncd.secret

use chroot = false
read only = no
list = false
strict modes = false
hosts deny = *
timeout = 600
dont compress = *.gz *.tgz *.zip *.z *.rpm *.deb *.iso *.bz2 *.tbz 
*.mkv *.avi *.mpg *.jpg *.rar
pid file = /var/run/rsyncd.pid

[File Backups]
hosts allow = 192.168.0.1/24 #your local network IP range
read only = false
gid = backup
uid = backup
auth users = backup_user 
path = /mnt/HD_a2/Backup_directory #Path of Backup on DNS unit

I’ve highlighted the lines you’ll need to change:

hosts allow
= This is the IP Address range of your local network, the above example is for a standard Class C network, make the appropriate changes to yours. The /24 denotes the type of subnet mask you’re using. /24 pertains to a standard 255.255.255.0, this typically will fit your home network. Otherwise, here’s a cheat sheet on subnets.

auth users
= This user has to be created through the DNS-323 web server. You can stick with the standard ‘Admin’ account if you want, but for security purposes it’s a good idea to have a separate one for backup jobs.

path
= is the path on your DNS-323 of where you’re going to backup your data.

3. After saving rsyncd.conf, you’ll have to create a new file, rsyncd.secret:

root@DNS323:/mnt/HD_a2/ffp/etc# vi rsyncd.secret

Contents of rsyncd.secrets is very short as it contains the username and password of your backup user authenticated from rsynd.conf:

 #One line per user; a User ID:(colon)then password 
backup_user:password

The command is just one line, username:password. This is where you fill in the username and password created in the web interfaced of your DNS-323, and specified rsyncd.conf.

root@DNS323:/mnt/HD_a2/ffp/etc# sh /mnt/HD_a2/ffp/start/
rsyncd.sh status
rsync not running
root@DNS323:/mnt/HD_a2/ffp/etc# sh /mnt/HD_a2/ffp/start/
rsyncd.sh start
Starting /ffp/bin/rsync --daemon --config=/ffp/etc/
rsyncd.conf

you can also run

sh rsyncd.sh status

To see if the Rsync service has been started properly. I would also recommend making sure that Rsync starts up with the DNS323 on each reboot or power off

root@DNS323:/mnt/HD_a2/ffp/start# chmod a+x rsyncd.sh

Now we configure the Synology to backup to RSYNC services on the DNS323

*New Screenshots compatible with DSM 6.2.3 added Jan 21, 2021*

4. After logging into DSM, goto Hyperbackup, open the backup wizard to open a new job. Choose ‘Data backup task’

For the Backup Destination type, choose RSYNC

For the backup settings, configure the Server type as ‘rsync-compatible server’, enter in the pertinent details of your DNS323. It should look similar to the screenshot below. For port, just keep the default 873. The Backup module, make sure to use the exact same “Path” from the rsyncd.conf file.

ie. path = /mnt/HD_a2/Backup_directory

Backup module = /mnt/HD_a2

Directory = Backup_directory

After you hit, next DSM will test the connection for you. As long as you’ve configured the RSYNC on the DNS-323 and started the service, DSM should pick it up. After you choose your backup selections, make a schedule; set it and forget it.

Items to keep in mind
*Rsync is not hailed for speed!. On average RSYNC only travels at around 1.5-4MBps.

*Synology Hyperbackup cannot run simultaneous jobs. This means if you’re backing up a lot of data, it will take a while! Plan Accordingly, take offline backups to USB, whatever your use case scenario might be.

-Dexter

Synology DS413J review

DS413J-oh yeah (Small)

I was overjoyed to get a bigger NAS device.  Mainly because my Dlink 323 was running out of space, and I yearned for something with a little more usability and functionality.  I shopped around looking and compared the QNAP, Synology, Thecus, WD, and even some Drobo units.  Smallnetbuilder’s NAS charts were a huge help in getting what I wanted.  I’m not here to plug them, I just think they have a lot of useful content and reviews that were suited to what I was looking for.
Moving away from the very consumer based Dlink 323, which was tapped out at 12MBps, I found myself in want of something faster and up to date. Synology’s hardware was sound, with a proprietary hybrid RAID, and a kick ass WebUI that simply destroyed the competition.  I originally was hooked on getting the DS1512 +, the price being the breaking point factor in this scenario.  I eventually went with the DS413J with 4 x 2TB 7200RPM Seagate Drives.  Consider that I was able to purchase the DS413J and four hard drives, the cost of the DS1512+ without hard drives was still MORE expensive.

All the reviews put the Synology Disk Station Manager (DSM) as the multi-faceted powerhouse to which all other NAS devices should follow, and it’s easy to see why.  You can drive the unit entirely from a browser any where, has plentiful plugins and offers usability for beginner to expert levels.

First Impressions
The DS413J came in a very marketing-manager-friendly box, plenty of pretty pictures and an overall glossy feel at least made me feel like I had made a worthwhile investment.  I was a little shocked to discover there was no manual with this unit, Synology smartly eschewed a physical one for a PDF attached to disk.  A nice little touch.  The unit was immaculate, pristine and wrapped with care in a sheen of plastic wrap and free of dust and any other particulates.  Unboxing the NAS felt more like working with a professional scientific instrument instead of a toy, it’s well put together and presented that it just has that feel to it.  I wasn’t crazy with the white plastic encasing the unit, the brushed aluminum top and back likely does more for cooling, but if it was entirely black or entirely aluminum that would have been a nice touch.  As it is, the white will do – if you’re nit-picky about that sort of thing.

Synology DS413 Box (Small)
The Box the Disk Station arrived in. Plenty of pretty picture on all sides and top. There’s even links to partner companies listed in bullet format

Hardware
The power brick is a large, unflattering chunk of plastic – if only the power supply was embedded in the unit it would have saved me a little more space on my Rack.  There’s ample screws for hard drive installation, from 1.5mm to 2.5mm, flat and flushed heads: more than enough for 4 drives.  The drive trays are simple flat gray plastic with no rubberized anti-vibration absorption, but the engineers have  tightly integrated them into the NAS chassis, so there’s no movement anyway.  The front of the unit has seven LED indicator lights: Power, Status, LAN, and one LED for each hard drive inserted.  The colors are straightforward for anyone to understand as well: Green=Good, Red=Bad.  The middle power button is always blue, probably because it just looks cool.

DiskStation_DS413j_1 (Small)
Blinking LED indicators tell you at a quick glance what’s going on with power, LAN, and your Hard drives. No LCD display, but you can do everything from the DSM web GUI

Software
This is where the Synology really shines, after setting up and formatting hard drives (surprisingly quick), you are given a choice to either install the DSM from the Synology external update site or manually (you first download the package and point to it).  I did the latter and installed it from my laptop via a wireless connection.  Immediately after logging in, DSM tells you such items as uptime, resource monitoring, logs and current connections all as a pop up in the bottom right hand side.  The wizard can help you configure backup, router configuration for firewall and external port access and offers easy to read configuration items in the control panel from the start.

DSM Image 1
DSM treats your experience like another desktop, complete with icons, and Windows-esque useful health ‘gadgets’ such as health monitors, transfers, logs and whatever else you can decide from the drop down menus

Usability
Easily the most user friendly NAS device I’ve ever come across; the hardware is straightforward – plug in your drives, provide power and ethernet, and press the power button.  The Synology Disk Station Manager (DSM) AJAX web server is incredibly powerful and lightning quick, even from external access where my uploads are slower.  Mounting files from within the DSM was a snap, just open their File Station (equivalent of Explorer, or if you prefer, Finder) and mount the remote folder share you have on your network.  Creating users and groups is intuitive and fast, the linux style of read/access based on shares makes things much easier to figure out. The Packages are well put together and definitely have great business potential; such as the multiple CRM’s, Wiki abilities, Mailstation and VPN server.  Even the backups are dead simple; I configured my old linux based NAS into an Rsync location for the DS413J.  The dual USB ports even allow for plugging in of external hard disks for USB copy / backup jobs, and everything can be scheduled.  The system log is also very useful for tracking down changes and logins, as well as the health monitor that tells you every task-manager-esque what’s going on, who’s doing what and what processes are using CPU and memory.

Quick pic of currently installed packages on the DSM GUI.  You can add even more 3rd party applications that are handy like 'currently connected'
Quick pic of currently installed packages on the DSM GUI. You can add even more 3rd party applications that are handy like ‘currently connected’

Features
I only have great things to say about the DSM, it’s like logging into a new computer each time you add a new package.  The new features add a new dimension each time, allowing for further tweaks and functionality that wasn’t before present.  Some such as Media Server didn’t appeal to me, but others such as 3rd party add-ons like Switch Service and Current Connection make the experience much more informative.  With such features like Radius Server, I could now change my wireless encryption to an enterprise level format capable of local and ldap authentication protocols.  I’m sure the next time I’m a party, I’ll have to drop that nugget of information.  Other features such as media station helps create an internal website complete with thumbnails and auto-playing movies and streaming audio (even over the internet).  There’s so much power at the DSM’s disposal, that it would take a whole article for each add-on feature.

The DSM package center has endless possibilities with different configurations and applications with categories such as business, productivity, web and mail serving and more
The DSM package center has endless possibilities with different configurations and applications with items for business, productivity, web and mail serving and more

Performance
I struggled with the price and (theoretical) performance of the much meatier Synology 1512+.  When weighing price vs. performance, the 413J came out ahead and I save a few hundred dollars a result.  Synology Claims a maximum 53MBps Upload (write) and 108MBPs Download (read) on their website when working with a 5GB file and 1500MTU max over a 1Gbps LAN environment.  My own benchmarks were not far from the result, although I did tweak my settings with 9000MTU on the Synology and Intel NIC with Win7 64x Ultimate edition with a 5GB file and the speed was little over 50MBps for a write, and around 55MBps for a read.

 

Verdict
I am definitely sold on the Synology name brand.  The DSM software gives a user complete control of data, backups, security, and a whole plethora of other features with the additional Synology packages available for download.  With features like SSH ability at the flip of a switch, remote management that’s both easy, intuitive and icon based, I only have great things to say about the Synology DSM unit.  The price is right for this unit, larger Synology units can accommodate more hard drives, have greater integration with virtualization platforms and even greater transfer speeds.  For the home user with storage needs, it’s a near perfect offering.

 

Closing Thoughts
I wrote a ‘love letter to Drobo’ some time ago.  I revisited the Drobo box with hope that I my opinions would have changed.  Not surprisingly, I’m still disappointed with drobo’s performance and lack of options.  I stand by my original post,   the product feels unfinished and flaky, and under performs in simple tasks like file transfers.  Presented with both choices for a NAS device, I would pick the Synology 10 times out of 10.

Windows 7 Wireless and Wired connections priority

I always thought that Windows 7 would automatically switch to the next fastest connection. I’d been trying to figure out why it seems to stick with a wireless connection even after connecting a network connection. Turns out, Windows 7 eschews speed for reliability.

I especially found this annoying when, after booting and automatically being connected to the wireless I plugged into CAT5 and tried transferring a file from my NAS only to see my wireless connection hitting the ceiling at 3.5MBps second. Luckily, I’ve found a solution that’s been covered in other places, but I like to put my own spin on things:

1. Goto Control Panel -> Network and Sharing Center, click on Change adapter settings

Image 000

2. From the adapter menu hit ‘alt’ to bring up the Windows File editing menu, and you’ll see the super-hidden ‘Advanced’ column that’s been evading you all these years.  Then to Advanced Settings…

Image 009

 

3.  This brings you to a listing of connections by priority.  Notice that Wireless is along the top, or first in priority.  Simply move the Local Area Connection to the top or just above the wireless connection.  Hit OK.

Image 003Image 002

4. All done!  Now the next time you boot up with wireless, and plug in a wired connection Windows 7 will automatically switch to the ‘fastest’ connection!



Exchange 2010 SP2 Automapping issue

There’s a slight bug with the Exchange 2010 server, in that it automatically remaps any shared mailboxes you’ve used when the client is either Outlook 2007 or 2010.

If you’re mapped a mailbox in the past, an automapping feature kicks in and puts the mailbox back on your profile, even if you’re starting out with a brand new profile. To disable this, you have to log into your exchange server and issue some commands from the Exchange Powershell:

Add-MailboxPermission "domain\user" -User "domain\user2" -AccessRights FullAccess -AutoMapping:$false

domain\user = user mailbox you no longer want to view
domain\user2 = the primary user, usually the one you’re setting up

This has been tested on Exchange 2010 SP2 and SP1 successfully

Exchange 2010 – get list of disconnected mailboxes immediately

Once a mailbox is disabled from the Exchange 2010 console, it shows up in the disconnected mailboxes after the nightly maintenance.  Sometimes however, a company can change it’s mind at the last minute and decide to either hire someone back and that’s when the IT admin has to bring that disconnected mailbox back within the hour.

Instead of waiting around for the nightly maintenance to occur, you can force your Exchange 2010 server to pick up the mailboxes almost immediately.

1. First and foremost, re-enable the user’s Active Directory account, as it has all the proper SSID’s and is actually the name you want to restore.

2. Check the disconnected mail, if you just disabled it you likely will not see it
3. if you don’t see it there, you’ll have to manually do the mailbox cleanup (commonly known as maintenance.  Open up a Exchange power shell and issue the cmdlet:
Get-MailboxDatabase | Clean-MailboxDatabase

Be careful with this command, as it cleans all your mailstores.  If you have only one mailstore you want to run this command on, you have to use:
Clean-MailboxDatabas “Your Database Name”

4. Once you’ve done that, refresh your disconnected mailboxes and you should see the mailbox you want to reconnect:
 

5. From here, right click and reconnect the mailbox you want!
-Dexter

How to: get multiple Remote Desktop Connections

When you have to remote desktop to a Windows based server or computer, your default option is RDC protocol.  This is a useful utility if you’re connecting to one computer at a time.  So what if you need to connect to ten or more?  Do keep in mind, not all those computers have the same credentials, and saving all those .RDP files to your desktop will get very cumbersome.

There’s a handy tool from Microsoft: Remote Desktop Connection Manager that allows you to do just that.
As you can see from the screencap directly from MS techblog, the application lets you open multiple RDC connections at a time giving you full control over: inherited credentials, gateway settings for VPN connections, individual display settings, individualized local resources… the list goes on.  Super handy utility when I was building a new virtual environment with Hyper-V; after creation of the VM, I put in the server name with full credentials and saved it under the proper group.

I’ve used other tools similar to this such as the RSAT tool that felt unfinished, as well as RoyalTSVisionAPP, and Terminals.  All these programs worked well for what I used them for, but each had their own little quirks and last minute features such as screen-shot ability.  The part I like the most about RDC Manager from Microsoft is the price: completely free.  Plus, it just feels like it goes with the rest of the Windows experience, from the toolbars to the menus it definately feels like a MS product.

So if you need to remote to a hell of a lot of computers and like a freebie that’s right from Microsoft, give it a shot.
-Dexter

Excel 2007: “Too many different cell formats” error message


If you have an Excel heavy group of users, you will likely come across this issue.  This happens when someone merges an existing excel file with another one, creating a super excel file that has links and formatting all over the place.  When an excel workbook has too many different combinations of formatting, it freaks out and you get the error message above when you try to change formatting of a cell.

Fear not, there is a fix:

Download the .Net4.0 XLStylesTool

This file cleans up the offending excel file by cleaning up whatever nasty bits of information are corrupting the data.  I’ve tested this tool, and it looks like it only cleans up formatting, leaving all data and formulas alone.  After running the tool, the file became editable again!

-Dexter

applies to: Excel 2007 files (all files ending with .xlsx) format