GNOME 2.30 has been released
.la Removal
This is the lines that will remove all the .la files from my packages, taken from AUR documentation:
find $PKG -name '*.la' -exec rm {} \;
Feel free to used it, with your own risk.
SQL Injection
This can led attacker to access private areas in your web application, steal sensitive information, erase your database or alter certain information in the database for his own gain. Therefore it is prudent to safeguard your web application by filtering unsafe input variables before inputting them into SQL statements.
How crackers perform SQL Injection
Here is a list of common SQL injection technique employed by malicious users across the internet.
Another good read that I suggest is SQL Injection by examples which provide great explanation of how SQL Injection attacks are performed.
Catch me on twitter
Should a Python programmer be paid higher than a PHP / Perl / Java programmer ?
So folks, what do you think? Should the Python devs get more? Share your thoughts.
How to Pick a Linux Distro (Distribution)
As I have embarked on finding the right Linux distro I have observed a great deal about the Linux world. Where Linux is quite popular in other countries, there is an undercurrent of Linux users in the US. Now, I know there are probably hundreds of thousands (if not millions) of people even in the US that use Linux, but compared to the Microsoft Windows users out there, that is a drop in the bucket. Generally, this minority of Linux users are intelligent people that enjoy using Linux for it's power and stability. This great strength of the community is also it's biggest problem. Since there are lots of smart people using Linux (that seem to already know how to use it), good and understandable instructions on using it are often hard to come by, or lack thoroughness at best. So as I searched for the "best" Linux distro, there wasn't much help that was immediately available. (Unlike what you would find for Windows)
Which Linux Distro is the "BEST"?
I was in search for the best distro, and all I could really find is, "There is no 'best.' It comes down to a matter of personal preference." Which is no help to a newb like me... I want some good pros and cons about a particular distro and more importantly, concise and easily "digestible." Give me bullet points dammit! So as I Googled around I stumbled across a really neat site geared for the most ignorant computer user or an experienced Linux user wanting to try something new. When I go into a store and I am seriously comparing some products, I am looking for a sales rep to sell me on a particular brand. Now, that doesn't mean I'm going to buy it, but I want some convincing reasons to buy one product over the other. Of course I will take this info and scour the Internet and read forums and user opinions. But I want someone to tell me what they think I should buy! This site does that for me.
The Linux Distro Test
Zegenie Studios has an easy little test with relevant questions for the most novice Linux user. Answer each question honestly and it will point you to what suites your Linux "skills" the most. I have taken the test numerous times and have massaged the answers a little differently each time. (Which I would recommend) The top three recommendations I received over and over were 1. Ubuntu 2. Mandriva One and 3. PCLinuxOS. There were a few extra distros that almost made the cut including: Kubuntu, Mepis and Xandros. One of my main criteria was FREE. I don't want to pay for what, in my mind, is unproven. Another neat feature that I would suggest is a "Live CD". This is basically a bootable CD that allows you to check out the distro, without having to fully commit a piece of your hard drive to this new (and shall I say foreign) operating system. There are lots of instructions on how to boot your computer with a CD, especially on the individual distribution sites themselves. There are also great differences in how some these distributions work, so take a look and read the FAQ and Wikis at each site. And once you have chosen a distribution read, read, read, read, read.
How to find cause of heavy usage on your Apache webserver
Here's a quick and dirty tips on how to find cause of heavy CPU resources usage on your Apache webserver (especially when running php scripts).
First you need to locate the Apache 2 "access.log" file. By default in Ubuntu, this file is located in "/var/logs/apache2" directory.
Then you need to run this command to find out which IP address accesses your website the most in a short time.
- tail -10000 access.log| awk '{print $1}' | sort | uniq -c |sort -n
The output of the command should contain a list of IP addresses along with the number of hits it made in the last 10,000 access of your website
- 47 117.58.252.98
- 81 202.124.242.186
- 84 202.124.245.26
- 182 194.164.101.217
- 220 208.101.22.146
- 225 72.167.131.144
- 3946 93.135.xxx.xxx
From here you can easily locate the offending ip address and proceed to block it from accessing your website further using .htaccess file or other blocking method.
Here is an example to block certain ip address from accessing your website using .htaccess file
-
- order deny,allow
- deny from 93.135.xxx.xxx
-
Save .htaccess file in the root directory of your web server (example /var/www), and the ip address wont be available to access your site again.
Hope that would help you!
I Got Google Buzz
IMHO, Google Buzz is working like Google Wave + Google Reader combined as one application and integrated in GMail. It's a place where you can share everything with others, but in terms of social networks. You can add Twitter and Flickr (besides Google's site such as Blogger and YouTube), but not yet for Plurks. I'm waiting for Plurk to be added to Google Buzz as it's my favorite social network site for now.
Oh well, as always Google always put something interesting on each of it's products