Thanks for need full document .
Thanks & Regards
Sandeep
On Thu, Jan 28, 2010 at 10:04 AM, prakash b <[email protected]> wrote:
> Hi Dondapati,
>
> Thanks for very usefull documentation.
>
> Rgds,
> Prakash B
>
> On Thu, Jan 28, 2010 at 3:12 AM, John Jimmy Dondapati <
> [email protected]> wrote:
>
>> I've played around with setting up bugzilla on Centos, Mysql and Apache
>> today and documented the whole process. Thought someone could use it someday
>> so posting it here. Hope this helps!
>>
>>
>> **
>>
>> *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
>> b...@localhostidentified 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!
>>
>>
>>
>> --
>> Cheers,
>> John
>>
>>
>
>
> --
> praca"sh.."
>
