Support Wikipedia

Wednesday, January 27, 2010

Bugzilla Setup : Mysql and Apache on Centos



Mysql setup



Install mysql

sudo yum search mysql // find the right names of the packages here

sudo yum install mysql-server.x86_64 mysql.x86_64 mysql-devel.x86_64

Edit mysql configuration

sudo vim /etc/my.cnf

Add the following lines if not already present

[mysqld]

# Allow packets up to 4MB

max_allowed_packet=4M

# Allow small words in full-text indexes

ft_min_word_len=2

Start Mysql server

sudo /etc/init.d/mysqld start

Login as root

mysql -uroot // no password by default

Create the database for bugs in the mysql terminal by using the following sql

create database bugs;

Create the user bugs

create user bugs identified by 'passw0rd';

Grant the permissions to user bugs on bugs database

GRANT SELECT, INSERT,UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES, CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.* TO bugs@localhost identified by 'passw0rd';

Flush privileges in order to take effect immediately. Very important!

FLUSH PRIVILEGES;

NOTE: Update your password if you need to :

update mysql.user set Password=password('passw0rd') where User='bugs';




Bugzilla Setup



Download latest stable bugzilla version from the website. It’s 3.4.4 as of now

wget http://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-3.4.4.tar.gz -O bugzilla-3.4.4.tar.gz

Change to the apache directory from where it serves files

cd /var/www/html/

Unzip the tar here /var/www/html/ so that apache can see it

sudo tar -xzvf ~/bugzilla-3.4.4.tar.gz

(optional) Rename the directory to hide the version

sudo mv bugzilla-3.4.4/ bugzilla

Change ownership so that apache can read/write to it

sudo chown -R apache.apache /var/www/html/bugzilla/

Change to bugzilla directory

cd /var/www/html/bugzilla/

Run checksetup.pl – this will show you the perl modules missing

sudo ./checksetup.pl --check-modules

Install gcc (if the linux distro doesn’t already come it), as you will need it to make/compile the modules

sudo yum install gcc.x86_64

Install any missing modules //here are commonly missing modules

sudo /usr/bin/perl install-module.pl CGI

sudo /usr/bin/perl install-module.pl Digest::SHA

sudo /usr/bin/perl install-module.pl Date::Format

sudo /usr/bin/perl install-module.pl DateTime

sudo /usr/bin/perl install-module.pl DateTime::TimeZone

sudo /usr/bin/perl install-module.pl DateTime::Locale

sudo /usr/bin/perl install-module.pl Template

sudo /usr/bin/perl install-module.pl Email::Send

sudo /usr/bin/perl install-module.pl Email::MIME

Run the checksetup.pl without any parameters to create a localconfig file.

sudo bash /var/www/html/bugzilla/checksetup.pl

Change the permissions in case there should be a conflict.

sudo chmod -R 777 /var/www/html/bugzilla/

Edit localconfig

sudo vim localconfig

Update the database connection details like username and password

# The DNS name of the host that the database server runs on.

$db_host = 'localhost';

# The name of the database

$db_name = 'bugs';

# Who we connect to the database as.

$db_user = 'bugs';

# Enter your database password here. It's normally advisable to specify

# a password for your bugzilla database user.

# If you use apostrophe (') or a backslash (\) in your password, you'll

# need to escape it by preceding it with a '\' character. (\') or (\)

# (Far simpler just not to use those characters.)

$db_pass = ‘passw0rd’;

# Sometimes the database server is running on a non-standard port. If that's

# the case for your database server, set this to the port number that your

# database server is running on. Setting this to 0 means "use the default

# port for my database server."

$db_port = 0;

# With the introduction of a configurable index page using the

# template toolkit, Bugzilla's main index page is now index.cgi.

# Most web servers will allow you to use index.cgi as a directory

# index, and many come preconfigured that way, but if yours doesn't

# then you'll need an index.html file that provides redirection

# to index.cgi. Setting $index_html to 1 below will allow

# checksetup.pl to create one for you if it doesn't exist.

# NOTE: checksetup.pl will not replace an existing file, so if you

# wish to have checksetup.pl create one for you, you must

# make sure that index.html doesn't already exist

$index_html = 1;

Re-run the checksetup.pl

sudo bash /var/www/html/bugzilla/checksetup.pl




Apache setup



Almost all linux distributions come with httpd pre-installed (i.e. Apache)

If not, install it using

sudo yum install apache

or

sudo yum install httpd

Edit /etc/httpd/conf/httpd.conf

sudo vim /etc/httpd/conf/httpd.conf

and add the following lines

ScriptAlias /cgi-bin/ "/var/www/html/bugzilla/"





 
< Directory /var/www/html/bugzilla >
AddHandler cgi-script .cgi
Options +Indexes +ExecCGI
DirectoryIndex index.cgi
AllowOverride Limit
< / Directory >



Find the line

DirectoryIndex index.html index.html.var

Change it to

DirectoryIndex index.html index.html.var index.cgi

Start the httpd server

sudo /etc/init.d/httpd restart



and you are good to go!


Try http://localhost/bugzilla and have fun!

  

Friday, January 15, 2010

Steve McCurry - photographs of India

I have recently came across Steve McCurry's work and I must say this guy is my Photography God. He has an amazing collection of photographs from India over a time period of 20 plus years.

I don't know if I am violating any laws by grabbing his images and displaying it here but I cannot resist from showcasing it here. Each of his photographs speak a wide variety of things. It's amazing how you can capture life in such little things to the minutest details.

Steve - I'm sorry if it offends you since I took these pics from your website without permission but please consider this as an advertisement of your work.

Hats off - you inspire me to take up photography which I'll for sure do. Thanks!





















































Afgan Girl (Sharbat Gula)




Many of us remember this photograph from the first Afgan invasion by USA. This was a very very famous pic from that period. It was the iconic representation of the afgan people during their troubled times and still continues to be.

I saw the same potrait at a Afgani restaurant (Maiwand Kabob - they have some amazing kababs) this afternoon and it kept haunting me. I remembered reading about it in the news papers sometime. I also remembered that the photographer tried to trace her for a few years (2 as I remembered) after the initial picture and finally succeeded.

The curiosity led me to dig deep and to my surprise the whole thing turned out to be no less fascinating than a Hollywood film. It actually took him (Steve McCurry i.e. the photographer) almost 17 years to trace this girl. She was 12 years old when she was photographed then and now she is 37.

All this while, she was unaware of her picture's popularity which is amazing to me. I mean, that's life at it's best. It hits you with a bundle of surprises. She is a house wife one day and the next day she is the most wanted person from a famous photograph. Awesome!



Image source : Steve McConnor's website (http://www.stevemccurry.com). Sorry Steve, I am only trying to retell your story here. No Offense!

Highlights :

* In recognition of her, National Geographic set up the Afghan Girls Fund, a charitable organization with the goal of educating Afghan girls and young women.
* The image itself was named "the most recognized photograph" in the history of the National Geographic magazine.
* She was unaware of her picture's popularity all those 17 years.


Read here for more details :
http://en.wikipedia.org/wiki/Afghan_Girl_%28photo%29

Support Wikipedia Support Wikipedia Support Wikipedia Support Wikipedia Support Wikipedia Support Wikipedia