For Confluence 7.1.0 and above
And do not add a
?sessionVariables=tx_isolation='READ-COMMITTED' to server.xml configs or Confluence do not startup.
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