Images for the post below "Install SP 2010 without an internet connection"

Sorry for the blurryness!

SUCCESS!!!!

Install SharePoint 2010 without an Internet Connection

Sometimes your servers do not have a live connection to the internet. In this case the SP 2010 default installer runs a PrerequisiteInstaller.exe file first to download from the internet all the SP 2010 prereqs for you. Very handy. Unless you have no internet connection from that server. UGH. No fear, you must first download all the prerequisites you need. There are dozens of blog posts and articles out there on how to do this. But the best way to find out what you really need is to go into a command prompt and navigate to the setup directory of the SP 2010 install DVD, and type PrerequisiteInstaller.exe /? It will pop up a dialog showing exactly all the switches and prerequisites this particular version of the SP 2010 bits is looking for. Then go to the other guys blog posts and get to the msft sites they reference, and download the correct version (x64 or whatnot) of each one into a simple folder called something like c:\sp\run\ or whatnot. Then install them one by one or multiple from the command line as Administrator like so: PrerequisiteInstaller.exe /SQLnCli:c:\sp\run\Sqlncli.msi /PowerShell:c:\sp\run\WindowsPowerShell-60-KB968930-x64.msu you can put as many on there as you want but I find running them one or two to three at a time is best. Once done installing all the prereqs, then you can finally run the setup.exe for SP 2010 and move on with your life. Then later gripe at the windows admin who setup your vms or servers with no LIVE internet connection or STRICT browsing policies. WHAT A BOZO! Enjoy!

Move a Site Collection from one content DB to another

Here is how to move a site collection from one content database to another in SharePoint 2010 Powershell command prompt: http://technet.microsoft.com/en-us/library/cc825328.aspx To move all site collections in a content database to another content database, there is a command in the above link as well. NOTE: The SQL Server database properties must have enough space in the transaction logs. Setting Auto Shrink and Auto Close to True, and changing the growth of the transaction log file to auto grow and 10% increments or something, as well as changing the Transaction Recovery Model from Full to Simple, for the DESTINATION database, is probably a good idea or you will get an error that the transaction log is full or does not have enough room.

Move Content Databases in SharePoint 2010

So recently I was working with a large insurance company who had multiple SP 2010 and SP 2007 farms. Each farm had a production, a test, and a dev environment as well. The business owners frequently want to do periodic refreshes of specific site collections from PROD to SYS (test). The issue is they have no granular backup/restore SharePoint backup agents. We are addressing that by looking to purchase Symantec Backup Exec or CommVault or Tivoli Storage Manager or other SP specific backup agents that allow granular backup and restore down to the list or item level. But I digress. Another solution in the interim is to move an entire content db from PROD to SYS. A content db can contain up to 9,000 site collections by default (well 15,000 max but you get a warning at 9k). Well, they had designed one particular app the Newstand to run in its own content db for the very reason that it would grow large in size. However, they failed to communicate that to their team so then another site collection was requested to be put into the db. There were supposed to be custom code changes that did not allow more than one site collection to be created, but those code changes did not work. Therefore, now we have a problem. 2 site collections in one content db, and no SharePoint specific backup tools to move them. I tried the granular backup and restore using powershell and that did not work (well it presented me with 10 errors or so ad I overcome all of them, until the very end when msft tells me - it simply cannot be restored. No other info, lovely!). So what to do, I told the business I am going to just move the entire content db from PROD to SYS and they will have to recreate the other SYS site collections (/sites/marketing/*). So here is how Microsoft says to move content databases in SharePoint 2010: http://technet.microsoft.com/en-us/library/cc287899.aspx Enjoy!

Check out this great MSN video: BCS Blog: Overview Demo

Want to learn how to hook SharePoint 2010 up to external data sources:

Check out this great MSN video: BCS Blog: Overview Demo

Meta refresh

Here is an example of Meta refresh



http-equiv="refresh" content="0;URL=https://mail.lyonscg.com/owa/">

Test post from windows live writer

Trying a new post from the recently downloaded Windows Live 2011 LiveWriter

Have a nice day!

5 social networking bookmarking sites which may help webmasters generate traffic

http://www.madville.com/out/tech/316835_five_social_bookmarking_sites_which_may_help_webmasters_to_generate_traffic_webupon

How to set up email forwarders in Exchange Server 2007

Login to the Exchange server
Open the Exchange Management Console
First create a mail contact then set up the forwarder.

Detailed instructions :
To create a MailContact using the Exchange Management Console:

1. Expand Recipient Configuration | Mail Contact
2. In the Action pane, click New Mail Contact
3. To create a new Contact object, leave the default (New Contact) selected | click Next
4. Type First name, Last name
5. Click Edit to add the external email address
6. Click New to complete creation of new MailContact

To forward mail for a recipient to the MailContact using the Exchange Management Console:

1. Expand Recipient Configuration | Mailbox | select mailbox | properties | Mail Flow Settings tab | Delivery Options
2. Under Forwarding address, select the Forward to checkbox
3. Click Browse to select the MailContact

Figure 1: Modifying Delivery Options to forward email to an alternate recipient

4. Optional: If a copy of the message needs to be delivered to both the external recipient and the original recipient's mailbox, select theDeliver message to both forwarding address and mailbox
5. Click OK to close Delivery Options properties
6. Click OK to close recipient's properties

MOSS 2007 server not sending email for domain

So one of our Sharepoint 2007 Servers was not sending out email to anyone anymore after a datacenter move. The reason was dns issues related to the move.

Here is how it was solved:
MB - per yesterdays research and changes: A request was sent to NetSource to create a reverse DNS for the IP 68.70.161.12 to point to portal.harmonicconsulting.com. HarmonicConsulting.com MX records we edited to add portal.harmonicconsulting.com as a e-mail server with a low priority. The SMTP server was reconfigured to relay mail for the harmonicconsulting.com domain to google and Sharepoint was configured to use the local SMTP server to send mail. Rlaying to harmoinic from the SMTP server worked - I can't seem to add myself to the notification list here so I will wait to hear badck from the real bacuff to verify this is working now. - Mark

Forgot root password

Forget your root password?
On Red Hat/Centos most any linux box:

1. Get physical access to the box
2. reboot it
3. during the grub menu, type e
4. go down to the line that has 'quiet' in it, usually that's the one I use but it doesnt'really matter. what you are basically going to do is type single at the end of whatever line you want to boot.

*this will also walk you though it
http://www.cyberciti.biz/faq/grub-boot-into-single-user-mode/


5. this will dump you to single user mode, and you can just do passwd to set new root password

Roaming Profiles Windows Server 2003

Trying to set up roaming profiles on Windows Server 2003 domain?

Try this:

To setup roaming profiles, first log onto your server and open Active Directory users and Computers. Right click on a user; choose properties and the click the profiles tab. In the profile box type the UNC path of the shared folder you made on the server. For example you would type:

\\servername\profiles\%username%

Where servername is the name of your server and the profiles folder is on the root of the C or D or whatever data drive the server is using. Do not type in the users name at the end but make sure it says %username% like in the example.

Make sure you have created this profiles folder and shared it with the same name as the folder. You can leave the share permissions wide open if you want because the %username% will create the users profile with permissions that grant only the user the right to view the contents.

The next time the user logs in, the users local profile will be copied to the new profiles folder on the server creating a new folder with the users name and permissions set up so that only the user can access it.

Rhapsody Playlist - GLEE TV Show hits ;-)

dorky post but trying some html generated from rhapsody to see if images are sent properly or are red xs after the post.

http://rhaplinks.real.com/rhaplink?rhapid=6393732&type=playlist&title=Playlist&from=msn
1. Sweet Caroline (Glee Cast Version) - Glee Cast
2. Bust A Move (Glee Cast Version) - Glee Cast
3. Don't Stop Believin' (Glee Cast Version) - Glee Cast
4. Halo / Walking On Sunshine (Glee Cast Version) - Glee Cast
5. Gold Digger (Glee Cast Version) - Glee Cast
6. Can't Fight This Feeling (Glee Cast Version) - Glee Cast
7. Rehab (Glee Cast Version) - Glee Cast
8. Dancing With Myself (Glee Cast Version) - Glee Cast

or this version (generic, not the blogger format as above):
http://rhaplinks.real.com/rhaplink?rhapid=6393746&type=playlist&title=Playlist&from=msn

MOSS 2007 External Web Resolution Issues/Alternate Access Mappings

So when building a MOSS site, you cannot simply assign an IP say 64.24.232.177 and then make a DNS A record say moss1.yourdomain.com point to it, then in IIS configure that MOSS Web Site to run on say, port 80 for example.

No, that is not good enough, you have to tell Sharepoint about it -- go into Central Administration, then there is a slew of different alternate access mappings you can configure for the site.

There are different zones (dont you just love IIS/Internet Explorer?!?):
default, intranet, public, extranet, custom (blah blah)

All you really need to do to enable your moss site to be viewed externally (assuming you set the DNS as explained above) is:

1. In IIS, configure the host header for the site (right click it go to properties, Advanced, Add the DNS name i.e. moss1.yourdomain.com in the host header box).

and

2. In MOSS Central Administration, Operations, Alternate Access Mappings add a public URL as http://moss1.yourdomain.com (I just added it into the default zone and erased what was there -- the http://hcmoss02 which is the internal name of the server)

VOILA you are done. Now your site resolves externally. Take a coffee break.

Shared images for MOSS 2007 templates

put shared images for the MOSS site in %12 hive%\template\images
i.e.:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES

Linux Find Command find text in files

To find the text "JoomlArt" in all files in all subdirectories under the current dir, use this:

find . -type f -name "*" -exec grep -il JoomlArt {} \;

If you just wanted to search in php file for example, it would be this:

find . -type f -name "*.php" -exec grep -il JoomlArt {} \;

(grep is not needed in these examples)

DirectAdmin forgot admin password?

If you forget the Direct Admin admin password, all you have to do is if you have ssh to the box as root type:

passwd admin

(then reset it you goof!)

exim permissions error

When I see this:

login as: root
root@64.254.200.10's password:
Last login: Mon Aug 31 15:44:06 2009 from adsl-70-131-140-218.dsl.emhril.sbcglob al.net
[root@ls3 ~]# 2009-08-31 15:45:42 1MiDl0-0001b0-SA Failed to create spool file / var/spool/exim/input//1MiDl0-0001b0-SA-D: Permission denied
[root@ls3 ~]#


I do this (temporarily):
chmod -R 777 /var/spool/exim
because this does not work:
chmod -R 755 /var/spool/exim

Directadmin - MySql move a database and grant user permission

So to move a Mysql database from one server to another all you have to do is copy the database over and then grant the appropriate permissions to the new database on the new server.

In the example below the username is da_admin and password kbjlms1X

the database name is aurorafcs_md
the database user name is also aurorafcs_md
the database user password is gggyro33

To grant the permissions:
2. [root@ns2 conf]# mysql -uda_admin -pkbjlms1X
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6118
Server version: 5.0.37-standard MySQL Community Edition - Standard (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on aurorafcs_md.* to aurorafcs_md@localhost identified by 'gggyro33';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye