Resource Menu


RE : Fatal Postgres Connect Error
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.Session

libresource.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/files

subversion.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_CMD

mail.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.postgres

jdbc.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

posted by moriger at Dec 30, 2008 8:30 PM