Category Archives: Microsoft

All Microsoft Products (Exchange, SQL, Windows, Server)

MCE Remote on XBMC

In case you haven’t noticed, I’m on an XBMC bender. I recently setup an older system as a file server, put a crap load of storage in it, and threw some movie ISOs on there. Then I installed XBMC on my main rig. The rest is history. I was fine with the wireless keyboard and mouse, but The Fiance says we must use a remote control.

My lucky day happened last week: woot had a woot-off AND they had some MCE remotes on sale. I bought two. They’re some crappy Pinnacle ones, but at newegg they run almost $40 and I got both with shipping for less than $35.

Trying to get it to work was another issue. Out of the box Vista will recognize this remote, but XBMC wouldn’t hear anything. Works great on Windows Media Center though. So I ended up trying a program called LMRemoteKeyMap. Pretty nifty, but I didn’t feel like learning all about xml, codes, remotes, and commands. I felt like being lazy.

So then I ended up with another program called IRServer Suite. Now this one worked out of the box. Every function works as advertised. The only change I made was to get the giant green button to act as the Windows key (so I can press start). Others have made it automatically open up XBMC, but for now I just wanted start to work.

Basically you’ll just open the Translator program and follow along to have it automatically do your work for you. See how lazy I’m being?

I might include some screen shots eventually.

Test SMTP Using Telnet

I’ve been using this more and more and have finally memorized most (if not all) of it. But this is for those of us who don’t really like to remember useless information.

Start -> Run -> CMD
telnet
open mail.mailserver.tld 25
At this point the server should respond with a 220 mail.mailserver.tld ESMTP Mail Service.
ehlo test.com
The server then should respond with 250 mail.mailserver.tld along with all the supported features of the mail server
mail from:tester@test.com
250 Sender OK
rcpt to: admin@test.com
At this point, the server should say 554 Relay access denied. This means your server is not an open relay.
rcpt to: actualemailaddress@mailserver.tld
250 Recipient OK
data
354 Start Mail input; end with CRLF.CRLF
subject: subjecthere
You’ll have to hit enter twice after the subject, then go on and type the body.
body here.
Note the . at the end – you’ll have to type a return and another . to finish.
Then there should be a server response 250 Queued mail for delivery. You can quit now.
quit

XBMC Keyboard Controls

Since my memory isn’t what it used to be (they say the memory is the first to go), I have decided to put down the keyboard controls for XBMC. This is for DVD playback. Long story short:
I have a server with a ton of ISO’s of movies
I have a decent computer hooked up to
A very nice HD TV via DVI-HDMI cables
XMBC allows me to play any movie I want, whenever I want.

x – stops the movie, returns to movie list
s – brings up shutdown window
p – pause / play
space bar – pause / play
r – rewind
f – fast forward
up arrow – next chapter
down arrow – previous chapter
right arrow – fast forward 30 seconds
left arrow – rewind 30 seconds
t – show title and real life time
i – info on data stream
o – status on chapter number and time
s – subtitles on/off
m – menu

Rip PAL DVD, Convert to NTSC

The people I work with always seem to find ways to make me think, search, and try. Although, as of late, it’s become quite hard to “stump the IT person”.

Guy came over and had a foreign movie that he wanted a duplicate created. Foreign to me is anything outside of the US of A. PAL happens to be outside the US of A. This DVD was created in the US of A, but then banned. So this copy was converted to PAL. I want it back!

Before I get too far into things, this is for WINDOWS OS COMPUTERS! I know there are plenty of Linux applications out there to do the same things (or at a minimum “very similar things”), but since I work on Windows machines all day, I decided to make it easy on everyone. You have a *nix post you want up here? Send it to me.

So basically you’ll need a few things (besides the obvious):
DVD Ripper – any should do, I use DVDFab though
VOB Blanker – free program
DVD Shrink – another free program

1. Rip the Movie (not to ISO format)
2. Open VOB Blanker, search for the IFO file
3. In the middle of the screen, find the chart with your VOB file listed
4. Right-click on the VOB file and select Video Attrib
5. In the window that opens up, select NTSC instead of PAL (or the opposite if you need PAL instead. Do the math)
6. On the bottom of the main window press the giant PROCESS!! button.
7. After about 10 minutes, your movie should be finished. Burn the movie – I used DVD Shrink to do this

It tested fine so far, and I’m not aware of any complications. Let me know if this doesn’t work for you.

Domain Controller Replication Failure

I have a client that has two domain controllers. When rebooting the PDC, we noticed that access to the Exchange server would stop. Traced the issue back to a GC not being found problem. Added the second DC to be a GC (it’s not recommended to have the Infrastructure Owner be a Global Catalog server, but with only 2 servers to play with…) so that the user systems would be able to use secondary DNS.

But then I noticed in the eventviewer that we were receiving an error:
Replication Failure: The reason is: The source server is currently rejecting replication requests.
Not good.
You can find out the exact error easier by going to Start >> Run >> replmon. Add your entire domain to the list, then expand out the servername. You’ll see red x’s on the non-replicating servers. Click on one of those red x’s to see the exact logs.

The fix:
In a command window, type:
repadmin /options SERVERNAME -DISABLE_INBOUND_REPL
repadmin /options SERVERNAME -DISABLE_OUTBOUND_REPL
The “-” is very important in this instance. It removes the restrictions. + would therefore add the restrictions.

Show Extended Status Messages Windows

I’m not a big fan of seeing the whole “windows is starting, please wait” crap that Microsoft makes me view upon startup. I like to know what’s really going on. Is it initializing something? Is it hung up? Am I wearing pants?

Well, that last part I can figure out on my own easy enough. And now I can figure out the first two as well. This requires the use of the trusty regedit application. Don’t make changes unless you know what you’re doing (or trust a guy who can tell if he is or is not wearing pants).

1.) Start >> Run >> Regedit
2.) Navigate to:
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system
3.) Add the following DWORD Key:
VerboseStatus
4.) Make sure the value of the DWORD is set to “1” (obviously no quotes)
5.) Reboot

Exchange 2007 Self-Signed Certificate

This will probably never come up in my ventures as the Administrator here at my job, but it has come up with one of our customers. They do not have a Certificate Authority (CA) and do not pay for an outside certificate. They also use Exchange 2007. I’m not privy to all the ins and outs of their network, but they’re a standard small business with 4 or 5 servers. And it’s been 53 weeks since they installed Exchange 2007.

Why is 53 a number you should scoff at? Every 52 weeks (365 days, 12 months, 1 year, 1/10th of a decade…) you have to resign the self-signed certificate that Exchange gives itself. Why do I even need a certificate, you ask. The certificate is required for all TLS communication. Anything that’s even remotely secured uses TLS. Outlook uses TLS. If the certificate is invalid or non-existent, Outlook will refuse to send and receive emails from your Exchange server. Not good. I’m not sure why their server lasted 53 weeks and not 52, but maybe the guy got it wrong (he’s fairly technical though).

Here’s a quick and easy way of renewing your certificate:
1.) On your Exchange 2007 server, open up the Exchange Management Shell
2.) Type “get-exchangecertificate” and hit enter. This will show all installed certificates.
Type “get-exchangecertificate | fl *” to show everything about the installed certificates.
Type “get-exchangecertificate | fl services, thumbprint” to show only the services with the thumbprint for each certificate.
3.) Type “get-exchangecertificate -thumbprint thumbprint_of_cert | new-exchangecertificate
4.) Type “enable-exchangecertificate -thumbprint thumbprint_of_new_cert -services “IMAP,POP,SMTP,IIS”
5.) Test the services
6.) Remove the old certificate. Type “remove-exchangecertificate – thumbprint thumbprint_of_old_cert

You’ll have to do this every year if you use the self-signed certs. If you use a CA, the issued certificate will last anywhere from 1 to 5 years. You can also use your internal CA to issue new signed-certificates. You can use the standard website template, and then use the Exchange Management Shell to add the services to the new certificate (enable-exchangecertificate -thumbprint thumbprint -services “imap,pop,smtp”. You can leave out IIS since it *should* already be there.

**** EDIT ****

New-ExchangeCertificate -SubjectName "DC=domain, DC=com, CN=server.domain.com" -DomainName server.domain.com,mail.domain.com -IncludeAcceptedDomains -IncludeAutoDiscover -Services "SMTP" -PrivateKeyExportable $true
This updates the certificate to cover all domains used by Exchange. You can also specify other domains like mail.domain, webmail.domain etc.

Get-ExchangeCertificate
Get-ExchangeCertificate | FL
These allow you to find the thumbprint of the certificate you created.

Enable-ExchangeCertificate -Thumbprint THUMBPRINT -Services SMTP,IMAP,POP,IIS
This will turn on the services for your thumbprinted certificate. Obviously you can choose which services to allow.

Export-ExchangeCertificate -Thumbprint THUMBPRINT -BinaryEncoded:$true -Path C:\SSCert.pfx -Password:(Get-Credential).password
This exports your personal certificate PFX file with the password you choose at the prompt. This can then be pushed out to users to trust this file. Check for root certificate installations for other details.

OR, if you have your own Certificate Authority:

New-ExchangeCertificate -GenerateRequest -SubjectName "o=My, o=Site, cn=MyServer.MyDomain.com" -IncludeAcceptedDomains
-Path c:\MyServer.MyDomain.com.req

Open this file using notepad or the like, and copy the information between the start and end of the certificate.
Now log into your Certificate Authority
http://CAServer/certsrv
Click Request a certificate
Submit an advanced certificate request
Submit a certifcate request by using a base-64-encoded CMC or PKCS #10 file, or submit a renewal request by using a base-64-encoded PKCS #7 file
Paste the certificate information from earlier
Change the Certificate Template to Web Server
Click submit

You should now have a certificate issued. You’ll probably want to download it – so select Base64 encoded and download the certificate. I always choose to download the full path AND the general cert.

Copy your newly issued/downloaded certificate to your Exchange server.
Import-ExchangeCertificate -Path c:\2009mycert.cer | Enable-ExchangeCertificate -Services SMTP,POP,IMAP,IIS

If you already have a certificate that’s the default one on Exchange, you’ll notice that the SMTP and IIS settings DO NOT STAY.
You’ll have to:
Enable-ExchangeCertificate -Thumbprint MYTHUMBPRINT -Services SMTP,IIS
Exchange will ask if you want to overwrite the current certificate with Y for yes.
You’re done!