Archive for February, 2006
blocking unfriendly traffic
If you think some wierd traffic is coming to your server, you can use netstat and ps to find evil programs, ports, and ips. Besides killing processes with the usual kill command you might try adding some rule to iptables while you investigate
netstat -lntpe
ps -auxfw
Drops a port (in this example 3131)
iptables -A INPUT -p […]
Posted: February 9th, 2006 under Linux, Firewalls and Security.
Comments: none
Exim outbound queue is HUGE
show the count of messages in queue
exim -bpc
list the messages in queue
exim -bp
These can selectively delete messages from the queue
if the message is frozen
exim -bpru|grep frozen|awk {’print $3′}|xargs exim -Mrm
if the message is
exim -bpru|grep ‘‘|awk {’print $3′}|xargs exim -Mrm
if all
exim -bpru|awk {’print $3′}|xargs exim -Mrm
Posted: February 9th, 2006 under Linux, Exim.
Comments: none
finding those orphaned users in a mssql server database
Ever move to a new mssql server database and orphan the users…. You get all kinds of nasty errors… here is some things to fix those mssql accounts. This will not work with Windows accounts.
You can find them with this SP
sp_change_users_login ‘report’
and you can fix them with this SP
sp_change_users_login ‘update_one’, ‘username’, […]
Posted: February 7th, 2006 under MS SQL Server.
Comments: none
Deleting files that cannot be deleted through normal means
Ever have a file that is locked by the OS and you absolutely cannot delete it….. Well here is a way, when you don’t have DOS as an option.
Install the Windows Recovery Console After Windows is Already Installed on the Computer
1. Click Start, click Run, and then type CD-ROM drive letter:\i386\winnt32.exe /cmdcons in the […]
Posted: February 6th, 2006 under Windows admin.
Comments: none
Enable the DTC between MSDTC and SQL server on windows 2003
Besides adding the dword of 1 to a new local machine, software, microsoft, msdtc, TurnOffRpcSecurity, you need to change AllowOnlySecureRpcCalls to be set to Zero.
Posted: February 4th, 2006 under MS SQL Server.
Comments: none