Openfire (master)

• 

  daryl herzmann <akrherz@iastate.edu> 15 Aug 2020 83fd733ebcc156e339e2dc20fe1ff5ad63a43aae

  Merge pull request #1681 from guusdk/OF-2061_OF-2062-db-upgrade-script
  OF-2061 OF-2062 db upgrade script
• 

  Guus der Kinderen 15 Aug 2020 7ee44fe1fb08507741d6c27595305938ccf8af39

  Add a toString impl for cached disco item instances

  • xmppserver/src/main/java/org/jivesoftware/openfire/disco/IQDiscoItemsHandler.java (version 7ee44fe1fb08507741d6c27595305938ccf8af39)
• 

  Guus der Kinderen 15 Aug 2020 f4af97bceae111258c92f2e46b566e5be3a167b1

  OF-2061 & OF-2062: Update expected db version.
  As a wise man once said:
  > Don't forget to bump the expected DB version to 31 so Openfire actually runs the script!

  • xmppserver/src/main/java/org/jivesoftware/database/SchemaManager.java (version f4af97bceae111258c92f2e46b566e5be3a167b1)
• 

  daryl herzmann <akrherz@iastate.edu> 15 Aug 2020 94437963583f2e8b3e57e3cbfb852264d63ba7ab

  Merge pull request #1680 from guusdk/OF-2062_pubsub-item-payload-size
  OF-2062 pubsub item payload size
• 

  Guus der Kinderen 14 Aug 2020 3b5589f0a0e022feb6dbf6086513b23fb9b1ea0f

  Fix silly mistake in database upgrade script.

  • distribution/src/database/upgrade/31/openfire_oracle.sql (version 3b5589f0a0e022feb6dbf6086513b23fb9b1ea0f)
• 

  Guus der Kinderen 14 Aug 2020 01b9e089a447735736dc4c98b13d0faebf61154e

  OF-2061 & OF-2062: Update default configuration for existing PEP services
  Existing PEP services each have a database record of what the default configuration of their nodes is. For PEP, it's very desirable to make two changes:
  - ensure that payload of items is persisted
  - increase the maximum allowable payload size
  
  This commit adds an update script that modifies the database-stored default configuration for leaf nodes of existing PEP services (identified as services for which the ID matches a JID - the script detects this by looking for an @ character).
  
  Similarly, the configurations of all existing nodes is updated accordingly, provided that the configuration does not appear to have been modified from the default (which is detected by comparing the maximum allowable payload size again).

  • distribution/src/database/upgrade/31/openfire_db2.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
  • distribution/src/database/upgrade/31/openfire_hsqldb.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
  • distribution/src/database/upgrade/31/openfire_mysql.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
  • distribution/src/database/upgrade/31/openfire_oracle.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
  • distribution/src/database/upgrade/31/openfire_postgresql.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
  • distribution/src/database/upgrade/31/openfire_sqlserver.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
  • distribution/src/database/upgrade/31/openfire_sybase.sql (version 01b9e089a447735736dc4c98b13d0faebf61154e)
• 

  Guus der Kinderen 14 Aug 2020 480357c513dcb5fc149b2f4599c0ded2b3032ada

  OF-2062: Update the maximum payload size to match database
  The most limited database (sqlserver and hsqldb) will be able to store 1GB-1byte of data.
  
  As for the maximum allowed data to be sent through XMPP, let's use the default maximum stanza size that can be read by Openfire (10mb).

  • xmppserver/src/main/java/org/jivesoftware/openfire/pep/PEPService.java (version 480357c513dcb5fc149b2f4599c0ded2b3032ada)
  • xmppserver/src/main/java/org/jivesoftware/openfire/pubsub/PubSubModule.java (version 480357c513dcb5fc149b2f4599c0ded2b3032ada)
• 

  Guus der Kinderen 14 Aug 2020 79d075089805c23bcc1ced5b8630364fdbf53945

  OF-2062: Increase database column size for pubsub payload
  The HSQLDB and Oracle types were limited to 4000 characters, which have now been increased to the default clob size. Mysql went from MEDIUMTEXT (16mb) to LONGTEXT (4gb).

  • distribution/src/database/openfire_db2.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/openfire_hsqldb.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/openfire_mysql.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/openfire_oracle.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/openfire_postgresql.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/openfire_sqlserver.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/openfire_sybase.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_db2.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_hsqldb.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_mysql.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_oracle.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_postgresql.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_sqlserver.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
  • distribution/src/database/upgrade/31/openfire_sybase.sql (version 79d075089805c23bcc1ced5b8630364fdbf53945)
• 

  Guus der Kinderen 14 Aug 2020 f82e8e727656eb0d5de2e05e8c0e0361dec90a7b

  fix typo in log message

  • xmppserver/src/main/java/org/jivesoftware/openfire/pubsub/DefaultPubSubPersistenceProvider.java (version f82e8e727656eb0d5de2e05e8c0e0361dec90a7b)