Comparison of issue-tracking systems

Hi,

Studing tracking systems and having doubt's on chosing whats the best for you ?

Check this.

JIRA rules!

JIRA Workflow Enhancer

Found out a very promising JIRA plugin!

More detail can be found here!




I'm going to test it and i will let you now my verdict!

JIRA Gantt-Chart Plugin

One of those plugins that everyone should use good for planning and you can goo on and support charity!

You can find more details in here

Install Postgres in CentOS

Later we had installed a CentOS server on a VMware workstation.

Lets now install a database on it my choice is no Postgres 8.2 database.

[centosuser@localhost ~]$ su - root

List PostGres available versions:

[root@localhost ~]#  yum list postgres\*




Loaded plugins: fastestmirror, refresh-packagekit

Loading mirror speeds from cached hostfile

 * base: ftp.up.pt

 * extras: ftp.up.pt

 * updates: ftp.up.pt

Available Packages

postgresql.x86_64                        8.4.7-1.el6_0.1                 updates

postgresql-contrib.x86_64            8.4.7-1.el6_0.1                 updates

postgresql-devel.i686                    8.4.7-1.el6_0.1                 updates

postgresql-devel.x86_64               8.4.7-1.el6_0.1                 updates

postgresql-docs.x86_64               8.4.7-1.el6_0.1                 updates

postgresql-jdbc.x86_64                8.4.701-3.el6                   base   

postgresql-libs.i686                      8.4.7-1.el6_0.1                 updates

postgresql-libs.x86_64                 8.4.7-1.el6_0.1                 updates

postgresql-odbc.x86_64              08.04.0200-1.el6                base   

postgresql-plperl.x86_64              8.4.7-1.el6_0.1                 updates

postgresql-plpython.x86_64          8.4.7-1.el6_0.1                 updates

postgresql-pltcl.x86_64                8.4.7-1.el6_0.1                 updates

postgresql-server.x86_64             8.4.7-1.el6_0.1                 updates

postgresql-test.x86_64                 8.4.7-1.el6_0.1                 updates

[centosuser@localhost ~]$ yum install postgresql-server

========================================================================

 Package                 Arch         Version               Repository     Size

========================================================================

Installing:

 postgresql-server       x86_64       8.4.7-1.el6_0.1       updates       3.3 M

Installing for dependencies:

 postgresql              x86_64       8.4.7-1.el6_0.1       updates       2.7 M

 postgresql-libs         x86_64       8.4.7-1.el6_0.1       updates       193 k



Transaction Summary

========================================================================

Install       3 Package(s)

Upgrade       0 Package(s)

Total download size: 6.1 M

Installed size: 28 M

Is this ok [y/N]: y

.....


Complete!

[root@localhost ~]#

Inicialize de cluster

[centosuser@localhost ~]$  service postgresql initdb

Started the service a

[centosuser@localhost ~]$  chkconfig postgresql on

Make sure in every boot the service start automaticly

[centosuser@localhost ~]$  service postgresql start

Install JIRA 4.4.3 (Database Conf)

I'm a JIRA fan and soo in the next posts i will take you in a tour for installing JIRA in a centosOS server.


We have already created a development enviroment later on with a centOS server and postgres database.


In this post we are going to create and database user!


Well that was fast :)
You can have more detail here about how to do it in linux and windows.


Now lets go to database
First lets see if database is running..

[root@localhost ~]# /etc/init.d/postgresql status
postmaster is stopped
[root@localhost ~]# /etc/init.d/postgresql start

/var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first.  [FAILED]

Hum...no it will need some extra work!

[root@localhost ~]# service postgresql-8.4 initdb
postgresql-8.4: unrecognized service
[root@localhost ~]# service postgresql initdb
Initializing database:                                     [  OK  ]
[root@localhost ~]# service postgresql start
Starting postgresql service:                               [  OK  ]
[root@localhost ~]# chkconfig postgresql on
[root@localhost ~]# /etc/init.d/postgresql status
postmaster (pid  2995) is running...

Ok, soo we inicialize de cluster, started the service and make sure in every boot the service start automaticly
Now we can create our user and database..

[root@localhost ~]# su - postgres
-bash-4.1$ createuser -P jira
Enter password for new role: 
Enter it again: 
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
-bash-4.1$
-bash-4.1$ exit
logout
[root@localhost ~]# su - jira
[jira@localhost ~]$ createdb jiradb
[jira@localhost ~]$ psql jiradb
psql (8.4.7)
Type "help" for help.

jiradb=>

And were done, you now have a jira system / database user and a new fresh postgres database witch we called jiradb!

You will have to edit your pg_hba.conf file to add permissions to jira user to connect to jiradb using password autentication mode..if you don't do this you will probabily have

FATAL: Ident authentication failed for user "jira"