tables:
List of relations
Schema | Name | Type | Owner
--------+-------------------------------+-------+----------
public | bugtrackerresource_ | table | postgres
public | dropboxresource_ | table | postgres
public | fileresource_ | table | postgres
public | formresource_ | table | postgres
public | forumresource_ | table | postgres
public | groupresource_ | table | postgres
public | issueresource_ | table | postgres
public | ldapgroupresource_ | table | postgres
public | mailinglistresource_ | table | postgres
public | messageresource_ | table | postgres
public | node_ | table | postgres
public | pageresource_ | table | postgres
public | profileresource_ | table | postgres
public | projectproxyresource_ | table | postgres
public | projectresource_ | table | postgres
public | qrtz_blob_triggers | table | postgres
public | qrtz_calendars | table | postgres
public | qrtz_cron_triggers | table | postgres
public | qrtz_fired_triggers | table | postgres
public | qrtz_job_details | table | postgres
public | qrtz_job_listeners | table | postgres
public | qrtz_locks | table | postgres
public | qrtz_paused_trigger_grps | table | postgres
public | qrtz_scheduler_state | table | postgres
public | qrtz_simple_triggers | table | postgres
public | qrtz_trigger_listeners | table | postgres
public | qrtz_triggers | table | postgres
public | repositoryresource_ | table | postgres
public | siteresource_ | table | postgres
public | subversionrepositoryresource_ | table | postgres
public | surveyresource_ | table | postgres
public | symboliclinkresource_ | table | postgres
public | synchronizerresource_ | table | postgres
public | templateresource_ | table | postgres
public | threadresource_ | table | postgres
public | timelineresource_ | table | postgres
public | workspace_ | table | postgres
public | wsconnectionresource_ | table | postgres
(38 rows)
libresourceConfig.properties:
mail.factory.name libresourceConfig
mail.factory.type javax.mail.Sessionlibresource.server=jonas
libresource.datasource=libresourceDS
libresource.log.dir=/usr/local/LibreSource/logs/
libresource.working.node=projects
libresource.web.conf=
notification.default.type=mail
jabber.server=192.168.1.243
jabber.username=libresource
jabber.password=changeMe
kernel.serverUrl=http://192.168.1.243:9000
kernel.authUrl=
kernel.indexationDataDir=/usr/local/LibreSource/tmp-work/index
libresource.distributedFilesystem=/usr/local/LibreSource/tmp-work/filessubversion.authz.file.path=$LS_CONFIG_SVN_AUTH_PATH
subversion.repository.base.path=$LS_CONFIG_SVN_REPOSITORY_BASE_PATH
subversion.create.repository.cmd=$LS_CONFIG_SVN_CREATE_CMD
subversion.rename.repository.cmd=$LS_CONFIG_SVN_RENAME_CMDmail.lookup=libresourceMail
event.topic.lookup=libresource.events
indexation.topic.lookup=libresource.indexation
job.topic.lookup=libresource.jobs
remote.topic.connection.factory=JTCF
topic.connection.factory=TCF
sql.timeline.query=SELECT id_ FROM timelineresource_ WHERE ? LIKE rooturi_;
sql.timeline.id=id_
libresourceDS.properties:
datasource.name libresourceDS
datasource.url jdbc:postgresql://localhost:5432/libresource
datasource.username postgres
datasource.password postgres
datasource.classname org.postgresql.Driver
datasource.mapper rdb.postgresjdbc.connchecklevel 0
jdbc.connmaxage 1440
jdbc.maxopentime 60
jdbc.connteststmt select 1
jdbc.minconpool 2
jdbc.maxconpool 30
jdbc.samplingperiod 30
jdbc.maxwaittime 5
jdbc.maxwaiters 100