Page tree
Skip to end of metadata
Go to start of metadata

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

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

  • No labels