Wiki

Clone wiki

BibSonomy / documentation / releases / 2015 / 3.3.0

3.3.0

Date: 2015-10-07 (planned: 2015-09-10)

released

external

  • person-entities / genealogy
  • oAuth page redesign

internal

  • sidebar refactoring
  • bibsonomy1 classes removed (new statistics code)
  • database-configuration via properties file
  • https-redirect bugfix
  • gravatar-code cleanup

Necessary Changes

Add all database connections (urls, username, password) to the property file on all servers.

properties

Database connections

database.main.driverClassName = com.mysql.jdbc.Driver
database.main.url = 
database.main.maxIdle = 50
database.main.maxActive = 260
database.main.maxWait = 10000
database.main.removeAbandoned = true
database.main.removeAbandonedTimeout = 300
database.main.username = bibsonomy
database.main.password = 

# slave database
database.slave.driverClassName = ${database.main.driverClassName}
database.slave.url = ${database.main.url}
database.slave.username = ${database.main.username}
database.slave.password = ${database.main.password}

# clicklogger database
database.clicklogger.driverClassName = ${database.main.driverClassName}
database.clicklogger.url = ${database.main.url}
database.clicklogger.maxIdle = ${database.main.maxIdle}
database.clicklogger.maxActive = ${database.main.maxActive}
database.clicklogger.maxWait = ${database.main.maxWait}
database.clicklogger.removeAbandoned = ${database.main.removeAbandoned}
database.clicklogger.removeAbandonedTimeout = ${database.main.removeAbandonedTimeout}
database.clicklogger.username = ${database.main.username}
database.clicklogger.password = ${database.main.password}

# tag recommender database
database.recommender.tag.driverClassName = ${database.main.driverClassName}
database.recommender.tag.url = 
database.recommender.tag.maxIdle = ${database.main.maxIdle}
database.recommender.tag.maxActive = ${database.main.maxActive}
database.recommender.tag.maxWait = ${database.main.maxWait}
database.recommender.tag.removeAbandoned = ${database.main.removeAbandoned}
database.recommender.tag.removeAbandonedTimeout = ${database.main.removeAbandonedTimeout}
database.recommender.tag.username = recommender
database.recommender.tag.password = 

# item recommender database
database.recommender.item.driverClassName = ${database.main.driverClassName}
database.recommender.item.url = 
database.recommender.item.maxIdle = ${database.main.maxIdle}
database.recommender.item.maxActive = ${database.main.maxActive}
database.recommender.item.maxWait = ${database.main.maxWait}
database.recommender.item.removeAbandoned = ${database.main.removeAbandoned}
database.recommender.item.removeAbandonedTimeout = ${database.main.removeAbandonedTimeout}
database.recommender.item.username = ${database.recommender.tag.username}
database.recommender.item.password = ${database.recommender.tag.password}

# lucene database (only read only; maybe slave for performance)
database.lucene.driverClassName = ${database.slave.driverClassName}
database.lucene.url = ${database.main.url}
database.lucene.maxIdle = ${database.main.maxIdle}
database.lucene.maxActive = ${database.main.maxActive}
database.lucene.maxWait = ${database.main.maxWait}
database.lucene.removeAbandoned = ${database.main.removeAbandoned}
database.lucene.removeAbandonedTimeout = ${database.main.removeAbandonedTimeout}
database.lucene.username = bibsonomy_lucene
database.lucene.password = ${database.main.password}

# opensocial database
database.opensocial.driverClassName = ${database.main.driverClassName}
database.opensocial.url = 
database.opensocial.maxIdle = ${database.main.maxIdle}
database.opensocial.maxActive = ${database.main.maxActive}
database.opensocial.maxWait = ${database.main.maxWait}
database.opensocial.removeAbandoned = ${database.main.removeAbandoned}
database.opensocial.removeAbandonedTimeout = ${database.main.removeAbandonedTimeout}
database.opensocial.username = bibsonomy_os
database.opensocial.password = ${database.main.password}

the following properties must be overridden:

  • database.main.url
  • database.main.username
  • database.main.password
  • database.slave.url
  • database.slave.username
  • database.slave.password
  • database.clicklogger.url (only if not database.main.url)
  • database.clicklogger.username (only if not database.main.username)
  • database.clicklogger.password (only if not database.main.password)
  • database.recommender.tag.url
  • database.recommender.tag.username
  • database.recommender.tag.password
  • database.recommender.item.url
  • database.recommender.item.username = (only if not database.recommender.tag.username)
  • database.recommender.item.password = (only if not database.recommender.tag.password)
  • database.opensocial.url
  • database.opensocial.username
  • database.opensocial.password

Person-Entities / Elasticsearch

* es.address = localhost:9300
* es.cluster.name = bibsonomy-world
* genealogy.import.user = genealogie

batch scripts

other software

database

oauth_provider_tokens (opensocial database)

ALTER TABLE `oauth_provider_tokens` CHANGE COLUMN `callback_url` `callback_url` TEXT NULL DEFAULT NULL ;

person-entities

  1. execute persn-entities database script bibsonomy-database/src/main/resources/database/migrations/3.3.0/person-entities.sql
  2. add indices

Updated