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"
