Samet Kilictas's Blog

Web 1.0 – That Geocities & Hotmail era was all about read-only content and static HTML websites. People preferred navigating the web through link directories of Yahoo! and dmoz.

Web 2.0 – This is about user-generated content and the read-write web. People are consuming as well as contributing information through blogs or sites like Flickr, YouTube, Digg, etc. The line dividing a consumer and content publisher is increasingly getting blurred in the Web 2.0 era.

Web 3.0 – This will be about semantic web (or the meaning of data), personalization (e.g. iGoogle), intelligent search and behavioral advertising among other things.

The size of a table can be found using oracle’s segment tables. Basically following code block returns a result of table size within related tablespaces in terms of MB and GB:

   SELECT tablespace_name,
          segment_name AS TABLENAME,
          trunc((sum(BYTES) / 1024 / 1024), 2) MB,
          trunc((sum(BYTES) / 1024 / 1024 / 1024), 2) GB
     FROM user_segments
 GROUP BY tablespace_name, segment_name

This way you may access only the tablespaces of logged in user

Yesterday, i just restarted my laptop and built-in speakers stopped working but headphones. I have re-installed drivers but didnt worked. So i tought it is some hardware problem related with soundcard. Then i got a sound from speakers for a second while unpluging my headhone jack from the port. I have plugged and unplugged the headphone jack couple of times and it worked. Problem was some kind of short in jack port.

Building up and making all modifications on your server is pretty boring. There is no need to find the sun again and again. I’ve had to go through the process of reconfiguring my virtual hosts for Apache2 several times and i found a pre modified shell script and modified the script according to my needs. This script enables you to create, destroy your virtual host in a second.

you can download the script from here : vhost.txt or;

mkdir ~/bin
cd ~/bin
wget http://samet.kilictas.com/wp-content/uploads/2011/05/vhost.txt
mv vhost.txt vhost
chmod 755 vhost

Now, to invoke the script, type the following:

. ~/bin/vhost

By using this script you can create, destroy a virtual host. In order to create a new host on your server user following command by replacing appreciate values:

vhost create <domain> <admin -email> <host -ip>

The script creates required directories,files as shown below;

Web directories
/www/htdocs/$domain

Web cgi-bin
/www/cgi-bin/$domain

Web logs
/www/logs/$domain/apache2
/www/logs/$domain/apache2/access.log
/www/logs/$domain/apache2/error.log

then builds virtual host config file and enables it right away (enabling is optional), which is placed in following directory

/etc/apache2/sites-available/$domain

After getting done with all these process it simply creates a little info file

/www/$domain/logs/site_info

Great you have created and enabled your virtual host, you may need to destroy a virtual host, here is how;

vhost destroy <domain>

Read more…