Blog of an overweight SharePoint addict

Thu 31 Jul 08

Today’s the day!

Filed under: General, SharePoint — Reginald @ 8:30 am

Quite sad really, I walked through the doors as an employee for the last time this morning.. No real sense of occaision about it. But seeing my desk as tidy as it is right now makes it sink in that today really is my last day here.. Everything that’s left is now sitting in a cardboard box on the floor next to me. My mobile, Remote access tokens and similar chattels are in the drawer ready to hand in to security and I now have a mountain of handovers to write. Hopefully it’ll be a relaxed morning before going to the pub at lunch time and never returning!!

Last night however was a different matter, we moved the Central Administration website from the current physical box it’s sitting on to the Virtual environment that the system moved to a week ago.

Now moving the central admin website is not a complicated affair, although having SSL does add a certain level of complexity. But here’s the order to do things in..

  • Run the SharePoint configuration wizard on the current central admin box, choosing “Do not disconnect from this server farm.” then click, No, this server will not house the Central admin facility.”. This removes the central admin from the server.
  • Now log onto the new admin server and repeat the above, this time the wizard will detect that there isn’t an admin website and will go straight into the site creation pages. Because you’re connecting into an existing farm, all of the database options will be configured, you just need to choose the port to run your admin pages on. To be honest as we’re going to use SSL, this doesn’t matter and can be any random high port.
  • Once the website has been provisioned, bring up the IIS manager console (Applying SSL is one of the few tasks you have to do on each web server through IIS admin!), Select the properties of the newly provisioned SharePoint Central Admin website and select Directory Security, then at the bottom click Server Certificates and apply your previously requested SSL certificate (I’m not going to tell you how to do this as there are TONS of blogs on the net with this info..)
  • Once the certificate is applied and you’re back on the previous screen, click the Edit button under Server certificates and choose the tick box against require secure channel.
  • Almost there now.. Bring up a command line that has access to STSADM and enter the following command:- STSADM -o setadminport -ssl -port 443
  • Finally.. IISRESET /noforce
  • And your work here is done.. When you connect to the named website, you should redirect onto SSL and be presented with your login request or your admin website.

    Cheers

    Reg.

    Wed 30 Jul 08

    24 Hours to go..

    Filed under: General, Programming, SharePoint, Workflow — Reginald @ 8:09 am

    Well I’m struggling to get everything finished that I wanted to before I leave, but here just aren’t enough hours in the day for everything. I was here until 11pm last night releasing the latest version of the Implementation workflow. Unfortunatly because we were releasing new forms, it meant stopping and restarting all 86 exising workflows, and then setting the task dates back to what the users had set. I’m not sure why these upgrades can’t be done in place, I’m guessing I need to completely rename the feature and install it alongside the old one for that to work properly… Time to do some testing around that I think..

    On the subject of workflows though, I did hit a problem when we were trying to restart the workflows. When you clicked on the item drop down (EditControlBlock) and selected workflows, instead of getting the relevant workflows.aspx page, we got an error page suggesting that the item was invalid, yet when you checked the Item ID and List ID, they were correct.

    The only solution was to save the item locally, delete the original and then re-upload the copy. This allowed you to then access the workflow.aspx page as the item had a new ID. I’d like to have spent more time troubleshooting that, but that wasn’t going to happen last night!

    Anyways, onto the next 24 hours, I’m due to finish here at Lunchtime tommorrow, in between then and now, I need to get several documents wirtten regarding the system and it’s architecture, a user management document and hopefully an application page that allows management of orphaned workflows. (Caused by users deleting items without ending the workflows first.. An event handler would be better, but I just don’t have time..!)

    Well now it’s time to get back to the above, and also emptying my desk and general tidying things away. I’m going to miss this place, as it’s been a good part of my life for the last 10 years. I’ve made some good friends, some I’ll keep in touch with, some will fall by the wayside. What I can say is that there’s a lot of people that i’ll miss seeing every day.. and perhaps one or two that I won’t!

    Reginald.

    Tue 22 Jul 08

    Two glasses of wine & a jar of Mayonnaise..

    Filed under: General, Laughter — Reginald @ 10:27 am

    I receive an awful lot of viral emails on a daily basis, mostly from friends and colleagues seeking to brighten my day. Invariably, I have a read, a little chuckle, then delete without sending them on.. But given the amount of hours that I’m doing recently, and the penchant in the IT industry for long hours and hard work, i thought this little story worth sharing through the blog..

    Enjoy, and consider the meaning.. Reg.

    When things in your life seem almost too much to handle, when 24 hours in a day are not enough, remember the mayonnaise jar and the 2 glasses of wine theory…….

    A professor stood before his philosophy class with some items on his desk in front of him. When the class began, wordlessly, he picked up a very large and empty mayonnaise jar and proceeded to fill it with golf balls.

    He then asked the students if the jar was full. They agreed that it was.

    The professor then picked up a box of pebbles and poured them into the jar. He shook the jar lightly. The pebbles rolled into the open areas between the golf balls. He then asked the students again if the jar was full. They agreed it was.

    The professor next picked up a box of sand and poured it into the jar. Of course, the sand filled up everything else. He asked once more if the jar was full. The students responded with a unanimous ‘YES.’

    The professor then produced two glasses of wine from under the table and poured the entire contents into the jar, effectively filling the empty space between the sand. The students laughed.

    ‘Now,’ said the professor, as the laughter subsided, ‘I want you to recognize that this jar represents your life. The golf balls are the important things; your family, your children, your health, your friends, and your favorite passions; things that if everything else was lost and only they remained, your life would still be full.

    The pebbles are the other things that matter like your job, your house, and your car. The sand is everything else; the small stuff.

    If you put the sand into the jar first’, he continued, ‘there is no room for the pebbles or the golf balls. The same goes for life. If you spend all your time and energy on the small stuff, you will never have room for the good things that are important to you.

    Pay attention to the things that are critical to your happiness. Play with your children. Take time to get medical checkups. Take your partner out to dinner. Play another 18 holes. Do one more run down the ski slope. There will always be time to clean the house and fix the disposal. Take care of the golf balls first; the things that really matter. Set your priorities . The rest is just sand.’

    One of the students raised her hand and inquired what the wine represented.

    The professor smiled. ‘I’m glad you asked. It just goes to show you that no matter how busy or full your life may seem, there’s always room for a couple of glasses of wine with a friend.’

    Mon 7 Jul 08

    Upgrading Features.

    Filed under: General, Programming, SharePoint, Visual Studio 2005 — Reginald @ 5:26 pm

    I’ve been quite naughty recently and I’ve been taking the easy way out when it comes to putting code upgrades in. It’s very easy to drag the DLL from the dev environment and just drop it into either the Gac or the local Bin, without any thought to what happens if someone comes along and re-uses the .WSP file in future!!

    So today I actually spent some time figuring out the stsadm -o UpgradeSolution command and testing it on my live environment to perform some upgrades to live code. The result, it worked quite nicely thank you and I’ve documented this into our ongoing procedures.

    So, How does it work, Well in reality, it’s no different from deploying a solution for the first time. You copy your WSP file into the holding area, in my case it’s D:\InboundProjects.

    Then enter the following command (tailored to fit your deployment options of course..)

    stsadm -o UpgradeSolution -name MYSOLUTION.WSP -filename D:\inboundprojects\MYSOLUTION.WSP -immediate -allowcaspolicies

    Follow this with a quick stsadm -o execadmsvcjobs to force the time job to run and bingo, the code is live. And just for my own happiness, I had an explorer window open to the local webserver wpcatalog directory just to be certain it updated the deployedf files correctly, which it did.

    Reginald.

    Powered by WordPress