PostgreSQL is not supported
Unfortunatelly PostgreSQL is not supported on Timesheet for Confluence.
You can try to make this configuration with your own risk. Please see at: https://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html
<Resource name="jdbc/agileapplicationstack" auth="Container" type="javax.sql.DataSource" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/timesheet?autoReconnect=true" username="timesheet" password="password" maxActive="20" maxIdle="10" maxWait="-1" />
Instead configuration below.
Prepare the external MySQL database to your Confluence before installing a plugin
Do I need to install MySQL connector?
Yes. MySQL J-connector is not bundled in Confluence so you need to install it to ./lib-folder.
Edit server.xml file
Configuration in Confluence 6.9 or above
You need to add
MaxTotal and it's value to Resource xml-tag:
In ./conf/server.xml file:
You need to add this configuration after every version upgrade of Confluence
Always you upgrade the Confluence you need make this configuration again manually. So backup your ./conf/server.xml first you proceed the upgrade. Do not replace new file with old file. Please just edit new one.
Create database (on command line or with phpMyAdmin)
Create a database timesheet.
Import SQL file (on command line or with phpMyAdmin)
Restart Confluence now.
Write this to a wiki page in a space:
To see all users in the timesheet:
To make user timesheet:
Since version 1.9 user timesheets can be approved by administrators or users who can edit a Confluence page:
How to use these macros on Confluence Pages?
Timesheet for Confluence Step by Step
Timesheet for Confluence - How to work with User Timesheets