Comcast backbone issues

Something is broken with Comcast Business Internet.

Speed test (urg) to Comcast in Seattle gives 50/10 – as expected:

image

Speed test to Comcast in San Jose gives 50/10 as expected:

image

Speed test to Comcast in Salt Lake gives 2/10 – which is horribly broken.

image

Same Ookla test outside Comcast – and I get 2/10 in Seattle.

image

Comcast Chicago compared with Comcast Seattle.

image

Excel 2013 and Power View – sometimes doesn’t start

I had a group of machines for a pilot project just stop launching Power View.

Very frustrating – and then my machine stopped working.

I finally tracked down the problem – and hopefully this helps others.

Using the Registry Editor – RegEdit – browse to

Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\User Settings

You should see a registry key PowerViewExcelAddin

clip_image003

Delete the key.

Now open Excel – create a new blank workbook.

On the Insert tab you should see PowerView

clip_image006

Click on PowerView – Excel will say you need to enable Power View – click on Enable.

clip_image007

The Power View and all of the BI should work now.

Change control–test before tinkering

Bobbins. I made a change to the web server config in Azure today – and it took the web server VMs offline.

Still troubleshooting on the why – but I had to rebuild the base server and re-attach the web content and database drive.

Lesson learned – test, test and document the changes..

Postfix, Office 365, SMTP AUTH and STARTTLS

A fun day.

First up there is a feature gap on Azure – where there is no reverse DNS – i.e. PTR records – for virtual machines.

The main problem I am having since moving things to Azure is that mail delivery from Postfix is getting some hosts rejected – because the receiving MTA receives no host on reverse DNS lookup of the sending MTA. Imagine I sent mail to [email protected] – and my MTA is running with a public IP address of {x.x.x.x}. The receiving MTA does a reverse lookup for {x.x.x.x} and finds no record. The mail is bounced.

My solution is to send mail via Office 365 – reconfiguring Postfix to relay via Office 365 using SMTP. The added challenge – Office 365 uses TLS for security and requires STARTTLS.

As I mentioned – a fun day grinding through docs and understanding what was needed to get this to work.

The short version:

This is the additional config for Postfix – here I am using SLES 11 SP2 – this is in /etc/postfix/main.cf

# Use Office 365 as relay

relayhost = [smtp.office365.com]:587

# Use credentials for auth to Office 365
smtp_sasl_auth_enable = yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_security_options = noanonymous
smtp_sasl_tls_security_options = noanonymous

smtp_send_dummy_mail_auth = yes
smtp_always_send_ehlo = yes
smtp_tls_security_level = encrypt
smtp_use_tls = yes

smtp_tls_CAfile = /etc/ssl/certs/cacert.pem

# misc
tls_random_source = dev:/dev/urandom

#logging
#smtpd_tls_loglevel = 2
#smtp_tls_loglevel = 2

#enhanced logging for Office 365
#debug_peer_list = smtp.office365.com
#debug_peer_level = 4

The plaintext username/password pair were placed in /etc/postfix/sasl_passwd

[smtp.office365.com]:587        Office 365 authentication:complex password

I also modified /etc/postfix/sender_canonical to remap the default from name to the same name used for Office 365 authentication

[email protected]  Office 365 authentication name

Finally I found an interesting set of bugs/features in WordPress – where the assumption is that the default PHP mailer is being used and that the wrong from email is being injected into the PHP mailer function. Messy. Opened for two years now.

This was resolved by using the WP Mail Options plugin to overwrite the mail from field.

End result – all working.

Hardware load-in

Early start this morning – head into Seattle to meet a truck and driver delivering a Perceptive Pixel 55” interactive touch screen for an event this evening.

The screen and PC are not too big – but they are fragile and expensive – so the shipping case is enormous! Over 1200 pounds (500kg) of wood, steel, wheels and hardware.WP_20140128_08_42_42_Pro

Delivery was an adventure; two hotels with similar sounding names within 100 yards of each other; narrow alleys; rubbish collection; cyclists and bad drivers.

WP_20140128_08_24_30_Pro

Eventually the box was unloaded and we went for an unescorted trip through the back offices of a large hotel. Guaranteed to get security interested and come find you :D

Novell layoffs

Sad to see Novell do another, seemingly fatal, round of layoffs.

The few good people left seem to be gone; those that are left pretty much bare bones product maintenance. Looks like the entire legacy Attachmate product line and the legacy Novell product lines have been merged under a single management structure.

From what I hear it’s “do less, with less” – which is a sad whimper to end with.

Best wishes to those that got let go; it’s a different world outside. Almost six years since I walked away.

To the cloud!

The never ending saga of running infrastructure has gone full circle. All of my self-hosted blogs and websites have moved from a Hyper-V server in my garage and up to Microsoft Windows Azure.

I spent a decade (2001-2011) self-hosting. Running both email and website on platforms as diverse as NetWare through RedHat, SUSE and finally Windows Server. In early 2011 I decided to get out of the hosting game and move the blogs to GoDaddy and the mail to Exchange Online (then BPOS, now Office 365).

GoDaddy really frustrated me. Poor performance, poor logging, strange “go slows” and unexpected disconnects of SSH. Understandably “I got what I paid for” – but frustrating none the less.

It has taken eighteen months – but slowly the various blogs and websites have been culled and archived, moved back to self-host and now up to Azure.

Windows Azure has really improved over the past two years – I started by evaluating the Platform as a Service capabilities back in November 2011. Functional – but missing some capabilities that I needed to run the photo blogs (all written for the LAMP stack).

More recently as the Infrastructure as a Service capabilities have moved from preview to production I tested this blog running on Azure. Performance and uptime have been great. The blog is running a SLES 11 SP3 platform on Azure – and it’s as functional as running on bare metal or any hypervisor.

I finally took the time to move the family blogs and business website to the platform over the last week or so. The migration of WordPress blogs and Gallery photo sites is pretty simple now.

.. another office move

Over the course of 5½ years I have had four different and evolving roles – and numerous offices. Today I moved back down to the ground floor of Building 121 on the Redmond campus; my fourth office in this build – and the tenth office overall.