Getting Jan’s RSS Reader webpart to work

I got an email from Jan asking me to comment on his Essentials webparts on his weblog. I really like them because they show what I have been working on. I set up a quick and dirty homepage to use them as a simple status report. I used a default template and just dropped the Navigation webpart, the Whats New webpart, and the RSSReader webpart on to the left side. Simple but satisfying!

Since I had recently reinstalled Sharepoint to fix an unrelated problem, I had to reinstall the webparts. So I made sure I had the latest versions and started off with the RSSReader. It looked easy. It had an installer! The bad news is that it finishs with an error.

========= WPPackager install log started 3/26/2004 11:18:39 AM =========
3/26/2004 11:18:58 AM: Error: Config file: ‘d:inetpubwwwrootweb.config’ for virtual server ‘http://companyweb/’ is missing or appears invalid. Could not apply required CAS settings to this server.
3/26/2004 11:18:58 AM: Error: Could not apply required CAS settings to virtual server ‘http://companyweb/’ during installation of ‘Lead-it SharePoint RSSReader Webpart’
3/26/2004 11:18:59 AM: Success: Installation Successfully Completed

The good news is that the error does not matter!? The dll is in the GAC. The web.config is configured. The webpart is in the wpcatalog. Once you figure out how to configure your firewall you are set. That was actually quite hard. I decided to put my findings in a second post on my weblog since it is specific to ISA.

The installation of Essentials was quite easy if you knew the locations of your wpcatalog, web.config, and GAC. I found that I only needed to restart the sharepoint server to start using them.

More Spam Protection

Yesterday I renewed my mail account on Yahoo and upgraded to Mail Plus. This adds more disk space, a spam learning feature, and virus protection. Today I installed the latest version of Mailwasher Pro and turned on its spam learning feature. Both these products show a remarkable amount of agreement on which mail is spam. I am hoping these two products will help me get rid of spam and avoid false positive mishaps. I think the use of Yahoo and other web mail providers is a viable strategy for small businesses. Although my setup is probably overkill it is not costly or time consuming. Email that makes it to my PC probably goes through three or four spam detectors and at least two virus checkers. I averaged 156 deleted emails per day with MailWasher. The bulk of these obviously were spam. It is interesting to note that the latest average for the week is only 126. Maybe this is a trend.

Re-Installing Sharepoint on SBS

Today I finally got Sharepoint installed and working. Here was the plan.

  1. Stop the Sharepoint database with NET STOP mssql$sharepoint.
  2. From the Add or Remove Programs, remove Sharepoint.
  3. From the Add or Remove Programs, remove the MSDE instance of sharepoint.
  4. Reboot.
  5. Install a new instance of SQL Server called SHAREPOINT using the Premium cdrom. When it asks, change the default disk location. Ignore warning message about SQL and Windows 2003.
  6. Apply SQL Service Pack 3a to the new instance.
  7. Start the database.
  8. Run STSV2 and pick the server farm option. It tells you that you will have to manually extend the site after the installation completes. I got an error at the end complaining about FrontPage extensions on the default server.
  9. Go into Sharepoint Central Administration and extend the companyweb site. I used the DefaultAppPool with Network Service.
  10. Pick a site template.

I verified my installation by saving a document into Sharepoint and then bringing it back up. It knew who I was and did not ask me for a logon.

Re-installing Sharepoint

I finally gave up on trying to tweak Sharepoint to work and starting the process of re-installing. Guess what! The reinstall fails. It doesn’t create the two databases. Maybe I am missing something? So I have downloaded STSV2. I think I will try to stuff it directly into a new SQL Server instance rather than go through MSDE first. I want to put the sharepoint databases on a seperate partition.

Along the way I downloaded the web version of SQL Enterprise manager. To get it to not ask me for my userid I had to give NETWORK SERVICE full access to the Microsoft.NetFrameworkv1.1.4322 directory. I was trying to view my MSDE instances. It didn’t help. My problem was that I was’entering the server name incorrectly.

Leadit.Sharepoint.Essentials

I modified my Sharepoint intranet site to use a couple of webparts from Leadit.SharePoint.Essentials. Jan Tielens did a nice job on everything except the instructions on how to install it. I think the Whatsnew and Navigation webparts on my main page are really handy. My intranet site is getting a little more useful than the ordinary file system it replaces.