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:
https://confluence.atlassian.com/confkb/startup-check-http-maxthreads-configuration-939930122.html
In ./conf/server.xml file:
<Host name="localhost" debug="0" appBase="webapps" unpackWARs="true" autoDeploy="false"> <Context path="" docBase="../confluence" debug="0" reloadable="false"> <!-- Logger is deprecated in Tomcat 5.5. Logging configuration for Confluence is specified in confluence/WEB-INF/classes/log4j.properties --> <Manager pathname="" /> <-- Find this...
... Add this after <Resource name="jdbc/agileapplicationstack" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/timesheet?autoReconnect=true" username="timesheet" password="password" maxActive="25" maxIdle="5" maxWait="10000" />
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)
Run timesheet_conf.sql file to your database. And since Timesheet for Confluence version 1.8 run also timesheet_for_approval.sql file to your database.
Restart Confluence now.
Macros
Write this to a wiki page in a space:
{grid-timesheet}
To see all users in the timesheet:
{grid-admin-timesheet}
To make user timesheet:
{grid-user-timesheet:user_id=admin|timesheet_id=timesheet_1|month=5|year=2017}
Since version 1.9 user timesheets can be approved by administrators or users who can edit a Confluence page:
{grid-user-timesheet:user_id=admin|timesheet_id=timesheet_1|month=5|year=2017|approved=true}
{grid-user-timesheet:user_id=admin|timesheet_id=timesheet_1|month=5|year=2017|approved=false}
How to use these macros on Confluence Pages?
Timesheet for Confluence Step by Step