We present a practical protection mechanism against SQL injection attacks. Such attacks target databases that are accessible through a web front-end, and take advantage of flaws in the input validation logic of Web components such as CGI scripts. We apply the concept of instruction-set randomization to SQL, creating instances of the language that are unpredictable to the attacker. Queries injected by the attacker will be caught and terminated by the database parser. We show how to use this technique with the MySQL database using an intermediary proxy that translates the random SQL to its standard language. Our mechanism imposes negligible performance overhead to query processing and can be easily retrofitted to existing systems.
Read the rest of this entry »

• 0 Comments

Traditionally, Microsoft’s core business has been focused on the Windows platform and the Office suite. Windows and Office, by all means, continue to be the heart of Microsoft. The latest versions of the flagship products, Windows Vista and the Office 2007 System, made available to the public at the end of January 2007, have fueled the vast majority of the company’s most recent fiscal second quarter record financial results of $16.37 billion in revenue, and $6.48 billion in operating income. With Office SP1 out of the way at the end of 2007, Microsoft is currently building Windows Vista Service Pack 1, Windows XP Service Pack 3 and Windows 7 client platforms, as well as putting the finishing touches on Windows Server 2008.
Read the rest of this entry »

• 0 Comments

Not a Linux fan? Looking for a hassle?free way of setting up a PHP environment on your Windows box? Read as Matthew guides us through the process of installing Apache, MySQL and PHP on a Windows based machine, otherwise known as WAMP.

This article is geared towards people who want to code and test their own, or other people’s, php scripts on their Windows box. No advanced technical knowledge is assumed. This tutorial is unsuitable for advanced users. Why Apache and MySQL? Because they are available for free, quite easy to use and reliable. Why windows? Because there are many installation guides written for the Linux user, but Windows generally gets overlooked. And getting it all to work can be a real daunting task.
Read the rest of this entry »

• 0 Comments

Very rare since a MySQL client library is distributed with PHP and built into PHP by default. However, it is possible to build PHP without MySQL support. Some possible fixes:
apt-get install php-mysql
rpm -Uvh php-mysql-4.2.2-1.i386.rpm
./configure –with-mysql=shared,/usr
cp modules/mysql.so /usr/local/lib/php
extension_dir=/usr/local/lib/php
extension=mysql.so
Read the rest of this entry »

• 0 Comments

You can download the MySQL database from the MySQL website http://www.mysql.com by clicking on the downloads tab. Scroll down to the MySQL database server & standard clients section and select the latest production release of MySQL, 4.0 at the time of writing.
Read the rest of this entry »

• 0 Comments

MySQL and Perl have been around for quite a while. They are still widely used even if the “fashion” is changing. This article talks about these two products working together as a whole, either on the Internet or on your local network. The provided example is written for Unix systems, free or not, even if it can be adapted to other widespread “systems”.
Read the rest of this entry »

• 0 Comments

Over the course of this book, it will be my job to guide you as you take your first steps beyond the HTML world of client-side site design. Together, we’ll explore what it takes to develop the kind of large, content-driven sites that are so successful today, but which can be a real headache to maintain if they aren’t built right. Before we get started, you need to gather together the tools you’ll need for the job. In this first chapter, I’ll guide you as you download and set up the two software packages you’ll need: PHP and MySQL.
Read the rest of this entry »

• 0 Comments

This project serves as an introduction to client-server programming. You will be expected to implement an abstract protocol called Simple Registration Protocol using simple TCP socket programming. To illustrate the use of the protocol, you will also implement a concrete application: a simple appointment management system. This application will introduce you to the use of LAMP (Linux, Apache, MySQL and PHP), a free, powerful and commonly-used combination for Web-based applications.
Read the rest of this entry »

• 0 Comments