MS Excel Auditing

to filter out those that are not in B, how would I do it? Is there a
way? i.e.
Column A Column B
123 12345
12345 123
123123 I want “123123” to show up in Column C or something — I want to know
the numbers that are not showing in both. [Excel 97]
Assuming that you have filled 30 rows in columns A and B (->range
A2:B31). In C2, enter :
=IF(COUNTIF(B$2:B$31,A2),””,A2)
and copy down. After this, you can apply a filter on column C (show only the not empty
cells).]]>

MAC addresses stored in different places in Linux

Where the MAC address is stored is pretty important for Virtual Machines because the MAC address can change if you move the VM or if you copy it, etc.

Ubuntu 7.1.0 puts it in
/etc/udev/rules.d/70-persistent-net.rules

Redhat puts it in
/etc/sysconfig/network-scripts/ifcfg-eth0

Seems that older Ubuntu versions put them in /etc/network/interfaces I think. I’ve also did a search and found that there’s a /etc/iftab as well.

Re: How to build redhat kernel for VMware for time issue

In the guest, you’ll want to run NTP and not use the VMware tools time sync. It seems to work better. Also, you might also considering Ubuntu 7.1.0 instead as with ESX 3.5, VMware Server 2.0, and Workstation 6.0, it has a VMI option, so that you can run a paravirtualized kernel and get up to 30% better performance. It also doesn’t have the LSILogic scsi driver bug that everyone seems to run into.

Re: iptables notes

ipchains-save output from a firewall

*filter
:INPUT DROP [3229:322102]
:FORWARD DROP [0:0]
:OUTPUT DROP [0:0]
:icmp-in – [0:0]
:icmp-out – [0:0]
:log-and-drop – [0:0]
:valid-source-address – [0:0]
:valid-source-address-udp – [0:0]
:valid-tcp-flags – [0:0]
-A INPUT -i lo -j ACCEPT
-A INPUT -p tcp -j valid-tcp-flags
-A INPUT -p ! udp -j valid-source-address
-A INPUT -p udp -j valid-source-address-udp
-A INPUT -p tcp -m tcp –tcp-flags SYN,RST,ACK SYN -j valid-source-address
-A INPUT -p icmp -j icmp-in
-A INPUT -m state –state RELATED,ESTABLISHED -j ACCEPT
-A INPUT -p tcp -m tcp –dport 80 -m state –state NEW -j ACCEPT
-A INPUT -p tcp -m tcp –dport 443 -m state –state NEW -j ACCEPT
-A INPUT -p tcp -m tcp –dport 22 -m state –state NEW -j ACCEPT
-A INPUT -p udp -m udp –dport 123 -j ACCEPT
-A OUTPUT -o lo -j ACCEPT
-A OUTPUT -p tcp -j valid-tcp-flags
-A OUTPUT -p icmp -j icmp-out
-A OUTPUT -p udp -m udp –sport 1024:65535 –dport 53 -j ACCEPT
-A OUTPUT -p tcp -m tcp –sport 1024:65535 –dport 53 -j ACCEPT
-A OUTPUT -m state –state RELATED,ESTABLISHED -j ACCEPT
-A OUTPUT -j REJECT –reject-with icmp-port-unreachable
-A icmp-in -p icmp -m icmp –icmp-type 0 -j ACCEPT
-A icmp-in -p icmp -m icmp –icmp-type 8 -j ACCEPT
-A icmp-in -p icmp -m icmp –icmp-type 3/4 -j ACCEPT
-A icmp-in -j DROP
-A icmp-out -p icmp -m icmp –icmp-type 8 -j ACCEPT
-A icmp-out -p icmp -m icmp –icmp-type 0 -j ACCEPT
-A icmp-out -j DROP
-A log-and-drop -j LOG –log-level 7 –log-tcp-options –log-ip-options
-A log-and-drop -j DROP
-A valid-source-address -s 127.0.0.1 -j DROP
-A valid-source-address -s 0.0.0.0/255.0.0.0 -j DROP
-A valid-source-address -d 255.255.255.255 -j DROP
-A valid-source-address-udp -s 127.0.0.1 -j DROP
-A valid-source-address-udp -s 0.0.0.0/255.0.0.0 -j DROP
-A valid-tcp-flags -p tcp -m tcp –tcp-flags FIN,SYN,RST,PSH,ACK,URG NONE -j log-and-drop
-A valid-tcp-flags -p tcp -m tcp –tcp-flags FIN,ACK FIN -j log-and-drop
-A valid-tcp-flags -p tcp -m tcp –tcp-flags PSH,ACK PSH -j log-and-drop
-A valid-tcp-flags -p tcp -m tcp –tcp-flags ACK,URG URG -j log-and-drop
-A valid-tcp-flags -p tcp -m tcp –tcp-flags FIN,SYN FIN,SYN -j log-and-drop
-A valid-tcp-flags -p tcp -m tcp –tcp-flags SYN,RST SYN,RST -j log-and-drop
-A valid-tcp-flags -p tcp -m tcp –tcp-flags FIN,RST FIN,RST -j log-and-drop
COMMIT

ESX 3.5 RC1 runs beautifully on a Dell SC1430!

I was expecting that there might be some problems since it’s not on the HCL, but it seems it runs perfectly! SATA worked just fine! Created VMFS partitions right on the SATA drives! The broadcom nic was supported using the tg3 driver. I was pleasantly surprised as the install to deployment was very easy.

This came as a great deal from Dell when they sent me the 30% off coupons for Dell SMB where the 2nd proc came free, I got a quad core 1.6ghz box for just 761 or so out the door. From newegg, I got 2 2gb dimms and then CompUSA a couple of SATA 500gb hds for roughly a total of 440 or so. The total was less than 1200 for an awesome machine!