I have installed Postgresql.
my psql is version 8.4, server version 9.3.
I have configured the dbconfig.xml with the following params:
<?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <delegator-name>default</delegator-name> <database-type>postgres72</database-type> <schema-name>test</schema-name> <jdbc-datasource> <url>jdbc:postgresql://host:5432/jiradb</url> <driver-class>org.postgresql.Driver</driver-class> <username>jiradbuser</username> <password>jiradbuser</password> <pool-min-size>20</pool-min-size> <pool-max-size>20</pool-max-size> <pool-max-wait>30000</pool-max-wait> <pool-max-idle>20</pool-max-idle> <pool-remove-abandoned>true</pool-remove-abandoned> <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout> <validation-query>select version();</validation-query> <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis> <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis> <pool-test-while-idle>true</pool-test-while-idle> </jdbc-datasource> </jira-database-config>
and I get the following error:
what kind of database-type do i need for this version?
thanks in advance,
Hi, thanks for your replies.
the db is running.
JIRA and the db are on the same linux server.
that is why I wrote "host" instead of IP.
when I tried to write the server ip I get different error:
HTTP Status 500 - Could not determine database type. (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) type Exception report message Could not determine database type. (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) description The server encountered an internal error that prevented it from fulfilling this request.
Yep sounds like there's no connection to the database. I'd do the following
Check the status of your database server to ensure that it is running.
If your database server is running, check your network configuration to ensure that it is accessible (ex. ping from your JIRA server).
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot