Father of the Year

Since yesterday, all the Internet media has been posting the video below regarding a Taiwanese father dumped his daughter when trying to catch the foul ball, and got the death of look from his wife. The author of this site even would nominate him as the 'father of the year'. Funny.

This clip did not actually show father dropped his girl, but very funny the reactions are from the anchors..)
http://youtu.be/_zZHJ4m2wKM

This video dose show the whole 'accident".
http://youtu.be/zZdywEQF7JE

It also made the headline on Houston Chron.com which I have to read everyday.

Use PFDAVAdmin to Grant Permission to All

Out default policy is everyone can view everyone's calendar in Outlook. We're still on Exchange 2003 so the best way to configure that is to use PFDAVAdmin program.

Please follow this great article.

SPF & Reserve DNS Record Setup

Changed the public IP for Exchange server last night and some users have got the Undeliverable message to some recepients like the example below,

Subject: Undeliverable: Financial Statements

 Your message did not reach some or all of the intended recipients.

Subject: Financial Statements
Sent: 9/20/2011 10:07 AM

The following recipient(s) cannot be reached:

John Doe on 9/20/2011 10:07 AM
You do not have permission to send to this recipient. For
assistance, contact your system administrator.
<mail.mydomain.com #5.7.1 smtp;550 5.7.1 This system is
configured to reject mail from 66.1.1.1 [66.1.1.1] (DNS
reverse lookup failed)>

I went to  http://www.openspf.org/Tools do some tests by sending an email to spf-test@openspf.org and here is what I got in reply:

Your message did not reach some or all of the intended recipients.

       Subject:   

      Sent: 9/20/2011 10:45 AM

 The following recipient(s) cannot be reached:

       spf-test@openspf.org on 9/20/2011 10:45 AM

            You do not have permission to send to this recipient.  For assistance, contact your system administrator.

            <mail.mydomain.com #5.7.1 smtp;550 5.7.1 <spf-test@openspf.org>: Recipient address rejected: SPF Tests: Mail-From Result="none": Mail From="cc@mydomain.com" HELO name="mail.mydomain.com" HELO Result="none" Remote IP="66.1.1.1">

So I had to put the Reverse DNS back. It's been a long time since I needed to do that, and I was also confused it with SPF record which needs to be done in DNS zone hosted by provider. Here is what I actually need to do:

1. Call ISP to set up the reverse DNS record for my Exchange server. (That easy!)
2. Set up SPF records for my domain and exchange server. (See below)

Check this page for more details.

Sent a test message again to spf-test@openspf.org, then I got:

Recipient address rejected: SPF Tests: Mail-From Result="pass": Mail From="cc@mydomain.com" HELO name="mail.mydomain.com" HELO Result="pass" Remote IP="66.1.1.1">

also, sent a test message to check-auth@verifier.port25.com, the result is:

SPF check:          pass
DomainKeys check:   neutral
DKIM check:         neutral
Sender-ID check:    pass
SpamAssassin check: ham

YAHOO!!

 

Rain Rain Come Back Again

As usual, the forecast has never been accurate, we did get some rains this weekend. Yahoo! we need more!

Shrink WSS3.0 Log.ldf size

WSS 3.0 server was running low on C drive. Only 2MB was available. I then ran the FolderInfo - my favorite disk space tool - so easy to use to find out "SharePoint_Config_xxx_log.LDF" has grown over 30GB.



 

Then I followed this article on web to shrink the file and it went down to 500KB only.



 

My Upgrade: from WSS3.0 to SharePoint 2010 Foundation

This is my upgrade experience by using "Attach databases and upgrade to SharePoint 2010". It's quite straight forward but since it was my first time upgrading a farm and I had created two new OS so it took me two days to figure out.

Source:
Single WSS3.0 server on a Windows 2003 server, 32bit standard with embedded SQL.

Target:
WFE: SharePoint 2010 Foundation farm on Windows 2008 standard server, 64 bit.
Database: SQL 2008 SP2 (64 bit) on Windows 2008 standard server, 64 bit.

Steps I took:

1. Follow this article, Attach databases and upgrade to SharePoint Server 2010

 

Ran STSADM.EXE -o preupgradecheck first on source WSS server.

Ran into the first problem while installing SP2010. The error is "Cannot connect to database master at SQL server at <SQL_server_name>. The database might not exist, or the current user does not have permission to connect to it.



Then I made sure the followings..

1. Both SharePoint and SQL ware assigned the static IP address, and SP server can PING SQL and DC without problem


2. Enable 'dbcreator' and 'securityadmin' Server Roles for the SP admin in Security/Logins in SQL Server Management Studio.


3. Enable TCP/IP in "Protocols for MSSQLSERVER"

2. I got the new SharePoint set up without problem and I could browse to the default home page at port 80, but what I needed was the restored content database instead of a blank new site. So I went to "Manage Content Databases" in the Central Administration and deleted the default WSS_Content database, and deleted the WSS_Content SQL database from SQL management studio.

3. Run Mount contentt database command again below.

Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL>

It went ok with the message below. Then I was able to see the "WSS_Restored" was created in my content database page.


4. Try to browse to the SharePoint website and all my old WSS3.0 root site shown ok, but not the subsites.

 

 

Websense Express Seat Count

1. From the Websense\BIN directory command prompt, type: consoleclient localhost 15869 Enter 2 for PrintSelf.


2. Enter 1 for Dump to Local File.


3. Enter 3 for the Data Dump Level.


4. Enter a text file name (example: Seatcount.txt).


5. Select entry for SubscriptionTracker.


6. Enter Q to quit.


7. At the DOS prompt, type the text file name (Seatcount.txt) and it will open up in Notepad.