Archive for August, 2008

Properly Reinstalling SQL Server 2005 Reporting Services

Monday, August 25th, 2008

From here

  1. Stop the default IIS web site.
  2. DO NOT SHUTDOWN IIS.
  3. Delete both SQL Server 2005 Report Server databases.
  4. In Control Panel, click on the Change button for the pertinent SQL Server 2005 install instance.
  5. Continue to select Report Server and the option to remove it.
  6. Reinstall Reporting Services by running the installer on the SQL Server 2005 disc.
  7. Once setup is complete, launch the Reporting Services Configuration tool with the Configuration Tools menu in your Start menu.
  8. Fix any red-X items in the list.
  9. You should be good to go!

Drain Smells

Sunday, August 24th, 2008

Mr. HandyPerson has always used a half-cup of baking soda, followed by about a half-cup of warm water to get the baking soda down into the sink drain, and then he poured in a cup of white vinegar.

Bash tips

Wednesday, August 20th, 2008

Originally from here.

(more…)

Automating a Quicker Exchange 2000 or 2003 / DC reboot

Wednesday, August 20th, 2008

Original article here.

You can make the server execute a script at shutdown time by using the Group Policy Editor, which is an MMC (Microsoft Management Console) snap-in.  I will explain how to use the Group Policy Editor shortly, but first, we need to create the batch file that will shut down the Exchange services.

(more…)

Exim Tips & Tricks - Unclog your queue!

Friday, August 15th, 2008

Original article here

This article will focus on some general Exim MTA tips and tricks as well as how to parse mail logs. I originally put this guide together for use with Exim on cPanel. Many cPanel server administrators use the built in Exim MTA without giving it a second thought because it works. It works until they end up providing virtual hosting systems (shared hosting) where some of the users do not update their scripts regularly or simply think setting a cron job that runs every minute and clogs the queue is a good idea. Then running the built in Exim MTA with no knowledge of how it works becomes a disaster! Learn Exim today and save your self some serious headaches!

Is your Exim queue piled up with thousands or even millions of emails? Are you getting complaints from your upstream provider because your servers are sending spam? Are your users complaining emails that they are expecting aren’t coming in or take hours or days to get there? Are your servers blacklisted on the major lists and you have no idea why? If any of these situations describe your problems then this guide should serve as a good primer for you to get the basic idea of how Exim works. You can use the knowledge here to solve all of these problems!

(more…)

Various Iptables Tricks

Friday, August 15th, 2008

> iptables -t nat -A POSTROUTING -o eth1 -j MASQUERADE
> iptables -t nat -P PREROUTING DROP
> # Box 1
> iptables -t nat -A PREROUTING -m mac –mac-source 00:50:da:e3:f3:45 -j
> ACCEPT
> # Box 2
> iptables -t nat -A PREROUTING -m mac –mac-source 00:d0:b7:18:0f:f5 -j
> ACCEPT
>
> Now this works as expected, all packets from the two MAC addresses above are
> masq’ed and routed, anything from any other MAC address is DROP’ed.

mmh… but it is a bit unclean to drop packets in the nat table. You want
to filter packets, so use the filter table. Why? Because it is
- unclean
- only the first packet of each connection hits the nat table.

iptables -t nat -A POSTROUTING -o eth1 -j MASQUERADE

iptables -t filter -N restr
iptables -t filter -A restr -p tcp –dport 25 -j DROP

iptables -t filter -P FORWARD DROP
iptables -t filter -A FORWARD -m mac –mac-source 00:50:da:e3:f3:45 -j ACCEPT
iptables -t filter -A FORWARD -m mac –mac-source 00:d0:b7:18:0f:f5 -j restr

(more…)

Modifying SBS 2003 SP1’s bkprunner.exe for Improved Backup Performance

Friday, August 15th, 2008

Originally from here

Open Explorer and go to “C:\Program Files\Microsoft Windows Small Business Server\Backup”
Make a copy of bkprunner.exe

Download and extract XVI32.
Run XVI32.exe
Open bkprunner.exe in XVI32

The address range $10F0-$11B7 is used for backups to .bkf files
The address range $11B8-$1277 is used for backups to tape

To turn off verify when backing up to a .bkf
Go to address $113A
In the hex pane (the middle one), type in the following hex values:
6E 00 6F 00 20
This enters in the text “no ” in Unicode format.