tag:blogger.com,1999:blog-107391932009-07-06T14:15:50.176-07:00Blog of Andrew KroneAndy's Surfing Blog, the goal is to include a written report every morning on my way to work. Ventura, Carpinteria, California Street, Faria, Mondos and RinconAndrew Kronenoreply@blogger.comBlogger128125tag:blogger.com,1999:blog-10739193.post-38465228369509668882009-07-06T14:15:00.001-07:002009-07-06T14:15:45.742-07:00The Great American Bubble Machine:The Great American Bubble Machine:<br /><br />http://www.rollingstone.com/politics/story/28816321/the_great_american_bubble_machine<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-3846522836950966888?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-81636218543227163372009-06-10T12:53:00.000-07:002009-06-10T12:54:16.821-07:00Peter Schiff<a href="http://www.ritholtz.com/blog/2009/06/peter-schiff-on-tds/">http://www.ritholtz.com/blog/2009/06/peter-schiff-on-tds/</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8163621854322716337?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-88683235438033478272009-05-01T18:30:00.000-07:002009-05-01T18:34:39.031-07:00One Command: "sudo apt-get install ndisgtk"Ugh, the online forums are such a waist of time!!! IF you want to install a wireless PCI card on Ubuntu run the above command and download the "inf" driver from the vendor's webpage.<br /><br />The above command can also help if your Ubuntu system freezes after installing a PCI card. The key is to use the intended driver for any card AND install the driver using NDIS wrappers before installing the PCI card. The generic Linux drivers are just too generic, Windows can't even keep a list of reliable drivers and the hardware manufacturers builf their equipment for Linux!!!!<br /><br />-Andy<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8868323543803347827?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-1962144741893117632009-04-20T20:56:00.000-07:002009-04-20T20:57:06.941-07:00Edicts to Live ByTen principles for a Black Swan-proof world<br /><br /> 1. What is fragile should break early while it is still small. Nothing should ever become too big to fail.<br /><br /> 2. No socialisation of losses and privatisation of gains. Whatever may need to be bailed out should be nationalised; whatever does not need a bail-out should be free, small and risk-bearing. We have managed to combine the worst of capitalism and socialism.<br /><br /> 3. People who were driving a school bus blindfolded (and crashed it) should never be given a new bus. The economics establishment (universities, regulators, central bankers, government officials, various organisations staffed with economists) lost its legitimacy with the failure of the system.<br /><br /> 4. Do not let someone making an “incentive” bonus manage a nuclear plant – or your financial risks. Odds are he would cut every corner on safety to show “profits” while claiming to be “conservative”.<br /><br /> 5. Counter-balance complexity with simplicity. The complex economy is already a form of leverage: the leverage of efficiency.<br /><br /> 6. Do not give children sticks of dynamite, even if they come with a warning.<br /><br /> 7. Only Ponzi schemes should depend on confidence. Governments should never need to “restore confidence”. Be robust in the face of them.<br /><br /> 8. Do not give an addict more drugs if he has withdrawal pains. Using leverage to cure the problems of too much leverage is denial.<br /><br /> 9. Economic life should be definancialised. Citizens should not depend on financial assets or fallible “expert” advice for their retirement.<br /><br /> 10. Make an omelette with the broken eggs. We need to rebuild the hull with new (stronger) materials; we will have to remake the system before it does so itself.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-196214474189311763?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-70676523018366433712009-04-15T11:55:00.001-07:002009-04-15T11:56:06.157-07:00Bank REO WebsitesIndyMac Bank REO:<br />http://apps.indymacbank.com/individuals/realestate/search.asp<br /><br />Ocwen Financial REO:<br />http://www.ocwen.com/reo/home.cfm<br /><br />JP Morgan Chase Bank REO:<br />http://mortgage.chase.com/pages/other/co_properties_landing.jsp<br /><br />M&T Bank REO:<br />http://services.mandtbank.com/personal/bank_owned_prop.cfm<br /><br />Wells Fargo REO:<br />https://www.pasreo.com/reo/<br /><br />Washington Mutual REO (WAMU):<br />http://www.wamuproperties.com<br /><br />American Home Mortgage REO:<br />They aren't taking mortgage applications anymore but they are selling real estate, go figure. ;)<br />http://www.ahmhomes.com<br /><br />Wachovia REO:<br />http://reo.wachovia.com/<br /><br />Washington Mutual REO:<br />I could not locate any information about their REO.<br /><br />Deutsche Bank REO:<br />No information is available online.<br /><br />SunTrust REO:<br />SunTrust Mortgage, Inc website claims that all REO is listed with local real estate agents. Below is a link to their REO practices.<br />http://www.suntrustmortgage.com/reo.asp<br /><br />First Niagra Bank REO:<br />The First Niagra website states that REO listings are not currently available but they do list contact information.<br />http://www.fnfg.com/personal_banking/mortgages/real_estate_owned_sale.asp<br /><br />Key Bank REO:<br />No Key Bank REO information is availabe at this time.<br /><br />Compass Bank REO:<br />https://www.compassbank.com/appforms/properties/index.jsp<br /><br />Fannie Mae REO:<br />http://www.mortgagecontent.net/reoSearchApplication/fanniemae/<br /><br />Freddie Mac REO:<br />http://www.homesteps.com/hm01_1featuresearch.htm<br /><br />HUD REO:<br />http://www.hud.gov/homes/index.cfm<br /><br />HomeSales.gov also offers properties offered for sale by the government.<br /><br />Coldwell Banker REO Division<br />Coldwell Banker REO Division<br /><br />Regions Bank Properties<br />http://realestate.regions.com/servlet/Ore/ForeclosedPropertySearch.jsp<br /><br />Citibank REO<br />http://www.citimortgage.com/Mortgage/Oreo/SearchListing.do<br /><br />SBA Properties<br />http://app1.sba.gov/pfsales/dsp_search.html<br /><br />FDIC Real Estate Owned<br />http://www4.fdic.gov/DRRORE/<br /><br />Sallie Mae Financial Services Properties<br />http://www.grpcapital.com/properties/index.html<br /><br />BB&T REO (Branch Bank and Trust)<br />http://www.bbt.com/applications/specialassets/search.asp<br /><br />Beal Bank Commercial REO<br />http://www.bealbank.com/Content.aspx?ID=13<br /><br />GRP Financial Services Properties<br />http://www.grpcapital.com/properties/index.php<br /><br />Fifth Third Bank REO:<br />No information is available online.<br /><br />First Charter REO:<br />No information is available online.<br /><br />People's Bank REO<br />http://www.peoples.com/im/cda/multi_elements/0,,1355,00.html<br /><br />State Street REO:<br />No information is available online.<br /><br />National City Mortgage REO<br />http://www.ncmcreo.com/<br /><br />Taylor Bean REO<br />http://www.taylorbeanhomes.com/<br /><br />Downey Savings & Loan<br />http://www.downeysavings.com/bank-owned-properties<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-7067652301836643371?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-86736907113873459682009-03-20T13:41:00.001-07:002009-03-20T13:41:41.860-07:00Pure Genius<object width="400" height="225"><param name="allowfullscreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="movie" value="http://vimeo.com/moogaloop.swf?clip_id=3261363&server=vimeo.com&show_title=1&show_byline=1&show_portrait=0&color=&fullscreen=1" /><embed src="http://vimeo.com/moogaloop.swf?clip_id=3261363&server=vimeo.com&show_title=1&show_byline=1&show_portrait=0&color=&fullscreen=1" type="application/x-shockwave-flash" allowfullscreen="true" allowscriptaccess="always" width="400" height="225"></embed></object><br /><a href="http://vimeo.com/3261363">The Crisis of Credit Visualized</a> from <a href="http://vimeo.com/jonathanjarvis">Jonathan Jarvis</a> on <a href="http://vimeo.com">Vimeo</a>.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8673690711387345968?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-71241693222266444112008-12-11T13:16:00.000-08:002008-12-11T15:09:19.017-08:00IMG00115.jpg<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/737716-737840.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/737716-737840.jpg" width="400" height="300" border="0" alt="" /></a></p>Sent from my Verizon Wireless BlackBerry<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-7124169322226644411?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-70504121838704972312008-12-11T13:04:00.000-08:002008-12-11T13:07:20.070-08:00OpenVPNA few more great things about OpenVPN:<br /><br />1). The whole setup below can be duplicated on a separate server in less than an hour should a server crash<br /><br />2). The second server does not require additional licensing<br /><br />3). The UDP protocol can easily be switched to TCP 443 to get through pesky firewalls<br /><br />4). Vista 64-bit works with the latest OpenVPN GUI<br /><br />5). Log Files easily show all access by username<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-7050412183870497231?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-89468789281019037112008-12-11T12:32:00.000-08:002008-12-11T13:02:05.287-08:00Two Factor Authentication for FreeRSA is a ripoff, they're following in the footsteps of Microsoft and unfortunately many companies believe RSA is the only way to secure their network.<br /><br />They're wrong, and here's why:<br /><br />OpenVPN + Server Cert/Key + Pam Authentication Module = FREE two factor authentication.<br /><br /><span style="font-weight:bold;">First, let's define two factor authentication:</span> It's nothing more than two requirements when you logon, tunnel or gain access to a network. For example you have a "pincode" or "password" that never changes. In addition you might have a key chain "token" that is constantly changing. Access requires both, and because the key chain token is always changing it becomes very difficult for the wrong person to gain access.<br /><br /><span style="font-weight:bold;">Little background on industry:</span> The Citrix Access Gateway is probably the industry standard at providing a single factor authentication gateway for a small company. I'm guessing most companies concerned with security have something very similar. The gateway or "CAG" sits behind the companies firewall and accepts authentication requests. That's the first factor, the second is generally a token like system requiring users to carry around a silly key chain. Why? If a user has a private certificate of authority AND a username/password access is still two factor.<br /><br />What absolutely amazes me is that there are open source applications that can provide 2 factor authentication for FREE.<br /><br />Here's what a working OpenVPN server config looks like using PAM:<br /><br /><span style="font-style:italic;">proto udp<br />;proto tcp<br />port 1194<br />dev tap<br />tls-server<br />dh /etc/openvpn/easy-rsa/keys/dh1024.pem<br />ca /etc/openvpn/easy-rsa/keys/ca.crt<br />cert /etc/openvpn/easy-rsa/keys/server.crt<br />key /etc/openvpn/easy-rsa/keys/server.key<br />duplicate-cn<br />#Define the ip address for the tap0 virtual device<br />server 10.8.0.0 255.255.255.0<br />ifconfig-pool-persist /etc/openvpn/ipp.txt<br />#route to be established on the server<br />route-up "route delete -net 10.8.0.0/24"<br />route-up "route add -net 10.8.0.0/24 tap0"<br /><br />#Allow Clients to talk to one another<br />client-to-client<br /><br />#Push the same ping to the server....<br />push "ping 10"<br />push "ping-restart 60"<br />push "route 172.16.4.0 255.255.255.0" #route to another subnet<br />push "route 172.16.5.0 255.255.255.0" #route to another<br />push "route 172.16.51.0 255.255.255.0" #route to one more<br />push "route 172.16.8.0 255.255.255.0" #route to and another<br />push "route 172.16.81.0 255.255.255.0" #route to some place<br />push "route 172.16.70.0 255.255.255.0" #route to northern US<br />push "route 172.16.33.0 255.255.255.0" #route to more north<br />push "dhcp-option DOMAIN companyname.com" #push the DNS domain suffix<br /><br /><br />comp-lzo<br />status-version 2<br />status /var/log/openvpn-status.log<br />verb 5<br /># Keep tunnel open with ping every 10 Seconds, restart ever 120 Seconds<br />keepalive 10 120<br /><br />plugin /usr/share/openvpn/plugin/lib/openvpn-auth-pam.so login<br />client-cert-not-required</span><br /><br />I'm going to skip a whole bunch of steps to get this working (see openvpn.org) but if the server is running with the above configuration (with no errors) you'll have a two factor authentication: 1). Using the signed Certificate of Authority and 2). The username/password on the Linux box access by the openvpn-auth-pam.so module above.<br /><br />Win XP/Vista/32bit/64bit Client Setup:<br /><br /><span style="font-weight:bold;">1). Install OpenVPN GUI v1.0.3<br />2). Load the ca.crt and client.opvn file.</span><br /><br />Here's an example of the client.ovpn file:<br /><br /><span style="font-style:italic;">client<br />dev tap<br /><br />;proto tcp<br />proto udp<br />remote 1.2.3.4 1194 (1.2.3.4 should be the public ip of the server)<br />resolv-retry infinite<br />nobind<br />persist-key<br />persist-tun<br />ca ca.crt<br />comp-lzo<br />verb 3<br />mute 20<br />auth-user-pass</span><br /><br />Save yourself $10k or $20k, learn OpenVPN.<br /><br />-Andy<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8946878928101903711?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com3tag:blogger.com,1999:blog-10739193.post-52891737931081517282008-09-30T11:42:00.001-07:002008-09-30T11:42:43.515-07:00The Economy....The Big Picture:<br />bigpicture.typepad.com<br /><br />Chris Martenson:<br />http://www.chrismartenson.com/<br /><br />Jesse's Cafe Americain:<br />http://jessescrossroadscafe.blogspot.com/<br /><br />Clusterfuck Nation:<br />http://jameshowardkunstler.typepad.com/<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-5289173793108151728?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-35706702528984121602008-07-08T12:47:00.000-07:002008-07-08T12:48:30.020-07:00Create a command prompt loop LinuxExample:<br /><br />[root@servername~ ]# while [ 1 ]<br />> do <br />> date;<br />> df –h |grep backup;<br />> sleep 600;<br />> done<br /><br />This creates a loop that checks the disks mounted to the directories with the name “backup” and displays the date every ten minutes. This is useful to see the progress of a very large sync command on a ten minute basis. Obviously it can be changed for virtually any command.<br /><br />Note: the “while [ 1 ]” basically means the while is always true, thus the “sleep 600” is required. Otherwise you would have an infinite loop just going crazy. <br /><br />You can kill the output with ctrl-c<br /><br />-Andy<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-3570670252898412160?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-72975597443306384822008-06-25T09:35:00.001-07:002008-06-25T11:00:19.288-07:00Backuppc: Moving the poolHere are the instructions to create a dual disk system using backuppc. This approach creates a "copy" of the pool data without RAID. I have two external USB drives, both 500 Gig here. The advantage (I think) of this method is that if a mistake is made or a disk crashes no rebuilding is needed, just a copy. Also, the second disk can be removed for safe keeping, all we need is a replacement disk (no rebuilding)<br /><br /><br />1). Stop backuppc:<br /> /etc/init.d/backuppc stop<br /><br />2). Sync the current default location to your new mount point excluding "pc" (USB device = /data1):<br /> rsync -avPH --exclude=pc/ --delete /var/lib/backuppc/ /data1/backuppc/ <br /> (This creates all the data for backuppc in /data1/backuppc, the "H" preserves hard links)<br /><br />3). Move the old location to a new file, just in case:<br /> mv /var/lib/backuppc /var/lib/backuppc_old<br /><br />4). Change the /data1 mount point in /etc/fstab to mount /var/lib/backuppc, here's the line:<br /> before: /dev/sdc /data1/backuppc ext3 defaults 0 0<br /> after: /dev/sdc /var/lib/backuppc ext3 defaults 0 0<br /><br />5). If there's a second disk, setup a crontab with an rsync:<br /> rsync -aPH --exclude=pc/ --delete /var/lib/backuppc/ /data2/backuppc/ >/dev/null 2>&1<br /><br />6). Reboot and verify the disk(s) are mounted correctlty<br /><br />7). Start backuppc, /etc/init.d/backuppc start<br /><br />8). After a few days if all is working remove /var/lib/backuppc_old<br /><br />Note: Rather than creating a symbolic link from /var/lib/backuppc to /data1/backuppc I opted to create a static mount point in /etc/fstab. This is more straightforward. When someone runs "df -k" they'll see the giant mount point at /var/lib/backuppc and hopefully notice that it's a USB device. <br /><br />Formatting USB: You may also have to format the USB drive with "mkfs.ext3 /dev/sdc". The device can be determined pretty easily with the Logical Volume Management Tool available in the GNOME GUI.<br /><br />Further Note: Changing /etc/BackupPC/conf.pl and some of the files like "/usr/lib/BackupPC/Lib.pm" so the top directory is hard changed is NOT recommended. This is because someone else may update the backuppc package and the topDir will break.<br /><br />-Andy<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-7297559744330638482?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com2tag:blogger.com,1999:blog-10739193.post-81891440162564256852008-05-13T11:28:00.000-07:002008-05-13T11:31:26.178-07:00Coinfiguring a Sylog Server on LinuxSimple stuff, just no good resource out there:<br /><br />1). Modify the line in /etc/syslog.conf from this:<br />*.info;mail.none;authpriv.none;cron.none /var/log/messages<br /><br />To this<br />*.info;mail.none;authpriv.none;cron.none;local0.none /var/log/messages<br /><br /><br />2). Add the following two lines to the bottom of /etc/syslog.conf, the file “specialfilename” is the name of the new log: <br /># Firebox logs<br />local0.* /var/log/specialfilename<br /><br />3). Modify /etc/syconfig/syslog so the”SYSLOGD_OPTIONS” look like this:<br />SYSLOGD_OPTIONS="-r -m 0"<br /><br />4). Restart the syslog server:<br />[root@yourserver etc]# /etc/init.d/syslog restart<br />Shutting down kernel logger: [ OK ]<br />Shutting down system logger: [ OK ]<br />Starting system logger: [ OK ]<br />Starting kernel logger: [ OK ]<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8189144016256425685?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-19173115932171367102008-04-23T08:50:00.000-07:002008-04-23T08:51:05.920-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0423080846-765922-766024.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0423080846-765922-766008.jpg" border="0" alt="" /></a></p>This message was sent using the Picture and Video Messaging service from Verizon Wireless!<p>To learn how you can snap pictures and capture videos with your wireless phone visit <a href="http://www.verizonwireless.com/picture">www.verizonwireless.com/picture</a>.<p> <p>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-1917311593217136710?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-58991862705058883662008-04-21T09:23:00.000-07:002008-04-21T09:24:01.736-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0421080923-741756-741957.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0421080923-741756-741822.jpg" border="0" alt="" /></a></p>This message was sent using the Picture and Video Messaging service from Verizon Wireless!<p>To learn how you can snap pictures and capture videos with your wireless phone visit <a href="http://www.verizonwireless.com/picture">www.verizonwireless.com/picture</a>.<p> <p>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-5899186270505888366?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-33472204504842124922008-04-16T08:36:00.000-07:002008-04-16T08:37:10.421-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0416080835-730424-730687.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0416080835-730424-730618.jpg" border="0" alt="" /></a></p>This message was sent using the Picture and Video Messaging service from Verizon Wireless!<p>To learn how you can snap pictures and capture videos with your wireless phone visit <a href="http://www.verizonwireless.com/picture">www.verizonwireless.com/picture</a>.<p> <p>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-3347220450484212492?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-1091439229426363712008-04-11T13:18:00.001-07:002008-04-11T13:18:29.787-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0411081317-709789-709847.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0411081317-709789-709841.jpg" border="0" alt="" /></a></p>This message was sent using the Picture and Video Messaging service from Verizon Wireless!<p>To learn how you can snap pictures and capture videos with your wireless phone visit <a href="http://www.verizonwireless.com/picture">www.verizonwireless.com/picture</a>.<p> <p>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-109143922942636371?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-23255852929047475522008-03-25T10:56:00.000-07:002008-03-25T11:01:43.810-07:00Removing Duplicate Lines from a text or Excel fileRemoving duplicate lines on a file is easy. Although, not sure how to do it with vi or notepad++ or crimson editor.<br /><br />Here's how to do it in Excel:<br /><br />1). Open the text file in Excel<br />2). Create a new macro<br />3). Cut and paste the procedure below into the macro<br />4). Run the macro<br />5). Relish how easy things are with Google<br /><br />Public Sub DeleteDuplicateRows()<br />'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''<br />' DeleteDuplicateRows<br />' This will delete duplicate records, based on the Active Column. That is, <br />' if the same value is found more than once in the Active Column, all but <br />' the first (lowest row number) will be deleted.<br />'<br />' To run the macro, select the entire column you wish to scan for <br />' duplicates, and run this procedure.<br />''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''<br /><br />Dim R As Long<br />Dim N As Long<br />Dim V As Variant<br />Dim Rng As Range<br /><br />On Error GoTo EndMacro<br />Application.ScreenUpdating = False<br />Application.Calculation = xlCalculationManual<br /><br /><br />Set Rng = Application.Intersect(ActiveSheet.UsedRange, _ <br /> ActiveSheet.Columns(ActiveCell.Column))<br /><br />Application.StatusBar = "Processing Row: " & Format(Rng.Row, "#,##0")<br /><br />N = 0<br />For R = Rng.Rows.Count To 2 Step -1<br />If R Mod 500 = 0 Then<br /> Application.StatusBar = "Processing Row: " & Format(R, "#,##0")<br />End If<br /><br />V = Rng.Cells(R, 1).Value<br />'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''<br />' Note that COUNTIF works oddly with a Variant that is equal to vbNullString.<br />' Rather than pass in the variant, you need to pass in vbNullString explicitly.<br />'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''<br />If V = vbNullString Then<br /> If Application.WorksheetFunction.CountIf(Rng.Columns(1), vbNullString) > 1 Then<br /> Rng.Rows(R).EntireRow.Delete<br /> N = N + 1<br /> End If<br />Else<br /> If Application.WorksheetFunction.CountIf(Rng.Columns(1), V) > 1 Then<br /> Rng.Rows(R).EntireRow.Delete<br /> N = N + 1<br /> End If<br />End If<br />Next R<br /><br />EndMacro:<br /><br />Application.StatusBar = False<br />Application.ScreenUpdating = True<br />Application.Calculation = xlCalculationAutomatic<br />MsgBox "Duplicate Rows Deleted: " & CStr(N)<br /><br />End Sub<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-2325585292904747552?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-38010041809467139932008-03-25T09:39:00.001-07:002008-03-25T09:39:28.146-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0325080938-768149-768472.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0325080938-768149-768421.jpg" border="0" alt="" /></a></p>This message was sent using PIX-FLIX Messaging service from Verizon Wireless!<br>To learn how you can snap pictures with your wireless phone visit<p><a href="http://www.verizonwireless.com/getitnow/getpix">www.verizonwireless.com/getitnow/getpix</a>.<p><br>To learn how you can record videos with your wireless phone visit <a href="http://www.verizonwireless.com/getitnow/getflix">www.verizonwireless.com/getitnow/getflix</a>.<p><br>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download <br>process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-3801004180946713993?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-80139015924525830682008-03-24T07:55:00.001-07:002008-03-24T07:55:33.521-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0324080754-733523-733666.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0324080754-733523-733659.jpg" border="0" alt="" /></a></p>This message was sent using PIX-FLIX Messaging service from Verizon Wireless!<br>To learn how you can snap pictures with your wireless phone visit<p><a href="http://www.verizonwireless.com/getitnow/getpix">www.verizonwireless.com/getitnow/getpix</a>.<p><br>To learn how you can record videos with your wireless phone visit <a href="http://www.verizonwireless.com/getitnow/getflix">www.verizonwireless.com/getitnow/getflix</a>.<p><br>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download <br>process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8013901592452583068?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-35786498037814366362008-03-20T08:23:00.000-07:002008-03-20T08:38:26.201-07:00Yum not workingYum should work out of the box: but it doesn't. On CentOS (Linux) you may see the following:<br /><br />[root@yourservername etc]# yum update apcupsd<br />Loading "installonlyn" plugin<br />Setting up Update Process<br />Setting up repositories<br />Reading repository metadata in from local files<br />Could not find update match for apcupsd<br />No Packages marked for Update/Obsoletion<br /><br /><br />Add these to "/etc/yum.repos.d/CentOS-Base.repo":<br /><br />[extras2]<br />name=Fedora Extras - $releasever - $basearch<br />baseurl=http://download.fedora.redhat.com/pub/fedora/linux/extras/6/$basearch/<br />gpgcheck=0<br />gpgkey=http://download.fedora.redhat.com/pub/fedora/linux/extras/RPM-GPG-KEY-Fedora-Extras <br /><br /><br />NOW, try it again:<br /><br />[root@servername etc]# yum install apcupsd<br />Loading "installonlyn" plugin<br />Setting up Install Process<br />Setting up repositories<br />extras2 100% |=========================| 1.1 kB 00:00 <br />Reading repository metadata in from local files<br />primary.xml.gz 100% |=========================| 1.7 MB 00:11 <br />################################################## 5211/5211<br />Parsing package install arguments<br />Resolving Dependencies<br />--> Populating transaction set with selected packages. Please wait.<br />---> Downloading header for apcupsd to pack into transaction set.<br />apcupsd-3.12.4-5.fc6.i386 100% |=========================| 15 kB 00:00 <br />---> Package apcupsd.i386 0:3.12.4-5.fc6 set to be updated<br />--> Running transaction check<br /><br />Dependencies Resolved<br /><br />=============================================================================<br /> Package Arch Version Repository Size <br />=============================================================================<br />Installing:<br /> apcupsd i386 3.12.4-5.fc6 extras2 405 k<br /><br />Transaction Summary<br />=============================================================================<br />Install 1 Package(s) <br />Update 0 Package(s) <br />Remove 0 Package(s) <br /><br />Total download size: 405 k<br />Is this ok [y/N]: y<br />Downloading Packages:<br />(1/1): apcupsd-3.12.4-5.f 100% |=========================| 405 kB 00:02 <br />Running Transaction Test<br />warning: apcupsd-3.12.4-5.fc6: Header V3 DSA signature: NOKEY, key ID 1ac70ce6<br />Finished Transaction Test<br />Transaction Test Succeeded<br />Running Transaction<br /> Installing: apcupsd ######################### [1/1] <br /><br />Installed: apcupsd.i386 0:3.12.4-5.fc6<br />Complete!<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-3578649803781436636?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-47153095121259751612008-03-19T12:08:00.001-07:002008-03-19T12:08:51.731-07:00SSL with SendmailThank to the following web site:<br /><br />http://www.cromwell-intl.com/unix/sendmail-ssl.html<br /><br />-Andy<br /><br /><br /><br />How to make sendmail use SSL/TLS whenever possible<br /><br /> 1. Create a certificate directory and go there:<br /> # mkdir /etc/mail/cert<br /> # cd /etc/mail/cert<br /> 2. Create a key for the server, giving a new pass phrase when prompted:<br /> # openssl genrsa -des3 -out server.key 1024<br /> # openssl rsa -in server.key -out server.key.open<br /> 3. Create a clear-text copy of the key (so it is not pass-phrase-protected), giving the pass phrase when asked:<br /> # openssl req -new -x509 -days 3650 -key server.key.open -out server.crt<br /> 4. Answer the X.509v3 questions appropriately.<br /> 5. Make the files root-read-only:<br /> # chmod 600 server.*<br /> 6. Edit /etc/mail/sendmail.cf and add these lines. You should find commented-out versions of these settings in the file, maybe about a third of the way through it.<br /> O CACertPath=/etc/mail/cert<br /> O CACertFile=/etc/mail/cert/server.crt<br /> O ServerCertFile=/etc/mail/cert/server.crt<br /> O ServerKeyFile=/etc/mail/cert/server.key.open<br /> O ClientKeyFile=/etc/mail/cert/server.crt<br /> 7. Restart sendmail:<br /> # /etc/init.d/sendmail restart<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-4715309512125975161?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-89119398367103722372008-03-18T09:34:00.000-07:002008-03-18T09:38:24.867-07:00Outlook 2003 Not Saving to Sent Items FolderOutlook 2003 defies intuition. It would make sense that there should be an outbox or a sent items or a "sent" but Microsoft would rather make it really confusing. If you're connecting through imap and you want to have a specific imap folder say "Sent Items" store your sent mail you need to create a rule:<br /><br />Tools > Rules > New Rule <br /><br />Don't use the template, start from scratch.<br /><br />What you want to create is a rule that reads like this:<br /><br />Apply this rule after I send the message. Uses the <span style="font-style:italic;">message</span> form and on this machine only move a copy to <span style="font-style:italic;">Sent Items </span>folder.<br /><br />-Andy<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8911939836710372237?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-62627400134558359182008-03-13T13:48:00.001-07:002008-03-13T13:48:57.132-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0313081347-737136-737234.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0313081347-737136-737218.jpg" border="0" alt="" /></a></p>This message was sent using PIX-FLIX Messaging service from Verizon Wireless!<br>To learn how you can snap pictures with your wireless phone visit<p><a href="http://www.verizonwireless.com/getitnow/getpix">www.verizonwireless.com/getitnow/getpix</a>.<p><br>To learn how you can record videos with your wireless phone visit <a href="http://www.verizonwireless.com/getitnow/getflix">www.verizonwireless.com/getitnow/getflix</a>.<p><br>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download <br>process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-6262740013455835918?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0tag:blogger.com,1999:blog-10739193.post-83798618401421138572008-03-11T08:31:00.000-07:002008-03-11T08:32:48.788-07:00<p class="mobile-photo"><a href="http://www.andrewkrone.com/blog/uploaded_images/0311080831-768790-768848.jpg"><img src="http://www.andrewkrone.com/blog/uploaded_images/0311080831-768790-768833.jpg" border="0" alt="" /></a></p>This message was sent using PIX-FLIX Messaging service from Verizon Wireless!<br>To learn how you can snap pictures with your wireless phone visit<p><a href="http://www.verizonwireless.com/getitnow/getpix">www.verizonwireless.com/getitnow/getpix</a>.<p><br>To learn how you can record videos with your wireless phone visit <a href="http://www.verizonwireless.com/getitnow/getflix">www.verizonwireless.com/getitnow/getflix</a>.<p><br>To play video messages sent to email, QuickTime® 6.5 or higher is required. Visit <a href="http://www.apple.com/quicktime/download">www.apple.com/quicktime/download</a> to download the free player or upgrade your existing QuickTime® Player. Note: During the download <br>process when asked to choose an installation type (Minimum, Recommended or Custom), select Minimum for faster download.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10739193-8379861840142113857?l=www.andrewkrone.com%2Fblog%2Findex.php'/></div>Andrew Kronenoreply@blogger.com0